Results 1 to 5 of 5

Thread: zimbra_logger MySQL schema not installed

  1. #1
    tfpk3 is offline Starter Member
    Join Date
    Dec 2006
    Posts
    2
    Rep Power
    8

    Default zimbra_logger MySQL schema not installed

    I have been attempting to do a fresh install of zcs-4.0.5_GA_518.FC4 on a clean install of FC 4 guested on a VMware ESX virtual machine. The install seemed to go well with no critical error messages and I was able to login to the web admin interface. However, when I do login I get a message that logger was not installed so no monitoring was being done. According to the install logs, logger was installed, but using the command-line tools (zmloggerctl or zmlogswatchctl) also shows that logger wasn't available. The logs show that zimbra_logger was not able to log into the MySQL database.

    After exploring the forums, I found the threads about passwords not being in sync. After unsuccessfully trying zmmylogpasswd, I restarted the logger instance of MySQL without the grant permissions (i.e., --skip-grant-tables flag) and logged into that instance only to find no "zimbra_logger" database established and no "zimbra_logger" user in the mysql user table. It looked like a fresh MySQL install with only the "mysql" and "test" databases.

    Everything else in the install looks okay. Is there a mysql schema file around that I could use to establish the database and tables? Something else I should do (other than install again, which I've done three times now).

    Thanks

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,495
    Rep Power
    56

    Default

    Welcome to the forums.

    You need zmloggerinit, do a search of the forums for details of the resolution.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    tfpk3 is offline Starter Member
    Join Date
    Dec 2006
    Posts
    2
    Rep Power
    8

    Default

    Bill -

    Thanks for the pointer. However, zmloggerinit failed to properly set up the database stuff. What it did do, however, was let me see where the schema files were kept so that I could successfully do a manual install of the database and, after a bit of password adjusting, got things running acceptably.

    Thanks again - Tom K.

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,495
    Rep Power
    56

    Default

    Glad you've got it working. Happy New Year.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    newmember is offline Senior Member
    Join Date
    May 2007
    Location
    Calgary
    Posts
    62
    Rep Power
    8

    Default

    I have the same situation as above, there is not user or table called zimbra_logger. I tried to follow the steps above but I do not know how to fix the permission to complete the user and table install.
    Here is my error when I run zmloggerinit.
    How do set up permissions to make zmloggerinit successful?



    Code:
    [zimbra@mail root]$ /opt/zimbra/libexec/zmloggerinit
    * Creating required directories
    * Creating database in /opt/zimbra/logger/db/data
    * Starting logger_mysql server
    * Loading schema /opt/zimbra/db/loggerdb.sql
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
    * Setting random password for mysql root user in zimbra local config
    * Setting random password for mysql zimbra user in zimbra local config
    * Changing mysql root user password
    /opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    * Changing mysql zimbra user password
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    **** PASSWORD CHANGE FAILED
    [zimbra@mail root]$

    Code:
    [zimbra@mail root]$ zmcontrol -v
    
    
    Release 4.5.11_GA_1751.RHEL5_20080128142638 CentOS5 FOSS edition
    
    [zimbra@mail root]$
    Last edited by newmember; 09-21-2008 at 04:34 PM.

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. Replies: 2
    Last Post: 12-09-2006, 05:14 AM
  3. Upgrading from 3.1.4_GA_518 to 4.0.3_GA_406
    By a2mc in forum Installation
    Replies: 6
    Last Post: 11-13-2006, 12:52 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 06:59 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
  •