Problem Upgrading from 4.0.1 to 4.0.x

[shankwc]

I had an error upgrading to 4.0.1. I think it had something to do with the documents not being properly setup from the 3.1 -> 4.0 move. When I upgrade from 4.0.1 to 4.0.2 the upgrade completes but I get a message about and INVALID_PDU when I attempt to login. If I try to push farther and upgrade the 4.0.2 to 4.0.3 it fails saying:

Restoring existing configuration file from /opt/zimbra/.saveconfig/config.save...done
Operations logged to /tmp/zmsetup.log.15204
Setting defaults...Setting defaults from existing config...Done
Upgrading from 4.0.2_GA_362 to 4.0.3_GA_406
Sun Nov 19 00:40:04 2006: Stopping zimbra services
Sun Nov 19 00:40:08 2006: Starting mysql
Sun Nov 19 00:40:10 2006: Checking logger mysql status
Sun Nov 19 00:40:10 2006: Starting logger mysql
Sun Nov 19 00:40:11 2006: SELECT value FROM config WHERE name = 'db.version'
This appears to be 4.0.2_GA
Schema upgrade required
Sun Nov 19 00:40:11 2006: Running /opt/zimbra/libexec/scripts/migrate-ComboUpdater.pl
Sun Nov 19 00:40:13 2006: Verified schema version 26.
ERROR 1060 (42S21) at line 1: Duplicate column name 'contact_count'
Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=jbPc95sRbjXlbk9BJRt1sGva --database=zimbra --batch --skip-column-names'. at /opt/zimbra/libexec/scripts/Migrate.pm line 136,

line 287.
Sun Nov 19 00:40:13 2006: Script failed with code 1 - exiting
UPGRADE FAILED - exiting


Ultimately, I have to revert to my backup in order to recover.

Please help, I'd really like to get past this.

Thanks in advance.

[phoenix]

This has been covered many times in the forums and a quick search would have found the answer. Try running /opt/zimbra/libexec/zmsetup.pl as root.

BTW, the current version is 4.0.4 and you might want to install that.

[shankwc]

I'm sorry , I thought I looked thoroughly. I applied your patch and was able to get 4.0.2 to start succesfully, but it still giving the INVALID_PDU error in the webmail login. Should I start looking at tomcat?

[phoenix]

Which operating system is this? Have you made any changes to the ports that Zimbra uses?

[shankwc]

Debian 3.1. No I've not made any changes, but I can check to see if one of the other admins did. Catelina.out doesn't give anything useful. Looks like mail is coming in - but web and other clients can't connect.

[phoenix]

I presume that all the services are actually running? Try a 'zmcontrol status' as the zimbra user. This problem is usually caused by a port change, you can also try clearing your browser cache.

[shankwc]

Yes zmcontrol says all is well. There are also a gazzillion message defers in the logs.

like this:

Nov 19 10:12:52 localhost postfix/qmgr[27990]: 970C1CF8888: to=, relay=none, delay=0, status=deferred (delivery temporarily suspended: connect to banshee.XXXXX.com[10.2.3.137]: Connection refused)

[shankwc]

also - zmprov won't work unless i do zmprov -l , otherwise i get html output that looks to be saying something about a servelet not working.

zimbra@banshee:/opt$ zmprov gacf
ERROR: zclient.IO_ERROR (invoke unable to parse response:  
HTTP Status 404 - Servlet AdminServlet is not available
type Status report
message Servlet AdminServlet is not available
description The requested resource (Servlet AdminServlet is not available) is not available.
Apache Tomcat/5.5.15
, server: localhost) (cause: com.zimbra.soap.SoapParseException unable to parse response:  
HTTP Status 404 - Servlet AdminServlet is not available
type Status report
message Servlet AdminServlet is not available
description The requested resource (Servlet AdminServlet is not available) is not available.
Apache Tomcat/5.5.15
)

[shankwc]

oh and just for reference - server is 3Ghz dual xeon, with 3G, and 230G HDD space. When zimbra is working it runs like a champ.

[phoenix]

SElinux or firewall active on this system? Is DNS working? What does this return:

host `hostname`

Note they're backticks not quotes.