mysql57 @5.7.25: port select fails: target "/opt/local/share/man/mysql57/man1/mysql-stress-test.pl.1.gz" doesn't exist

[zslg01]

I installed mysql57, did a port select, got an error. Did not use to happen.

[zslg01]

Terminal log

[zslg01]

This IS a MySQL port issue .. who ever build it forgot to include the MySQL test component OR did not remove that component from the port select info for MySQL.

[ryandesign (Ryan Carsten Schmidt)]

The rtf file inside the zip file shows this error message:

$ sudo port select mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/mysql-stress-test.pl.1.gz": target "/opt/local/share/man/mysql57/man1/mysql-stress-test.pl.1.gz" doesn't exist

Looks like mysql-stress-test.pl.1 was present in mysql57 @5.7.17 but is no longer present in @5.7.25.

[chrstphrchvz (Christopher Chavez)]

I think this was caused by -DINSTALL_MYSQLTESTDIR=0 being added during the update to 5.7.25; this prevents the mysql-test directory from being installed, which is where mysql-stress-test.pl and a few other scripts expected by mysql_select come from. Is there a reason this was added?

[chrstphrchvz (Christopher Chavez)]

Replying to chrstphrchvz:

I think this was caused by -DINSTALL_MYSQLTESTDIR=0 being added during the update to 5.7.25; this prevents the mysql-test directory from being installed, which is where mysql-stress-test.pl and a few other scripts expected by mysql_select come from. Is there a reason this was added?

Actually, that option alone might not be why. I tried recompiling without just that option, and while the scripts get installed, the man pages are still missing.

[zslg01]

Does the person who updated it to 5.7.25 still hang around? Maybe [he, she] can throw some light on this. Has anyone tried Mariadb at the equivalent level? In any case I need to get a project done. With the MySQL project non-support on MacPorts I think I am going to have to go looking for alternatives (native Mariadb, Homebrew). In the long run I'll move development to Linux and special-case MacOS as needed. Thanks for the help from the previous posters.

[Schamschula (Marius Schamschula)]

Yes. I'm still around.

The short answer is that mysql 5.7.25 would not build with the previous config.args. I used some settings from Homebrew's formula to make it build again.

[ostefano (Stefano Ortolani)]

With the deprecation of mysql56, this bug is becoming slightly more critical. Is there a workaround yet?

[icemac (Michael Howitz)]

My personal workaround was to create an empty file for each link (about 6 or 7) the installer wants to create.

This way it was at least possible to install the package.

[y-a-v-a (Vincent Bruijn)]

I had to undertake these steps to get mysql57 to be selected for mysql.

$ sudo port select --set mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/mysql-stress-test.pl.1.gz": target "/opt/local/share/man/mysql57/man1/mysql-stress-test.pl.1.gz" doesn't exist
$ sudo touch /opt/local/share/man/mysql57/man1/mysql-stress-test.pl.1.gz
$ sudo port select --set mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/mysql-test-run.pl.1.gz": target "/opt/local/share/man/mysql57/man1/mysql-test-run.pl.1.gz" doesn't exist
$ sudo touch /opt/local/share/man/mysql57/man1/mysql-test-run.pl.1.gz
$ sudo port select --set mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/mysql_client_test.1.gz": target "/opt/local/share/man/mysql57/man1/mysql_client_test.1.gz" doesn't exist
$ sudo touch /opt/local/share/man/mysql57/man1/mysql_client_test.1.gz
$ sudo port select --set mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/mysql_client_test_embedded.1.gz": target "/opt/local/share/man/mysql57/man1/mysql_client_test_embedded.1.gz" doesn't exist
$ sudo touch /opt/local/share/man/mysql57/man1/mysql_client_test_embedded.1.gz
$ sudo port select --set mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/mysqltest.1.gz": target "/opt/local/share/man/mysql57/man1/mysqltest.1.gz" doesn't exist
$ sudo touch /opt/local/share/man/mysql57/man1/mysqltest.1.gz
$ sudo port select --set mysql mysql57
Selecting 'mysql57' for 'mysql' failed: could not create new link "/opt/local/man/man1/mysqltest_embedded.1.gz": target "/opt/local/share/man/mysql57/man1/mysqltest_embedded.1.gz" doesn't exist
$ sudo touch /opt/local/share/man/mysql57/man1/mysqltest_embedded.1.gz
$ sudo port select --set mysql mysql57
Selecting 'mysql57' for 'mysql' succeeded. 'mysql57' is now active.

[zslg01]

Thanks for the comment on adding some files to get it to install. I've since moved to postgresql - some mods needed but performance seems good and the database is solid.

[ryandesign (Ryan Carsten Schmidt)]

Has duplicate #60275.

[ernstki (Kevin Ernst)]

Reformatting so it's actually copy-pasteable:

sudo touch /opt/local/share/man/mysql57/man1/mysql-stress-test.pl.1.gz
sudo touch /opt/local/share/man/mysql57/man1/mysql-test-run.pl.1.gz
sudo touch /opt/local/share/man/mysql57/man1/mysql_client_test.1.gz
sudo touch /opt/local/share/man/mysql57/man1/mysql_client_test_embedded.1.gz
sudo touch /opt/local/share/man/mysql57/man1/mysqltest.1.gz
sudo touch /opt/local/share/man/mysql57/man1/mysqltest_embedded.1.gz