Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: mysql.server is not running

  1. #1
    M.K.Z.R is offline Active Member
    Join Date
    Feb 2010
    Posts
    35
    Rep Power
    5

    Default mysql.server is not running

    Hi,

    I re-installed zimbra. But it seems that this time mysql.server is not working.

    [zimbra@zimbra root]$ zmcontrol start
    Host xxxx.xxxx.xx
    Starting logger...Done.
    Starting mailbox...Done.
    Starting memcached...Done.
    Starting imapproxy...Done.
    Starting antispam...Done.
    Starting antivirus...Done.
    Starting snmp...Done.
    Starting spell...Done.
    Starting mta...Done.
    Starting stats...Done.

    [zimbra@zimbra root]$ zmcontrol status
    Host zimbra.amnesty.nl
    antispam Running
    antivirus Running
    imapproxy Running
    ldap Running
    logger Running
    mailbox Stopped
    mysql.server is not running.
    memcached Running
    mta Running
    snmp Running
    spell Running
    stats Stopped

    [zimbra@zimbra root]$ mysql.server start
    Starting mysqld...done.

    [zimbra@zimbra root]$ mysql.server status
    mysql is not running

    [zimbra@zimbra root]$ mysql mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)

    [zimbra@zimbra root]$ zmmysqlstatus
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
    Error while running 'mysql --user=zimbra --password=zimbra --database=zimbra --batch --skip-column-names'. at /opt/zimbra/bin/zmmysqlstatus line 248.

    How can I fix this problem?

  2. #2
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Why did you re-install when you had it working ? How did you clean up the old install ?

  3. #3
    M.K.Z.R is offline Active Member
    Join Date
    Feb 2010
    Posts
    35
    Rep Power
    5

    Default

    Quote Originally Posted by uxbod View Post
    Why did you re-install when you had it working ? How did you clean up the old install ?
    I re-installed my whole linux machine first i removed zimbra with the command sh install.sh -u and: rm -rf zimbraserver

  4. #4
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Code:
    cat /etc/hosts
    cat /etc/resolv.conf
    dig yourdomain mx
    dig yourdomain any
    host `hostname` <- note backticks and not single quotes
    Did you also disable SELinux and IPTables ?

  5. #5
    dalmate is offline Elite Member
    Join Date
    Jan 2009
    Posts
    364
    Rep Power
    6

    Default

    can you ping localhost or 127.0.0.1?
    If you can't ping that, mysql can't start

  6. #6
    M.K.Z.R is offline Active Member
    Join Date
    Feb 2010
    Posts
    35
    Rep Power
    5

    Default

    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    XXX.XXX.X.X XXXX.XXXX.com XXXX
    127.0.0.1 localhost.localdomain localhost
    ::1 localhost6.localdomain6 localhost6


    nameserver XX.XX.XX.XX
    nameserver XX.XX.XX.XX


    [zimbra@zimbra root]$ dig yourdomain mx

    ; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain mx
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 31279
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

    ;; QUESTION SECTION:
    ;yourdomain. IN MX

    ;; AUTHORITY SECTION:
    . 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

    ;; Query time: 34 msec
    ;; SERVER: XX.XX.XX.XX#53(XX.XX.XX.XX)
    ;; WHEN: Fri Mar 26 09:53:10 2010
    ;; MSG SIZE rcvd: 103

    [zimbra@zimbra root]$ dig yourdomain any

    ; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain any
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 61384
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

    ;; QUESTION SECTION:
    ;yourdomain. IN ANY

    ;; AUTHORITY SECTION:
    . 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

    ;; Query time: 35 msec
    ;; SERVER: XX.XX.XX.XX#53(XX.XX.XX.XX)
    ;; WHEN: Fri Mar 26 09:53:25 2010
    ;; MSG SIZE rcvd: 103


    [zimbra@zimbra root]$ 'hostname'
    XXX.XXX.com

  7. #7
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Well that tells us nothing as you have removed all the necessary detail; plus you need to execute
    Code:
    host `hostname`
    and not just
    Code:
    `hostname`

  8. #8
    M.K.Z.R is offline Active Member
    Join Date
    Feb 2010
    Posts
    35
    Rep Power
    5

    Default

    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    192.168.8.6 zimbra.xxxx.com zimbra
    127.0.0.1 localhost.localdomain localhost
    ::1 localhost6.localdomain6 localhost6


    nameserver 194.109.6.66
    nameserver 194.109.9.99


    [zimbra@zimbra root]$ dig yourdomain mx

    ; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain mx
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 31279
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

    ;; QUESTION SECTION:
    ;yourdomain. IN MX

    ;; AUTHORITY SECTION:
    . 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

    ;; Query time: 34 msec
    ;; SERVER: 194.109.6.66#53(194.109.6.66)
    ;; WHEN: Fri Mar 26 09:53:10 2010
    ;; MSG SIZE rcvd: 103

    [zimbra@zimbra root]$ dig yourdomain any

    ; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5 <<>> yourdomain any
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NXDOMAIN, id: 61384
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

    ;; QUESTION SECTION:
    ;yourdomain. IN ANY

    ;; AUTHORITY SECTION:
    . 86400 IN SOA a.root-servers.net. nstld.verisign-grs.com. 2010032600 1800 900 604800 86400

    ;; Query time: 35 msec
    ;; SERVER: 194.109.6.66#53(194.109.6.66)
    ;; WHEN: Fri Mar 26 09:53:25 2010
    ;; MSG SIZE rcvd: 103

    [zimbra@zimbra root]$ host 'hostname'
    Host hostname not found: 3(NXDOMAIN)

  9. #9
    M.K.Z.R is offline Active Member
    Join Date
    Feb 2010
    Posts
    35
    Rep Power
    5

    Default

    [zimbra@zimbra root]$ host `hostname`
    zimbra.xxxx.com has address 194.109.106.6

  10. #10
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Your DNS A record for the Zimbra server does not match /etc/hosts.

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. zmmailboxdctl is stopped frequently..
    By tamilnandhu in forum Installation
    Replies: 13
    Last Post: 04-12-2008, 08:59 AM
  2. Can't seem to get global in BES
    By sdemeyer in forum Zimbra Connector for BlackBerry
    Replies: 12
    Last Post: 03-19-2008, 08:22 AM
  3. Replies: 4
    Last Post: 11-14-2007, 02:19 PM
  4. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  5. Trouble sending mail from Outlook
    By czaveri in forum Users
    Replies: 15
    Last Post: 07-24-2006, 11:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •