[SOLVED] mysql.server not running

[king0770]

ZCS ver 4.5.6 (60 day trial)
Ubuntu 6.0.6

Hello All!

I am having some difficulty understanding why the mysql.server will not start.

zimbra@green:~$ zmcontrol status
Host green.somedomain.com
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running
mta Running
snmp Running
spell Running

zimbra@green:~$ mysql.server start
mysqld_safe already running with pid 5386

zimbra@green:~$ mysql.server stop
Killing mysqld with pid 5386 . done.

zimbra@green:~$ zmcontrol status
Host green.somedomain.com
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running
mta Running
snmp Running
spell Running

zimbra@green:~$ mysql.server start
zimbra@green:~$ Starting mysqld daemon with databases from /opt/zimbra/db/data

zimbra@green:~$ zmcontrol status
Host green.somedomain.com
antispam Running
antivirus Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running
mta Running
snmp Running
spell Running


I did notice the following in the catalina.out file, anyone knows what it means?

SEVERE: Parse Fatal Error at line 1 column 1: Content is not allowed in prolog.
org.xml.sax.SAXParseException: Content is not allowed in prolog.

Any help in understanding this problem would be greatly appreciated!

[king0770]

Here's the last 250 lines of the /var/log/zimbra.log

Sep 11 23:33:35 green amavis[4674]: Module Unix::Syslog 0.99
Sep 11 23:33:35 green amavis[4674]: Amavis:B code loaded
Sep 11 23:33:35 green amavis[4674]: Amavis::Cache code loaded
Sep 11 23:33:35 green amavis[4674]: SQL base code NOT loaded
Sep 11 23:33:35 green amavis[4674]: SQL::Log code NOT loaded
Sep 11 23:33:35 green amavis[4674]: SQL::Quarantine NOT loaded
Sep 11 23:33:35 green amavis[4674]: Lookup::SQL code NOT loaded
Sep 11 23:33:35 green amavis[4674]: Lookup::LDAP code loaded
Sep 11 23:33:35 green amavis[4674]: AM.PDP-in proto code loaded
Sep 11 23:33:35 green amavis[4674]: SMTP-in proto code loaded
Sep 11 23:33:35 green amavis[4674]: Courier proto code NOT loaded
Sep 11 23:33:35 green amavis[4674]: SMTP-out proto code loaded
Sep 11 23:33:35 green amavis[4674]: Pipe-out proto code NOT loaded
Sep 11 23:33:35 green amavis[4674]: BSMTP-out proto code NOT loaded
Sep 11 23:33:35 green amavis[4674]: Local-out proto code loaded
Sep 11 23:33:35 green amavis[4674]: OS_Fingerprint code NOT loaded
Sep 11 23:33:35 green amavis[4674]: ANTI-VIRUS code loaded
Sep 11 23:33:35 green amavis[4674]: ANTI-SPAM code loaded
Sep 11 23:33:35 green amavis[4674]: ANTI-SPAM-SA code loaded
Sep 11 23:33:35 green amavis[4674]: Unpackers code loaded
Sep 11 23:33:35 green amavis[4674]: Found $file at /usr/bin/file
Sep 11 23:33:35 green amavis[4674]: No $dspam, not using it
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .mail
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .asc
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .uue
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .hqx
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .ync
Sep 11 23:33:35 green amavis[4674]: No decoder for .F tried: unfreeze, freeze -d, melt, fcat
Sep 11 23:33:35 green amavis[4674]: Found decoder for .Z at /bin/uncompress
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .gz
Sep 11 23:33:35 green amavis[4674]: Found decoder for .bz2 at /usr/bin/bzip2 -d
Sep 11 23:33:35 green amavis[4674]: No decoder for .lzo tried: lzop -d
Sep 11 23:33:35 green amavis[4674]: No decoder for .rpm tried: rpm2cpio.pl, rpm2cpio
Sep 11 23:33:35 green amavis[4674]: Found decoder for .cpio at /bin/cpio
Sep 11 23:33:35 green amavis[4674]: Found decoder for .tar at /bin/cpio
Sep 11 23:33:35 green amavis[4674]: No decoder for .deb tried: ar
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .zip
Sep 11 23:33:35 green amavis[4674]: No decoder for .rar tried: rar, unrar
Sep 11 23:33:35 green amavis[4674]: No decoder for .arj tried: arj, unarj
Sep 11 23:33:35 green amavis[4674]: No decoder for .arc tried: nomarch, arc
Sep 11 23:33:35 green amavis[4674]: No decoder for .zoo tried: zoo
Sep 11 23:33:35 green amavis[4674]: No decoder for .lha tried: lha
Sep 11 23:33:35 green amavis[4674]: No decoder for .cab tried: cabextract
Sep 11 23:33:35 green amavis[4674]: No decoder for .tnef tried: tnef
Sep 11 23:33:35 green amavis[4674]: Internal decoder for .tnef
Sep 11 23:33:35 green amavis[4674]: No decoder for .exe tried: rar, unrar; lha; arj, unarj
Sep 11 23:33:35 green amavis[4674]: Using internal av scanner code for (primary) ClamAV-clamd
Sep 11 23:33:35 green amavis[4674]: Creating db in /opt/zimbra/amavisd/db/; BerkeleyDB 0.31, libdb 4.2
Sep 11 23:33:35 green amavis[4674]: SpamControl: initializing Mail::SpamAssassin
Sep 11 23:33:36 green amavis[4674]: SpamControl: init_pre_fork done
Sep 11 23:34:01 green CRON[4687]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:34:06 green zmtomcatmgr[4790]: status requested
Sep 11 23:34:06 green zmtomcatmgr[4790]: status OK
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: antivirus: Stopped
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: logger: Running
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: mta: Running
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:34:07 green zimbramon[4688]: 4688:info: 2007-09-11 23:34:02, STATUS: green.somedomain.com: spell: Running
Sep 11 23:34:07 green CRON[4687]: (pam_unix) session closed for user zimbra
Sep 11 23:34:42 green clamd[4500]: Loaded 153889 signatures.
Sep 11 23:34:42 green clamd[4500]: Bound to tcp port 3310
Sep 11 23:34:42 green clamd[4500]: Setting connection queue length to 15
Sep 11 23:34:42 green clamd[4500]: Archive: Archived file size limit set to 104857600 bytes.
Sep 11 23:34:42 green clamd[4500]: Archive: Recursion level limit set to 8.
Sep 11 23:34:42 green clamd[4500]: Archive: Files limit set to 1000.
Sep 11 23:34:42 green clamd[4500]: Archive: Compression ratio limit set to 250.
Sep 11 23:34:42 green clamd[4500]: Archive support enabled.
Sep 11 23:34:42 green clamd[4500]: Archive: Blocking encrypted archives.
Sep 11 23:34:42 green clamd[4500]: Algorithmic detection enabled.
Sep 11 23:34:42 green clamd[4500]: Portable Executable support enabled.
Sep 11 23:34:42 green clamd[4500]: ELF support enabled.
Sep 11 23:34:42 green clamd[4500]: Mail files support enabled.
Sep 11 23:34:42 green clamd[4500]: Mail: Recursion level limit set to 64.
Sep 11 23:34:42 green clamd[4500]: OLE2 support enabled.
Sep 11 23:34:42 green clamd[4500]: PDF support disabled.
Sep 11 23:34:42 green clamd[4500]: HTML support enabled.
Sep 11 23:34:42 green clamd[4500]: Self checking every 1800 seconds.
Sep 11 23:35:04 green login[4656]: (pam_unix) session opened for user root by (uid=0)
Sep 11 23:35:53 green su[4907]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:36:01 green CRON[4913]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:36:04 green zmtomcatmgr[5014]: status requested
Sep 11 23:36:04 green zmtomcatmgr[5014]: status OK
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:36:04 green zimbramon[4914]: 4914:info: 2007-09-11 23:36:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:36:04 green CRON[4913]: (pam_unix) session closed for user zimbra
Sep 11 23:36:22 green zmtomcatmgr[5140]: status requested
Sep 11 23:36:22 green zmtomcatmgr[5140]: status OK
Sep 11 23:36:53 green zmtomcatmgr[5306]: status requested
Sep 11 23:36:53 green zmtomcatmgr[5306]: status OK
Sep 11 23:37:13 green zmtomcatmgr[5492]: status requested
Sep 11 23:37:13 green zmtomcatmgr[5492]: status OK
Sep 11 23:38:01 green CRON[5578]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:38:04 green zmtomcatmgr[5679]: status requested
Sep 11 23:38:04 green zmtomcatmgr[5679]: status OK
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:38:04 green zimbramon[5579]: 5579:info: 2007-09-11 23:38:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:38:04 green CRON[5578]: (pam_unix) session closed for user zimbra
Sep 11 23:39:32 green sshd[5769]: Accepted password for root from 192.168.1.15 port 51527 ssh2
Sep 11 23:39:32 green sshd[5771]: (pam_unix) session opened for user root by root(uid=0)
Sep 11 23:39:47 green su[5786]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:39:58 green zmtomcatmgr[5886]: status requested
Sep 11 23:39:58 green zmtomcatmgr[5886]: status OK
Sep 11 23:40:01 green CRON[5917]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:40:01 green CRON[5919]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:40:01 green CRON[5921]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:40:01 green CRON[5923]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:40:01 green zimbramon[5918]: 5918:info: 2007-09-11 23:40:01, QUEUE: 0 0
Sep 11 23:40:01 green CRON[5917]: (pam_unix) session closed for user zimbra
Sep 11 23:40:02 green zimbramon[5922]: 5922:info: 2007-09-11 23:40:01, DISK: green.somedomain.com: dev: /dev/hda3, mp: /, tot: 7513, avail: 6165
Sep 11 23:40:02 green zimbramon[5922]: 5922:info: 2007-09-11 23:40:01, DISK: green.somedomain.com: dev: /dev/hda1, mp: /boot, tot: 89, avail: 52
Sep 11 23:40:02 green CRON[5921]: (pam_unix) session closed for user zimbra
Sep 11 23:40:07 green zmtomcatmgr[6122]: status requested
Sep 11 23:40:07 green zmtomcatmgr[6122]: status OK
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:40:07 green zimbramon[5924]: 5924:info: 2007-09-11 23:40:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:40:07 green CRON[5923]: (pam_unix) session closed for user zimbra
Sep 11 23:40:07 green CRON[5919]: (pam_unix) session closed for user zimbra
Sep 11 23:40:32 green zmtomcatmgr[6287]: status requested
Sep 11 23:40:32 green zmtomcatmgr[6287]: status OK
Sep 11 23:41:03 green zmtomcatmgr[6474]: status requested
Sep 11 23:41:03 green zmtomcatmgr[6474]: status OK
Sep 11 23:42:01 green CRON[6557]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:42:04 green zmtomcatmgr[6658]: status requested
Sep 11 23:42:04 green zmtomcatmgr[6658]: status OK
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:42:04 green zimbramon[6558]: 6558:info: 2007-09-11 23:42:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:42:04 green CRON[6557]: (pam_unix) session closed for user zimbra
Sep 11 23:44:01 green CRON[6745]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:44:03 green zmtomcatmgr[6846]: status requested
Sep 11 23:44:03 green zmtomcatmgr[6846]: status OK
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:44:04 green zimbramon[6746]: 6746:info: 2007-09-11 23:44:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:44:04 green CRON[6745]: (pam_unix) session closed for user zimbra
Sep 11 23:45:01 green CRON[6881]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:45:02 green slapd[3820]: is_entry_objectclass("", "2.5.6.1") no objectClass attribute
Sep 11 23:45:02 green slapd[3820]: is_entry_objectclass("", "2.5.6.1") no objectClass attribute
Sep 11 23:46:01 green CRON[6965]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:46:03 green zmtomcatmgr[7066]: status requested
Sep 11 23:46:03 green zmtomcatmgr[7066]: status OK
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:46:03 green zimbramon[6966]: 6966:info: 2007-09-11 23:46:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:46:03 green CRON[6965]: (pam_unix) session closed for user zimbra
Sep 11 23:48:01 green CRON[7204]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:48:04 green zmtomcatmgr[7305]: status requested
Sep 11 23:48:04 green zmtomcatmgr[7305]: status OK
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:48:04 green zimbramon[7205]: 7205:info: 2007-09-11 23:48:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:48:04 green CRON[7204]: (pam_unix) session closed for user zimbra
Sep 11 23:50:01 green CRON[7401]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:50:01 green CRON[7403]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:50:01 green CRON[7405]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:50:01 green CRON[7407]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:50:01 green zimbramon[7402]: 7402:info: 2007-09-11 23:50:01, QUEUE: 0 0
Sep 11 23:50:01 green CRON[7401]: (pam_unix) session closed for user zimbra
Sep 11 23:50:02 green zimbramon[7406]: 7406:info: 2007-09-11 23:50:01, DISK: green.somedomain.com: dev: /dev/hda3, mp: /, tot: 7513, avail: 6165
Sep 11 23:50:03 green zimbramon[7406]: 7406:info: 2007-09-11 23:50:01, DISK: green.somedomain.com: dev: /dev/hda1, mp: /boot, tot: 89, avail: 52
Sep 11 23:50:03 green CRON[7405]: (pam_unix) session closed for user zimbra
Sep 11 23:50:05 green zmtomcatmgr[7579]: status requested
Sep 11 23:50:05 green zmtomcatmgr[7579]: status OK
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: antispam: Running
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: antivirus: Running
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: ldap: Running
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: logger: Running
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: mailbox: Stopped
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: mta: Running
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: snmp: Running
Sep 11 23:50:05 green zimbramon[7408]: 7408:info: 2007-09-11 23:50:01, STATUS: green.somedomain.com: spell: Running
Sep 11 23:50:05 green CRON[7407]: (pam_unix) session closed for user zimbra
Sep 11 23:50:08 green CRON[7403]: (pam_unix) session closed for user zimbra
Sep 11 23:52:01 green CRON[7693]: (pam_unix) session opened for user zimbra by (uid=0)
Sep 11 23:54:01 green CRON[7783]: (pam_unix) session opened for user zimbra by (uid=0)

[jholder]

can you
su - zimbra
mysql mysql

?
Does it let you in?

[king0770]

I guess not...

ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)

[king0770]

Actually this worked:

zimbra@green:/tmp$ mysql -u zimbra -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.0.33-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

[jholder]

Okay, you need to reset your mysql password. Somehow it didn't set.

If you don't have any data in there, it might be easier to just run the
su - zimbra
cd /opt/zimbra/libexec
./zmmyinit

Script.

WARNING: Running that script wil WIPE/ERASE all data!

john

[jholder]

Originally Posted by king0770

Actually this worked:

zimbra@green:/tmp$ mysql -u zimbra -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 17
Server version: 5.0.33-log Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

Did you change the Zimbra user password?

[king0770]

Thank you very much for your quick replies by the way.

Since this is a test box, I'll run the zmmyinit:


* Creating required directories
* Generating mysql config /opt/zimbra/conf/my.cnf
* Creating database in /opt/zimbra/db/data
* Starting mysql server
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying
* Failed to connect to mysql...retrying (just repeats)
* Failed to connect to mysql...giving up!

zimbra@green:~/libexec$ mysql.server start
mysqld_safe already running with pid 6369

Is it running? I think so...

zimbra@green:~/libexec$ ps -ef | grep [s]ql
zimbra 3928 1 0 Sep11 ? 00:00:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --ledir=/opt/zimbra/logger/mysql/libexec
zimbra 3991 3928 0 Sep11 ? 00:00: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 --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-external-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock
zimbra 6333 1 0 Sep11 pts/0 00:00:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --ledir=/opt/zimbra/mysql/libexec
zimbra 6369 6333 0 Sep11 pts/0 00:00: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

[king0770]

The mysql password for the zimbra acct is zimbra

[jholder]

Are you running in a VPS?

Do you have a loopback interface?

If yes, what's in your hosts file?

If no, you'll need a loopback address because that's how mysql connects.