Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: [SOLVED] [Solaris 10] : Mysql database install problem

  1. #1
    Join Date
    Mar 2008
    Posts
    16
    Rep Power
    7

    Question [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.
    Attached Files Attached Files

  2. #2
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    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 ?

  3. #3
    Join Date
    Mar 2008
    Posts
    16
    Rep Power
    7

    Default

    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.

  4. #4
    dijichi2 is offline OpenSource Builder & Moderator
    Join Date
    Oct 2005
    Posts
    1,176
    Rep Power
    12

    Default

    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?

  5. #5
    Join Date
    Mar 2008
    Posts
    16
    Rep Power
    7

    Default

    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.
    Attached Files Attached Files
    Last edited by nemesix; 05-19-2008 at 08:59 AM.

  6. #6
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    25

    Default

    As I mentioned before please check check /opt/zimbra/logger/db/_zmhostname_.err for any error messages, especially when ZCS was being installed.

  7. #7
    Join Date
    Mar 2008
    Posts
    16
    Rep Power
    7

    Default

    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.

  8. #8
    dijichi2 is offline OpenSource Builder & Moderator
    Join Date
    Oct 2005
    Posts
    1,176
    Rep Power
    12

    Default

    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!

  9. #9
    dijichi2 is offline OpenSource Builder & Moderator
    Join Date
    Oct 2005
    Posts
    1,176
    Rep Power
    12

    Default

    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.

  10. #10
    Join Date
    Mar 2008
    Posts
    16
    Rep Power
    7

    Default

    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 01:52 AM.

Similar Threads

  1. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 04:27 PM
  2. Zimbra wont start, only LDAP...
    By redbaron in forum Installation
    Replies: 14
    Last Post: 08-11-2007, 12:17 AM
  3. Replies: 5
    Last Post: 10-14-2005, 03:29 AM
  4. different install problem
    By tachijuan in forum Installation
    Replies: 4
    Last Post: 09-29-2005, 05:46 PM
  5. Installation fails, possible mysql problem
    By webminster in forum Installation
    Replies: 6
    Last Post: 09-09-2005, 03:41 PM

Posting Permissions

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