#1  
Old 29th December 2006, 13:51
sudha sudha is offline
Junior Member
 
Join Date: Dec 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy mysql

#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..
Reply With Quote
Sponsored Links
  #2  
Old 29th December 2006, 13:53
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,240 Times in 4,108 Posts
Default

Please post the output of:

netstat -tap

and

ps aux | grep mysql
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 29th December 2006, 13:59
sudha sudha is offline
Junior Member
 
Join Date: Dec 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #4  
Old 30th December 2006, 21:24
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
Default

MySQL isn't running at all. Please start it:
Code:
/etc/init.d/mysql start
or
Code:
/etc/init.d/mysqld start
(depends on your distribution).
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 31st December 2006, 15:55
Craig Craig is offline
Member
 
Join Date: Dec 2006
Posts: 56
Thanks: 1
Thanked 3 Times in 1 Post
Default

Quote:
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.
Reply With Quote
  #6  
Old 2nd January 2007, 09:09
sudha sudha is offline
Junior Member
 
Join Date: Dec 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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!
Reply With Quote
  #7  
Old 2nd January 2007, 09:20
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,461
Thanks: 813
Thanked 5,240 Times in 4,108 Posts
Default

Which errors do you get in your syslog (/var/log/syslog or /var/log/messages)?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #8  
Old 2nd January 2007, 10:31
sudha sudha is offline
Junior Member
 
Join Date: Dec 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #9  
Old 3rd January 2007, 17:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,727 Times in 2,565 Posts
Default

What's the output of
Code:
ls -la /var/run/mysqld
?

Which distribution do you use?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #10  
Old 4th January 2007, 10:58
sudha sudha is offline
Junior Member
 
Join Date: Dec 2006
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

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 ..
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
Can't Remote Access mysql 4.1 dedibox Installation/Configuration 2 24th August 2006 10:32
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 20:26.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.