Quote:
Originally Posted by brian  Is logger running? This means it can't contact the database. |
Yep:
[zimbra@webmail ~]$ zmcontrol status
Host webmail.intotheoven.com
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Running
mta Running
snmp Running
spell Running
stats Running
[zimbra@webmail libexec]$ ps -ef|grep logger
zimbra 11800 1 0 Jan02 ? 00:00:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --external-locking --ledir=/opt/zimbra/logger/mysql/libexec
zimbra 11872 11800 0 Jan02 ? 00:07:25 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db/data --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-external-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock --external-locking
zimbra 11954 11904 0 Jan02 ? 00:00:13 /usr/bin/perl /opt/zimbra/libexec/zmlogger
zimbra 21976 28343 0 20:25 pts/0 00:00:00 grep logger
[zimbra@webmail libexec]$
I'm not sure if it's a sudo issue or a variable. If I run it as user 'zimbra' it runs fine.
In the /tmp/gengraphs.out file from the cron job, the first line talks about not finding a shared library.
/opt/zimbra/java/bin/java: error while loading shared libraries: libjli.so: cannot open shared object file: No such file or directory
DBI connect('database=zimbra_logger;mysql_read_default _file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock','zimbra',...) failed: Access denied for user 'zimbra'@'localhost' (using password: NO) at /opt/zimbra/libexec/zmgengraphs line 120
DB: Can't connect to dbi:mysql:database=zimbra_logger;mysql_read_defaul t_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock: Access denied for user 'zimbra'@'localhost' (using password: NO)