[MacPorts] #17412: mysql5 5.0.67_1+server - mysql_install_db errors
#17412: mysql5 5.0.67_1+server - mysql_install_db errors -----------------------------------+---------------------------------------- Reporter: edmond@… | Owner: macports-tickets@… Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Keywords: | Port: -----------------------------------+---------------------------------------- When running mysql_install_db errors occur: {{{ mal:/opt/local/lib/mysql5 edmond% sudo -u mysql ./bin/mysql_install_db FATAL ERROR: Could not find fill_help_tables.sql inside --basedir When using --basedir you must point either into a MySQL binary distribution directory or a compiled tree previously populated by 'make install' mal:/opt/local/lib/mysql5 root# sudo -u mysql ./bin/mysql_install_db --user=mysql bindir = __PREFIX/bin FATAL ERROR: Could not find fill_help_tables.sql inside --basedir When using --basedir you must point either into a MySQL binary distribution directory or a compiled tree previously populated by 'make install' }}} Which is because of the following code: {{{ if test -z "$basedir" then basedir="/opt/local" bindir="/opt/local/lib/mysql5/bin" mysqld="/opt/local/libexec/mysqld" pkgdatadir="/opt/local/share/mysql5/mysql" else bindir="$basedir/bin" # We set up bootstrap-specific paths later, so skip this for now if test "$cross_bootstrap" -eq 0 then }}} It looks like $basedir should be null when it reaches the above, but instead it is "__PREFIX/bin" which turns up nothing when searching for key files. Perhaps some substitution failed? I got it to work, by forcing the correct values in the script, but I'm guessing that's not intended. -- Ticket URL: <http://trac.macports.org/ticket/17412> MacPorts <http://www.macports.org/> Ports system for Mac OS
#17412: mysql5 5.0.67_1+server - mysql_install_db errors -----------------------------------+---------------------------------------- Reporter: edmond@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Keywords: | Port: mysql5 -----------------------------------+---------------------------------------- Changes (by jmr@…): * owner: macports-tickets@… => ryandesign@… * port: => mysql5 -- Ticket URL: <http://trac.macports.org/ticket/17412#comment:1> MacPorts <http://www.macports.org/> Ports system for Mac OS
#17412: mysql5 5.0.67_1+server - mysql_install_db errors -----------------------------------+---------------------------------------- Reporter: edmond@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Keywords: | Port: mysql5 -----------------------------------+---------------------------------------- Comment(by edmond@…): {{{ The problem seems to be in the __PREFIX tag not getting converted to the actual prefix in the /opt/local/etc/my.cnf file. }}} -- Ticket URL: <http://trac.macports.org/ticket/17412#comment:2> MacPorts <http://www.macports.org/> Ports system for Mac OS
#17412: mysql5 5.0.67_1+server - mysql_install_db errors -----------------------------------+---------------------------------------- Reporter: edmond@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Keywords: | Port: mysql5 -----------------------------------+---------------------------------------- Description changed by ryandesign@…: Old description:
When running mysql_install_db errors occur:
{{{ mal:/opt/local/lib/mysql5 edmond% sudo -u mysql ./bin/mysql_install_db FATAL ERROR: Could not find fill_help_tables.sql inside --basedir
When using --basedir you must point either into a MySQL binary distribution directory or a compiled tree previously populated by 'make install' mal:/opt/local/lib/mysql5 root# sudo -u mysql ./bin/mysql_install_db --user=mysql bindir = __PREFIX/bin FATAL ERROR: Could not find fill_help_tables.sql inside --basedir
When using --basedir you must point either into a MySQL binary distribution directory or a compiled tree previously populated by 'make install' }}}
Which is because of the following code:
{{{ if test -z "$basedir" then basedir="/opt/local" bindir="/opt/local/lib/mysql5/bin" mysqld="/opt/local/libexec/mysqld" pkgdatadir="/opt/local/share/mysql5/mysql" else bindir="$basedir/bin" # We set up bootstrap-specific paths later, so skip this for now if test "$cross_bootstrap" -eq 0 then }}}
It looks like $basedir should be null when it reaches the above, but instead it is "__PREFIX/bin" which turns up nothing when searching for key files. Perhaps some substitution failed? I got it to work, by forcing the correct values in the script, but I'm guessing that's not intended.
New description: When running mysql_install_db errors occur: {{{ mal:/opt/local/lib/mysql5 edmond% sudo -u mysql ./bin/mysql_install_db FATAL ERROR: Could not find fill_help_tables.sql inside --basedir When using --basedir you must point either into a MySQL binary distribution directory or a compiled tree previously populated by 'make install' mal:/opt/local/lib/mysql5 root# sudo -u mysql ./bin/mysql_install_db --user=mysql bindir = __PREFIX/bin FATAL ERROR: Could not find fill_help_tables.sql inside --basedir When using --basedir you must point either into a MySQL binary distribution directory or a compiled tree previously populated by 'make install' }}} Which is because of the following code: {{{ if test -z "$basedir" then basedir="/opt/local" bindir="/opt/local/lib/mysql5/bin" mysqld="/opt/local/libexec/mysqld" pkgdatadir="/opt/local/share/mysql5/mysql" else bindir="$basedir/bin" # We set up bootstrap-specific paths later, so skip this for now if test "$cross_bootstrap" -eq 0 then }}} It looks like $basedir should be null when it reaches the above, but instead it is "!__PREFIX/bin" which turns up nothing when searching for key files. Perhaps some substitution failed? I got it to work, by forcing the correct values in the script, but I'm guessing that's not intended. -- -- Ticket URL: <http://trac.macports.org/ticket/17412#comment:3> MacPorts <http://www.macports.org/> Ports system for Mac OS
#17412: mysql5 5.0.67_1+server - mysql_install_db errors -----------------------------------+---------------------------------------- Reporter: edmond@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Keywords: | Port: mysql5 -----------------------------------+---------------------------------------- Comment(by ryandesign@…): mysql5 does not install a file ${prefix}/etc/my.cnf. It installs these files: {{{ ${prefix}/share/mysql5/mysql/my-huge.cnf ${prefix}/share/mysql5/mysql/my-innodb-heavy-4G.cnf ${prefix}/share/mysql5/mysql/my-large.cnf ${prefix}/share/mysql5/mysql/my-medium.cnf ${prefix}/share/mysql5/mysql/my-small.cnf }}} The prefix is properly substituted in each of those files. You are meant to copy one of these files to ${prefix}/etc/mysql5/my.cnf and modify to suit. -- Ticket URL: <http://trac.macports.org/ticket/17412#comment:4> MacPorts <http://www.macports.org/> Ports system for Mac OS
#17412: mysql5 5.0.67_1+server - mysql_install_db errors -----------------------------------+---------------------------------------- Reporter: edmond@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Keywords: | Port: mysql5 -----------------------------------+---------------------------------------- Comment(by edmond@…): Thanks. -- Ticket URL: <http://trac.macports.org/ticket/17412#comment:5> MacPorts <http://www.macports.org/> Ports system for Mac OS
#17412: mysql5 5.0.67_1+server - mysql_install_db errors -----------------------------------+---------------------------------------- Reporter: edmond@… | Owner: ryandesign@… Type: defect | Status: new Priority: Normal | Milestone: Port Bugs Component: ports | Version: 1.6.0 Keywords: | Port: mysql5 -----------------------------------+---------------------------------------- Comment(by edmond@…): Perhaps the usability for people, like myself, who aren't familiar with mysql administration or MacPorts, would be higher is a default my.cnf was installed and variants could be chosen to select the others? Not sure if that has been considered, so I thought I'd suggest it. -- Ticket URL: <http://trac.macports.org/ticket/17412#comment:6> MacPorts <http://www.macports.org/> Ports system for Mac OS
participants (1)
-
MacPorts