Thought I'd share this experience so that other's avoid the same.
I installed Kanotix to the harddrive, upgraded to MySQL 4.0 and now
cannot seem to start a MySQL server. I keep getting this error:
[EMAIL PROTECTED]:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld...failed.
Please take a look at the syslog.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/
mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/
mysqld.sock' exists!
I checked the logs:
Sep 27 15:29:07 kanotix mysqld_safe[14096]: started
Sep 27 15:29:07 kanotix mysqld[14100]: 050927 19:29:07 /usr/sbin/
mysqld: unknown variable 'old_passwords=1'
Sep 27 15:29:07 kanotix mysqld[14100]:
Sep 27 15:29:07 kanotix mysqld_safe[14102]: ended
Sep 27 15:29:13 kanotix /etc/init.d/mysql[14171]: 0 processes alive
and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping'
resulted in
Sep 27 15:29:13 kanotix /etc/init.d/mysql[14171]: ^G/usr/bin/
mysqladmin: connect to server at 'localhost' failed
Sep 27 15:29:13 kanotix /etc/init.d/mysql[14171]: error: 'Can't
connect to local MySQL server through socket '/var/run/mysqld/
mysqld.sock' (2)'
Sep 27 15:29:13 kanotix /etc/init.d/mysql[14171]: Check that mysqld
is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Sep 27 15:29:13 kanotix /etc/init.d/mysql[14171]:
Normally I read errors bottom to top. So, I was browsing the
filesystem for the socket and googling for help with the socket
error. That got me nowhere.
Turns out that the problem seems to be with old_passwords. But where
is old_passwords? A quick grep:
[EMAIL PROTECTED]:~# grep -B 2 -r old /etc/mysql/
/etc/mysql/my.cnf-# For compatibility to other Debian packages that
still use
/etc/mysql/my.cnf-# libmysqlclient10 and libmysqlclient12.
/etc/mysql/my.cnf:# old_passwords = 1
I commented out that problem and now MySQL starts up just fine.
What a pain in the neck, but I learned two things:
1) Debian seems to use /var/log/syslog in addition to /var/log/
message. In other words, check both.
2) Debian is sufficiently different from Red Hat for there to be a
significant learning curve.
Regards,
- Robert
http://www.cwelug.org/downloads
Help others get OpenSource software. Distribute FLOSS
for Windows, Linux, *BSD, and MacOS X with BitTorrent
_______________________________________________
CWE-LUG mailing list
[email protected]
http://www.cwelug.org/
http://www.cwelug.org/archives/
http://www.cwelug.org/mailinglist/
