Results 1 to 7 of 7

Thread: mailbox not running - tomcat fails to login to mysql

  1. #1
    milprog is offline Intermediate Member
    Join Date
    Jan 2006
    Posts
    16
    Rep Power
    9

    Default mailbox not running - tomcat fails to login to mysql

    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
    Last edited by milprog; 07-28-2006 at 11:48 PM.

  2. #2
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

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

    ?
    thx
    jh

  3. #3
    milprog is offline Intermediate Member
    Join Date
    Jan 2006
    Posts
    16
    Rep Power
    9

    Default

    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
    --------------
    Last edited by milprog; 07-30-2006 at 12:40 AM.

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,201
    Rep Power
    56

    Default

    Your hosts file should be:

    Code:
    127.0.0.1 localhost.localdomain  localhost 
    192.168.193.36 v-zimbra.milnet.lan v-zimbra
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    milprog is offline Intermediate Member
    Join Date
    Jan 2006
    Posts
    16
    Rep Power
    9

    Default

    ...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?

  6. #6
    milprog is offline Intermediate Member
    Join Date
    Jan 2006
    Posts
    16
    Rep Power
    9

    Default

    ..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

  7. #7
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 21
    Last Post: 02-04-2010, 10:06 AM
  2. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  3. tomcat not running / postfix/postqueue errors
    By seravitae in forum Installation
    Replies: 7
    Last Post: 03-10-2007, 08:18 PM
  4. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  5. Trouble sending mail from Outlook
    By czaveri in forum Users
    Replies: 15
    Last Post: 07-24-2006, 11:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •