[SOLVED] Logger not working

[marklindley]

mmorse,

I am trying to fix this error

Message: Csfe service error
Error code: service.FAILURE
Method: ZmCsfeCommand.invoke
Details:system failure: getting database logger connection

I have followed one of the posts to fix the problem but I can't seem to run this command to fix the table.




zimbra@mailserver:~$ cd ~/logger/db/data/zimbra_logger
zimbra@mailserver:~/logger/db/data/zimbra_logger$ ~/logger/mysql-standard-5.0.26-pc-linux-gnu-i686-glibc23/bin/myisamchk -r service_status
bash: /opt/zimbra/logger/mysql-standard-5.0.26-pc-linux-gnu-i686-glibc23/bin/myisamchk: No such file or directory
zimbra@mailserver:~/logger/db/data/zimbra_logger$

Thanks Mark


BTW thanks for the other link

[marklindley]

Hi Guys,

I have worked out how to run the repair on the db but this didn't fix the problem. I am still get the error below even though I ran the upgrade installation again. I have also tried some of the other solutions in the threds

Message: Csfe service error
Error code: service.FAILURE
Method: ZmCsfeCommand.invoke
Details:system failure: getting database logger connection



Any help would be much appreciated.

Thanks Mark

[marklindley]

Hi,

I am following the wiki to reset the logger password but I am getting this error

zimbra@mailserver:/etc/init.d$ logmysql mysql -D zimbra_logger -P 7307
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)


Can anyone help please. The logger is driving me nuts. I can't get it to work.


Thanks Mark

[marklindley]

Hi Guy's

I have tried everything to get the logger running but I can't workout what to do next?

zimbra@mailserver:/etc/init.d$ zmcontrol status
Host mailserver.itismail.co.uk
antispam Running
antivirus Running
ldap Running
logger Stopped
logmysql.server is not running
mailbox Running
mta Running
snmp Running
spell Running
stats Running
zimbra@mailserver:/etc/init.d$ ps auuxww | grep mysql
root 29287 0.0 0.1 2468 1256 pts/0 S 15:16 0: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 29328 0.0 1.8 99652 13404 pts/0 Sl 15:16 0:00 /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 --user=zimbra --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-external-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock --external-locking
zimbra 29722 0.0 0.2 2988 1524 pts/0 S 15:17 0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --external-locking --ledir=/opt/zimbra/mysql/libexec
zimbra 29796 0.0 4.4 275288 33320 pts/0 Sl 15:17 0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --pid-file=/opt/zimbra/db/mysql.pid --skip-external-locking --port=7306 --socket=/opt/zimbra/db/mysql.sock --external-locking
zimbra 30436 0.0 0.4 4728 3264 pts/0 S 15:17 0:00 /usr/bin/perl -w /opt/zimbra/libexec/zmstat-mysql

Thanks Mark

[mmorse]

This happen when you attempt to view statistics in the admin console?
Could you post the links you've followed?

Also see: Logger - Zimbra :: Wiki
Have you tried zmloggerinit yet?
This is a brand new setup so you have nothing to loose by doing so - it should create a new database and generate the necessary passwords

[marklindley]

Hi mmorse

I have tried a lot of threads ... here is the error.

1. Resetting LDAP & MySQL Passwords - Zimbra :: Wiki
2.Logger - Zimbra :: Wiki


zimbra@mailserver:/root$ /opt/zimbra/libexec/zmloggerinit
* Creating required directories
* Creating database in /opt/zimbra/logger/db/data
* Starting logger_mysql server
* Loading schema /opt/zimbra/db/loggerdb.sql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
* Setting random password for mysql root user in zimbra local config
* Setting random password for mysql zimbra user in zimbra local config
* Changing mysql root user password
/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
* Changing mysql zimbra user password
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
**** PASSWORD CHANGE FAILED
zimbra@mailserver:/root$


Really lost on this, been working on it nearly 2 days now. I don't want to reinstall from fresh because I have add all of my domains and user accounts

Thanks Mark

[mmorse]

wow I see you now have 3 threads on this - I'll consolidate them up in a bit

ya, logger is a frustration to many, so don't give up - you can still run zimbra without logger (though you won't have any daily reports, server message statistics, and can't zmmsgtrace properly)

This is not to be confused with the stats service - which might get renamed perfmon (Bug 20549 - rename stats service)

(before doing this I assume you have no users connected, because well, your killing any running zimbra processes)

sudo zimbra
zmcontrol stop
switch back to another user
(use sudo as needed - I don't know if your root or not)
ps auxww | grep zimbra
ps auxww | grep mysql
(kill any remaining processes on either of those)
rm -rf /opt/zimbra/logger/db (maybe only db/data/ ?)
zmloggerinit

[marklindley]

Carried out all of the steps but I still get the same problem :S




root@mailserver:/opt/zimbra/logger# locate zmloggerinit
/opt/zimbra/libexec/zmloggerinit
/opt/zimbra/log/zmloggerinit.log
root@mailserver:/opt/zimbra/logger# /opt/zimbra/libexec/zmloggerinit
* Creating required directories
* Creating database in /opt/zimbra/logger/db/data
* Starting logger_mysql server
* Loading schema /opt/zimbra/db/loggerdb.sql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
* Setting random password for mysql root user in zimbra local config
* Setting random password for mysql zimbra user in zimbra local config
* Changing mysql root user password
/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!
* Changing mysql zimbra user password
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
**** PASSWORD CHANGE FAILED

Thanks Mark

[marklindley]

root@mailserver:/opt/zimbra/logger# locate zmloggerinit
/opt/zimbra/libexec/zmloggerinit
/opt/zimbra/log/zmloggerinit.log
root@mailserver:/opt/zimbra/logger# /opt/zimbra/libexec/zmloggerinit
* Creating required directories
* Creating database in /opt/zimbra/logger/db/data
* Starting logger_mysql server
* Loading schema /opt/zimbra/db/loggerdb.sql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
* Setting random password for mysql root user in zimbra local config
* Setting random password for mysql zimbra user in zimbra local config
* Changing mysql root user password
/opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!
* Changing mysql zimbra user password
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
**** PASSWORD CHANGE FAILED

[jholder]

Do you have localhost adapter, and an localhost entry in your hosts file?