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

Thread: failed upgrade from 5.0.11 to 6.0.6

  1. #1
    admin1 is offline Loyal Member
    Join Date
    Oct 2007
    Location
    Massachusetts
    Posts
    76
    Rep Power
    7

    Question failed upgrade from 5.0.11 to 6.0.6

    All seemed fine until :

    Restoring existing configuration file from /opt/zimbra/.saveconfig/localconfig.xml...done
    Operations logged to /tmp/zmsetup.04192010-004026.log
    Upgrading from 5.0.11_GA_2695 to 6.0.6_GA_2324
    Stopping zimbra services...done.
    Verifying /opt/zimbra/conf/my.cnf
    ERROR 1033 (HY000) at line 1: Incorrect information in file: './zimbra/config.frm'
    Mon Apr 19 00:41:00 2010: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=xnWjGf0pHOUGmMvOEWEH_e0B8e9wM8 --database=zimbra --batch --skip-column-names'.
    What might cause this?

    Thanks

  2. #2
    azeem is offline Active Member
    Join Date
    May 2007
    Location
    Norway
    Posts
    28
    Rep Power
    8

    Default HELP - Upgrade 5.0.14 to 6.0.7.1 failed

    I'm haveing the same problem when upgrading from 5.0.14 to 6.0.7.1

    I have seen a few references to this error, but no real solution. Any help is greatly appreciated


    Arnljot

  3. #3
    iway is offline Partner (VAR/HSP)
    Join Date
    May 2008
    Posts
    432
    Rep Power
    7

    Default

    Have you opened a support case?

  4. #4
    azeem is offline Active Member
    Join Date
    May 2007
    Location
    Norway
    Posts
    28
    Rep Power
    8

    Default

    I'm running the Open Source version, so I really need community help. All my other upgrades over the years have run without fault. Luckily I have a snapshot of the VM running the Zimbra server, but I hope I'll get the upgrade running before monday.
    Last edited by azeem; 06-19-2010 at 03:31 PM.

  5. #5
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,580
    Rep Power
    57

    Default

    Quote Originally Posted by azeem View Post
    I'm running the Open Source version, so I really need community help. All my other upgrades over the years have run without fault. Luckily I have a snapshot of the VM running the Zimbra server, but I hope I'll get the upgrade running before monday.
    Try this first: [SOLVED] Upgrade from 6.0.1 to 6.0.2 fails

    When you've finished the upgrade please update your forum profile (it's somewhat out of date ) with the output of the following:

    Code:
    zmcontrol -v
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  6. #6
    azeem is offline Active Member
    Join Date
    May 2007
    Location
    Norway
    Posts
    28
    Rep Power
    8

    Default

    Not so easy unfortunately. The md5sum checks out.

    It seems the SQL server is already running. I tried to run the ./install.sh one more time, and this time I get the following error when verifying db integrity:

    Do you want to verify message store database integrity? [Y] y
    Verifying integrity of message store databases. This may take a while.
    Starting mysqld...done.
    /opt/zimbra/mysql/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2) when trying to connect
    No errors found
    command failed
    This did not happen during the first install/upgrade.


    Also, when I start the sql server manually, I get the same error message as I get during install :
    mail2:~# /opt/zimbra/bin/mysql --user=zimbra --password=<my password> --database=zimbra --batch --skip-column-names
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/db/mysql.sock' (2)
    However, doing a '/opt/zimbra/bin/mysql.server status' tells me the mysq server is not running. Trying to start it with '/opt/zimbra/bin/mysql.server start' works without error, but status is stil 'not running' and the following is logged in /opt/zimbra/log/mysql_error.log
    100620 12:35:48 mysqld started
    100620 12:35:50 InnoDB: Started; log sequence number 0 565847811
    100620 12:35:50 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
    100620 12:35:50 [ERROR] Do you already have another mysqld server running on port: 7306 ?
    100620 12:35:50 [ERROR] Aborting

    100620 12:35:50 InnoDB: Starting shutdown...
    100620 12:35:51 InnoDB: Shutdown completed; log sequence number 0 565847811
    100620 12:35:51 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

    100620 12:35:51 mysqld ended
    When I do a 'ps aux | grep sql' , I get:
    zimbra 11793 0.0 0.0 3164 1644 ? S 01:19 0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --external-locking --log-error=/opt/zimbra/log/mysql_error.log --ledir=/opt/zimbra/mysql/libexec
    zimbra 11839 0.0 2.2 569064 46796 ? Sl 01:19 0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --pid-file=/opt/zimbra/db/mysql.pid --skip-external-locking --port=7306 --socket=/opt/zimbra/db/mysql.sock --external-locking
    root 9838 0.0 0.0 2856 688 pts/0 R+ 12:19 0:00 grep sql
    This is obviously a different binary.....

    As you can tell, I have no clue about mysql, and some of the suff I'm trying is probably way off. However, I believe something is not right on the database side of things.

    I have not had any db problems in the past. I run Zimbra on a VM on Debian 4 OS. The VM has 2 GB of RAM.

  7. #7
    iway is offline Partner (VAR/HSP)
    Join Date
    May 2008
    Posts
    432
    Rep Power
    7

    Default

    You could try to kill all mysql processes befor doing the upgrade. kill process-id

  8. #8
    azeem is offline Active Member
    Join Date
    May 2007
    Location
    Norway
    Posts
    28
    Rep Power
    8

    Default

    Here is the startup sequence with errors:
    Starting ldap...Done.
    Unable to determine enabled services from ldap.
    Enabled services read from cache. Service list may be inaccurate.
    Starting logger...Failed.
    Starting logswatch...ERROR: service.FAILURE (system failure: unable to lookup server by name: mail2.platinium.no message: [LDAP: error code 49 - Invalid Credentials]) (cause: javax.naming.AuthenticationException [LDAP: error code 49 - Invalid Credentials])
    zimbra logger service is not enabled! failed.


    Starting mailbox...Done.
    Starting antispam...Done.
    Starting snmp...Done.
    Starting spell...Done.
    Starting mta...Failed.
    Starting zmmtaconfig...zmmtaconfig is already running.
    Starting saslauthd...saslauthd[8301] :set_auth_mech : failed to initialize mechanism zimbra
    failed.
    zmsaslauthdctl failed to start


    Starting stats...Done.

  9. #9
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,580
    Rep Power
    57

    Default

    Quote Originally Posted by azeem View Post
    I have not had any db problems in the past. I run Zimbra on a VM on Debian 4 OS. The VM has 2 GB of RAM.
    What sort of a VM is this, xen, vserver, VMware etc.?

    Shutdown Zimbra and check if there's any of the services still running and kill them, when you've got rid of them all try the upgrade again. I'd suggest you download the current 6.0.7.1 for the upgrade.

    Before you run the upgrade let's also see the output of the following commands (run on the Zimbra server):

    Code:
    cat /etc/hosts
    cat /etc/resolv.conf
    dig yourdomain.com mx
    dig yourdomain.com any
    host `hostname` <- use that exact command with backticks not single quotes
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  10. #10
    azeem is offline Active Member
    Join Date
    May 2007
    Location
    Norway
    Posts
    28
    Rep Power
    8

    Default

    Thanks for your input Phoenix.

    I'm running on Xen, and have been for several years. I'm using FOSS 6.0.7.1 to upgrade. AFter stopping Zimbra, two mysql proccesses are still running. I killed them both, and did the upgrade again, with the same result.

    Here are my dns details:

    mail2:~# cat /etc/hosts
    127.0.0.1 localhost.platinium.no localhost
    192.168.0.9 mail2.platinium.no mail2

    mail2:~# cat /etc/resolv.conf
    search tveterveien.local
    nameserver 192.168.0.10

    mail2:~# dig platinium.no mx

    ; <<>> DiG 9.3.4-P1.2 <<>> platinium.no mx
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 30509
    ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0

    ;; QUESTION SECTION:
    ;platinium.no. IN MX

    ;; AUTHORITY SECTION:
    platinium.no. 3600 IN SOA winsrv01.tveterveien.local. hostmaster.tveterveien.local. 11 900 600 86400 3600

    ;; Query time: 4 msec
    ;; SERVER: 192.168.0.10#53(192.168.0.10)
    ;; WHEN: Sun Jun 20 17:01:01 2010
    ;; MSG SIZE rcvd: 103

    mail2:~# dig platinium.no any

    ; <<>> DiG 9.3.4-P1.2 <<>> platinium.no any
    ;; global options: printcmd
    ;; Got answer:
    ;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 9277
    ;; flags: qr aa rd ra; QUERY: 1, ANSWER: 2, AUTHORITY: 0, ADDITIONAL: 1

    ;; QUESTION SECTION:
    ;platinium.no. IN ANY

    ;; ANSWER SECTION:
    platinium.no. 3600 IN NS winsrv01.tveterveien.local.
    platinium.no. 3600 IN SOA winsrv01.tveterveien.local. hostmaster.tveterveien.local. 11 900 600 86400 3600

    ;; ADDITIONAL SECTION:
    winsrv01.tveterveien.local. 3600 IN A 192.168.0.10

    ;; Query time: 0 msec
    ;; SERVER: 192.168.0.10#53(192.168.0.10)
    ;; WHEN: Sun Jun 20 17:01:09 2010
    ;; MSG SIZE rcvd: 133

    mail2:~# host mail2.platinium.no
    mail2.platinium.no has address 192.168.0.9
    mail2.platinium.no mail is handled by 10 mail2.platinium.no.
    mail2:~#
    The dig output looks incomplete, but the server is running in a local domain while hosting mail for two public domains. This has worked all the way up to my upgrade attempt.

    Here you see the public mx record which points to our external virus cleaner:
    Your Input platinium.no
    Results
    (MX) Pref 10, dkcphmx70.softcom.dk.
    (MX) Pref 10, dkcphmx68.softcom.dk.
    (MX) Pref 10, deframx24.softcom.dk.

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. [SOLVED] upgrade to 5.0.21 from 5.0.11 failed
    By alto in forum Administrators
    Replies: 3
    Last Post: 04-14-2010, 08:30 AM
  2. Replies: 7
    Last Post: 02-15-2010, 08:55 PM
  3. Replies: 8
    Last Post: 01-28-2010, 12:32 PM
  4. [SOLVED] 5.0.11 to 5.0.12 Upgrade Fails (Stop failed)
    By Mccreations in forum Installation
    Replies: 11
    Last Post: 03-31-2009, 07:05 AM
  5. Help!!! Moving ZCS does not work!
    By ASebestian in forum Migration
    Replies: 7
    Last Post: 02-12-2009, 06:06 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
  •