Results 1 to 10 of 25

Thread: Logger

Hybrid View

  1. #1
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default Logger

    Hi all,
    I know I have been a terrible burden. I have a question:

    My logger won't start. From previous posts, I know that my logger password is incorrect.

    I have followed http://www.zimbra.com/forums/showthr...ogger+password
    but it seems a little vauge to me.

    Is the logger password stored in the mysql database? If so, I know I have to use the skip grant tables option.

    After that, what's the command? Do I need to reset the general root password?

    I know it uses
    zmlocalconfig -e -f mysql_logger_root_password='password';
    but I"m not quite sure how to reset it.

    Thanks!
    jh

  2. #2
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    Your on the right track. Take the password from:

    zmlocalconfig -e -f mysql_logger_root_password='<>';

    Then use:

    update user set password=PASSWORD('<>') where user like 'root%';
    flush privileges;

    To reset it.

    Restart logger and hope for the best.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  3. #3
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    does this reset the logger root, or the root password in general (ie will it effect the mailbox?)

    Here's hoping.
    (By the way, I've been compliling extensive notes and will be updating the wiki with sql errors and such soon...so it's not all in vain!)
    Last edited by jholder; 03-27-2006 at 07:17 PM.

  4. #4
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    If you login to the logger MySQL db then it should be root for the logger.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  5. #5
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    This is going to be dumb,
    but baby steps...

    Thats
    1) start mysql without the grant tables
    2) Bash# mysql
    3) Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 1 to server version: 4.1.16-standard-log

    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

    mysql>logger
    -> update user set password=PASSWORD('<>') where user like 'root%';

    ->flush privileges;

    ?
    Last edited by jholder; 03-27-2006 at 07:41 PM.

  6. #6
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    Sorry I should have given the exact commands to get to the logger db.

    mysql -P 7307

    use zimbra;
    update user set password=PASSWORD('pass') where user like 'root%';
    flush privileges;
    Last edited by KevinH; 03-27-2006 at 07:58 PM.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

Similar Threads

  1. Replies: 28
    Last Post: 05-21-2008, 12:04 PM
  2. logger stopped by itself
    By zzzzsg in forum Administrators
    Replies: 23
    Last Post: 08-15-2007, 03:55 PM
  3. logger installed twice
    By bowergo in forum Installation
    Replies: 1
    Last Post: 03-24-2007, 12:48 PM
  4. Logger not working in 4.0 RC1
    By jdell in forum Administrators
    Replies: 11
    Last Post: 08-24-2006, 07:50 PM
  5. Replies: 18
    Last Post: 03-20-2006, 01:22 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
  •