problem with logger

[Matthew]

I would like to start logger but it won't start.

Here's what happened:

zimbra@server:/root$ zmcontrol status
Host server.homelinux.org
        ldap                    Running
        logger                  Stopped
                logmysql.server is not running
                zmlogswatchctl is not running
        mailbox                 Running
        mta                     Running
        snmp                    Running
        stats                   Running
zimbra@server:/root$ zmlog
zmloggerctl     zmlogswatchctl
zimbra@server:/root$ zmlogswatchctl start
Starting logswatch...done.
zimbra@server:/root$ zmloggerctl start
Starting mysqld...done.
Starting logswatch...logswatch is already running.
zimbra@server:/root$ zmcontrol status
Host server.homelinux.org
        ldap                    Running
        logger                  Stopped
                logmysql.server is not running
        mailbox                 Running
        mta                     Running
        snmp                    Running
        stats                   Running
zimbra@server:/root$ logmysql.server start
Starting mysqld...done.
zimbra@server:/root$ zmcontrol status
Host server.homelinux.org
        ldap                    Running
        logger                  Stopped
                logmysql.server is not running
        mailbox                 Running
        mta                     Running
        snmp                    Running
        stats                   Running
zimbra@server:/root$

i followed this wiki

zimbra@server:/root$ logmysql.server start
Starting mysqld...done.
zimbra@server:/root$ cat /opt/zimbra/logger/db/mysql.pid
cat: /opt/zimbra/logger/db/mysql.pid: No such file or directory

But there is no solution on the wiki.

[phoenix]

Whick version and release of ZImbra is this? Please update your forum profile with the output of the following:

zmcontrol -v

Shutdown Zimbra and see if there are any zimbra processes still running with

ps aux | grep zimbra

If there are processes running then kill them all and you can restart zimbra, let me know if that fixes the problem? If that does you'll need to make another change to fix it permanently.

If that's not the problem what errors do you see in the log files

[Matthew]

thank you for your reply,

No running processes found.

just these:

zimbra   14525  0.0  0.3   7136  1924 pts/0    S    20:11   0:00 su zimbra
zimbra   14526  0.0  0.3   4640  2044 pts/0    S+   20:11   0:00 bash
root     18786  0.0  0.1   3004   756 pts/1    R+   21:44   0:00 grep zimbra

there were some errors:

/opt/zimbra/logger/mysql/libexec/mysqld: Can't change dir to '/opt/zimbra/logger/db/data/' (Errcode: 2)
090205 21:48:06 [ERROR] Aborting

090205 21:48:06 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete

STOPPING server from pid file /opt/zimbra/logger/db/mysql.pid
090205 21:48:06  mysqld ended
090205 21:48:06  mysqld ended

so i made the directory.
following the next error:

zimbra@server:/root$ tail /opt/zimbra/log/logger_mysql_error.log
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
STOPPING server from pid file /opt/zimbra/logger/db/mysql.pid
090205 21:52:57  mysqld ended
090205 21:52:57  mysqld ended

So I'm at this point now.

[fizi]

Try running this as root:

/opt/zimbra/libexec/zmfixperms

[Matthew]

root@server:~# /opt/zimbra/libexec/zmfixperms
root@server:~# su zimbra
zimbra@server:/root$ logmysql.server
Usage: /opt/zimbra/bin/logmysql.server start|stop|restart|reload|status
zimbra@server:/root$ logmysql.server start
Starting mysqld...done.
zimbra@server:/root$ zmcontrol status
Host server.homelinux.org
        ldap                    Running
        logger                  Stopped
                logmysql.server is not running
        mailbox                 Running
        mta                     Running
        snmp                    Running
        stats                   Running
zimbra@server:/root$

Not working.

[uxbod]

Check /opt/zimbra/log/mysql_error.log

[Matthew]

Version: '5.0.67-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
090213 13:05:21 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown

090213 13:05:21  InnoDB: Starting shutdown...
090213 13:05:24  InnoDB: Shutdown completed; log sequence number 0 10861166
090213 13:05:24 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

090213 13:05:24  mysqld ended

090213 13:06:02  mysqld started
090213 13:06:02 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090213 13:06:02 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
090213 13:06:02  InnoDB: Started; log sequence number 0 10861166
090213 13:06:02 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.67-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution

this is the output.

[fizi]

Can you tell us the size of these files?

/var/log/zimbra.log

/opt/zimbra/logger/db/data/zimbra_logger/*

From the looks of the log you posted MySQL appears to be starting properly.

I assume you haven't altered your logger my.cnf.

[tw1sted]

Originally Posted by fizi

Can you tell us the size of these files?

/var/log/zimbra.log

/opt/zimbra/logger/db/data/zimbra_logger/*

From the looks of the log you posted MySQL appears to be starting properly.

I assume you haven't altered your logger my.cnf.

Does anyone have solution for this kind of problem? I am trying for a few days to resolve the same problem, but with no success. Exactly same errors, and same version of Zimbra.

Any idea is welcome

[tianway]

why not reinstall the log service?