Results 1 to 5 of 5

Thread: Upgrading from 8.0.6_GA_5922 to 8.0.7_GA_6021

  1. #1
    Oswald-Kolle is offline Loyal Member
    Join Date
    May 2006
    Posts
    83
    Rep Power
    9

    Default Upgrading from 8.0.6_GA_5922 to 8.0.7_GA_6021

    Hi,

    I have a problem with upgrading from 8.0.6_GA_5922 to 8.0.7_GA_6021.

    Here are the last lines of the upgrading-process:
    Code:
    Restoring existing configuration file from /opt/zimbra/.saveconfig/localconfig.xml...done
    Operations logged to /tmp/zmsetup.04252014-153639.log
    Upgrading from 8.0.6_GA_5922 to 8.0.7_GA_6021
    Stopping zimbra services...done.
    Starting mysql...done.
    ERROR 1045 (28000): Access denied for user 'zimbra'@'localhost' (using password: YES)
    Fri Apr 25 15:36:58 2014: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=StringReplaced --database=zimbra --batch --skip-column-names'.
    What could be the problem for this?!

    After this failure - it is possible to start zimbra (manually) with "zmcrontrol start" as zimbra user...

  2. #2
    pup_seba is offline Loyal Member
    Join Date
    Aug 2012
    Posts
    98
    Rep Power
    2

    Default

    Hi,

    I've never faced that particular problem, but I would guess that there's a mismatch among mysql passwords somewhere.

    I would start by:

    1) Analyze logs, including the ones in /tmp/install* and /tmp/zmsetup*
    2) Run "zmlocalconfig -s | grep -i pass" to see which passwords you have for user root and zimbra in your mysql.

    It's weird that the log reads "using password: YES"...do you have access to the file /opt/zimbra/.saveconfig/localconfig.xml? Is there any password in there?

    Regards,
    Sebas

  3. #3
    Oswald-Kolle is offline Loyal Member
    Join Date
    May 2006
    Posts
    83
    Rep Power
    9

    Default

    Quote Originally Posted by pup_seba View Post
    Hi,

    I've never faced that particular problem, but I would guess that there's a mismatch among mysql passwords somewhere.

    I would start by:

    1) Analyze logs, including the ones in /tmp/install* and /tmp/zmsetup*
    2) Run "zmlocalconfig -s | grep -i pass" to see which passwords you have for user root and zimbra in your mysql.

    It's weird that the log reads "using password: YES"...do you have access to the file /opt/zimbra/.saveconfig/localconfig.xml? Is there any password in there?

    Regards,
    Sebas
    I have two different passwords - is that correct?
    Code:
    mysql_root_password = Password1
    zimbra_mysql_password = Password2
    Maybe the problem could be that there is a second mysql instance running on the server - which never made any problems with the zimbra installation... All other updates went like they should...

    And now - after the failed update I got a cron error within the logrotate:
    Code:
    /etc/cron.daily/logrotate:
    error: zimbra:5 unknown user 'USER'
    error: found error in /var/log/zimbra.log , skipping
    error: zimbra:17 unknown user 'USER'
    error: found error in /var/log/zimbra-stats.log , skipping

  4. #4
    Oswald-Kolle is offline Loyal Member
    Join Date
    May 2006
    Posts
    83
    Rep Power
    9

    Default

    Okay - I tried again to reset the zimbra mysql password - I am able to log in from console with that password (also seen in the output seen above).
    The Update ends with the same error - nothing in the logs - no error no useable information...

    This is in the /tmp/log
    Code:
    (Lese Datenbank ... 113522 Dateien und Verzeichnisse sind derzeit installiert.)
    Entpacken von zimbra-spell (aus .../zimbra-spell_8.0.7.GA.6021.UBUNTU12.64_amd64.deb) ...
    zimbra-spell (8.0.7.GA.6021.UBUNTU12.64) wird eingerichtet ...
    And this in the /tmp/zmsetup.log
    Code:
    Mon Apr 28 21:23:45 2014 *** Running as zimbra user: /opt/zimbra/bin/mysql.server start
    Starting mysqld...done.
    Mon Apr 28 21:23:58 2014 done.
    This is within the first part of the logrotate:
    Code:
    /var/log/zimbra.log {
        daily
        missingok
        notifempty
        create 0644 USER GROUP
        postrotate
          kill -HUP `cat /var/run/syslog*.pid 2> /dev/null` 2> /dev/null || true
          su - zimbra -c "/opt/zimbra/bin/zmswatchctl restart" > /dev/null 2>&1 || true
        endscript
        compress
    }
    I changed the USER to zimbra and the GROUP also to zimbra - now the error is gone - but I really would like to know, whatelse is not working properly....
    The logfiles look okay...
    Last edited by Oswald-Kolle; 04-28-2014 at 12:55 PM.

  5. #5
    Oswald-Kolle is offline Loyal Member
    Join Date
    May 2006
    Posts
    83
    Rep Power
    9

    Default

    Okay - I solved the Problem...
    For all the others - here is the "workaround"
    edit the "/opt/zimbra/bin/mysql"
    and add "-P 7306" to the exec line.

    During the update-process, you have to do this during / after the "Installing packages"


    Thats all - now it is working as expected!!
    So it seems like the upgrade process is trying to connect to the standard port of other mysql installations...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Upgrading to 5.0.1
    By davidfsmith in forum Administrators
    Replies: 6
    Last Post: 01-14-2008, 12:27 AM
  2. Upgrading
    By rajan in forum Administrators
    Replies: 6
    Last Post: 11-25-2007, 02:36 PM
  3. Upgrading from 4.5.4 to 4.5.5
    By Krishopper in forum Installation
    Replies: 20
    Last Post: 05-17-2007, 10:30 PM
  4. Upgrading from 3.1.0 to 4.5.4
    By dquattle in forum Migration
    Replies: 3
    Last Post: 03-31-2007, 10:34 AM

Posting Permissions

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