Results 1 to 8 of 8

Thread: logmysql.server is not running

  1. #1
    ons
    ons is offline Junior Member
    Join Date
    May 2008
    Posts
    8
    Rep Power
    7

    Default logmysql.server is not running

    Hi,

    We are implementing Zimbra Network Edition on CentOS 5 over two Xen virtual servers.

    We have two different servers. The first one -the internal server- acts as a LDAP server, and the second one -external server- is the MTA wich will have Internet access.

    The first one works perfectly, although the external server fails from the outset after installation.

    The zmcontrol status output is:

    Code:
    antispam                Running
            antivirus               Running
            logger                  Stopped
                    logmysql.server is not running
            mta                     Running
            snmp                    Running
            spell                   Running
            stats                   Running
    So when we tried to stop and start server again, we get:

    Code:
       Starting logger...FAILED
            Starting antispam...Done.
            Starting antivirus...Done.
            Starting snmp...FAILED
            Starting spell...Done.
            Starting mta...Done.
            Starting stats...Done.

    If we execute logmysql as zimbra user, we get:

    Code:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    That file doesn't exists.


    If we execute Zimbra's mysqld as root, we get:

    Code:
    080722 12:14:38 [ERROR] Can't find messagefile '/opt/zimbra/mysql-standard-5.0.51a-pc-linux-gnu-i686-glibc23/share/mysql/english/errmsg.sys'
    080722 12:14:38 [ERROR] Aborting

    The error in /opt/zimbra/log/logger_mysql_error is:

    Code:
    080722 10:55:03 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

    The content of /opt/zimbra/log/zmmyinit.log is:

    Code:
    Starting mysqld daemon with databases from /opt/zimbra/logger/db/data
    STOPPING server from pid file /opt/zimbra/logger/db/mysql.pid
    080722 10:54:06  mysqld ended
    That file doesn't exists.


    Also, we try to access Zimbra Administration Console via HTTP, but it doesn't works.


    Can someone please help?

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

    Default

    Welcome to the forums

    Have you disabled SELinux and IPTables ?
    Code:
    su - zimbra
    zmcontrol -v

  3. #3
    ons
    ons is offline Junior Member
    Join Date
    May 2008
    Posts
    8
    Rep Power
    7

    Default

    Quote Originally Posted by uxbod View Post
    Welcome to the forums

    Have you disabled SELinux and IPTables ?
    Code:
    su - zimbra
    zmcontrol -v
    Thanks

    SELinux and IP Tables are both disabled.

    Code:
    zmcontrol -v
    Release 5.0.8_GA_2462.RHEL5_64_20080709155301 CentOS5_64 NETWORK edition
    Code:
     ./iptables status
    Firewall is stopped.

    We have an external firewall, does this affect? We have configured our internal Zimbra server as LDAP master server for our Zimbra external server, and the external server can only access internal server network via 389 TCP port.
    Last edited by ons; 07-22-2008 at 03:43 AM.

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

    Default

    Okay, so some basic tests
    Code:
    cat /etc/hosts
    cat /etc/resolv.conf
    dig _domainname_ mx
    dig _domainname_ any
    host `hostname` <- note backticks and not double quotes

  5. #5
    ons
    ons is offline Junior Member
    Join Date
    May 2008
    Posts
    8
    Rep Power
    7

    Default

    Quote Originally Posted by uxbod View Post
    Okay, so some basic tests
    Code:
    cat /etc/hosts
    cat /etc/resolv.conf
    dig _domainname_ mx
    dig _domainname_ any
    host `hostname` <- note backticks and not double quotes
    In /etc/hosts, we have the following lines -for security reasons, our server names are fictitious-:

    Code:
    # Do not remove the following line, or various programs
    # that require network functionality will fail.
    127.0.0.1               localhost.localdomain localhost
    ::1                         localhost6.localdomain6 localhost6
    10.10.10.20            externalserver.externaldomain.net externalserver
    10.10.10.30            repositoryserver.domain.net repositoryserver
    Our /etc/resolv.conf:

    Code:
    ; generated by /sbin/dhclient-script
    search externaldomain.net
    nameserver 10.10.10.50

    'Dig' and host 'commands' doesn't work in our Zimbra server.
    In our DNS server, if we try 'host servername' and 'dig' we get;

    Code:
    [root@nameserver ~]# host externalserver.externaldomain.net
    externalserver.externaldomain.net has address 10.132.8.206
    
    [root@nameserver ~]# dig externalserver.externaldomain.net mx
    
    ; <<>> DiG 9.3.3rc2 <<>> externalserver.externaldomain.net mx
    ;; global options:  printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 48971
    ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0
    
    ;; QUESTION SECTION:
    ;externalserver.externaldomain.net.   IN      MX
    
    ;; AUTHORITY SECTION:
    externalserver.net           21600   IN      SOA     nameserver.externaldomain.net. admin.externaldomain.net. 200608105 21600 3600 604800 21600
    
    ;; Query time: 0 msec
    ;; SERVER: 127.0.0.1#53(127.0.0.1)
    ;; WHEN: Wed Jul 23 09:26:45 2008
    ;; MSG SIZE  rcvd: 103
    
    
    [root@nameserver ~]# dig externalserver.externaldomain.net any
    
    ; <<>> DiG 9.3.3rc2 <<>> externalserver.externaldomain.net any
    ;; global options:  printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 32324
    ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 1, ADDITIONAL: 1
    
    ;; QUESTION SECTION:
    ;externalserver.externaldomain.net.   IN      ANY
    
    ;; ANSWER SECTION:
    externalserver.externaldomain.net. 7200 IN    A       10.10.10.20
    externalserver.externaldomain.net. 7200 IN    TXT     "00e9bfac83fc25a804e6d6c2204028e6da"
    
    ;; AUTHORITY SECTION:
    externaldomain.net.           86400   IN      NS      nameserver.anotherdomain.net.
    
    ;; ADDITIONAL SECTION:
    nameserver.anotherdomain.net. 86400 IN    A       10.10.10.50
    
    ;; Query time: 0 msec
    ;; SERVER: 127.0.0.1#53(127.0.0.1)
    ;; WHEN: Wed Jul 23 09:26:50 2008
    ;; MSG SIZE  rcvd: 161
    Is this all right?
    Last edited by ons; 07-23-2008 at 12:42 AM.

  6. #6
    ons
    ons is offline Junior Member
    Join Date
    May 2008
    Posts
    8
    Rep Power
    7

    Default [solved]

    We haven't installed the Zimbra Store module. We removed Zimbra and then re-installed it with the Zimbra Store module; everything works fine now.

  7. #7
    michelangelo is offline New Member
    Join Date
    Aug 2008
    Posts
    3
    Rep Power
    7

    Default

    I'm from Brazil, sorry my poor English...

    I have the same problems with the same errors, is this DNS?

    I cant reinstall the system, is active and i cant stop him, we don't know if the backup is OK, so, what i can do to solve this problem without a re-install the system, any ideas?

    Thanks

    Alan

  8. #8
    michelangelo is offline New Member
    Join Date
    Aug 2008
    Posts
    3
    Rep Power
    7

    Default

    The problem was my /etc/hosts where the localhost line was commented

    PROBLEM SOLVED! Everything fine now.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Outlook no longer updating
    By jeremy.pratt in forum Zimbra Connector for BlackBerry
    Replies: 10
    Last Post: 05-30-2008, 03:22 PM
  2. zmmailboxdctl is stopped frequently..
    By tamilnandhu in forum Installation
    Replies: 13
    Last Post: 04-12-2008, 08:59 AM
  3. 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
  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
  •