Results 1 to 10 of 13

Thread: Upgrade Zimbra OSE 7.2.1 to 8.0.0 MySQL Failed

Hybrid View

  1. #1
    Join Date
    Oct 2012
    Posts
    16
    Rep Power
    3

    Default Upgrade Zimbra OSE 7.2.1 to 8.0.0 MySQL Failed

    Hi,

    I want to upgrade my Zimbra 7.2.1 OSE in Ubuntu 10.04 LTS 64Bits to Zimbra OSE 8.0.0. But i have problem in MySQL.

    The upgrade was blocked in "Starting mysql".

    Code:
    Do you want to verify message store database integrity? [Y] 
    Verifying integrity of message store databases.  This may take a while.
    Starting mysqld.../opt/zimbra/mysql/bin/mysqladmin: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
    Fatal error in defaults handling. Program aborted
    /opt/zimbra/mysql/bin/mysqladmin: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
    Fatal error in defaults handling. Program aborted
    done.
    mysqld is alive
    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --auto-repair --password=XXXXXXXX
    mysql.general_log
     Error    : You can't use locks with log tables.
     mysql.slow_log
     Error    : You can't use locks with log tables.
    mysqld is alive
    Stopping mysqld... done.
    
    ...
    
    Restoring existing configuration file from /opt/zimbra/.saveconfig/localconfig.xml...done
    Operations logged to /tmp/zmsetup.10072012-173944.log
    Upgrading from 7.2.1_GA_2790 to 8.0.0_GA_5434
    Stopping zimbra services...done.
    Starting mysql...

  2. #2
    Join Date
    Dec 2009
    Location
    Michigan
    Posts
    454
    Rep Power
    5

    Default

    Do you want to verify message store database integrity? [Y]
    Try again, but this time, say no to the above question.

    Doug
    Ben Franklin quote:

    "Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."

  3. #3
    Join Date
    Oct 2012
    Posts
    16
    Rep Power
    3

    Default

    I can do this. But im sur that "Starting mysql..." keep blocking

  4. #4
    Join Date
    Oct 2012
    Posts
    16
    Rep Power
    3

    Default

    Someone can help me ?

  5. #5
    Join Date
    Oct 2012
    Posts
    16
    Rep Power
    3

    Default

    I dont have "/etc/mysql/conf.d/" directory in my server.

  6. #6
    Join Date
    Oct 2012
    Posts
    16
    Rep Power
    3

    Default

    I have resolve my problem :

    Code:
    /opt/zimbra/mysql/bin/mysqladmin: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
    Fatal error in defaults handling. Program aborted
    /opt/zimbra/mysql/bin/mysqladmin: Can't read dir of '/etc/mysql/conf.d/' (Errcode: 2)
    Fatal error in defaults handling. Program aborted
    I have create cront.d folder in /etc/mysql

    Now i have this error in the upgrade
    Code:
    Starting mysql...done.
    ERROR 1133 (42000) at line 2: Can't find any matching row in the user table
    ERROR 1396 (HY000) at line 1: Operation DROP USER failed for ''@'mail'

Similar Threads

  1. Upgrade to Zimbra 8 failed - script failed with code 256
    By dm4creavil in forum Administrators
    Replies: 0
    Last Post: 10-02-2012, 06:53 AM
  2. zimbra 6.0.2 to 6.0.3 crash on mysql Upgrade
    By hrch in forum Administrators
    Replies: 1
    Last Post: 12-08-2009, 11:33 PM
  3. DBD::mysql::st execute failed
    By padraig in forum Administrators
    Replies: 3
    Last Post: 07-18-2007, 03:46 AM
  4. 3.0 to 4.5.3 Upgrade failed (mysql error)
    By dealt in forum Installation
    Replies: 35
    Last Post: 03-19-2007, 10:30 PM
  5. failed upgrade, failed restore, big trouble
    By feralcoder in forum Installation
    Replies: 2
    Last Post: 03-19-2007, 05:38 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •