Unable to connect to Mysql

Discussion in 'Installation/Configuration' started by mbascombe, Dec 7, 2009.

  1. mbascombe

    mbascombe New Member

    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.
     
  2. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Any errors in your logs?
    What's the output of
    Code:
    ls -la /var/run/mysqld/
    ?
     
  3. mbascombe

    mbascombe New Member

    @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 ..
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Looks ok. Did you check your logs?
    Can you post the exact error message that you see when you try to restart MySQL?
     
  5. mbascombe

    mbascombe New Member

    there is no error for mysql. I hope I'm looking in the right place. /var/log/mysql
     
  6. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Please check /var/log/syslog.

    Can you post the exact error message that you see when you try to restart MySQL?
     
  7. mbascombe

    mbascombe New Member

    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=<20091210115023.067734B0001@server1.bascombe.info>
    Dec 10 06:50:23 webserver1 postfix/qmgr[1467]: 067734B0001: from=<root@bascombe.info>, size=2422, nrcpt=1 (queue active)
    Dec 10 06:50:23 webserver1 postfix/local[13000]: 067734B0001: to=<root@bascombe.info>, 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=<webmaster@emersongamoryincometaxservice.com>, 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=<20091210153150.6C15BA8CC68@server1.bascombe.info>
    Dec 10 10:31:50 webserver1 postfix/qmgr[1467]: 6C15BA8CC68: from=<web6webmaster@bascombe.info>, size=401, nrcpt=1 (queue active)
    Dec 10 10:31:50 webserver1 postfix/local[15852]: 6C15BA8CC68: to=<admispconfig@localhost.localdomain>, 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=<web6webmaster@bascombe.info>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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=<web6webmaster@bascombe.info>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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=<webmaster@emersongamoryincometaxservice.com>, 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=<20091210153158.2E2E2A8CC68@server1.bascombe.info>
    Dec 10 10:31:58 webserver1 postfix/qmgr[1467]: 2E2E2A8CC68: from=<web2_matthew@bascombe.info>, size=400, nrcpt=1 (queue active)
    Dec 10 10:31:58 webserver1 postfix/local[15835]: 2E2E2A8CC68: to=<admispconfig@localhost.localdomain>, 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=<matthewbascombe@msn.com>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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 <BAY0-MC3-F20bMwWExa005909da@bay0-mc3-f20.Bay0.hotmail.com> 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=<eeeman2001@yahoo.com>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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=<web2_matthew@bascombe.info>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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=<web2_matthew@bascombe.info>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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=<webmaster@emersongamoryincometaxservice.com>, size=2637, nrcpt=1 (queue active)
    Dec 10 10:32:05 webserver1 postfix/smtp[15876]: ADF28A8CC68: to=<matthewbascombe@msn.com>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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 <BAY0-MC1-F133ZziVlO009a3042@bay0-mc1-f13.Bay0.hotmail.com> 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=<webmaster@emersongamoryincometaxservice.com>, size=2493, nrcpt=3 (queue active)
    Dec 10 10:41:59 webserver1 postfix/smtp[16047]: 262ADA8CC67: to=<eeeman2001@yahoo.com>, orig_to=<webmaster@emersongamoryincometaxservice.com>, 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=<18420389.1260462581602.JavaMail.root@bz-direct.com>
    Dec 10 11:29:53 webserver1 postfix/qmgr[1467]: BF24DA8CC67: from=<bounce-lohdowdghyfshkg@bz-direct.com>, 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=<20091210162953.22545A8CC69@server1.bascombe.info>
    Dec 10 11:29:53 webserver1 postfix/qmgr[1467]: 22545A8CC69: from=<web2_matthew@bascombe.info>, 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=<admispconfig@localhost.localdomain>, 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=<web2_matthew@bascombe.info>, orig_to=<matthew@bascombe.info>, 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=<18420389.1260462581602.JavaMail.root@bz-direct.com>
    Dec 10 11:29:56 webserver1 postfix/local[16655]: BF24DA8CC67: to=<web2_matthew@bascombe.info>, orig_to=<matthew@bascombe.info>, 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=<bounce-lohdowdghyfshkg@bz-direct.com>, 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=<matthewbascombe@msn.com>, orig_to=<matthew@bascombe.info>, 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)
    
    
    
     
  8. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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
    ?
     
  9. mbascombe

    mbascombe New Member

    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:~#
    
    
     
  10. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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
     
  11. mbascombe

    mbascombe New Member

    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.
     
  12. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    There's no script for this, so you'd have to do this manually, one by one.
     
  13. mbascombe

    mbascombe New Member

    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.
     

Share This Page