Page 1 of 3 123 LastLast
Results 1 to 10 of 25

Thread: Logger

  1. #1
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    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 logger won't start: /opt/zimbra/bin/zmlogswatchctl: line 69: kill: (5491) - No such
    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
    KevinH's Avatar
    KevinH is offline Expert Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    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 08:17 PM.

  4. #4
    KevinH's Avatar
    KevinH is offline Expert Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    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 08:41 PM.

  6. #6
    KevinH's Avatar
    KevinH is offline Expert Member
    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 08:58 PM.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  7. #7
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    I know it's late.

    So Here's the different permutations I've tried on whatcha gave me.
    -----------------------------------------
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 6 to server version: 4.1.16-standard-log

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

    mysql> use zimbra
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A

    Database changed
    mysql> update user set password=PASSWORD('passhere') where user like 'root%';
    ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist
    mysql> use zimbra
    Database changed
    mysql> update user set password=PASSWORD('passhere') where user like 'root%';
    ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist
    mysql> exit
    Bye
    ---------------
    So either my table doesn't exist, or I'm doing it wrong
    PS-You like family guy?

  8. #8
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    19

    Default

    zimbra.user not there. Did you start it with some odd way. Maybe try starting it WITH grant tables. I think if you disabled them then they won't be there to reset the password.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  9. #9
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Same thing:
    ERROR 1146 (42S02): Table 'zimbra.user' doesn't exist

    Now, this is only with mysql.server started.

    Should I start Zimbra up?
    Last edited by jholder; 03-27-2006 at 09:09 PM.

  10. #10
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default still no luck

    So the use mysql worked, and it let me reset the password.

    I also did a flush...restarted many times...

    Here's my order of what I did.
    mysql> use mysql
    mysql> update user set password=PASSWORD('passhere') where user like 'root%';
    flush privileges;
    zmmypasswd --root passhere
    zmlocalconfig -e -f mysql_logger_root_password='passhere';

    I'm pretty sure I'm not smart enough to do this right. Everything works but the logger...and I want to upgrade (I'm using an old build), but I don't even want to try to upgrade w/o fixing this dang logger problem.

    Am I missing a step?
    ---------------------------------------------------------
    If I run
    Code:
    + BASE=/opt/zimbra
    + SCRIPTS='logmysql.server zmlogswatchctl'
    + case "$1" in
    + STATUS=0
    + for i in '$SCRIPTS'
    + '[' logmysql.server = logmysql.server ']'
    + /opt/zimbra/bin/logmysqladmin status
    + R=1
    + '[' 1 -ne 0 ']'
    + STATUS=1
    + for i in '$SCRIPTS'
    + '[' zmlogswatchctl = logmysql.server ']'
    + /opt/zimbra/bin/zmlogswatchctl status
    /opt/zimbra/bin/zmlogswatchctl: line 69: kill: (4369) - No such process
    + R=1
    + '[' 1 -ne 0 ']'
    + STATUS=1
    + exit 1
    -------------------------------------------------------
    If I try to start the logmysqladmin
    I get
    [zimbra@tusd-exch01 bin]$ logmysqladmin start
    /opt/zimbra/logger/mysql/bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
    [zimbra@tusd-exch01 bin]$ logmysql.server stop
    Killing mysqld with pid 30959 ..[zimbra@tusd-exch01 bin]$ logmysql.server start
    [zimbra@tusd-exch01 bin]$ Starting mysqld daemon with databases from /opt/zimbra/logger/db/data

    I know this is annoying....but any help will be rewarded.

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

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

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, 02: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
  •