Zimbra installation CentOS 5 using Windows dns server

[alsayed]

Hi,

thanks for offering a community edition. I was trying to install Zimbra for the past 3 months but no success. I'm using windows server dns.

when I connect to the administration console it keep saying "connecting..."
here is my logs. I've already 23 tab opened in my browser in Zimbra forums but I couldn't find much help in them nor in #zimbra@freenode

cat /etc/hosts

# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               localhost.localdomain localhost
192.168.0.105           mail01.alsayedlinux.com mail01
::1             localhost6.localdomain6 localhost6

cat /etc/resolv.conf

search localdomain
nameserver 192.168.0.100
nameserver 4.2.2.2
nameserver 4.2.2.3
You have mail in /var/spool/mail/zimbra

dig alsayedlinux.com mx

; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5_4.2 <<>> alsayedlinux.com mx
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 28037
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

;; QUESTION SECTION:
;alsayedlinux.com.              IN      MX

;; AUTHORITY SECTION:
alsayedlinux.com.       3600    IN      SOA     server001.alsayedgroup.com. hostmaster.alsayedgroup.com. 13 900 600 86400 3600

;; Query time: 1 msec
;; SERVER: 192.168.0.100#53(192.168.0.100)
;; WHEN: Sun Jun 27 20:44:39 2010
;; MSG SIZE  rcvd: 104

dig alsayedlinux.com any

; <<>> DiG 9.3.6-P1-RedHat-9.3.6-4.P1.el5_4.2 <<>> alsayedlinux.com any
;; global options:  printcmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 40575
;; flags: qr aa rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 0, ADDITIONAL: 1

;; QUESTION SECTION:
;alsayedlinux.com.              IN      ANY

;; ANSWER SECTION:
alsayedlinux.com.       3600    IN      NS      server001.alsayedgroup.com.
alsayedlinux.com.       3600    IN      SOA     server001.alsayedgroup.com. hostmaster.alsayedgroup.com. 13 900 600 86400 3600

;; ADDITIONAL SECTION:
server001.alsayedgroup.com. 3600 IN     A       192.168.0.100

;; Query time: 1 msec
;; SERVER: 192.168.0.100#53(192.168.0.100)
;; WHEN: Sun Jun 27 20:45:44 2010
;; MSG SIZE  rcvd: 134

zmcontrol status

Host mail01.alsayedlinux.com
        antispam                Running
        antivirus               Running
        ldap                    Running
        logger                  Running
        mailbox                 Stopped
                mysql.server is not running.
        mta                     Stopped
                postfix is not running
        snmp                    Running
        spell                   Running
        stats                   Stopped

/opt/zimbra/log/mysql_error.log

100622 19:25:27  mysqld started
100622 19:25:27 [ERROR] Can't start server: cannot resolve hostname!: Success
100622 19:25:27  mysqld ended

100622 19:29:17  mysqld started
100622 19:29:17 [ERROR] Can't start server: cannot resolve hostname!: Success
100622 19:29:17  mysqld ended

100622 20:09:05  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
100622 20:09:05  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
100622 20:09:05  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
100622 20:09:08  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 100 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100
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
100622 20:09:10  InnoDB: Started; log sequence number 0 0
100622 20:09:10 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100622 20:09:10  mysqld ended

100622 22:18:51  mysqld started
100622 22:18:51 [ERROR] Can't start server: cannot resolve hostname!: Success
100622 22:18:52  mysqld ended

100622 22:59:06  mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100622 22:59:07  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Creating foreign key constraint system tables
InnoDB: Starting in background the rollback of uncommitted transactions
100622 22:59:07  InnoDB: Rollback of non-prepared transactions completed
InnoDB: Foreign key constraint system tables created
100622 22:59:07  InnoDB: Started; log sequence number 0 36808
100622 22:59:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100622 22:59:07  mysqld ended

100626 21:36:24  mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100626 21:36:26  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100626 21:36:27  InnoDB: Started; log sequence number 0 36808
100626 21:36:27 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100626 21:36:27  mysqld ended

100627 17:51:28  mysqld started
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
100627 17:51:29  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
100627 17:51:29  InnoDB: Started; log sequence number 0 36808
100627 17:51:29 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
100627 17:51:29  mysqld ended

[phoenix]

The simple answer is you have no DNS A or MX records for pointing to your Zimbra server LAN IP for the domain alsayedlinux.com (it doesn't matter whether you have Windows or Linux DNS server) and you can see that from the results of your dig commands, this has been covered many times in the forums.

[alsayed]

I've searched the forum for setting dns in windows for zimbra but I couldn't find any guide. could some one help please.

we have M$ exchange and we want to replace it with an open source mail system.

[phoenix]

Originally Posted by alsayed

I've searched the forum for setting dns in windows for zimbra but I couldn't find any guide. could some one help please.

You need to create A & MX records in your DNS server that point to the LAN IP of your Zimbra server. If you don't know how to do that you should ask whoever administers your DNS server to do it for you.

The alternative would be to install a Split DNS using something like BIND on your Zimbra server. I've already said there are plenty of threads in the forums that describe what's necessary and how to test the DNS configuration once you've set-up your DNS server.