I'm upgrade to ubuntu 9.10 with ISPConfig 2 and encountered a major problem (for me atleat) where I'm unable to connect to my database. When accessing my site I get " Database Error: Unable to connect to the database. Could not connect to MySQL." when I try the ISPConfig panel the error is " The server is not responding ( or the local MySQL server's socket is not correctly configured)". I can stop mysql but get an error when I restart or force-reload get the error of missing /var/run/mysqld/mysqld.sock. Also realize that /../../../mysqld.pid is missing too. Been reading and searching but can't seem to get any help. this only happen after upgrade Ubuntu.
@webserver1:~# ls -la /var/run/mysqld total 0 drwxr-xr-x 2 mysql root 40 2009-12-07 13:06 . drwxr-xr-x 14 root root 560 2009-12-08 14:58 ..
Looks ok. Did you check your logs? Can you post the exact error message that you see when you try to restart MySQL?
Please check /var/log/syslog. Can you post the exact error message that you see when you try to restart MySQL?
webserver1:~# /etc/init.d/mysql restart * Stopping MySQL database server mysqld [ OK ] * Starting MySQL database server mysqld [fail] and the syslog HTML: Dec 10 06:49:32 webserver1 rsyslogd: [origin software="rsyslogd" swVersion="4.2.0" x-pid="663" x-info="http://www.rsyslog.com"] rsyslogd was HUPed, type 'lightweight'. Dec 10 06:49:56 webserver1 ntpd[19905]: kernel time sync status change 2001 Dec 10 06:50:23 webserver1 postfix/pickup[22428]: 067734B0001: uid=0 from=<root> Dec 10 06:50:23 webserver1 postfix/cleanup[12975]: 067734B0001: message-id=<[email protected]> Dec 10 06:50:23 webserver1 postfix/qmgr[1467]: 067734B0001: from=<[email protected]>, size=2422, nrcpt=1 (queue active) Dec 10 06:50:23 webserver1 postfix/local[13000]: 067734B0001: to=<[email protected]>, orig_to=<root>, relay=local, delay=0.08, delays=0.05/0.02/0/0.01, dsn=2.0.0, status=sent (delivered to command: procmail -a "EXTENSION") Dec 10 06:50:23 webserver1 postfix/qmgr[1467]: 067734B0001: removed Dec 10 07:00:01 webserver1 CRON[13119]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 07:00:01 webserver1 postfix/smtpd[13122]: warning: ::1: address not listed for hostname localhost Dec 10 07:00:01 webserver1 postfix/smtpd[13122]: connect from unknown[::1] Dec 10 07:00:01 webserver1 postfix/smtpd[13122]: lost connection after CONNECT from unknown[::1] Dec 10 07:00:01 webserver1 postfix/smtpd[13122]: disconnect from unknown[::1] Dec 10 07:05:04 webserver1 named[929]: network unreachable resolving 'apache.org/NS/IN': 2001:500:e::1#53 Dec 10 07:05:04 webserver1 named[929]: network unreachable resolving 'apache.org/NS/IN': 2001:610:3:200a:192:87:36:2#53 Dec 10 07:05:04 webserver1 named[929]: network unreachable resolving '0.ns.spamhaus.org/AAAA/IN': 2001:630:1:106::6#53 Dec 10 07:05:04 webserver1 named[929]: network unreachable resolving '61.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 07:05:06 webserver1 named[929]: network unreachable resolving '8.13.156.64.sbl.spamhaus.org/TXT/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 07:09:01 webserver1 CRON[13236]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 07:17:01 webserver1 CRON[13344]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 10 07:24:07 webserver1 ntpd[19905]: kernel time sync status change 6001 Dec 10 07:24:14 webserver1 named[929]: client 24.124.127.38#4144: query (cache) 'www.google.com/A/IN' denied Dec 10 07:30:01 webserver1 CRON[13505]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 07:30:01 webserver1 postfix/smtpd[13507]: warning: ::1: address not listed for hostname localhost Dec 10 07:30:01 webserver1 postfix/smtpd[13507]: connect from unknown[::1] Dec 10 07:30:01 webserver1 postfix/smtpd[13507]: lost connection after CONNECT from unknown[::1] Dec 10 07:30:01 webserver1 postfix/smtpd[13507]: disconnect from unknown[::1] Dec 10 07:33:05 webserver1 named[929]: network unreachable resolving '209.34.55.65.iadb.isipp.com/A/IN': 2001:470:1:41:a800:ff:fe50:3143#53 Dec 10 07:33:05 webserver1 named[929]: network unreachable resolving 'ns3.clickaction.net/AAAA/IN': 2001:503:a83e::2:30#53 Dec 10 07:35:29 webserver1 named[929]: connection refused resolving '136.63.33.216.sa-other.bondedsender.org/TXT/IN': 84.243.213.38#53 Dec 10 07:35:29 webserver1 named[929]: connection refused resolving '34.190.54.65.sa-trusted.bondedsender.org/TXT/IN': 84.243.213.38#53 Dec 10 07:39:01 webserver1 CRON[13622]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 08:00:01 webserver1 CRON[13885]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 08:00:01 webserver1 postfix/smtpd[13887]: warning: ::1: address not listed for hostname localhost Dec 10 08:00:01 webserver1 postfix/smtpd[13887]: connect from unknown[::1] Dec 10 08:00:01 webserver1 postfix/smtpd[13887]: lost connection after CONNECT from unknown[::1] Dec 10 08:00:01 webserver1 postfix/smtpd[13887]: disconnect from unknown[::1] Dec 10 08:09:01 webserver1 CRON[14000]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 08:14:56 webserver1 named[929]: client 65.49.16.2#55823: query (cache) 'gis.gd/AAAA/IN' denied Dec 10 08:17:01 webserver1 CRON[14108]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 10 08:24:01 webserver1 freshclam[2017]: Received signal: wake up Dec 10 08:24:01 webserver1 freshclam[2017]: ClamAV update process started at Thu Dec 10 08:24:01 2009 Dec 10 08:24:01 webserver1 freshclam[2017]: SECURITY WARNING: NO SUPPORT FOR DIGITAL SIGNATURES Dec 10 08:24:01 webserver1 freshclam[2017]: See the FAQ at http://www.clamav.net/support/faq for an explanation. Dec 10 08:24:01 webserver1 freshclam[2017]: Your ClamAV installation is OUTDATED! Dec 10 08:24:01 webserver1 freshclam[2017]: Local version: 0.94.2 Recommended version: 0.95.3 Dec 10 08:24:01 webserver1 freshclam[2017]: DON'T PANIC! Read http://www.clamav.net/support/faq Dec 10 08:24:01 webserver1 freshclam[2017]: main.cld is up to date (version: 51, sigs: 545035, f-level: 42, builder: sven) Dec 10 08:24:31 webserver1 freshclam[2017]: nonblock_connect: connect timing out (30 secs) Dec 10 08:24:31 webserver1 freshclam[2017]: Can't connect to port 80 of host database.clamav.net (IP: 81.173.192.234) Dec 10 08:24:31 webserver1 freshclam[2017]: Trying host database.clamav.net (155.98.64.87)... Dec 10 08:24:32 webserver1 freshclam[2017]: Downloading daily-10145.cdiff [100%] Dec 10 08:24:32 webserver1 freshclam[2017]: Downloading daily-10146.cdiff [100%] Dec 10 08:24:32 webserver1 freshclam[2017]: daily.cld updated (version: 10146, sigs: 125757, f-level: 44, builder: arnaud) Dec 10 08:24:32 webserver1 freshclam[2017]: Your ClamAV installation is OUTDATED! Dec 10 08:24:32 webserver1 freshclam[2017]: Current functionality level = 38, recommended = 44 Dec 10 08:24:32 webserver1 freshclam[2017]: DON'T PANIC! Read http://www.clamav.net/support/faq Dec 10 08:24:32 webserver1 freshclam[2017]: Database updated (670792 signatures) from database.clamav.net (IP: 155.98.64.87) Dec 10 08:24:32 webserver1 freshclam[2017]: -------------------------------------- Dec 10 08:30:01 webserver1 CRON[14272]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 08:30:01 webserver1 postfix/smtpd[14275]: warning: ::1: address not listed for hostname localhost Dec 10 08:30:01 webserver1 postfix/smtpd[14275]: connect from unknown[::1] Dec 10 08:30:01 webserver1 postfix/smtpd[14275]: lost connection after CONNECT from unknown[::1] Dec 10 08:30:01 webserver1 postfix/smtpd[14275]: disconnect from unknown[::1] Dec 10 08:32:26 webserver1 ntpd[19905]: kernel time sync status change 2001 Dec 10 08:39:01 webserver1 CRON[14388]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 08:46:18 webserver1 named[929]: network unreachable resolving 'c.ns.chtah.com/A/IN': 2001:503:c27::2:30#53 Dec 10 08:46:18 webserver1 named[929]: network unreachable resolving 'c.ns.chtah.com/AAAA/IN': 2001:503:c27::2:30#53 Dec 10 08:46:18 webserver1 named[929]: network unreachable resolving 'c.ns.chtah.com/A/IN': 2001:503:ba3e::2:30#53 Dec 10 08:46:24 webserver1 named[929]: network unreachable resolving '125.100.165.66.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 08:49:22 webserver1 named[929]: network unreachable resolving 'B.NIC.io/A/IN': 2001:500:3::42#53 Dec 10 08:49:22 webserver1 named[929]: network unreachable resolving 'NS3.ICB.CO.UK/A/IN': 2001:630:181:35::83#53 Dec 10 08:49:22 webserver1 named[929]: network unreachable resolving '21.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 08:49:22 webserver1 named[929]: network unreachable resolving '21.190.54.65.iadb.isipp.com/A/IN': 2001:470:1:41:a800:ff:fe50:3143#53 Dec 10 08:53:38 webserver1 named[929]: client 216.218.192.166#53315: query (cache) 'bascombereunion.com/AAAA/IN' denied Dec 10 09:00:01 webserver1 CRON[14655]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 09:00:01 webserver1 postfix/smtpd[14659]: warning: ::1: address not listed for hostname localhost Dec 10 09:00:01 webserver1 postfix/smtpd[14659]: connect from unknown[::1] Dec 10 09:00:01 webserver1 postfix/smtpd[14659]: lost connection after CONNECT from unknown[::1] Dec 10 09:00:01 webserver1 postfix/smtpd[14659]: disconnect from unknown[::1] Dec 10 09:09:01 webserver1 CRON[14770]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 09:17:01 webserver1 CRON[14877]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 10 09:30:01 webserver1 CRON[15038]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 09:30:01 webserver1 postfix/smtpd[15040]: warning: ::1: address not listed for hostname localhost Dec 10 09:30:01 webserver1 postfix/smtpd[15040]: connect from unknown[::1] Dec 10 09:30:01 webserver1 postfix/smtpd[15040]: lost connection after CONNECT from unknown[::1] Dec 10 09:30:01 webserver1 postfix/smtpd[15040]: disconnect from unknown[::1] Dec 10 09:39:01 webserver1 CRON[15152]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 10:00:01 webserver1 CRON[15415]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 10:00:01 webserver1 postfix/smtpd[15418]: warning: ::1: address not listed for hostname localhost Dec 10 10:00:01 webserver1 postfix/smtpd[15418]: connect from unknown[::1] Dec 10 10:00:01 webserver1 postfix/smtpd[15418]: lost connection after CONNECT from unknown[::1] Dec 10 10:00:01 webserver1 postfix/smtpd[15418]: disconnect from unknown[::1] Dec 10 10:00:34 webserver1 named[929]: network unreachable resolving '212.34.55.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 10:00:34 webserver1 named[929]: network unreachable resolving '212.34.55.65.iadb.isipp.com/A/IN': 2001:470:1:41:a800:ff:fe50:3143#53 Dec 10 10:00:36 webserver1 named[929]: network unreachable resolving '25.98.33.160.sbl.spamhaus.org/TXT/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 10:04:30 webserver1 named[929]: network unreachable resolving '219.253.15.67.sbl.spamhaus.org/TXT/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 10:05:59 webserver1 named[929]: network unreachable resolving 'cprpt.com/NS/IN': 2001:503:231d::2:30#53 Dec 10 10:05:59 webserver1 named[929]: network unreachable resolving '206.34.55.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 10:05:59 webserver1 named[929]: network unreachable resolving '206.34.55.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 10:09:01 webserver1 CRON[15533]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 10:14:20 webserver1 named[929]: client 76.76.11.241#6276: query (cache) 'bascombereunion.com/ANY/IN' denied Dec 10 10:14:20 webserver1 named[929]: client 76.76.11.241#6276: query (cache) 'bascombereunion.com/SOA/IN' denied Dec 10 10:14:20 webserver1 named[929]: client 76.76.11.241#6276: query (cache) 'bascombereunion.com/A/IN' denied Dec 10 10:14:20 webserver1 named[929]: client 76.76.11.241#6276: query (cache) 'bascombereunion.com/MX/IN' denied Dec 10 10:14:21 webserver1 named[929]: client 76.76.11.241#6276: query (cache) 'www.bascombereunion.com/A/IN' denied Dec 10 10:17:01 webserver1 CRON[15641]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 10 10:30:01 webserver1 CRON[15801]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 10:30:01 webserver1 postfix/smtpd[15804]: warning: ::1: address not listed for hostname localhost Dec 10 10:30:01 webserver1 postfix/smtpd[15804]: connect from unknown[::1] Dec 10 10:30:01 webserver1 postfix/smtpd[15804]: lost connection after CONNECT from unknown[::1] Dec 10 10:30:01 webserver1 postfix/smtpd[15804]: disconnect from unknown[::1] Dec 10 10:31:47 webserver1 postfix/smtpd[15829]: connect from unknown[117.198.210.113] Dec 10 10:31:48 webserver1 postfix/smtpd[15829]: F3365A8CC65: client=unknown[117.198.210.113] Dec 10 10:31:50 webserver1 postfix/cleanup[15834]: F3365A8CC65: message-id=<> Dec 10 10:31:50 webserver1 postfix/qmgr[1467]: F3365A8CC65: from=<[email protected]>, size=2348, nrcpt=1 (queue active) Dec 10 10:31:50 webserver1 postfix/pickup[15751]: 6C15BA8CC68: uid=10019 from=<web6webmaster> Dec 10 10:31:50 webserver1 postfix/cleanup[15834]: 6C15BA8CC68: message-id=<[email protected]> Dec 10 10:31:50 webserver1 postfix/qmgr[1467]: 6C15BA8CC68: from=<[email protected]>, size=401, nrcpt=1 (queue active) Dec 10 10:31:50 webserver1 postfix/local[15852]: 6C15BA8CC68: to=<[email protected]>, relay=local, delay=0.05, delays=0.01/0.01/0/0.03, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-) Dec 10 10:31:50 webserver1 postfix/qmgr[1467]: 6C15BA8CC68: removed Dec 10 10:31:50 webserver1 postfix/smtpd[15829]: disconnect from unknown[117.198.210.113] Dec 10 10:31:54 webserver1 ntpd[19905]: kernel time sync status change 6001 Dec 10 10:31:58 webserver1 postfix/local[15835]: F3365A8CC65: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=9.7, delays=2/0.01/0/7.7, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-) Dec 10 10:31:58 webserver1 postfix/cleanup[15834]: 262ADA8CC67: message-id=<> Dec 10 10:31:58 webserver1 postfix/local[15835]: F3365A8CC65: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=9.7, delays=2/0.01/0/7.7, dsn=2.0.0, status=sent (forwarded as 262ADA8CC67) Dec 10 10:31:58 webserver1 postfix/qmgr[1467]: F3365A8CC65: removed Dec 10 10:31:58 webserver1 postfix/qmgr[1467]: 262ADA8CC67: from=<[email protected]>, size=2493, nrcpt=3 (queue active) Dec 10 10:31:58 webserver1 postfix/pickup[15751]: 2E2E2A8CC68: uid=10008 from=<web2_matthew> Dec 10 10:31:58 webserver1 postfix/cleanup[15834]: 2E2E2A8CC68: message-id=<[email protected]> Dec 10 10:31:58 webserver1 postfix/qmgr[1467]: 2E2E2A8CC68: from=<[email protected]>, size=400, nrcpt=1 (queue active) Dec 10 10:31:58 webserver1 postfix/local[15835]: 2E2E2A8CC68: to=<[email protected]>, relay=local, delay=0.03, delays=0.02/0/0/0.01, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-) Dec 10 10:31:58 webserver1 postfix/qmgr[1467]: 2E2E2A8CC68: removed Dec 10 10:31:58 webserver1 postfix/smtp[15890]: 262ADA8CC67: host a.mx.mail.yahoo.com[67.195.168.31] said: 451 Message temporarily deferred - [70] (in reply to end of DATA command) Dec 10 10:31:58 webserver1 postfix/smtp[15890]: 262ADA8CC67: host e.mx.mail.yahoo.com[67.195.168.230] refused to talk to me: 421 Message from (75.127.248.139) temporarily deferred - 4.16.50. Please refer to http://help.yahoo.com/help/us/mail/defer/defer-06.html Dec 10 10:31:58 webserver1 postfix/smtp[15876]: 262ADA8CC67: to=<[email protected]>, orig_to=<[email protected]>, relay=mx3.hotmail.com[65.54.188.110]:25, delay=0.76, delays=0/0.02/0.46/0.28, dsn=2.0.0, status=sent (250 <[email protected]> Queued mail for delivery) Dec 10 10:31:58 webserver1 postfix/smtp[15890]: 262ADA8CC67: host f.mx.mail.yahoo.com[98.137.54.237] refused to talk to me: 421 Message from (75.127.248.139) temporarily deferred - 4.16.50. Please refer to http://help.yahoo.com/help/us/mail/defer/defer-06.html Dec 10 10:31:59 webserver1 postfix/smtp[15890]: 262ADA8CC67: host g.mx.mail.yahoo.com[98.137.54.238] refused to talk to me: 420 Resources unavailable temporarily. Please try later (mta1032.mail.sp2.yahoo.com) Dec 10 10:31:59 webserver1 postfix/smtp[15890]: 262ADA8CC67: to=<[email protected]>, orig_to=<[email protected]>, relay=c.mx.mail.yahoo.com[206.190.54.127]:25, delay=1.2, delays=0/0.03/1.2/0, dsn=4.0.0, status=deferred (host c.mx.mail.yahoo.com[206.190.54.127] refused to talk to me: 421 Message from (75.127.248.139) temporarily deferred - 4.16.50. Please refer to http://help.yahoo.com/help/us/mail/defer/defer-06.html) Dec 10 10:32:02 webserver1 named[929]: network unreachable resolving 'ns5.0b8.ru/A/IN': 2001:503:c27::2:30#53 Dec 10 10:32:02 webserver1 named[929]: network unreachable resolving 'ns5.0b8.ru/AAAA/IN': 2001:503:c27::2:30#53 Dec 10 10:32:02 webserver1 named[929]: network unreachable resolving 'ns5.0b8.ru/A/IN': 2001:dc3::35#53 Dec 10 10:32:02 webserver1 named[929]: network unreachable resolving 'ns5.0b8.ru/AAAA/IN': 2001:dc3::35#53 Dec 10 10:32:02 webserver1 named[929]: network unreachable resolving 'ns5.0b8.ru/A/IN': 2001:500:1::803f:235#53 Dec 10 10:32:02 webserver1 named[929]: FORMERR resolving 'hatbeen.com/NS/IN': 124.42.91.162#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns5.0b8.ru/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'hatbeen.com/NS/IN': 202.111.175.126#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns6.0b8.ru/AAAA/IN': 202.111.175.126#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns5.0b8.ru/AAAA/IN': 202.111.175.126#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns6.0b8.ru/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns5.0b8.ru/AAAA/IN': 58.218.250.107#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns6.0b8.ru/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns5.0b8.ru/AAAA/IN': 58.218.250.107#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns6.0b8.ru/AAAA/IN': 58.218.250.107#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns5.0b8.ru/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:03 webserver1 named[929]: FORMERR resolving 'ns6.0b8.ru/AAAA/IN': 58.218.250.107#53 Dec 10 10:32:04 webserver1 named[929]: FORMERR resolving 'ns6.0b8.ru/AAAA/IN': 202.111.175.126#53 Dec 10 10:32:04 webserver1 named[929]: FORMERR resolving 'ns5.0b8.ru/AAAA/IN': 202.111.175.126#53 Dec 10 10:32:04 webserver1 postfix/local[15852]: 262ADA8CC67: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=6.6, delays=0/0/0/6.5, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-) Dec 10 10:32:04 webserver1 postfix/cleanup[15834]: ADF28A8CC68: message-id=<> Dec 10 10:32:04 webserver1 postfix/local[15852]: 262ADA8CC67: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=6.6, delays=0/0/0/6.6, dsn=2.0.0, status=sent (forwarded as ADF28A8CC68) Dec 10 10:32:04 webserver1 postfix/qmgr[1467]: ADF28A8CC68: from=<[email protected]>, size=2637, nrcpt=1 (queue active) Dec 10 10:32:05 webserver1 postfix/smtp[15876]: ADF28A8CC68: to=<[email protected]>, orig_to=<[email protected]>, relay=mx3.hotmail.com[65.54.188.72]:25, delay=0.63, delays=0/0/0.45/0.18, dsn=2.0.0, status=sent (250 <[email protected]> Queued mail for delivery) Dec 10 10:32:05 webserver1 postfix/qmgr[1467]: ADF28A8CC68: removed Dec 10 10:32:06 webserver1 named[929]: network unreachable resolving '25.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 10:32:06 webserver1 named[929]: connection refused resolving '25.190.54.65.sa-trusted.bondedsender.org/TXT/IN': 84.243.213.38#53 Dec 10 10:32:15 webserver1 named[929]: FORMERR resolving 'ns3.lettercolony.com/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:15 webserver1 named[929]: FORMERR resolving 'hatbeen.com/NS/IN': 58.218.250.107#53 Dec 10 10:32:15 webserver1 named[929]: FORMERR resolving 'ns4.lettercolony.com/AAAA/IN': 202.111.175.126#53 Dec 10 10:32:15 webserver1 named[929]: FORMERR resolving 'ns4.lettercolony.com/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:15 webserver1 named[929]: FORMERR resolving 'ns3.lettercolony.com/AAAA/IN': 202.111.175.126#53 Dec 10 10:32:16 webserver1 named[929]: FORMERR resolving 'ns3.lettercolony.com/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:16 webserver1 named[929]: FORMERR resolving 'ns4.lettercolony.com/AAAA/IN': 124.42.91.162#53 Dec 10 10:32:16 webserver1 named[929]: FORMERR resolving 'ns3.lettercolony.com/AAAA/IN': 202.111.175.126#53 Dec 10 10:32:16 webserver1 named[929]: FORMERR resolving 'ns4.lettercolony.com/AAAA/IN': 202.111.175.126#53 Dec 10 10:35:10 webserver1 postfix/anvil[15831]: statistics: max connection rate 1/60s for (smtp:117.198.210.113) at Dec 10 10:31:47 Dec 10 10:35:10 webserver1 postfix/anvil[15831]: statistics: max connection count 1 for (smtp:117.198.210.113) at Dec 10 10:31:47 Dec 10 10:35:10 webserver1 postfix/anvil[15831]: statistics: max cache size 1 at Dec 10 10:31:47 Dec 10 10:39:01 webserver1 CRON[16000]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 10:41:58 webserver1 postfix/qmgr[1467]: 262ADA8CC67: from=<[email protected]>, size=2493, nrcpt=3 (queue active) Dec 10 10:41:59 webserver1 postfix/smtp[16047]: 262ADA8CC67: to=<[email protected]>, orig_to=<[email protected]>, relay=c.mx.mail.yahoo.com[209.191.88.254]:25, delay=602, delays=601/0.01/0.42/0.37, dsn=2.0.0, status=sent (250 ok dirdel) Dec 10 10:41:59 webserver1 postfix/qmgr[1467]: 262ADA8CC67: removed Dec 10 10:46:11 webserver1 named[929]: network unreachable resolving '199.34.55.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 10:46:11 webserver1 named[929]: network unreachable resolving 'ns1.jamelfinds.com/A/IN': 2001:503:a83e::2:30#53 Dec 10 10:48:32 webserver1 freshclam[2017]: Received signal: wake up Dec 10 10:48:32 webserver1 freshclam[2017]: ClamAV update process started at Thu Dec 10 10:48:32 2009 Dec 10 10:48:32 webserver1 freshclam[2017]: SECURITY WARNING: NO SUPPORT FOR DIGITAL SIGNATURES Dec 10 10:48:32 webserver1 freshclam[2017]: See the FAQ at http://www.clamav.net/support/faq for an explanation. Dec 10 10:48:32 webserver1 freshclam[2017]: Your ClamAV installation is OUTDATED! Dec 10 10:48:32 webserver1 freshclam[2017]: Local version: 0.94.2 Recommended version: 0.95.3 Dec 10 10:48:32 webserver1 freshclam[2017]: DON'T PANIC! Read http://www.clamav.net/support/faq Dec 10 10:48:32 webserver1 freshclam[2017]: main.cld is up to date (version: 51, sigs: 545035, f-level: 42, builder: sven) Dec 10 10:48:32 webserver1 freshclam[2017]: daily.cld is up to date (version: 10146, sigs: 125757, f-level: 44, builder: arnaud) Dec 10 10:48:32 webserver1 freshclam[2017]: -------------------------------------- Dec 10 10:48:58 webserver1 ntpd[19905]: kernel time sync status change 2001 Dec 10 10:50:08 webserver1 named[929]: network unreachable resolving '212.34.55.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 10:50:10 webserver1 named[929]: network unreachable resolving '1.13.160.192.sbl.spamhaus.org/TXT/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 10:56:50 webserver1 named[929]: client 65.19.155.106#54910: query (cache) 'gis.gd/A/IN' denied Dec 10 10:57:16 webserver1 named[929]: client 64.62.151.34#40433: query (cache) 'gis.gd/AAAA/IN' denied Dec 10 11:00:01 webserver1 CRON[16269]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 11:00:01 webserver1 postfix/smtpd[16272]: warning: ::1: address not listed for hostname localhost Dec 10 11:00:01 webserver1 postfix/smtpd[16272]: connect from unknown[::1] Dec 10 11:00:01 webserver1 postfix/smtpd[16272]: lost connection after CONNECT from unknown[::1] Dec 10 11:00:01 webserver1 postfix/smtpd[16272]: disconnect from unknown[::1] Dec 10 11:04:32 webserver1 named[929]: network unreachable resolving 'usw4.akam.net/A/IN': 2001:503:c27::2:30#53 Dec 10 11:04:32 webserver1 named[929]: network unreachable resolving 'asia1.akam.net/A/IN': 2001:503:c27::2:30#53 Dec 10 11:04:32 webserver1 named[929]: network unreachable resolving 'asia1.akam.net/AAAA/IN': 2001:dc3::35#53 Dec 10 11:04:32 webserver1 named[929]: network unreachable resolving 'usw4.akam.net/AAAA/IN': 2001:dc3::35#53 Dec 10 11:04:32 webserver1 named[929]: network unreachable resolving 'usw4.akam.net/A/IN': 2001:dc3::35#53 Dec 10 11:04:32 webserver1 named[929]: network unreachable resolving 'asia1.akam.net/A/IN': 2001:dc3::35#53 Dec 10 11:09:01 webserver1 CRON[16386]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 11:17:01 webserver1 CRON[16492]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly) Dec 10 11:17:03 webserver1 named[929]: network unreachable resolving '0.ns.spamhaus.org/A/IN': 2001:610:0:800c:195:169:124:71#53 Dec 10 11:17:03 webserver1 named[929]: network unreachable resolving '61.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 11:17:03 webserver1 named[929]: network unreachable resolving '27.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 11:17:03 webserver1 named[929]: network unreachable resolving '40.185.42.70.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 11:17:03 webserver1 named[929]: network unreachable resolving '61.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 11:17:03 webserver1 named[929]: network unreachable resolving '27.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 11:17:03 webserver1 named[929]: network unreachable resolving '40.185.42.70.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 11:29:52 webserver1 postfix/smtpd[16649]: connect from mail2.bz-direct.com[199.1.145.192] Dec 10 11:29:52 webserver1 postfix/smtpd[16649]: BF24DA8CC67: client=mail2.bz-direct.com[199.1.145.192] Dec 10 11:29:53 webserver1 postfix/cleanup[16654]: BF24DA8CC67: message-id=<[email protected]> Dec 10 11:29:53 webserver1 postfix/qmgr[1467]: BF24DA8CC67: from=<[email protected]>, size=10585, nrcpt=1 (queue active) Dec 10 11:29:53 webserver1 postfix/pickup[15751]: 22545A8CC69: uid=10008 from=<web2_matthew> Dec 10 11:29:53 webserver1 postfix/cleanup[16654]: 22545A8CC69: message-id=<[email protected]> Dec 10 11:29:53 webserver1 postfix/qmgr[1467]: 22545A8CC69: from=<[email protected]>, size=401, nrcpt=1 (queue active) Dec 10 11:29:53 webserver1 postfix/smtpd[16649]: disconnect from mail2.bz-direct.com[199.1.145.192] Dec 10 11:29:53 webserver1 postfix/local[16672]: 22545A8CC69: to=<[email protected]>, relay=local, delay=0.05, delays=0.01/0.03/0/0.01, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-) Dec 10 11:29:53 webserver1 postfix/qmgr[1467]: 22545A8CC69: removed Dec 10 11:29:56 webserver1 postfix/local[16655]: BF24DA8CC67: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=3.5, delays=0.44/0.01/0/3.1, dsn=2.0.0, status=sent (delivered to command: /usr/bin/procmail -f-) Dec 10 11:29:56 webserver1 postfix/cleanup[16654]: 35BECA8CC69: message-id=<[email protected]> Dec 10 11:29:56 webserver1 postfix/local[16655]: BF24DA8CC67: to=<[email protected]>, orig_to=<[email protected]>, relay=local, delay=3.5, delays=0.44/0.01/0/3.1, dsn=2.0.0, status=sent (forwarded as 35BECA8CC69) Dec 10 11:29:56 webserver1 postfix/qmgr[1467]: 35BECA8CC69: from=<[email protected]>, size=10729, nrcpt=1 (queue active) Dec 10 11:29:56 webserver1 postfix/qmgr[1467]: BF24DA8CC67: removed Dec 10 11:29:56 webserver1 postfix/smtp[16690]: 35BECA8CC69: to=<[email protected]>, orig_to=<[email protected]>, relay=mx2.hotmail.com[65.54.188.94]:25, delay=0.73, delays=0/0.01/0.45/0.27, dsn=2.0.0, status=sent (250 mail from IP 75.127.248.139 soft failed sender ID check. Please ensure this IP is authorized to send mail on behalf of [bz-direct.com]) Dec 10 11:29:56 webserver1 postfix/qmgr[1467]: 35BECA8CC69: removed Dec 10 11:30:01 webserver1 CRON[16694]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 11:30:01 webserver1 postfix/smtpd[16649]: warning: ::1: address not listed for hostname localhost Dec 10 11:30:01 webserver1 postfix/smtpd[16649]: connect from unknown[::1] Dec 10 11:30:01 webserver1 postfix/smtpd[16649]: lost connection after CONNECT from unknown[::1] Dec 10 11:30:01 webserver1 postfix/smtpd[16649]: disconnect from unknown[::1] Dec 10 11:33:21 webserver1 postfix/anvil[16651]: statistics: max connection rate 1/60s for (smtp:199.1.145.192) at Dec 10 11:29:52 Dec 10 11:33:21 webserver1 postfix/anvil[16651]: statistics: max connection count 1 for (smtp:199.1.145.192) at Dec 10 11:29:52 Dec 10 11:33:21 webserver1 postfix/anvil[16651]: statistics: max cache size 1 at Dec 10 11:29:52 Dec 10 11:38:05 webserver1 named[929]: client 69.162.74.234#60008: query (cache) 'bascombereunion.com/ANY/IN' denied Dec 10 11:38:05 webserver1 named[929]: client 69.162.74.234#60008: query (cache) 'bascombereunion.com/SOA/IN' denied Dec 10 11:38:05 webserver1 named[929]: client 69.162.74.234#60008: query (cache) 'bascombereunion.com/A/IN' denied Dec 10 11:38:05 webserver1 named[929]: client 69.162.74.234#60008: query (cache) 'bascombereunion.com/MX/IN' denied Dec 10 11:38:05 webserver1 named[929]: client 69.162.74.234#60008: query (cache) 'www.bascombereunion.com/A/IN' denied Dec 10 11:39:01 webserver1 CRON[16808]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 11:57:11 webserver1 ntpd[19905]: kernel time sync status change 6001 Dec 10 11:58:38 webserver1 named[929]: network unreachable resolving '215.218.85.209.in-addr.arpa/PTR/IN': 2001:500:31::63#53 Dec 10 11:58:39 webserver1 named[929]: network unreachable resolving '205.43.108.207.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 11:58:39 webserver1 named[929]: connection refused resolving '42.84.76.192.sa-other.bondedsender.org/TXT/IN': 84.243.213.38#53 Dec 10 12:00:01 webserver1 CRON[17072]: (root) CMD (/root/ispconfig/php/php /root/ispconfig/scripts/shell/check_services.php &> /dev/null) Dec 10 12:00:01 webserver1 postfix/smtpd[17075]: warning: ::1: address not listed for hostname localhost Dec 10 12:00:01 webserver1 postfix/smtpd[17075]: connect from unknown[::1] Dec 10 12:00:01 webserver1 postfix/smtpd[17075]: lost connection after CONNECT from unknown[::1] Dec 10 12:00:01 webserver1 postfix/smtpd[17075]: disconnect from unknown[::1] Dec 10 12:07:35 webserver1 named[929]: network unreachable resolving '218.90.55.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 12:07:35 webserver1 named[929]: network unreachable resolving '218.90.55.65.iadb.isipp.com/A/IN': 2001:470:1:41:a800:ff:fe50:3143#53 Dec 10 12:09:01 webserver1 CRON[17190]: (root) CMD ( [ -x /usr/lib/php5/maxlifetime ] && [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -n 200 -r -0 rm) Dec 10 12:09:15 webserver1 named[929]: network unreachable resolving '140.248.127.75.in-addr.arpa/PTR/IN': 2001:500:13::63#53 Dec 10 12:09:52 webserver1 named[929]: network unreachable resolving '89.178.4.1.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 12:11:11 webserver1 postfix/smtpd[17226]: connect from unknown[94.23.114.28] Dec 10 12:11:11 webserver1 postfix/smtpd[17226]: lost connection after CONNECT from unknown[94.23.114.28] Dec 10 12:11:11 webserver1 postfix/smtpd[17226]: disconnect from unknown[94.23.114.28] Dec 10 12:11:11 webserver1 named[929]: network unreachable resolving 'ns12.ovh.net/AAAA/IN': 2001:41d0:1:4a86::1#53 Dec 10 12:12:08 webserver1 named[929]: network unreachable resolving 'a.uribl.com/A/IN': 2001:503:231d::2:30#53 Dec 10 12:12:08 webserver1 named[929]: network unreachable resolving '33.190.54.65.zen.spamhaus.org/A/IN': 2001:7b8:3:1f:0:2:53:2#53 Dec 10 12:12:09 webserver1 named[929]: network unreachable resolving '4.61.95.64.sbl.spamhaus.org/TXT/IN': 2001:7b8:3:1f:0:2:53:1#53 Dec 10 12:14:31 webserver1 postfix/anvil[17229]: statistics: max connection rate 1/60s for (smtp:94.23.114.28) at Dec 10 12:11:11 Dec 10 12:14:31 webserver1 postfix/anvil[17229]: statistics: max connection count 1 for (smtp:94.23.114.28) at Dec 10 12:11:11 Dec 10 12:14:31 webserver1 postfix/anvil[17229]: statistics: max cache size 1 at Dec 10 12:11:11 Dec 10 12:17:01 webserver1 CRON[17343]: (root) CMD ( cd / && run-parts --report /etc/cron.hourly)
No MySQL errors in syslog, but I wonder why named is logging "network unreachable"... Is the Internet connection of the server working? What are the outputs of Code: netstat -tap and Code: df -h ?
I believe that will be for another domain name that I was setting up. Is there a way I can delete mysql with losing my database and then reinstall it. HTML: root@webserver1:~# netstat -tap Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 webserver1.basco:domain *:* LISTEN 929/named tcp 0 0 localhost.locald:domain *:* LISTEN 929/named tcp 0 0 *:ssh *:* LISTEN 951/sshd tcp 0 0 *:smtp *:* LISTEN 1458/master tcp 0 0 localhost.localdoma:953 *:* LISTEN 929/named tcp 0 0 *:81 *:* LISTEN 2003/ispconfig_http tcp 0 0 webserver1.bascombe:ssh ool-4b7ff88c.stat:58378 ESTABLISHED 17275/sshd: root@no tcp 0 0 webserver1.bascombe:ssh ool-4b7ff88c.stat:58379 ESTABLISHED 17292/0 tcp6 0 0 [::]:ftp [::]:* LISTEN 1529/proftpd: (acce tcp6 0 0 [::]:ssh [::]:* LISTEN 951/sshd tcp6 0 0 [::]:smtp [::]:* LISTEN 1458/master tcp6 0 0 localhost:953 [::]:* LISTEN 929/named tcp6 0 0 [::]:https [::]:* LISTEN 1560/apache2 tcp6 0 0 [::]:imaps [::]:* LISTEN 1334/couriertcpd tcp6 0 0 [::]:pop3s [::]:* LISTEN 1370/couriertcpd tcp6 0 0 [::]:pop3 [::]:* LISTEN 1349/couriertcpd tcp6 0 0 [::]:imap2 [::]:* LISTEN 1313/couriertcpd tcp6 0 0 [::]:www [::]:* LISTEN 1560/apache2 HTML: root@webserver1:~# df -h Filesystem Size Used Avail Use% Mounted on /dev/sda1 224G 6.6G 206G 4% / udev 1004M 180K 1004M 1% /dev none 1004M 0 1004M 0% /dev/shm none 1004M 96K 1004M 1% /var/run none 1004M 0 1004M 0% /var/lock none 1004M 0 1004M 0% /lib/init/rw root@webserver1:~#
Maje an SQL dump of your databases... http://www.howtoforge.com/faq/6_3_en.html ... and then remove MySQL from your system: Code: apt-get --purge remove mysql-server mysql-client Then reinstall both packages and import your SQL dump(s): http://www.howtoforge.com/faq/6_4_en.html
Is there a way to go about migrating my websites and databases from Ubuntu with ISPConfig2 to Ubuntu with ISPConfig 3 with minimal interruption. I do have the resources in term of servers.
After weeks of trying to figure out why I can't access mysql, I can upon a thread today talking about upgrading mysql and it mention editing /etc/mysql/my.cnf and comment out the If you choose to install the MySQL 5.1, you might run into the problem where it will not restart. You just need to edit /etc/mysql/my.cnf. Comment out this line: Code: # * BerkeleyDB # # Using BerkeleyDB is now discouraged as its support will cease in 5.1.12. #skip-bdb this was able solve my problem and I'm happy to say that I'm back up and running.
