mysql

[sudha]

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

iam getting the above error message

i tried all these..

updatedb
locatemysqld.sock
locatemysql.sock

but i cud'nt find anything

please help me..

[till]

Please post the output of:

netstat -tap

and

ps aux | grep mysql

[sudha]

OUTPUT OF netstat -tap

(Not all processes could be identified, non-owned process info
will not be shown, you would have to be root to see it all.)
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 localhost.localdo:32769 *:* LISTEN -
tcp 0 0 localhost.localdo:32770 *:* LISTEN -
tcp 0 0 *:netbios-ssn *:* LISTEN -
tcp 0 0 localhost.localdoma:ipp *:* LISTEN -
tcp 0 0 *:smtp *:* LISTEN -
tcp 0 0 *:microsoft-ds *:* LISTEN -
tcp 0 0 192.168.0.7:60368 192.217.199.105:www TIME_WAIT -
tcp 0 0 192.168.0.7:35364 213.200.109.22:www ESTABLISHED8559/firefox-bin
tcp 0 0 192.168.0.7:58374 cs52.msg.dcn.yahoo:5050 ESTABLISHED8526/gaim
tcp 0 0 localhost.localdo:32769 localhost.localdo:40429 ESTABLISHED-
tcp 0 0 192.168.0.7:53660 red.as-us.falkag.ne:www TIME_WAIT -
tcp 0 0 192.168.0.7:53658 red.as-us.falkag.ne:www TIME_WAIT -
tcp 0 0 localhost.localdoma:ipp localhost.localdo:52588 ESTABLISHED-
tcp 0 0 192.168.0.7:47183 209.50.189.199:www TIME_WAIT -
tcp 0 0 192.168.0.7:39536 209.50.189.199:www ESTABLISHED8559/firefox-bin
tcp 0 0 192.168.0.7:58866 66.249.89.99:www ESTABLISHED8559/firefox-bin
tcp 0 0 192.168.0.7:58851 66.249.89.99:www ESTABLISHED8559/firefox-bin
tcp 0 0 localhost.localdo:52588 localhost.localdoma:ipp ESTABLISHED8524/gnome-cups-ico
tcp 0 0 localhost.localdo:40429 localhost.localdo:32769 ESTABLISHED-
tcp6 0 0 *:www *:* LISTEN -

OUT PUT OF ps aux | grep mysql
sudhagar 14178 0.0 0.1 2936 608 pts/2 R+ 18:28 0:00 grep mysql

[falko]

MySQL isn't running at all. Please start it:

/etc/init.d/mysql start

or

/etc/init.d/mysqld start

(depends on your distribution).

[Craig]

Originally Posted by falko

MySQL isn't running at all. Please start it:

If you are in the ISPConfig web interface, you can also go to [Management] > [Server] > [Services] and restart it from there. If one or both of these two methods don't work, you definitely should post back because something a bit more serious is wrong.

[sudha]

i got the below error when i tried /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!

[till]

Which errors do you get in your syslog (/var/log/syslog or /var/log/messages)?

[sudha]

my syslog file looks sm thing like this..

1 Jan 2 13:07:55 localhost syslogd 1.4.1#17ubuntu3: restart.
2 Jan 2 13:07:55 localhost anacron[8531]: Job `cron.daily' terminated
3 Jan 2 13:07:55 localhost anacron[8531]: Normal exit (1 job run)
4 Jan 2 13:09:01 localhost /USR/SBIN/CRON[9340]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxlifetime) -print0 | xargs -r -0 rm)
5 Jan 2 13:10:58 localhost kernel: [4295288.549000] atkbd.c: Unknown key pressed (translated set 2, code 0xaa on isa0060/serio0).
6 Jan 2 13:10:58 localhost kernel: [4295288.549000] atkbd.c: Use 'setkeycodes e02a <keycode>' to make it known.
7 Jan 2 13:11:00 localhost kernel: [4295289.817000] atkbd.c: Unknown key released (translated set 2, code 0xaa on isa0060/serio0).
8 Jan 2 13:11:00 localhost kernel: [4295289.817000] atkbd.c: Use 'setkeycodes e02a <keycode>' to make it known.
(translated set 2, code 0xaa on isa0060/serio0).

...

.
.
.

47,1 Top

[falko]

What's the output of

ls -la /var/run/mysqld

?

Which distribution do you use?

[sudha]

The output of ls -la /var/run/mysqld is..
total 8
drwxr-xr-x 2 mysql root 4096 2006-12-15 20:46 .
drwxr-xr-x 16 root root 4096 2007-01-04 14:36 ..