[SOLVED] Logger and mailbox not running

[Mudasar]

Hi,

I ma using zimbra successfully on different linux and solaris boxes, i have installed in on the Linux AS 4 but got he following status results

---------------------------------------------------------
[zimbra@monitoring bin]$ ./zmcontrol status
Host monitoring.i2c.com
antispam Running
antivirus Running
ldap Running
logger Stopped
logmysql.server is not running
mailbox Stopped
mysql.server is not running
zmmailboxdctl is not running
mta Running
snmp Running
spell Running
stats Stopped
---------------------------------------------------------

this problem was all ready reported but no solution and no reply on it for last 5 month. (Problem With Status)
so i start a new thread. i have attached three log file /var/log/zimbra.log, /opt/zimbra/log/mailbox.log and /opt/zimbra/log/zmmailboxd.out.

Thanks.

[uxbod]

Welcome to the forums

Looks like your MySQL password is incorrect

MESSAGE: Access denied for user 'zimbra'@'localhost' (using password: YES)

So, have a read off MySql Password - Zimbra :: Wiki

[Mudasar]

Hi,

Thanks for your reply......

in your link there is only to show mysql password detail. can you please tell me where can i put this password deatil.......... if you mean to reset the mysql password......it can not be possible until mysql is running.....as i send Zimbra status its mysql is also not running....

but i have run the following command (with out put)

----------------------------------------------------------------[zimbra@monitoring root]$ zmmypasswd --root zimbra
/opt/zimbra/bin/mysqladmin -u root --password=zimbra password zimbra
/opt/zimbra/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/opt/zimbra/db/mysql.sock' exists!
**** PASSWORD CHANGE FAILED
----------------------------------------------------------------

Thanks

[uxbod]

are you able to connect using

su - zimbra
logmysql

[Mudasar]

Hi,

I dont think i will work until my sql will in running state

-----------------------------------------------------------------
[zimbra@monitoring bin]$ logmysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)

-----------------------------------------------------------------

Thanks,

[uxbod]

Please check the file /opt/zimbra/logger/db/data/.err to see if any of the MySQL tables are corrupt aswell.

[Mudasar]

Hi,

Thanks for your help, there was error in your mention file, some thing like dns is unable to resolve the name. i have correct the DNS entry. After that when i start the zimbra it gives me error "cannot create mysql.host". i reinstall the zimbra now it is working fine. (Sorry i havent the error messages)

Thanks