Page 2 of 2 FirstFirst 12
Results 11 to 15 of 15

Thread: Missing MySQL logger root password

  1. #11
    dual_prophet is offline Intermediate Member
    Join Date
    May 2006
    Posts
    19
    Rep Power
    9

    Default

    Quote Originally Posted by ecactive
    Kevin,

    We are experiencing the same issue on a recent upgrade to 3.1.2 on one of our servers.

    I think you will also find if you run zmlogprocess whilst logged in as zimbra user you will get a database access denied error as well for the zimbra user.

    We have been working through this problem for the last 24-48 hrs with no avail. We have modified the zmlogprocess script to use the root user/pass, to use zimbra/pass, to use a different user/pass we added to the logger mysql instance .

    We are still receiving the same access denied issues from the system.

    We have observed that we can access mysql with the correct user/pass and that localconfig.xml is providing the correct information.

    mysql mysql -u root -p -P 7307 when run and provided with the root password allows you access to the mysql utility as well as running it with the user zimbra and appropriate password.

    Perhaps there is an error in the perl DBI module? What version of DBI is zimbra being developed against?

    Regards,

    Andrew.
    The steps I took to resolve this issue are outlined here:

    http://wiki.zimbra.com/index.php?tit...ySQL_Passwords

  2. #12
    ecactive is offline Active Member
    Join Date
    Apr 2006
    Posts
    27
    Rep Power
    9

    Default

    Yes, I am aware of those instructions. However, we have modified our mysql users and know that the user/pass is correct.

    We have hardcoded zmlogprocess to those user/pass combinations and still receive the user access error.

    Very strange...

  3. #13
    dual_prophet is offline Intermediate Member
    Join Date
    May 2006
    Posts
    19
    Rep Power
    9

    Default

    You should undo the hardcoding of the username & password, that's not where the problem is. Check your /opt/zimbra/conf/localconfig.xml and make sure:

    key name="mysql_logger_root_password"
    key name="zimbra_logger_mysql_password"

    are correct. Also make sure that no stray mysql processes are running before or after the changes.

  4. #14
    ecactive is offline Active Member
    Join Date
    Apr 2006
    Posts
    27
    Rep Power
    9

    Default

    Those key names are correct as well as their values.

  5. #15
    kevindods is offline Advanced Member
    Join Date
    Oct 2005
    Posts
    181
    Rep Power
    9

    Default Still not properly solved things...

    Also tried the upgrade to 3.1.3 and the problem still persists. Services run after install ok and server performs as normal, but now the zmcontrol start doesnt seem to start services post install. Possibly a password sync issue but having followed all the various reset password wikis posts etc, it is not possible to connect to the mysql service from the command line so I cant apply any further changes. Shame as the system had been reliable till now, and after running all the betas and various versions from Oct last year not really had an issue.

    Think we are going to have to rebuild the server and import all the data/messages we can back in. Back up from the first failed install is so out of date it is no use!

    Unless anyone has any more ideas?

    Anyone found a sensible means of extracting and restoring email, contacts and calendar from a working service other than the backup process?

    Kevin
    Last edited by kevindods; 06-26-2006 at 03:44 AM.

Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 AM
  2. Traslation SVN tree status
    By meikka in forum I18N/L10N - Translations
    Replies: 7
    Last Post: 02-13-2007, 11:13 AM
  3. Logger MySQL db Root password error
    By MACaid in forum Administrators
    Replies: 2
    Last Post: 06-14-2006, 02:06 PM
  4. Login does not appear
    By alexz in forum Administrators
    Replies: 10
    Last Post: 04-18-2006, 06:46 AM
  5. Seeming variety of problems on suse-9.1
    By Crexis in forum Installation
    Replies: 52
    Last Post: 03-04-2006, 12:19 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
  •