mysql.server and tomcat not running

[peterz]

Zimbra newbie here. After 26 hours straight, have not been able to get admin console up.Have tried installing on openSUSE 10.2 and now, for the last 12 hours have been trying to get upon Fedora 6.

System: X86, Single Server install, 1.5 MB of RAM, Pentium4 2.5Ghz

Install seems to go fine until last stage: Failed to initialize documents - see logfile.

After that:
zmcontrol status
Host mail.egad.com
antispam Running
antivirus Running
ldap Running
logger Stopped
zmlogswatchctl is not running
mailbox Stopped
mysql.server is not running
tomcat is not running
mta Running
snmp Running
spell Running

and of course, checking on mysql:

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

I have done atleast 6 installs, (all clean). I've gone in and manually changed the mysql password and tried it running only through the install.

DNS seems to be working, since the zimbra.log shows active email coming in.

Checked the status of the mysql password:
[zimbra@mail ~]$ zmlocalconfig -s -m nokey mysql_root_password
zimbra

I've been through all the Wiki's and made adjustments for Fedora Core 6:
/etc/sudoers : #Defaults requiretty

I've tried working the imapproxy problem, but I can't get to a console to finish the single server fix with zmperiditionctl stop.

I've tried all of the following:

https://localhost:7071/zimbraAdmin
https://localhost:7071
https://mail.egad.com:7071/zimbraAdmin
https://mail.egad.com:7071

Always the same thing: Access Denied.

hosts:
127.0.0.1 localhost.localdomain localhost
66.93.64.34 mail.egad.com mail
::1 localhost.localdomain localhost


Help! I've never had this much trouble trying to get a mail server up and running.

[peterz]

Have also found this error in the catalina.out file:

...
...
ay 8, 2007 10:46:45 AM org.apache.catalina.core.StandardContext resourcesStart
SEVERE: Error starting static Resources
java.lang.IllegalArgumentException: Document base /opt/zimbra/apache-tomcat-5.5.15/server/webapps/manager does not exist or is not a readable directory
....
....

Unfortunately, I don't know what to do with this information.

[jholder]

Well, if you did several clean installs and the mysql password is still out of sync, then you have the problem.

Try resetting the password to Zimbra using this wiki:
http://wiki.zimbra.com/index.php?tit...ySQL_Passwords

Remember, you need to set it TO zimbra, then change it later. Otherwise, it will be more difficult.

Once you can get it to the mysql console:
su - zimbra
mysqladmin

without an access denied, then we'll look at the next issue. I'm willing to be there's more going on than meets the eye

[SpEnTBoY]

Originally Posted by peterz

Have also found this error in the catalina.out file:

...
...
ay 8, 2007 10:46:45 AM org.apache.catalina.core.StandardContext resourcesStart
SEVERE: Error starting static Resources
java.lang.IllegalArgumentException: Document base /opt/zimbra/apache-tomcat-5.5.15/server/webapps/manager does not exist or is not a readable directory
....
....

Unfortunately, I don't know what to do with this information.

Not sure about the other errors but I do know that there was a temp fix for tomcat that was released a while ago on the forum to trap a vulnerability.

Part was to move the webapps directory to webapps_old (or some different name). So it's quite possible you don't have that directory at all.

I just checked my hiehrarchy:

# ls -ld /opt/zimbra/apache-tomcat-5.5.15/server/*apps*
drwxr-xr-x 4 zimbra zimbra 4096 Apr 17 07:57 /opt/zimbra/apache-tomcat-5.5.15/server/webapps_old

I'm not sure all your errors are related however.

[jholder]

Originally Posted by SpEnTBoY

Not sure about the other errors but I do know that there was a temp fix for tomcat that was released a while ago on the forum to trap a vulnerability.

Part was to move the webapps directory to webapps_old (or some different name). So it's quite possible you don't have that directory at all.

I just checked my hiehrarchy:

# ls -ld /opt/zimbra/apache-tomcat-5.5.15/server/*apps*
drwxr-xr-x 4 zimbra zimbra 4096 Apr 17 07:57 /opt/zimbra/apache-tomcat-5.5.15/server/webapps_old

I'm not sure all your errors are related however.

It's a trivial error.
The bigger problem is with mysql.
We have to figure that out first.

[peterz]

Thanks for the fast reply! It's been lonely and frustrating at this end.

The mysqladmin command works fine.

But, upon looking in /opt/zimbra/apache-tomcat-5.5.15/server/webapps/
there is nothing in the webapps folder.
Could this have been the result of the Failed To Initialize Documents during the last part of the install?

This is still the status:
zmcontrol status
Host mail.egad.com
antispam Running
antivirus Running
ldap Running
logger Stopped
zmlogswatchctl is not running
mailbox Stopped
mysql.server is not running
tomcat is not running
mta Running
snmp Running
spell Running

[jholder]

But, upon looking in /opt/zimbra/apache-tomcat-5.5.15/server/webapps/
there is nothing in the webapps folder.
Could this have been the result of the Failed To Initialize Documents during the last part of the install?

Lets fix mysql first

run a
su - zimbra
mysql.server start

and post what it says.

[peterz]

Here's everything I had to do:

[zimbra@mail ~]$ mysql.server start
[zimbra@mail ~]$ A mysqld process already exists

[zimbra@mail ~]$ mysql.server stop
Killing mysqld with pid 20185 .STOPPING server from pid file /opt/zimbra/db/mysql.pid
070508 11:57:32 mysqld ended

[zimbra@mail ~]$ mysql.server start
[zimbra@mail ~]$ Starting mysqld daemon with databases from /opt/zimbra/db/data

[zimbra@mail ~]$ zmcontrol status
Host mail.egad.com
antispam Running
antivirus Running
ldap Running
logger Stopped
zmlogswatchctl is not running
mailbox Stopped
mysql.server is not running
tomcat is not running
mta Running
snmp Running
spell Running
[zimbra@mail ~]$

Still no mysql.server

[peterz]

I went into the zmmtaconfig.log and noticed that imapproxy is not enabled. Seeing that this was identified in other posts as a problem, it apparently isn't here:

Tue May 8 13:22:11 2007 Service imapproxy is not enabled. Skipping perdition
Tue May 8 13:22:11 2007 Section antivirus did not change skipping
Tue May 8 13:22:11 2007 Section antispam did not change skipping
Tue May 8 13:22:11 2007 Section mta did not change skipping
Tue May 8 13:22:11 2007 Section sasl did not change skipping
Tue May 8 13:22:11 2007 Section webxml did not change skipping
Tue May 8 13:22:11 2007 Section mailbox did not change skipping
Tue May 8 13:22:11 2007 Section perdition did not change skipping
Tue May 8 13:22:11 2007 Sleeping for 60.

[jholder]

Peterz,
Can you contact me via e-mail?
jholder@zimbra.com

Thanks
john