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

Thread: MySQL tables not created

  1. #1
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    7

    Default MySQL tables not created

    Hi,

    After succeed to install Zimbra on Debian 4.0 amd64 machine with the Ubuntu 64 packages, it seems that the mysql tables are not created I got this message in zmloggerinit.log :

    Code:
    Installing MySQL system tables...
    080630  4:33:50 [ERROR] Can't start server: cannot resolve hostname!: Success
    Installation of system tables failed!
    The hostname cmd return the right hostname and localhost is well resolved too.

    I try to start the mysqld daemon with:
    /opt/zimbra/logger/mysql/libexec/mysqld --skip-grant &
    and use the command line tool
    /opt/zimbra/logger/mysql/bin/mysql:

    But there is no table in the DB .

    I noticed that some directories in /opt/zimbra was owned by root and I had to change the owner of /opt/zimbra/mysql/var to zimbra:zimbra to start mysql perhaps it's because of that the tables aren't created ?

    How to fix that (recreate the tables) and what is the directories to be owned by root or zimbra ?

    Thanks in advance.

    Sam.

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

    Default

    Which version of ZCS and release did you install ?
    Code:
    su - zimbra
    zmcontrol -v
    you can fix the permissions by running as root
    Code:
    /opt/zimbra/libexec/zmfixperms -extended
    by the looks of things the ZCS install did not like your DNS setup. Are you behind a firewall? Please post
    Code:
    cat /etc/hosts
    cat /etc/resolv.conf
    dig _yourdomain_ mx
    dig _yourdomain_ any
    host `hostname` <- note backticks and not double quotes

  3. #3
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    7

    Default

    Quote Originally Posted by uxbod View Post
    Which version of ZCS and release did you install ?
    Code:
    su - zimbra
    zmcontrol -v
    This command give: Release 5.0.6_GA_2313.UBUNTU6_64 DEBIAN4.0_64 I forced the Ubuntu 64bits on Debian 4.0 64bits

    Quote Originally Posted by uxbod View Post
    you can fix the permissions by running as root
    Code:
    /opt/zimbra/libexec/zmfixperms -extended
    Ok, but /opt/zimbra/mysql/var back to owner root...
    Quote Originally Posted by uxbod View Post
    by the looks of things the ZCS install did not like your DNS setup. Are you behind a firewall?
    Yes this is a virtual server hosted on machine with a firewall.

    Please post

    cat /etc/hosts = 88.191.208.158 soleil-4.arial-concept.com
    cat /etc/resolv.conf =

    Code:
    nameserver 127.0.0.1
    nameserver 88.191.254.60
    nameserver 88.191.254.70
    dig _yourdomain_ mx =

    Code:
    ; <<>> DiG 9.3.4 <<>> arial-concept.com mx
    ;; global options:  printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 6206
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 3, ADDITIONAL: 4
    
    ;; QUESTION SECTION:
    ;arial-concept.com.             IN      MX
    
    ;; ANSWER SECTION:
    arial-concept.com.      3600    IN      MX      10 soleil-3.arial-concept.com.
    arial-concept.com.      3600    IN      MX      50 soleil-bk.arial-concept.com.
    
    ;; AUTHORITY SECTION:
    arial-concept.com.      10492   IN      NS      b.dns.gandi.net.
    arial-concept.com.      10492   IN      NS      a.dns.gandi.net.
    arial-concept.com.      10492   IN      NS      c.dns.gandi.net.
    
    ;; ADDITIONAL SECTION:
    soleil-bk.arial-concept.com. 3304 IN    A       88.191.62.143
    c.dns.gandi.net.        172488  IN      A       217.70.182.20
    a.dns.gandi.net.        172488  IN      A       217.70.179.40
    b.dns.gandi.net.        172488  IN      A       217.70.184.40
    
    ;; Query time: 4 msec
    ;; SERVER: 88.191.254.60#53(88.191.254.60)
    ;; WHEN: Mon Jun 30 19:10:26 2008
    ;; MSG SIZE  rcvd: 211
    dig _yourdomain_ any =

    Code:
    ; <<>> DiG 9.3.4 <<>> arial-concept.com any
    ;; global options:  printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 5127
    ;; flags: qr rd ra; QUERY: 1, ANSWER: 5, AUTHORITY: 3, ADDITIONAL: 4
    
    ;; QUESTION SECTION:
    ;arial-concept.com.             IN      ANY
    
    ;; ANSWER SECTION:
    arial-concept.com.      3525    IN      MX      50 soleil-bk.arial-concept.com.
    arial-concept.com.      3525    IN      MX      10 soleil-3.arial-concept.com.
    arial-concept.com.      10417   IN      NS      b.dns.gandi.net.
    arial-concept.com.      10417   IN      NS      a.dns.gandi.net.
    arial-concept.com.      10417   IN      NS      c.dns.gandi.net.
    
    ;; AUTHORITY SECTION:
    arial-concept.com.      10417   IN      NS      c.dns.gandi.net.
    arial-concept.com.      10417   IN      NS      a.dns.gandi.net.
    arial-concept.com.      10417   IN      NS      b.dns.gandi.net.
    
    ;; ADDITIONAL SECTION:
    soleil-bk.arial-concept.com. 3229 IN    A       88.191.62.143
    c.dns.gandi.net.        172413  IN      A       217.70.182.20
    a.dns.gandi.net.        172413  IN      A       217.70.179.40
    b.dns.gandi.net.        172413  IN      A       217.70.184.40
    
    ;; Query time: 0 msec
    ;; SERVER: 88.191.254.60#53(88.191.254.60)
    ;; WHEN: Mon Jun 30 19:11:41 2008
    ;; MSG SIZE  rcvd: 253
    host `hostname` = soleil-4.arial-concept.com has address 88.191.208.158

    Thanks for your help.

    Sam.

  4. #4
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    7

    Default

    ...I have an idea; this machine is a virtual server who share the interface eth0 with the host machine and there is 3 IPs coming on the same interface 2 are already used by the host machine and 1 gest and I have to bind each apps on his own IP this that I do for the first machines.

    Now I do the same for the Zimbra apps I add "inet_interface = 88.191.208.158" in postfix main.cf and add the IP on bind-address setting on my.cnf (mysql) I also add "Listen 88.191.208.158:7780" in httpd.conf I had just "Listen 7780" !?

    Tell me if I have to bind some others apps...

    Thanks again.

    Sam.

  5. #5
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    7

    Default

    ...after add in /etc/hosts :

    127.0.0.1 localhost.localdomain localhost

    and redo the installation all services are started but the install.sh don't exit and I got always this in malbox.log:

    Code:
    ** END NESTED EXCEPTION **
    
    
    Attempted reconnect 3 times. Giving up.
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
            at com.mysql.jdbc.Connection.createNewIO(Connection.java:2838)
            at com.mysql.jdbc.Connection.(Connection.java:1531)
            at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
            at java.sql.DriverManager.getConnection(DriverManager.java:525)
            at java.sql.DriverManager.getConnection(DriverManager.java:140)
            at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)
            at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java: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)
            ... 33 more
    Sam.

  6. #6
    Join Date
    Aug 2005
    Posts
    24
    Rep Power
    10

    Default

    Hi Sam,
    That's not the full exception. Please post the full exception.

  7. #7
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    7

    Default

    Argh... it seems à password problem for user zimbra on MySQL how to fix that ?

    Code:
    ** BEGIN NESTED EXCEPTION **                                                                                                                                 
                                                                                                                                                                 
    java.sql.SQLException                                                                                                                                        
    MESSAGE: Access denied for user 'zimbra'@'soleil-4.arial-concept.com' (using password: YES)                                                                  
                                                                                                                                                                 
    STACKTRACE:                                                                                                                                                  
                                                                                                                                                                 
    java.sql.SQLException: Access denied for user 'zimbra'@'soleil-4.arial-concept.com' (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:525)                                                                                      
            at java.sql.DriverManager.getConnection(DriverManager.java:140)                                                                                      
            at org.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:97)                                   
            at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java: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.Zimbra.waitForDatabase(Zimbra.java:114)                                                                                        
            at com.zimbra.cs.util.Zimbra.startup(Zimbra.java:154)                                                                                                
            at com.zimbra.cs.util.Zimbra.startup(Zimbra.java:129)                                                                                                
            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:585)                                                                                                  
            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)                                                                                                        
                                                                                                                                                                 
                                                                                                                                                                 
    ** END NESTED EXCEPTION **

    Thanks again for your help.

    Sam.

  8. #8
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Right on the front page of the wiki is the link to fix it.

  9. #9
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    7

    Default

    So, I run the command on user zimbra "zmmylogpasswd xxxxx" and start Zimbra but I always have the same error in mailbox.log about acces denied for zimbra@soleil-4.arial-concept.com !?

    But all services are started.

    Please help...

    Sam.

  10. #10
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    7

    Default

    ...I do "zmmypasswd xxxxx" too but it's the same.

    Sam.

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  2. [SOLVED] Install Problem in Ubuntu 6.06 Server
    By xtimox in forum Installation
    Replies: 16
    Last Post: 03-27-2008, 10:36 AM
  3. DNS Questions and Trouble Installing
    By smurraysb in forum Installation
    Replies: 22
    Last Post: 03-14-2008, 04:27 PM
  4. BUILD FAILED error is killing me
    By hanysys in forum Developers
    Replies: 11
    Last Post: 05-11-2007, 07:09 AM
  5. Replies: 18
    Last Post: 03-20-2006, 02:22 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
  •