mailbox not running - tomcat fails to login to mysql

[milprog]

Hi all

I finally managed to get zimbra (zcs-3.1.4_GA_518.FC4.tgz) installed in my vserver. However, zmcontrol status tells me "mailbox not running" because tomcat did not start.

When I try to start tomcat by hand, I get the error message
[main] [] system - Config initialization failed
com.zimbra.cs.service.ServiceException: system failure: getting database connection
(...)
Caused by: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'zimbra'@'v-zimbra.milnet.lan' (using password: YES)

Mysql is running and listening on two ports, the installation log showed all success except for these three errors:
(..during ldap initialization)
ERROR: account.NO_SUCH_SERVER (no such server: v-zimbra.milnet.lan)
** Importing server cert
(..)
ERROR: account.DOMAIN_EXISTS (domain already exists: milnet.lan)
470f788f-d471-4fdc-8fef-5974ab85e4f0
(..)
Error: key trial_expiration_date is not set
(..)
The log confirms that mysql passwords for root and zimbra have been set. However, I don't know what these passwords are, so I can't check the connection 'by hand'. Can anybody tell me how I can find these passwords?

The only thing I changed during installation is the mail domain: the server is called 'v-zimbra.milnet.lan' but the maildomain is simply 'milnet.lan' . DNS should be ok (I have a proper MX record).

Any help to troubleshoot this would much be appreciated.

Regards
--Marcel

[jholder]

looks like your sql password is wrong.
Just to verify, what happens when you do this:
su -zimbra
mysql mysql

?
thx
jh

[milprog]

this seems to work. I get the \s output below. But now I see that I logged in to zimbra@localhost while tomcat tries to login to 'zimbra'@'v-zimbra.milnet.lan' (not @localhost). Obviously it takes the login name from the first entry in the hosts file. Now I modified my hosts file: previously this was

192.168.193.36 v-zimbra.milnet.lan localhost.localdomain localhost

...now I changed it to

192.168.193.36 localhost localhost.localdomain v-zimbra.milnet.lan

and now Catalina starts properly.

Thanks for your quick response and best regards

--Marcel


Connection id: 1723
Current database: mysql
Current user: zimbra@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: t
Server version: 4.1.16-standard-log
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /opt/zimbra/db/mysql.sock
Uptime: 2 days 9 hours 7 min 35 sec

Threads: 1 Questions: 1738 Slow queries: 0 Opens: 21 Flush tables: 1 Open tables: 15 Queries per second avg: 0.008
--------------

[phoenix]

Your hosts file should be:

127.0.0.1 localhost.localdomain  localhost 
192.168.193.36 v-zimbra.milnet.lan v-zimbra

[milprog]

...when I try this I get errors and zimbra fails to load amavisd. I even tried to use a "pseudo lo" interface from within my vserver, but this does not work either.

When I try to telnet localhost 10024 , amavisd closes the connection without responding. All my outgoing messages are in the deferred queue with the error "server dropped initial connection without greeting message".

Telnet to localhost port 25 works as expected.

any ideas?

[milprog]

..meanwhile I found the solution myself. I had to

1) replace 127.0.0.1 by the real IP address of my vserver in /opt/zimbra/amavisd/sbin/amavisd

2) uncomment the line
$inet_socket_port = 10024;

3) install the 'file' utility (yum install file)

now amavisd appears to work despite the fact that /opt/zimbra/amavisd-new-2.3.3/tmp cannot be mounted. In my VServer, I mount this partition via /etc/vservers/v-zimbra/fstab , which works just fine.

Regards
--Marcel

[jholder]

Milprog,
I'm glad that you found a solution.
Feel free to expand our wiki by creating an install section for vserver so that others can learn from your expertise.

Thanks
jh