#1  
Old 16th April 2006, 12:37
Richard Richard is offline
Junior Member
 
Join Date: Apr 2006
Location: Norway
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default MYSQL Will NOT start....

I see that I am not the only newbee that has had problems with MQSQL but please help. I have included the syslog at the bottom but this means little to me, perhaps some of you understand what it is trying to tell me? Under that again is what I get if I run an apt-get upgrade?

MySql will not start and I get the error 'ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)' when I do a mysql -p 'password'

I am running Debian Sarge with PHP4 and MySql. The system has been stable and I have installed a few applications the are using PHP4 and MySql, however yesterday I did something stupid and do not know how to fix it!

I was trying to get the mail server running with no luck at all and I read in one chat room that by doing an apt-get remove postfix postfix-tls libsas12 sas12-bin lisas12-modules ipod-ssl uw-imapd-sssl and then re-installing them that the mail server would work. It does NOT! And now MySQL is not working either.

I have run;
locate mysqld.sock
locate mysql.sock
And neither return a result so I guess that MySql is not actually running.

How do I start MySqld.sock ? I have seen lots of posts that say start this, and start that, but with no explanation of how too. Please Please help as I am desperate to get MySql working again.

Hope there is help out there for me.

Best regards

Richard.

/var/log/syslog
Apr 16 06:28:28 server1 syslogd 1.4.1#17: restart.
Apr 16 06:28:28 server1 postfix/pickup[1433]: E4A4C1CC1AB: uid=0 from=<root>
Apr 16 06:28:29 server1 postfix/cleanup[1616]: E4A4C1CC1AB: message-id=<20060416042828.E4A4C1CC1AB@server1.example.com >
Apr 16 06:28:29 server1 postfix/qmgr[1050]: E4A4C1CC1AB: from=<root@richard@rbuckley.com>, size=903, nrcpt=1 (queue active)
Apr 16 06:28:31 server1 postfix/smtp[1618]: E4A4C1CC1AB: to=<root@richard@rbuckley.com>, orig_to=<root>, relay=mail1.123utpeking.no[212.247.$
Apr 16 06:28:31 server1 postfix/cleanup[1616]: A76BB1CC1A6: message-id=<20060416042831.A76BB1CC1A6@server1.example.com >
Apr 16 06:28:31 server1 postfix/qmgr[1050]: A76BB1CC1A6: from=<>, size=3085, nrcpt=1 (queue active)
Apr 16 06:28:31 server1 postfix/qmgr[1050]: E4A4C1CC1AB: removed
Apr 16 06:28:32 server1 postfix/smtp[1618]: A76BB1CC1A6: to=<root@richard@rbuckley.com>, relay=mail1.123utpeking.no[212.247.101.19], delay=1$
Apr 16 06:28:32 server1 postfix/qmgr[1050]: A76BB1CC1A6: removed
Apr 16 06:39:01 server1 /USR/SBIN/CRON[1622]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 06:47:01 server1 /USR/SBIN/CRON[1632]: (root) CMD (test -x /usr/sbin/anacron || run-parts --report /etc/cron.weekly)
Apr 16 06:47:04 server1 syslogd 1.4.1#17: restart.
Apr 16 07:04:33 server1 -- MARK --
Apr 16 07:09:01 server1 /USR/SBIN/CRON[1851]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 07:17:01 server1 /USR/SBIN/CRON[1861]: (root) CMD ( run-parts --report /etc/cron.hourly)
Apr 16 07:39:01 server1 /USR/SBIN/CRON[1863]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 08:04:33 server1 -- MARK --
Apr 16 08:09:01 server1 /USR/SBIN/CRON[1874]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 08:17:01 server1 /USR/SBIN/CRON[1884]: (root) CMD ( run-parts --report /etc/cron.hourly)
Apr 16 08:39:02 server1 /USR/SBIN/CRON[1886]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 09:00:01 server1 /USR/SBIN/CRON[1896]: (root) CMD (/usr/sbin/rdate 128.2.136.71 | logger -t NTP)
Apr 16 09:00:01 server1 postfix/pickup[1872]: C79E91CC1AB: uid=0 from=<root>
Apr 16 09:00:01 server1 postfix/cleanup[1901]: C79E91CC1AB: message-id=<20060416070001.C79E91CC1AB@server1.example.com >
Apr 16 09:00:01 server1 postfix/qmgr[1050]: C79E91CC1AB: from=<root@richard@rbuckley.com>, size=536, nrcpt=1 (queue active)
Apr 16 09:00:02 server1 postfix/smtp[1903]: C79E91CC1AB: to=<root@richard@rbuckley.com>, orig_to=<root>, relay=mail1.123utpeking.no[212.247.$
Apr 16 09:00:02 server1 postfix/cleanup[1901]: 612491CC1C0: message-id=<20060416070002.612491CC1C0@server1.example.com >
Apr 16 09:00:02 server1 postfix/qmgr[1050]: 612491CC1C0: from=<>, size=2718, nrcpt=1 (queue active)
Apr 16 09:00:02 server1 postfix/qmgr[1050]: C79E91CC1AB: removed
Apr 16 09:00:02 server1 postfix/smtp[1903]: 612491CC1C0: to=<root@richard@rbuckley.com>, relay=mail1.123utpeking.no[212.247.101.19], delay=0$
Apr 16 09:00:02 server1 postfix/qmgr[1050]: 612491CC1C0: removed
Apr 16 09:09:01 server1 /USR/SBIN/CRON[1906]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 09:17:01 server1 /USR/SBIN/CRON[1916]: (root) CMD ( run-parts --report /etc/cron.hourly)
Apr 16 09:39:01 server1 /USR/SBIN/CRON[1918]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 10:04:33 server1 -- MARK --
Apr 16 10:09:01 server1 /USR/SBIN/CRON[1929]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 10:17:02 server1 /USR/SBIN/CRON[1939]: (root) CMD ( run-parts --report /etc/cron.hourly)
Apr 16 10:39:01 server1 /USR/SBIN/CRON[1941]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 11:04:33 server1 -- MARK --
Apr 16 11:09:01 server1 /USR/SBIN/CRON[1951]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 11:17:01 server1 /USR/SBIN/CRON[1961]: (root) CMD ( run-parts --report /etc/cron.hourly)
Apr 16 11:39:01 server1 /USR/SBIN/CRON[1975]: (root) CMD ( [ -d /var/lib/php4 ] && find /var/lib/php4/ -type f -cmin +$(/usr/lib/php4/maxli$
Apr 16 11:52:15 server1 postfix/postfix-script: stopping the Postfix mail system
Apr 16 11:52:15 server1 postfix/master[1043]: terminating on signal 15
Apr 16 11:52:16 server1 postfix/postfix-script: starting the Postfix mail system
Apr 16 11:52:16 server1 postfix/master[2103]: daemon started -- version 2.1.5
Apr 16 12:04:33 server1 -- MARK --

apt-get upgrade
server1:/usr/lib# apt-get upgrade
Reading Package Lists... Done
Building Dependency Tree... Done
The following packages have been kept back:
kernel-image-2.4-686
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.
3 not fully installed or removed.
Need to get 0B of archives.
After unpacking 0B of additional disk space will be used.
Do you want to continue? [Y/n] y
Setting up ipopd (2002edebian1-11sarge1) ...
WARNING: Port "pop2" unselected in debconf but possibly handled locally.
Creating generic self-signed certificate: /etc/ssl/certs/ipop3d.pem
(replace with hand-crafted or authorized one if needed).
hostname: Unknown host
dpkg: error processing ipopd (--configure):
subprocess post-installation script returned error exit status 1
Setting up uw-imapd (2002edebian1-11sarge1) ...
WARNING: Port "imap3" unselected in debconf but possibly handled locally.
Creating generic self-signed certificate: /etc/ssl/certs/imapd.pem
(replace with hand-crafted or authorized one if needed).
hostname: Unknown host
dpkg: error processing uw-imapd (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of uw-imapd-ssl:
uw-imapd-ssl depends on uw-imapd (>= 4:2002.rc7debian); however:
Package uw-imapd is not configured yet.
dpkg: error processing uw-imapd-ssl (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
ipopd
uw-imapd
uw-imapd-ssl
E: Sub-process /usr/bin/dpkg returned an error code (1)

Last edited by Richard; 16th April 2006 at 13:13.
Reply With Quote
Sponsored Links
  #2  
Old 16th April 2006, 14:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

What's the output of
Code:
/etc/init.d/mysql restart
and
Code:
ls -l /var/run/mysqld/mysqld.sock
and
Code:
netstat -tap
and
Code:
ps aux | grep -i mysql
(in that order)?
__________________
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
  #3  
Old 16th April 2006, 14:38
Richard Richard is offline
Junior Member
 
Join Date: Apr 2006
Location: Norway
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySql Problems.....

Hi,

I have cut a pasted exactly what I did and the results that I got directly from Putty.

Thanks for replying I only hope that you can help...

Last login: Sun Apr 16 14:17:16 2006 from p54836b51.dip.t-dialin.net
server1:~# /etc/init.d/mysql restart
server1:~# ls -l /var/run/mysqld/mysqld.sock
ls: /var/run/mysqld/mysqld.sock: No such file or directory
server1:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
PID/Program name
tcp 0 0 *:imaps *:* LISTEN 9
45/inetd
tcp 0 0 *op3s *:* LISTEN 9
45/inetd
tcp 0 0 *op3 *:* LISTEN 9
45/inetd
tcp 0 0 *:imap2 *:* LISTEN 9
45/inetd
tcp 0 0 *:www *:* LISTEN 1
083/apache2
tcp 0 0 *:ssh *:* LISTEN 1
063/sshd
tcp 0 0 *:smtp *:* LISTEN 1
042/master
tcp 0 0 *:https *:* LISTEN 1
083/apache2
tcp 0 0 debianbox.com:ssh p54836B51.dip.t-di:1202 ESTABLISHED1
142/sshd: root@not
tcp 0 148 debianbox.com:ssh 192.168.1.33:2843 ESTABLISHED1
150/1
tcp 0 0 debianbox.com:ssh p54836B51.dip.t-di:1196 ESTABLISHED1
126/0
server1:~# /etc/init.d/mysql restart
server1:~# ls -l /var/run/mysqld/mysqld.sock
ls: /var/run/mysqld/mysqld.sock: No such file or directory
server1:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN 945/inetd
tcp 0 0 *op3s *:* LISTEN 945/inetd
tcp 0 0 *op3 *:* LISTEN 945/inetd
tcp 0 0 *:imap2 *:* LISTEN 945/inetd
tcp 0 0 *:www *:* LISTEN 1083/apache2
tcp 0 0 *:ssh *:* LISTEN 1063/sshd
tcp 0 0 *:smtp *:* LISTEN 1042/master
tcp 0 0 *:https *:* LISTEN 1083/apache2
tcp 0 0 debianbox.com:ssh p54836B51.dip.t-di:1202 ESTABLISHED1142/sshd: root@not
tcp 0 148 debianbox.com:ssh 192.168.1.33:2843 ESTABLISHED1150/1
tcp 0 0 debianbox.com:ssh p54836B51.dip.t-di:1196 ESTABLISHED1126/0
server1:~# ps aux | grep -i mysql
server1:~#
Reply With Quote
  #4  
Old 16th April 2006, 15:10
Richard Richard is offline
Junior Member
 
Join Date: Apr 2006
Location: Norway
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySql Problems

Hi Again,

I hope that I'm not just throwing too much bad infomation at you as I know that you are trying to help. I just read a tip in another forum and they suggested this;

server1:/var/run# mysqladmin -h host_name variables
mysqladmin: connect to server at 'host_name' failed
error: 'Unknown MySQL Server Host 'host_name' (1)'
Check that mysqld is running on host_name and that the port is 3306.
You can check this by doing 'telnet host_name 3306'

So I tried to do the telenet........

server1:/var/run# telnet localhost 3306
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection refused
server1:/var/run#

It didn't help but I thought the error messages might help you help me?

Richard
Reply With Quote
  #5  
Old 16th April 2006, 15:38
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Can you post the output of
Code:
updatedb
locate mysqld.sock
locate mysql.sock
?
__________________
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
  #6  
Old 16th April 2006, 15:44
Richard Richard is offline
Junior Member
 
Join Date: Apr 2006
Location: Norway
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySql Problems

Hi Falko,

Thanks for taking the time to help me with this....
I need shooting.....

The outputs that you asked for were;

server1:~# updatedb
server1:~# locate mysqld.sock
server1:~# locate mysql.sock
server1:~#

This I guess is NOT good news!

Richard
Reply With Quote
  #7  
Old 16th April 2006, 19:47
Richard Richard is offline
Junior Member
 
Join Date: Apr 2006
Location: Norway
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySql Problems.....

After an afternoon of trying all the MySql Forums and trying anything and everything I tried these commands again that you asked me about earlier….

/etc/init.d/mysql restart

ls -l /var/run/mysqld/mysqld.sock

netstat -tap

ps aux | grep -i mysql

The output of these commands is now;

server1:/etc/init.d# /etc/init.d/mysql restart
server1:/etc/init.d# ls -l /var/run/mysqld/mysqld.sock
ls: /var/run/mysqld/mysqld.sock: No such file or directory
server1:/etc/init.d# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN 1797/couriertcpd
tcp 0 0 *op3s *:* LISTEN 1712/couriertcpd
tcp 0 0 *op3 *:* LISTEN 1655/couriertcpd
tcp 0 0 *:imap2 *:* LISTEN 1748/couriertcpd
tcp 0 0 *:www *:* LISTEN 1083/apache2
tcp 0 0 *:ssh *:* LISTEN 1063/sshd
tcp 0 0 *:smtp *:* LISTEN 1904/master
tcp 0 0 *:https *:* LISTEN 1083/apache2
tcp 0 0 debianbox.com:ssh 192.168.1.33:3237 ESTABLISHED1962/sshd: root@not
tcp 0 148 debianbox.com:ssh 192.168.1.33:3096 ESTABLISHED1283/0
server1:/etc/init.d# ps aux | grep -i mysql
root 1982 0.0 0.3 2256 984 pts/0 T 16:18 0:00 nano /usr/include/mysql/mysql_embed.h
root 2249 0.0 0.4 2256 1036 pts/0 T 19:25 0:00 nano mysqld_error.h
root 2259 0.0 0.3 2256 1012 pts/0 T 19:32 0:00 nano mysql.log
root 2260 0.0 0.3 2256 1012 pts/0 T 19:32 0:00 nano mysql.err
root 2292 0.0 0.3 2256 1020 pts/0 T 19:39 0:00 nano mysql
root 2301 0.0 0.2 1824 584 pts/0 S+ 19:42 0:00 grep -i mysql

Please help!

Richard

Last edited by Richard; 16th April 2006 at 19:50.
Reply With Quote
  #8  
Old 17th April 2006, 09:14
Richard Richard is offline
Junior Member
 
Join Date: Apr 2006
Location: Norway
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Would this work?

Hi Falko,

What do you think would happen if;

I made a copy of the files in /etc/lib/mysql/mysql
Then did a full re-install of MySql -
then replaced the files in /etc/lib/mysql/mysql with the copy that I took?

Do you think that all the data would be preserved or is that too simple?

Richard
Reply With Quote
  #9  
Old 17th April 2006, 10:54
Richard Richard is offline
Junior Member
 
Join Date: Apr 2006
Location: Norway
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default Problem solved

Ok so I messed up and this problem was all my own fault.

The solution that finally worked was;

A re-install of mysql-server (Nothing else)

All databases and tables were preserved.

Thanks for the help

Richard
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
ERROR: The PHP binary coming with ISPConfig does not work properly on your system! qvindesland Installation/Configuration 22 21st May 2007 16:05
empty recycle bin + commit changes immediately Ovidiu General 10 18th January 2006 21:19
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
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 09:41


All times are GMT +2. The time now is 14:01.


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