Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
Go Back   Zimbra :: Forums > Zimbra Collaboration Suite > Installation
Reload this Page MySQL tables not created

Welcome to the Zimbra :: Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
Page 1 of 2 1 2
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-30-2008, 07:38 AM
Senior Member
  
Posts: 59
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.
Reply With Quote
  #2 (permalink)  
Old 06-30-2008, 08:09 AM
Moderator
  
Posts: 7,928
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
__________________
Reply With Quote
  #3 (permalink)  
Old 06-30-2008, 10:19 AM
Senior Member
  
Posts: 59
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.
Reply With Quote
  #4 (permalink)  
Old 06-30-2008, 01:39 PM
Senior Member
  
Posts: 59
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.
Reply With Quote
  #5 (permalink)  
Old 06-30-2008, 04:36 PM
Senior Member
  
Posts: 59
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.
Reply With Quote
  #6 (permalink)  
Old 06-30-2008, 04:59 PM
Administrator
  
Posts: 21
Default
Hi Sam,
That's not the full exception. Please post the full exception.
Reply With Quote
  #7 (permalink)  
Old 06-30-2008, 05:37 PM
Senior Member
  
Posts: 59
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.
Reply With Quote
  #8 (permalink)  
Old 06-30-2008, 05:49 PM
Former Zimbran
  
Posts: 5,606
Default
Right on the front page of the wiki is the link to fix it.
Reply With Quote
  #9 (permalink)  
Old 07-01-2008, 07:06 AM
Senior Member
  
Posts: 59
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.
Reply With Quote
  #10 (permalink)  
Old 07-01-2008, 07:17 AM
Senior Member
  
Posts: 59
Default
...I do "zmmypasswd xxxxx" too but it's the same.

Sam.
Reply With Quote
Reply
Page 1 of 2 1 2

« Previous Thread | Today's Posts or Week's Posts | Next Thread »

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode


Similar Threads

Product Information

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

blog.zimbra.com


Home - Blog - Contact Us - Archive - Top


 

SEO by vBSEO ©2011, Crawlability, Inc.