Page 2 of 4

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Tue Mar 06, 2007 10:57 pm
by dealt
Hi! The migration script worked after adjusting the innodb buffer pool size but the LDAP problem occured again (same issues i had before when upgrading to 4.5.1):

Wed Mar 7 04:30:05 2007: Updating from 3.0.1_GA

ERROR: service.FAILURE (system failure: unable to get config) (cause: javax.nami ng.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to get config) (cause: javax.nami ng.NamingException [LDAP: error code 80 - internal error])

Wed Mar 7 04:30:18 2007: Checking 3.1.0_GA

Wed Mar 7 04:30:18 2007: Updating from 3.1.0_GA

Wed Mar 7 04:32:10 2007: Checking 3.1.1_GA

Wed Mar 7 04:32:10 2007: Updating from 3.1.1_GA

Wed Mar 7 04:32:10 2007: Checking 3.1.2_GA

Wed Mar 7 04:32:10 2007: Updating from 3.1.2_GA

Wed Mar 7 04:32:10 2007: Checking 3.1.3_GA

Wed Mar 7 04:32:10 2007: Updating from 3.1.3_GA

Wed Mar 7 04:32:10 2007: Checking 3.1.4_GA

Wed Mar 7 04:32:10 2007: Updating from 3.1.4_GA

Wed Mar 7 04:32:15 2007: Checking 3.2.0_M1

Wed Mar 7 04:32:15 2007: Updating from 3.2.0_M1

ERROR: service.FAILURE (system failure: unable to list all COS) (cause: javax.na ming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to get config) (cause: javax.nami ng.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to get config) (cause: javax.nami ng.NamingException [LDAP: error code 80 - internal error])

Wed Mar 7 04:33:22 2007: Checking 3.2.0_M2

Wed Mar 7 04:33:22 2007: Updating from 3.2.0_M2

ERROR: service.FAILURE (system failure: unable to get config) (cause: javax.nami ng.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to get config) (cause: javax.nami ng.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to list all COS) (cause: javax.na ming.NamingException [LDAP: error code 80 - internal error])

Wed Mar 7 04:33:32 2007: Checking 4.0.0_RC1

Wed Mar 7 04:33:32 2007: Updating from 4.0.0_RC1

Wed Mar 7 04:33:45 2007: Checking 4.0.0_GA

Wed Mar 7 04:33:45 2007: Updating from 4.0.0_GA

Wed Mar 7 04:33:45 2007: Checking 4.0.1_GA

Wed Mar 7 04:33:45 2007: Updating from 4.0.1_GA

Wed Mar 7 04:33:48 2007: Checking 4.0.2_GA

Wed Mar 7 04:33:48 2007: Updating from 4.0.2_GA

ERROR: service.FAILURE (system failure: unable to list all COS) (cause: javax.na ming.NamingException [LDAP: error code 80 - internal error])

Wed Mar 7 04:33:54 2007: Checking 4.0.3_GA

Wed Mar 7 04:33:54 2007: Updating from 4.0.3_GA

Wed Mar 7 04:34:20 2007: Checking 4.0.4_GA

Wed Mar 7 04:34:20 2007: Updating from 4.0.4_GA

Wed Mar 7 04:34:20 2007: Checking 4.0.5_GA

Wed Mar 7 04:34:20 2007: Updating from 4.0.5_GA

Wed Mar 7 04:34:20 2007: Checking 4.1.0_BETA1

Wed Mar 7 04:34:20 2007: Updating from 4.1.0_BETA1

Wed Mar 7 04:34:20 2007: Migrating amavisd-new to version 2.4.3

Wed Mar 7 04:34:20 2007: Checking /opt/zimbra/amavisd-new-2.4.1/db

Wed Mar 7 04:34:20 2007: Checking /opt/zimbra/amavisd-new-2.4.1/.spamassassin

Wed Mar 7 04:34:20 2007: Checking /opt/zimbra/amavisd-new-2.3.3/db

Wed Mar 7 04:34:20 2007: Migrating amavis-new db from version 2.3.3 to 2.4.3

Wed Mar 7 04:34:20 2007: Checking /opt/zimbra/amavisd-new-2.3.3/.spamassassin

Wed Mar 7 04:34:20 2007: Migrating amavis-new .spamassassin from version 2.3.3 to 2.4.3

Wed Mar 7 04:34:20 2007: Checking /opt/zimbra/amavisd-new-2.3.1/db

Wed Mar 7 04:34:20 2007: Checking /opt/zimbra/amavisd-new-2.3.1/.spamassassin

Wed Mar 7 04:34:20 2007: Checking 4.5.0_BETA1

Wed Mar 7 04:34:20 2007: Updating from 4.5.0_BETA1

Wed Mar 7 04:34:23 2007: Checking 4.5.0_BETA2

Wed Mar 7 04:34:23 2007: Updating from 4.5.0_BETA2

Wed Mar 7 04:34:23 2007: Checking 4.5.0_RC1

Wed Mar 7 04:34:23 2007: Updating from 4.5.0_RC1

ERROR: service.FAILURE (system failure: unable to list all COS) (cause: javax.na ming.NamingException [LDAP: error code 80 - internal error])

Wed Mar 7 04:34:30 2007: Failed to delete cn=timezones,cn=config,cn=zimbra: int ernal error

Wed Mar 7 04:34:30 2007: Checking 4.5.0_RC2

Wed Mar 7 04:34:30 2007: Updating from 4.5.0_RC2

Wed Mar 7 04:34:35 2007: Checking 4.5.0_GA

Wed Mar 7 04:34:35 2007: Updating from 4.5.0_GA

Wed Mar 7 04:34:35 2007: Checking 4.5.1_GA

Wed Mar 7 04:34:35 2007: Updating from 4.5.1_GA

Wed Mar 7 04:34:38 2007: Checking 4.5.2_GA

Wed Mar 7 04:34:38 2007: Updating from 4.5.2_GA

Wed Mar 7 04:34:38 2007: Checking 4.5.3_GA

Wed Mar 7 04:34:38 2007: Updating from 4.5.3_GA

Wed Mar 7 04:34:47 2007: Stopping ldap

Upgrade complete

Checking for port conflicts

Starting ldap...Done

Setting defaults from ldap...ERROR: service.FAILURE (system failure: unable to l ookup server by name: stiimail.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: javax.naming.NamingException [LDAP: error code 80 - int ernal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup COS by name: default me ssage: [LDAP: error code 80 - internal error]) (cause: javax.naming.NamingExcept ion [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

ERROR: service.FAILURE (system failure: unable to lookup server by name: stiimai l.stii.dost.gov.ph message: [LDAP: error code 80 - internal error]) (cause: java x.naming.NamingException [LDAP: error code 80 - internal error])

Done
Main menu
1) Hostname: stiimail.stii.dost.gov.ph

2) Ldap master host: stiimail.stii.dost.gov.ph

3) Ldap port: 389

4) Ldap password: set

5) zimbra-ldap: Enabled

6) zimbra-store: Enabled

+Create Admin User: no

+Enable automated spam training: yes

******* +Spam training user: UNSET

******* +Non-spam(Ham) training user: UNSET

+Global Documents Account: wiki@stiimail.stii.dost.gov.ph

+SMTP host: stiimail.stii.dost.gov.ph

******* +Web server HTTP port: UNSET

******* +Web server HTTPS port: UNSET

+Web server mode: mixed

+Enable POP/IMAP proxy: no

******* +IMAP server port: UNSET

******* +IMAP server SSL port: UNSET

******* +POP server port: UNSET

******* +POP server SSL port: UNSET

+Use spell check server: yes

+Spell server URL: http://stiimail.stii.dost.gov.ph: 7780/aspell.php
7) zimbra-mta: Enabled

8) zimbra-snmp: Enabled

9) zimbra-logger: Enabled

10) zimbra-spell: Enabled

r) Start servers after configuration yes

s) Save config to file

x) Expand menu

q) Quit
Address unconfigured (**) items (? - help)


Here are my os configurations that I think are helpful in solving this issue:
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

202.90.141.143 stiimail.stii.dost.gov.ph stiimail
cat /etc/redhat-release

Fedora Core release 4 (Stentz)
cat /etc/resolv.conf

search stii.dost.gov.ph

nameserver 202.90.141.137
nslookup

> stiimail.stii.dost.gov.ph

Server: 202.90.141.137

Address: 202.90.141.137#53
Name: stiimail.stii.dost.gov.ph

Address: 202.90.141.143

>

How can I fix this? THanks

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Tue Mar 06, 2007 11:09 pm
by jholder
try this

su -zimbra

ldap start

telnet
stiimail.stii.dost.gov.ph 389
Does it work?


3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Tue Mar 06, 2007 11:13 pm
by jholder
I'm stupid. I bet the problem is iptables.

I forgot that we were using them back then.
Make sure that you have iptables stopped
su -zimbra

zmiptables -u

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Tue Mar 06, 2007 11:23 pm
by dealt
[quote user="jholder"]I'm stupid. I bet the problem is iptables.

I forgot that we were using them back then.
Make sure that you have iptables stopped
su -zimbra

zmiptables -u[/QUOTE]
Do I have to restore my backup first, then stop zmiptables, then do the upgrade? Or just re-run install.sh?

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Tue Mar 06, 2007 11:27 pm
by jholder
Good question. I don't know. You're only the second user that I've seen upgrade from a 3.1 release :)
I'd guess that zmiptables is probably stopped, and the script already exists, so I'd say just run the script.
If it fails, or doesn't run, do a forums search on iptables.
john

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Tue Mar 06, 2007 11:51 pm
by dealt
[quote user="jholder"]Good question. I don't know. You're only the second user that I've seen upgrade from a 3.1 release :)
I'd guess that zmiptables is probably stopped, and the script already exists, so I'd say just run the script.
If it fails, or doesn't run, do a forums search on iptables.
john[/QUOTE]
Hi! I did the following:
su - zimbra

[zimbra@stiimail ~]$ telnet stiimail.stii.dost.gov.ph:389

stiimail.stii.dost.gov.ph:389/telnet: Name or service not known

[zimbra@stiimail ~]$ telnet stiimail.stii.dost.gov.ph 389

Trying 202.90.141.143...

Connected to stiimail.stii.dost.gov.ph (202.90.141.143).

Escape character is '^]'.
..then re-run install.sh script, im still having the same problems. I'll try to restore my backup then do the same process.

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Tue Mar 06, 2007 11:54 pm
by jholder
Sorry,

By script, I meant the zmiptables -u script.
Go ahead and run that.

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Wed Mar 07, 2007 12:59 am
by dealt
[quote user="jholder"]Sorry,

By script, I meant the zmiptables -u script.
Go ahead and run that.[/QUOTE]
Er.. i dont seem to have zmiptables script
[root@stiimail store]# find / -name zmiptables

find: WARNING: Hard link count is wrong for /proc: this may be a bug in your filesystem driver. Automatically turning on find's -noleaf option. Earlier results may have failed to include directories that should have been searched.
Right now, I have a working zimbra 3.0 (restored from backup) and I can connect to ldap via telnet:
[root@stiimail store]# su - zimbra

[zimbra@stiimail ~]$ telnet stiimail.stii.dost.gov.ph 389

Trying 202.90.141.143...

Connected to stiimail.stii.dost.gov.ph (202.90.141.143).

Escape character is '^]'.


What went wrong?:confused:

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Wed Mar 07, 2007 9:44 pm
by dealt
Does the installation script stop the ldap service during installation?

3.0 to 4.5.3 Upgrade failed (mysql error)

Posted: Wed Mar 07, 2007 10:09 pm
by jholder
Try this as root:

iptables -t nat -F