| 
05-19-2008, 05:43 AM
| | Member | | Join Date: Mar 2008 ZCS Version: Release 5.0.3_GA_2005.SOLARIS10_i386.TEST8 SOLARIS10 FOSS edition
Posts: 16
| |  [SOLVED] [Solaris 10] : Mysql database install problem
Hello everybody,
I have install the Zimbra zcs-5.0.3_GA_2005.SOLARIS10_i386.TEST8.FRANKLIN v last month with success on Solaris 10 x86.
Actually I try to install the Sparc version (zcs-5.0.3_GA_2005.SOLARIS10_sparc.TEST8.FRANKLIN) , But this doesn't work.
When I do zmcontrol status, I get : Code: Host zimbra.bollore-technologies.fr
antispam Running
antivirus Running
ldap Running
logger Stopped
zmlogswatchctl is not running
mailbox Stopped
zmmailboxdctl is not running
mta Running
snmp Running
spell Running
stats Running I have read the mailbox log, and I have this : Code: com.zimbra.common.service.ServiceException: system failure: getting database connection
ExceptionId:main:1211197507402:b6fe0aeb149561de
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:231)
at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:231)
at com.zimbra.cs.util.Config.init(Config.java:62)
at com.zimbra.cs.util.Config.initConfig(Config.java:89)
at com.zimbra.cs.util.Config.getString(Config.java:101)
at com.zimbra.cs.db.Versions.checkDBVersion(Versions.java:77)
at com.zimbra.cs.db.Versions.checkVersions(Versions.java:73)
at com.zimbra.cs.util.Zimbra.startup(Zimbra.java:88)
at com.zimbra.soap.SoapServlet.init(SoapServlet.java:114)
at javax.servlet.GenericServlet.init(GenericServlet.java:241)
at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:433)
at org.mortbay.jetty.servlet.ServletHolder.doStart(ServletHolder.java:256)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:612)
at org.mortbay.jetty.servlet.Context.startContext(Context.java:139)
at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1222)
at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:501)
at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:449)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
at org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java
:161)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
at org.mortbay.jetty.Server.doStart(Server.java:217)
at org.mortbay.setuid.SetUIDServer.doStart(SetUIDServer.java:100)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:979)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.mortbay.start.Main.invokeMain(Main.java:183)
at org.mortbay.start.Main.start(Main.java:497)
at org.mortbay.start.Main.main(Main.java:115)
Caused by: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Server connection failur
e during transaction. Due to underlying exception: 'java.sql.SQLException: Access denied for user '
zimbra'@'localhost' (using password: YES)'.
** BEGIN NESTED EXCEPTION **
java.sql.SQLException
MESSAGE: Access denied for user 'zimbra'@'localhost' (using password: YES)
STACKTRACE:
java.sql.SQLException: Access denied for user 'zimbra'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2772)
at com.mysql.jdbc.Connection.(Connection.java:1531)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerCon
nectionFactory.java:97)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.j
ava:300)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:140)
at com.zimbra.cs.db.DbPool.getConnection(DbPool.java:222)
at com.zimbra.cs.util.Config.init(Config.java:62)
at com.zimbra.cs.util.Config.initConfig(Config.java:89)
at com.zimbra.cs.util.Config.getString(Config.java:101)
at com.zimbra.cs.db.Versions.checkDBVersion(Versions.java:77)
at com.zimbra.cs.db.Versions.checkVersions(Versions.java:73)
at com.zimbra.cs.util.Zimbra.startup(Zimbra.java:88)
at com.zimbra.soap.SoapServlet.init(SoapServlet.java:114)
at javax.servlet.GenericServlet.init(GenericServlet.java:241)
at org.mortbay.jetty.servlet.ServletHolder.initServlet(ServletHolder.java:433)
at org.mortbay.jetty.servlet.ServletHolder.doStart(ServletHolder.java:256)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.servlet.ServletHandler.initialize(ServletHandler.java:612)
at org.mortbay.jetty.servlet.Context.startContext(Context.java:139)
at org.mortbay.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1222)
at org.mortbay.jetty.handler.ContextHandler.doStart(ContextHandler.java:501)
at org.mortbay.jetty.webapp.WebAppContext.doStart(WebAppContext.java:449)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
at org.mortbay.jetty.handler.ContextHandlerCollection.doStart(ContextHandlerCollection.java
:161)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerCollection.doStart(HandlerCollection.java:147)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.jetty.handler.HandlerWrapper.doStart(HandlerWrapper.java:117)
at org.mortbay.jetty.Server.doStart(Server.java:217)
at org.mortbay.setuid.SetUIDServer.doStart(SetUIDServer.java:100)
at org.mortbay.component.AbstractLifeCycle.start(AbstractLifeCycle.java:40)
at org.mortbay.xml.XmlConfiguration.main(XmlConfiguration.java:979)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.mortbay.start.Main.invokeMain(Main.java:183)
at org.mortbay.start.Main.start(Main.java:497)
at org.mortbay.start.Main.main(Main.java:115) In fact I don' have 'zimbra' user in Mysql, and I haven't no zimbra databases : Code: mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| test |
+--------------------+
mysql> use mysql
mysql> select host,user,password from user;
+-----------+--------+-------------------------------------------+
| host | user | password |
+-----------+--------+-------------------------------------------+
| localhost | root | *B4D3FF54301FE956646B70582DFF12BF932CC85A |
| zimbra | root | |
| 127.0.0.1 | root | |
+-----------+--------+-------------------------------------------+ If you have an idea of the problem I encounter, thank you for making me by your proposals to solve my problem.
Thank you in advance for your answers. |
05-19-2008, 06:10 AM
|  | Moderator | | Join Date: Nov 2006 Location: Northampton, UK ZCS Version: Release 5.0.7_GA_2450.RHEL5_20080630192737 CentOS5 NETWORK edition (Unsupported OS)
Posts: 1,407
| |
Do you get the same if you do Code: su - zimbra
logmysql also, if you do Code: su - zimbra
zmlocalconfig -s | grep -i mysql you should see the MySQL password. Check that you can connect using it when you do Code: su - zimbra
mysql -p Also check /opt/zimbra/logger/db/ .err for any error messages.
When you posted the mysql show databases, did you connect as zimbra, or do you have another instance of MySQL on your server ?
__________________
Server | CentOS 5.1 | Dual Opteron 250 | Tyan K8W Mobo | 6GB RAM | 3WARE 9550-SX4 | 4 x Samsung 200GB SATA II |
Zimbra | Release Release 5.0.7_GA_2450.RHEL5_20080630192737 NETWORK edition running under Xen 3.2.1 CentOS 5.2 i386 VM |
Network | Cisco 877 Router - Cisco ASA 5505 FW - Cisco 1131AP | |
05-19-2008, 07:08 AM
| | Member | | Join Date: Mar 2008 ZCS Version: Release 5.0.3_GA_2005.SOLARIS10_i386.TEST8 SOLARIS10 FOSS edition
Posts: 16
| |
Hi,
When I launch logmysql I get : Code: ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES) I have tried to Init databases too with /opt/zimbra/libexec/zmmyinit : Code: * 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...giving up! For access to Mysql I have used the root password in zmlocalconfig. But I use zimbra login to connect at Mysql I can't because the zimbra user don't exist. |
05-19-2008, 07:34 AM
| | OpenSource Buildmaster | | Join Date: Nov 2005
Posts: 1,003
| |
interesting. how much memory have you got? there were memory issues with the innodb memory calculations that the zimbra installer does that I used to override, but it seemed to be OK in recent code so I renabled. certainly it has worked fine for quite a few people using this release.
mysql not starting like that during the install phase will produce your symptoms, if you look back through your zmsetup.log you will probably find similar entries saying failed to connect.. retrying.
what problems did you have with the sparc version? |
05-19-2008, 07:56 AM
| | Member | | Join Date: Mar 2008 ZCS Version: Release 5.0.3_GA_2005.SOLARIS10_i386.TEST8 SOLARIS10 FOSS edition
Posts: 16
| | 
Hi dijichi2,
For the moment, My problem with Sparc version is only Mysql. I installed the Sparc version of the same way that the i386.
The i386 Work fine with any problem (Good Work, and thanks  ),
Now I tried to install on Sun Fire 280R Server, I have 1024Mb of Memory and 2GB of Swap.
During installation I had several error after the launch of services. The only error was displayed at the initialization of the documents. But in zmsetup.log I can read this for Mysql : Code: zimbra-store is enabled
Initializing store sql database...
*** Running as zimbra user: /opt/zimbra/libexec/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
* Loading schema /opt/zimbra/db/db.sql
* Loading version from /opt/zimbra/db/versions-init.sql
ERROR 1049 (42000) at line 2: Unknown database 'zimbra'
* Setting random passwd for mysql root user in zimbra localconfig
* Setting random passwd for mysql zimbra user in zimbra localconfig
* Changing mysql root user password
* Changing mysql zimbra user password
ERROR 1133 (42000) at line 1: Can't find any matching row in the user table
**** PASSWORD CHANGE FAILED
done.
Setting zimbraSmtpHostname for zimbra.bollore-technologies.fr... I join my log file in this post.
Thank you very much for your help.
Last edited by nemesix : 05-19-2008 at 07:59 AM.
|
05-19-2008, 08:08 AM
| | Moderator | | Join Date: Nov 2006 Location: Northampton, UK ZCS Version: Release 5.0.7_GA_2450.RHEL5_20080630192737 CentOS5 NETWORK edition (Unsupported OS)
Posts: 1,407
| |
As I mentioned before please check check /opt/zimbra/logger/db/_zmhostname_.err for any error messages, especially when ZCS was being installed.
__________________
Server | CentOS 5.1 | Dual Opteron 250 | Tyan K8W Mobo | 6GB RAM | 3WARE 9550-SX4 | 4 x Samsung 200GB SATA II |
Zimbra | Release Release 5.0.7_GA_2450.RHEL5_20080630192737 NETWORK edition running under Xen 3.2.1 CentOS 5.2 i386 VM |
Network | Cisco 877 Router - Cisco ASA 5505 FW - Cisco 1131AP | |
05-19-2008, 08:25 AM
| | Member | | Join Date: Mar 2008 ZCS Version: Release 5.0.3_GA_2005.SOLARIS10_i386.TEST8 SOLARIS10 FOSS edition
Posts: 16
| |
In /opt/zimbra/logger/db/data/zimbra.log I have this : Code: 080519 13:38:52 mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
080519 13:38:53 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
080519 13:38:54 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
080519 13:38:55 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
080519 13:38:57 InnoDB: Started; log sequence number 0 0
080519 13:38:57 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '5.0.45-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
A mysqld process already exists at Mon May 19 13:43:57 CEST 2008 There is nothing indicating that either damaged to Mysql.
I have tried to create manualy zimbra user, but it doesn't works.  |
05-19-2008, 08:43 AM
| | OpenSource Buildmaster | | Join Date: Nov 2005
Posts: 1,003
| |
Unfortunately the swap size is pretty much ignored. It's the physical RAM that is used for the memory calculations - for Solaris I think I took it from prtdiag (even from inside a zone) and use that figure to calculate the memory slicing. From my experience building and testing, mysql and java are much more sensitive to low memory conditions under Solaris than other platforms. I never had any success with 1Gb, I had to have at least 1.5Gb to get anything working properly,and 2Gb to really run well.
I would strongly suggest the mysql problem is related to the memory size. It's possible in between package installation and zmsetup.pl (for instance when it first pauses after starting zmsetup) you could then go in by hand and alter the innodb settings in my.cnf.in - try commenting them all out to start with. You may find this gets you working. But unlikely. Try and add more memory! |
05-19-2008, 08:44 AM
| | OpenSource Buildmaster | | Join Date: Nov 2005
Posts: 1,003
| |
Quote:
Version: '5.0.45-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 Source distribution
A mysqld process already exists at Mon May 19 13:43:57 CEST 2008
| ps - before you start the install, make 200% sure you don't have any other mysql process running, and try and shut down absolutely everything else while you run the installer. |
05-20-2008, 12:38 AM
| | Member | | Join Date: Mar 2008 ZCS Version: Release 5.0.3_GA_2005.SOLARIS10_i386.TEST8 SOLARIS10 FOSS edition
Posts: 16
| |
Good morning,
I have reinstall my server to be sure that the old plant does not disturb the installation. But I have the same problem.
during install I have this messages on my console terminal Code: May 20 09:28:49 zimbra.bollore-technologies.fr zmmailboxdmgr[10543]: no manager process is running
May 20 09:29:33 zimbra zmmailboxdmgr[10889]: no manager process is running
May 20 09:29:33 zimbra.bollore-technologies.fr zmmailboxdmgr[10889]: no manager process is running
May 20 09:30:25 zimbra zmmailboxdmgr[10897]: mailboxd/JVM exited twice in 30 seconds (tolerance=60)
May 20 09:30:25 zimbra.bollore-technologies.fr zmmailboxdmgr[10897]: mailboxd/JVM exited twice in 30 seconds (tolerance=60)
May 20 09:30:29 zimbra zmmailboxdmgr[11463]: no manager process is running
May 20 09:30:29 zimbra.bollore-technologies.fr zmmailboxdmgr[11463]: no manager process is running I have install the i386 version on vmware image of solaris 10 with 704 MB of memory. The sparc needs more memory than the i386 version ?
On what server you've been conclusive results?
Thanks for your answers, and for your interest.
[EDIT]
It's my "top" screen for all process after install : Code: last pid: 18099; load avg: 0.99, 0.66, 0.85; up 0+00:44:34 09:50:18
67 processes: 64 sleeping, 2 running, 1 on cpu
CPU states: 98.7% idle, 0.0% user, 1.3% kernel, 0.0% iowait, 0.0% swap
Memory: 1024M phys mem, 502M free mem, 2048M swap, 2048M free swap
May 20 09:50:11 zimbra.bollore-technologies.fr zmmailboxdmgr[17965]: no manager process is running
17638 root 1 59 0 2408K 1840K cpu 0:00 0.51% top
6916 zimbra 10 59 0 45M 10M sleep 0:02 0.12% mysqld
7041 zimbra 10 59 0 45M 13M sleep 0:02 0.06% mysqld
922 noaccess 24 59 0 164M 68M sleep 0:29 0.04% java
8372 zimbra 1 59 0 9240K 6968K run 0:02 0.04% perl
324 root 4 59 0 5128K 2600K sleep 0:00 0.01% inetd
9 root 16 59 0 11M 4656K sleep 0:19 0.01% svc.configd
7 root 13 59 0 11M 6056K sleep 0:03 0.01% svc.startd
8386 zimbra 1 59 0 16M 4336K sleep 0:00 0.00% httpd
348 root 1 59 0 1328K 856K run 0:00 0.00% utmpd
10925 zimbra 1 59 0 62M 58M sleep 0:11 0.00% clamd
8139 zimbra 1 59 0 57M 30M sleep 0:03 0.00% amavisd
493 root 16 59 0 14M 6144K sleep 0:03 0.00% fmd
7856 zimbra 1 59 0 7904K 4536K sleep 0:03 0.00% zmmtaconfig
5808 zimbra 5 59 0 108M 10M sleep 0:01 0.00% slapd
117 daemon 3 59 0 4592K 2184K sleep 0:01 0.00% kcfd
10926 zimbra 1 59 0 3376K 1984K sleep 0:01 0.00% freshclam
8244 zimbra 1 59 0 58M 6936K sleep 0:00 0.00% amavisd
8245 zimbra 1 59 0 58M 6920K sleep 0:00 0.00% amavisd
8250 zimbra 1 59 0 58M 6824K sleep 0:00 0.00% amavisd
8248 zimbra 1 59 0 58M 6744K sleep 0:00 0.00% amavisd
8363 zimbra 1 59 0 6560K 4240K sleep 0:00 0.00% swatch
546 root 1 59 0 9592K 3992K sleep 0:00 0.00% snmpd
17612 postfix 1 59 0 11M 3752K sleep 0:00 0.00% showq
8840 root 1 59 0 11M 3408K sleep 0:00 0.00% master [/EDIT]
Last edited by nemesix : 05-20-2008 at 12:52 AM.
| | Thread Tools | | | | Display Modes |  Linear Mode | 
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On | | | |
Zimbra :: Bugzilla
Zimbra :: Wiki
