logmysql.server is not running

[ons]

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:

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:

   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:

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:

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:

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:

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?

[uxbod]

Welcome to the forums

Have you disabled SELinux and IPTables ?

su - zimbra
zmcontrol -v

[ons]

Originally Posted by uxbod

Welcome to the forums

Have you disabled SELinux and IPTables ?

su - zimbra
zmcontrol -v

Thanks

SELinux and IP Tables are both disabled.

zmcontrol -v
Release 5.0.8_GA_2462.RHEL5_64_20080709155301 CentOS5_64 NETWORK edition

 ./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.

[uxbod]

Okay, so some basic tests

cat /etc/hosts
cat /etc/resolv.conf
dig _domainname_ mx
dig _domainname_ any
host `hostname` <- note backticks and not double quotes

[ons]

Originally Posted by uxbod

Okay, so some basic tests

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-:

# 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:

; 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;

[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?

[ons]

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.

[michelangelo]

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

[michelangelo]

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

PROBLEM SOLVED! Everything fine now.