Trying to setup on Fedora FC4

[Sean]

Hi,

Having no luck at all trying to get started installing Zimbra on an FC4 box after four or five hours so thought i'd break down and ask a question. It looks like one of the problems is that zimbra can't connect to the database:

2005-09-09 05:28:02,276 INFO [main] [] soap - Servlet SoapServlet starting up
2005-09-09 05:28:02,587 INFO [main] [] misc - version=2005.0.0_39.FC3 release=1_ARMSTRONG builddate=20050829-1058 buildhost=wolfowitz.liquidsys.com
2005-09-09 05:28:17,563 FATAL [main] [] system - Config initialization failed
com.zimbra.cs.service.ServiceException: system failure: getting database connection
at com.zimbra.cs.service.ServiceException.FAILURE(Ser viceException.java:95)
at com.zimbra.cs.db.DbPool.getConnection(DbPool.java: 250)
at com.zimbra.cs.util.Config.init(Config.java:72)
at com.zimbra.cs.util.Config.initConfig(Config.java:9 9)
at com.zimbra.cs.util.Config.getString(Config.java:11 1)
at com.zimbra.cs.db.Versions.checkDBVersion(Versions. java:87)
at com.zimbra.cs.db.Versions.checkVersions(Versions.j ava:82)
at com.zimbra.cs.util.Zimbra.startup(Zimbra.java:119)
at com.zimbra.soap.SoapServlet.init(SoapServlet.java: 77)
at javax.servlet.GenericServlet.init(GenericServlet.j ava:211)
at org.apache.catalina.core.StandardWrapper.loadServl et(StandardWrapper.java:1068)
at org.apache.catalina.core.StandardWrapper.load(Stan dardWrapper.java:900)
at org.apache.catalina.core.StandardContext.loadOnSta rtup(StandardContext.java:3823)
at org.apache.catalina.core.StandardContext.start(Sta ndardContext.java:4087)
at org.apache.catalina.core.ContainerBase.addChildInt ernal(ContainerBase.java:759)
at org.apache.catalina.core.ContainerBase.addChild(Co ntainerBase.java:739)
at org.apache.catalina.core.StandardHost.addChild(Sta ndardHost.java:524)
at org.apache.catalina.startup.HostConfig.deployWAR(H ostConfig.java:800)
at org.apache.catalina.startup.HostConfig.deployWARs( HostConfig.java:695)
at org.apache.catalina.startup.HostConfig.deployApps( HostConfig.java:472)
at org.apache.catalina.startup.HostConfig.start(HostC onfig.java:1106)
at org.apache.catalina.startup.HostConfig.lifecycleEv ent(HostConfig.java:310)
at org.apache.catalina.util.LifecycleSupport.fireLife cycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1019)
at org.apache.catalina.core.StandardHost.start(Standa rdHost.java:718)
at org.apache.catalina.core.ContainerBase.start(Conta inerBase.java:1011)
at org.apache.catalina.core.StandardEngine.start(Stan dardEngine.java:440)
at org.apache.catalina.core.StandardService.start(Sta ndardService.java:450)
at org.apache.catalina.core.StandardServer.start(Stan dardServer.java:683)
at org.apache.catalina.startup.Catalina.start(Catalin a.java:537)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.catalina.startup.Bootstrap.start(Bootst rap.java:271)
at org.apache.catalina.startup.Bootstrap.main(Bootstr ap.java:409)
Caused by: java.sql.SQLException: Server connection failure during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user 'zimbra'@'localhost.localdomain' (using password: YES)'.

I can connect to the zimbra database using root, but I don't know what the password is supposed to be for the 'zimbra' user or where that is set in the application. Any ideas how to debug this problem?

Thanks,
Sean

[KevinH]

See Cannot connect to Zimbra after installation

[Sean]

See Cannot connect to Zimbra after installation

Kevin,

That entry already existed in the hosts file, so I don't think that's it. If I start mysql myself things get a little futher, but if I knew where to find the proper mysql 'zimbra' users password I could test connecting manually to see if that is working too.

On another front I actually see more errors in the log:

Sep 10 01:34:13 localhost zimbramon[25594]: 25594:info: start app mtaconfig
Sep 10 01:34:13 localhost zimbramon[25594]: 25594:err: Can't start running app mtaconfig
Sep 10 01:34:13 localhost zimbramon[25594]: 25594:info: start app postfix
Sep 10 01:34:13 localhost zimbramon[25594]: 25594:err: SMTP RESPONSE: FAILURE from localhost: problem connecting to "localhost", port 25: Connection refused
Sep 10 01:34:13 localhost zimbramon[25594]: 25594:info: Starting child postfix: (20050910013413)
Sep 10 01:34:32 localhost zimbramon[25594]: 25594:err: SMTP RESPONSE: FAILURE from localhost: problem connecting to "localhost", port 25: Connection refused
Sep 10 01:34:34 localhost zimbramon[25594]: 25594:crit: doStartup

It seems postfix ends up running on port 7075 rather than port 25 and no administrator page is available on port 7071...

I'm thinking I should just start over with the source distribution and see if I have better luck.

Sean

[KevinH]

Ok as long as your hostname is not in that same /etc/hosts line and the localhost line exactly as I posted it is first in the /etc/hosts file you should be ok.

The MTA does run on port 7075 and is mapped via iptables to port 25 for service.

The admin UI is SSL only so make sure your going to:

https://:7071/zimbraAdmin/


-kevin

[Sean]

[QUOTE=KevinH]Ok as long as your hostname is not in that same /etc/hosts line and the localhost line exactly as I posted it is first in the /etc/hosts file you should be ok.

The MTA does run on port 7075 and is mapped via iptables to port 25 for service.

The admin UI is SSL only so make sure your going to:

https://:7071/zimbraAdmin/

Kevin,

Thanks for your pointers. After reinstalling things worked much better and I'm through to the admin page now. My guess is that I had mysql already running during my first install attempt and it fouled things up quite badly.

Sean

[marcmac]

To find the mysql password, use zmlocalconfig -s zimbra_mysql_password - this will display the password.

[QUOTE=Sean]

Ok as long as your hostname is not in that same /etc/hosts line and the localhost line exactly as I posted it is first in the /etc/hosts file you should be ok.

The MTA does run on port 7075 and is mapped via iptables to port 25 for service.

The admin UI is SSL only so make sure your going to:

https://:7071/zimbraAdmin/

Kevin,

Thanks for your pointers. After reinstalling things worked much better and I'm through to the admin page now. My guess is that I had mysql already running during my first install attempt and it fouled things up quite badly.

Sean