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

Thread: MySQL tables not created

  1. #1
    przyswa is offline Senior Member
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    6

    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
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,016
    Rep Power
    24

    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
    przyswa is offline Senior Member
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    6

    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
    przyswa is offline Senior Member
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    6

    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
    przyswa is offline Senior Member
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    6

    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
    administrator is offline Administrator
    Join Date
    Aug 2005
    Posts
    24
    Rep Power
    9

    Default

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

  7. #7
    przyswa is offline Senior Member
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    6

    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

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

  9. #9
    przyswa is offline Senior Member
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    6

    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
    przyswa is offline Senior Member
    Join Date
    Jun 2008
    Posts
    59
    Rep Power
    6

    Default

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

    Sam.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

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