Bug #79232 secure_file_priv_basic.test does not properly check for symlinks

• Submitted: 11 Nov 2015 14:33
• Modified: 15 Nov 2015 7:58
• Reporter: Alexey Kopytov
• Status: Verified
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.6, 5.7
• OS: Any
• CPU Architecture: Any

[11 Nov 2015 14:33] Alexey Kopytov

Description:
The secure_file_priv_basic test does not work when MYSQLTEST_VARDIR is a
symlink, and there's a check for that in include/not_var_link.inc.

The problem is that the test also fails when there is a symlink in any
directory in the MYSQLTEST_VARDIR path, but include/not_var_link.inc
only checks if the last directory in the path is a symlink.

How to repeat:
Unpack a server binary tarball to a directory. Create a symlink to that
directory and execute the sys_vars.secure_file_priv_basic test from the
symlink directory.

Suggested fix:
Either fix not_var_link.inc to check the whole path for symlinks, or fix
secure_file_priv_basic.test to not depend on specific MYSQLTEST_VARDIR
values (I guess it's possible with some SQL tricks) and then get rid of
not_var_link.inc altogether.

[15 Nov 2015 7:58] MySQL Verification Team

Hello Alexey,

Thank you for the report.

Thanks,
Umesh