mysql5-devel: Could not find /opt/local/lib/mysql5-devel/bin/my_print_defaults

[ebgssth@…]

mysql_install_db5 failed with the following errors.

$ sudo port install mysql5-devel +server
--->  Installing mysql5-devel 5.1.22-rc_0+darwin_8+server
******************************************************
* In order to setup the database, you might want to run
* sudo -u mysql mysql_install_db5
* if this is a new install
******************************************************
--->  Activating mysql5-devel 5.1.22-rc_0+darwin_8+server
--->  Cleaning mysql5-devel

$ sudo -u mysql mysql_install_db5
sudo -u mysql mysql_install_db5
FATAL ERROR: Could not find /opt/local/lib/mysql5-devel/bin/my_print_defaults

If you are using a binary release, you must run this script from
within the directory the archive extracted into.  If you compiled
MySQL yourself you must run 'make install' first or use
use --source-install --install-dir=xxx from the top source directory

$ ls /opt/local/lib/mysql5-devel/bin/my_print_default*
/opt/local/lib/mysql5-devel/bin/my_print_defaults5

[ebgssth@…]

Related bug tickets on mysql.com

​http://bugs.mysql.com/bug.php?id=11913 ​http://bugs.mysql.com/bug.php?id=25226

Summary

--program-suffix, a configure option, is broken. IMHO, for the time being, we should avoid using this at least untill MySQL tean fix this problems.

reinplace might help but according to ticket above, that "require an extensive modification to multiple scripts" so will be a hard work.

I wonder how other packaging system handle this problem. Any clues anyone?

[ebgssth@…]

patch to get mysql_install_db working. ​http://lists.mysql.com/internals/27940

[ebgssth@…]

Suggested patch

--- Portfile.mysql5-devel.old   2007-10-23 07:08:44.000000000 +0900
+++ Portfile.mysql5-devel.new   2007-10-23 07:29:00.000000000 +0900
@@ -45,7 +45,6 @@
     --includedir=${prefix}/include/${name} \
     --datadir=${prefix}/share/${name} \
     --sysconfdir=${prefix}/etc/${name} \
-    --program-suffix=5 \
     --with-zlib-dir=${prefix} \
     --with-ssl=${prefix} \
     --with-extra-charsets=complex \
@@ -125,7 +124,7 @@
     if { [variant_isset server] } {
        ui_msg "******************************************************"
        ui_msg "* In order to setup the database, you might want to run"
-       ui_msg "* sudo -u ${mysqluser} mysql_install_db5"
+       ui_msg "* sudo -u ${mysqluser} mysql_install_db"
        ui_msg "* if this is a new install" 
        ui_msg "******************************************************"
     }

[jyrkiwahlstedt]

copying over stuff from mysql5 stable to drop configure option --program-suffix (declared broken), committing revised Portfile as revision 30318, ticket will be closed after confirmed action

[ebgssth@…]

I verified that mysql5-devel works fine now. But I think I would be better to fix program name in ui_msg, too.

post-install {
    if { [variant_isset server] } {
        ui_msg "******************************************************"
        ui_msg "* In order to setup the database, you might want to run"
-       ui_msg "* sudo -u ${mysqluser} mysql_install_db5"
+       ui_msg "* sudo -u ${mysqluser} mysql_install_db"
        ui_msg "* if this is a new install" 
        ui_msg "******************************************************"
    }
}

[ebgssth@…]

I misunderstood. Sorry for confusing. ui_msg is correct. Please close this ticket.

[ryandesign (Ryan Carsten Schmidt)]

Closing, as requested by reporter.

[(none)]

Milestone Port Bugs deleted