[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

FIXED Re: MySql will not restart



Out of desperation, I apt-get(ted) the latest stable mysql-server.

The only thing I can think of is that an upgrade of a package earlier in the week caused problems when logs were rotated this a.m.





----- Original Message ----
From: harland christofferson <debian-user@audubonstrings.com>
To: debian-user@lists.debian.org
Sent: Sunday, October 14, 2007 8:43:50 AM
Subject: MySql will not restart

running 2.4.27-2-k7

For years, MySql was running fine.

This a.m., webpages were not being served.

I thought that it was MySql.

I tried this:

#/etc/init.d/mysql restart

I received this:

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 followed instructions:

#grep mysql /var/log/syslog

Yields:

 /etc/init.d/mysql[14242]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
/etc/init.d/mysql[14242]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
/etc/init.d/mysql[14242]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
/etc/init.d/mysql[14242]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

There is no /var/run/mysqld/mysqld.sock file

My /etc/mysql/debian.cnf is:

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = bnL0UFfwUuSv6Mb3
socket   = /var/run/mysqld/mysqld.sock

I can ping my localhost.

#ping localhost
PING localhost.gateway.2wire.net (127.0.0.1) 56(84) bytes of data.
64 bytes from www.audubonstrings.com (127.0.0.1): icmp_seq=1 ttl=64 time=0.106 ms
64 bytes from www.audubonstrings.com (127.0.0.1): icmp_seq=2 ttl=64 time=0.118 ms

The only think I can think of is that this is somehow resolving to my ISP?

It has been a long time since I have pinged the localhost so I cannot recall if it used to be my domain or if it was always my ISP gateway.

If this is the problem, does anyone have a suggestion on how to repair?

 





Reply to: