Re: Catastrophic Installation Failure now!
The problem was caused by a permission change in the mysql data directory, in my case /disk02/db/mysql/DATA - why and how is beyond my comprehension. It would be a good tactic for developers to to include a troubleshooting script to check directory permissions in installations, as this is such a common problem. At a minimum a simple checklist would help. I have had situations where I have looked at files/directories after an installation and could not tell what it should be. Thanks again! jaymax wrote: MAJOR SCREWUP I was frustrated by a failure to create a ROOT password and decided to do a clean reinstall Did a make deinstall from the following ports -- View this message in context: http://old.nabble.com/Catastrophic-Installation-Failure-now%21-tp27100257p27126987.html Sent from the freebsd-questions mailing list archive at Nabble.com. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Catastrophic Installation Failure now!
Running 'mysqlcheck with default connection arguments /usr/local/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) when trying to connect FATAL ERROR: Upgrade failed Registered packages are now : # pkg_info | grep mysql bsdpan-DBD-mysql-4.013 DBD::mysql - MySQL driver for the Perl5 Database Interface mysql-client-5.4.3 Multithreaded SQL database (client) mysql-scripts-5.4.3 Multithreaded SQL database (scripts) mysql-server-5.4.3 Multithreaded SQL database (server) php5-mysql-5.2.11_1 The mysql shared extension for php php5-mysqli-5.2.12 The mysqli shared extension for php qt4-mysql-plugin-4.4.3 Qt MySQL database plugin WHAT THE ***bleep*** AM I DOING WRONG ? -- View this message in context: http://old.nabble.com/Catastrophic-Installation-Failure-now%21-tp27100257p27100257.html Sent from the freebsd-questions mailing list archive at Nabble.com. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Catastrophic Installation Failure now!
On Sun, 10 Jan 2010, jaymax wrote: MAJOR SCREWUP I was frustrated by a failure to create a ROOT password and decided to do a clean reinstall Did a make deinstall from the following ports [i] /usr/ports/databases/mysql54-server [ii] /usr/ports/databases/mysql54-client [iii]/usr/ports/databases/mysql54-scripts Did a rm of the /etc/my.cnf file (There were no others in related or relevant areas) FreeBSD standard should be in /usr/local/etc. I don't know mysql, though. Reinstallation proceeded as follows: in /usr/ports/databases/mysql54-server == make 'pager=more' 'prompt=mysql54' 'socket=/usr/tmp/mysql.sock' 'localstatedir=/disk02/db/mysql/DATA' 'with_linuxthreads=yes' 'with_ssl=yes' install clean in /usr/ports/databases/mysql54-scripts == make install clean mysql client apparently installed as a dependency by the server Those are outdated ports, or at least the only thing close in my ports tree is mysql55. Did the following: [i]/usr/local/bin/mysql_install_db then [ii] /usr/local/bin/mysqld_safe first startup Stdout == [1] 37786 ax# 100110 07:05:36 mysqld_safe Logging to '/disk02/db/mysql/DATA/ax.lall.com.err'. ... 100110 7:05:38 [ERROR] Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13) According to some web searching, host.frm is supposed to be created by mysql_install_db. Looking at the log file it created may help; suspect directory ownership or permissions, or maybe it is working in the wrong directory entirely. -Warren Block * Rapid City, South Dakota USA ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Catastrophic Installation Failure now!
On Sun, 10 Jan 2010 09:17:35 -0800 (PST) jaymax jayma...@gmail.com articulated: I was frustrated by a failure to create a ROOT password and decided to do a clean reinstall Did a make deinstall from the following ports [i] /usr/ports/databases/mysql54-server [ii] /usr/ports/databases/mysql54-client [iii]/usr/ports/databases/mysql54-scripts Did a rm of the /etc/my.cnf file (There were no others in related or relevant areas) Try this. pkg_delete -dfv mysql* That should delete all traces of MySQL You might also want to backup the contents of the /var/db/mysql folder also. In any case, delete the folder and it contents. While you are at it, delete the files in /usr/ports/distfiles also. Update the ports tree, and cd to the version of mysql you want to install. Run make config to insure it is configured correctly. Run; make install make clean Make sure that the correct entry is in the /etc/rc.conf file to enable MySQL to start on boot. I think it is: mysql_enable=YES. Either reboot or cd to the /usr/local/etc/rc.d directory and run the mysql startup script. I believe ./mysql is correct. This should create all of the necessary files and directories you need to initialise MySQL. -- Jerry ges...@yahoo.com ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org