Re: FreeBSD Port: mysql-server-5.5.9
On 03/10/11 11:37, joeb wrote: I have been using mysql since fbsd 7.2 and always just issued the mysql_install_db command on the command line to create mysql's control databases and it always worked fine. But now with fbsd 8.2 I get the following error and have no idea why. I installed using pkg_add -r mysql55-server command. I see that 3 weeks ago you updated the mysql55-server port from mysql 554 to 559. I believe there is an error in your update causing the mysql_install_db command to error out. The error message follows. # /usr/local/binmysql_install_db --user=mysql or #rootmysql_install_db --user=mysql FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. * end of error msg. # /usr/local/binlocate my_print_defaults /usr/local/bin/my_print_defaults As you can see the script the error message says it can not find is really in the same location as the mysql_install_db script, so it should have found it. I ended up pointing to the 8.1 packages with the pkg-add command to install and then the mysql-server5.5.4 mysql_install_db command ran from the command line without any errors. ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org The problem appears to be in the mysql_install_db script # All unrecognized arguments to this script are passed to mysqld. basedir= *Should be /usr/local* builddir= ldata=./data langdir= srcdir= I suspect that when the mysql_install_db script was generated that the source for the mysql_install_db was update/modified/changed: basedir= *mysql-5.5.9/scripts* builddir= ldata=@localstatedir@ langdir= srcdir= I suspect that@bindir@ would be the appropriate value. But if you do this you get: basedir=./bin builddir= ldata=./data langdir= srcdir= I suspect that given the level of complexity of the build process that trying to patch the source files to fix this would be extremely difficult. The other approach is to modify the PORT Makefile and have the mysql_install_db modified before installation with the correct binary directory. -- Patrick Powell Astart Technologies papow...@astart.com1530 Jamacha Road, Suite X, Network and System San Diego, CA 92019 Consulting 858-874-6543 Web Site: www.astart.com ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
Re: FreeBSD Port: mysql-server-5.5.9
joeb ha scritto: If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. You should use the rc.d script, or pass --basedir=/usr/local -- Alex Dupre ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
RE: FreeBSD Port: mysql-server-5.5.9
-Original Message- From: Alex Dupre [mailto:a...@freebsd.org] Sent: Friday, March 11, 2011 3:43 AM To: j...@a1poweruser.com Cc: po...@freebsd.org Subject: Re: FreeBSD Port: mysql-server-5.5.9 joeb ha scritto: If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. You should use the rc.d script, or pass --basedir=/usr/local -- Alex Dupre You need to re-read the original post. You have missed the meaning of the problem. Some testing on your part to reproduce the problem is required. ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
FreeBSD Port: mysql-server-5.5.9
I have been using mysql since fbsd 7.2 and always just issued the mysql_install_db command on the command line to create mysql's control databases and it always worked fine. But now with fbsd 8.2 I get the following error and have no idea why. I installed using pkg_add -r mysql55-server command. I see that 3 weeks ago you updated the mysql55-server port from mysql 554 to 559. I believe there is an error in your update causing the mysql_install_db command to error out. The error message follows. # /usr/local/bin mysql_install_db --user=mysql or #root mysql_install_db --user=mysql FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. * end of error msg. # /usr/local/bin locate my_print_defaults /usr/local/bin/my_print_defaults As you can see the script the error message says it can not find is really in the same location as the mysql_install_db script, so it should have found it. I ended up pointing to the 8.1 packages with the pkg-add command to install and then the mysql-server5.5.4 mysql_install_db command ran from the command line without any errors. ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
Re: FreeBSD Port: mysql-server-5.5.9
On Thu, 10 Mar 2011 14:37:20 -0500 joeb j...@a1poweruser.com articulated: I have been using mysql since fbsd 7.2 and always just issued the mysql_install_db command on the command line to create mysql's control databases and it always worked fine. But now with fbsd 8.2 I get the following error and have no idea why. I installed using pkg_add -r mysql55-server command. I see that 3 weeks ago you updated the mysql55-server port from mysql 554 to 559. I believe there is an error in your update causing the mysql_install_db command to error out. The error message follows. # /usr/local/bin mysql_install_db --user=mysql or #root mysql_install_db --user=mysql FATAL ERROR: Could not find ./bin/my_print_defaults If you compiled from source, you need to run 'make install' to copy the software into the correct location ready for operation. If you are using a binary release, you must either be at the top level of the extracted archive, or pass the --basedir option pointing to that location. * end of error msg. # /usr/local/bin locate my_print_defaults /usr/local/bin/my_print_defaults As you can see the script the error message says it can not find is really in the same location as the mysql_install_db script, so it should have found it. I ended up pointing to the 8.1 packages with the pkg-add command to install and then the mysql-server5.5.4 mysql_install_db command ran from the command line without any errors. How do you start mysql, via the command line or using the rc.d script? -- Jerry ✌ freebsd-ports.u...@seibercom.net Disclaimer: off-list followups get on-list replies or get ignored. Please do not ignore the Reply-To header. __ ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
Re: FreeBSD Port: mysql-server-5.5.9
On Thu, 10 Mar 2011, joeb wrote: I have been using mysql since fbsd 7.2 and always just issued the mysql_install_db command on the command line to create mysql's control databases and it always worked fine. But now with fbsd 8.2 I get the following error and have no idea why. I installed using pkg_add -r mysql55-server command. I see that 3 weeks ago you updated the mysql55-server port from mysql 554 to 559. I believe there is an error in your update causing the mysql_install_db command to error out. The error message follows. # /usr/local/bin mysql_install_db --user=mysql or #root mysql_install_db --user=mysql I'm not sure I follow this, but if you have an existing db, the command to issue IMMEDIATELY after updating mysql is mysql_upgrade. (see man mysql_upgrade). If mysql_upgrade it not necessary (for example in a reinstall) it will say so harmlessly. Error messages you may get if you fail to mysql_upgrade, in my experience, vary from not pertinent to completely misleading. -- Lars Eighner http://www.larseighner.com/index.html 8800 N IH35 APT 1191 AUSTIN TX 78753-5266 ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
Re: FreeBSD Port: mysql-server-5.5.9
On Mar 10, 2011, at 11:37 AM, joeb wrote: FATAL ERROR: Could not find ./bin/my_print_defaults Does running rehash in your shell help it find the binary? Or does using --basedir /usr/local/bin help? Regards, -- -Chuck ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org
RE: FreeBSD Port: mysql-server-5.5.9
Tried that with on results. -Original Message- From: Chuck Swiger [mailto:cswi...@mac.com] Sent: Thursday, March 10, 2011 3:26 PM To: j...@a1poweruser.com Cc: FreeBSD Ports Mailing List Subject: Re: FreeBSD Port: mysql-server-5.5.9 On Mar 10, 2011, at 11:37 AM, joeb wrote: FATAL ERROR: Could not find ./bin/my_print_defaults Does running rehash in your shell help it find the binary? Or does using --basedir /usr/local/bin help? Regards, -- -Chuck ___ freebsd-ports@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-ports To unsubscribe, send any mail to freebsd-ports-unsubscr...@freebsd.org