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

Thread: Logger service issues

  1. #1
    GadgetGuru is offline Junior Member
    Join Date
    Sep 2006
    Posts
    5
    Rep Power
    8

    Unhappy Logger service issues

    Hello,

    I am running the Open Source version of Zimbra on an OSX/PPC machine with everything working perfectly so far, with one exception.

    My WebMail HTTP port: 8080
    My WebMail HTTPS port: 8443
    My Web Admin port: 8000

    I have wiki working as well.

    The one issue I am having is with the logger.

    zmcontrol status shows the logger as running, and yet when I login to the Web Admin console, it says: "Server status data is not available. To see the server status, logger service must be installed."

    I have been running Zimbra for a day or so, so I should have some data. I have verified that the logger database does exist within mysql.

    Upon running zmlocalconfig, I have discovered a couple of anomalies:

    logger_mysql_bind_address = localhost
    mysql_bind_address=localhost

    Should these be bound to mydomain.com instead of localhost? Will changing this make the logs show up? Any other suggestions?

    Thanks much,
    -GadgetGuru

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

    Default

    The bind_address is also localhost on my system, so it should be OK. You've verified the db exists in mysql, does it also have any data in it?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    phoenix is online now Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,499
    Rep Power
    56

    Default

    Sorry, I also meant to add: what happens if you run the logp[rocess manually with /opt/zimbra/libexec/zmlogprocess?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  4. #4
    lafonge is offline New Member
    Join Date
    Sep 2006
    Posts
    3
    Rep Power
    8

    Default

    Hi,

    I am having the same issue. 10.4.7 with a fresh install. zmcontrol shows all zm processes are running. executing the zmlogprocess command yeilds the following result with no change in the functionality of server stats.

    boba:~/libexec zimbra$ ./zmlogprocess
    Processing mta entries from 0
    Found 0 messages
    Deleting processed postfix logs from raw_logs...Done
    Processing clamd entries from 0
    Found 0 entries
    Deleting processed clamd logs from raw_logs...Done
    Processing amavis entries from 0
    Found 0 entries
    Deleting processed amavis logs from raw_logs...Done
    Processing sendmail entries from 0
    Found 0 entries
    Deleting processed sendmail logs from raw_logs...Done
    Processing zimbramon entries from 0
    Found 0 entries
    Deleting processed zimbramon logs from raw_logs...Done
    Aggregating hour mta from 2006-09-21 22:00:00 to 2006-09-21 23:00:00
    Aggregating day mta from 2006-09-20 00:00:00 to 2006-09-21 00:00:00
    Aggregating hour amavis from 2006-09-21 22:00:00 to 2006-09-21 23:00:00
    Aggregating day amavis from 2006-09-20 00:00:00 to 2006-09-21 00:00:00
    Aggregating hour disk from 2006-09-21 22:00:00 to 2006-09-21 23:00:00
    Aggregating day disk from 2006-09-20 00:00:00 to 2006-09-21 00:00:00
    RAW: 31
    SUM: 730
    Pruning raw mta logs from 2006-08-21 00:00:00
    Pruning raw amavis logs from 2006-08-21 00:00:00
    Pruning raw disk logs from 2006-08-21 00:00:00
    Pruning summary mta logs from 2004-09-21 00:00:00
    Pruning summary amavis logs from 2004-09-21 00:00:00
    Pruning summary disk logs from 2004-09-21 00:00:00
    Pruning other raw logs from 2006-08-21 00:00:00

  5. #5
    rewster is offline New Member
    Join Date
    Jan 2006
    Posts
    4
    Rep Power
    9

    Default Logger Issues

    I too am experiencing the same issue... i am not sure how to check to see if there is Data in the DB... since (i believe) there is multiple MySQL instances running (i could be wrong about this but if i am why have more than mysql source directory???)...

    First the MySQL from $PATH(=/opt/zimbra/bin/)
    [i'll use the code tags to make it a bit more readable in this posts]

    Code:
    secure:~ zimbra$ mysql
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 2522 to server version: 4.1.20-log
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql> show databases;
    +----------+
    | Database |
    +----------+
    | mailbox1 |
    | mailbox2 |
    | mailbox3 |
    | mailbox4 |
    | mysql    |
    | test     |
    | zimbra   |
    +----------+
    7 rows in set (0.32 sec)
    
    mysql>
    I did a brief search of any data in the DB's or Table's and i couldn't find any logging data

    So i try the MySQL in the Logger Directory...

    Code:
    secure:~ zimbra$ ./logger/mysql/bin/mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
    i might have to have different flags (-s -u -p) to get a socket connection going but i don't know those... maybe i can find it out while looking thru mysqladmin variables

    Though while i was hunting around (and following phoenix's advice) i found these two errors:

    Code:
    secure:~ zimbra$ /opt/zimbra/libexec/zmlogprocess
    DBI connect('database=zimbra_logger;mysql_read_default_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock','zimbra',...) failed: Access denied for user 'zimbra'@'localhost' (using password: YES) at /opt/zimbra/libexec/zmlogprocess line 63
    DB: Can't connect to dbi:mysql:database=zimbra_logger;mysql_read_default_file=/opt/zimbra/conf/my.logger.cnf;mysql_socket=/opt/zimbra/logger/db/mysql.sock: Access denied for user 'zimbra'@'localhost' (using password: YES)
    and

    Code:
    secure:~ 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
    But i'll need someone who knows more to confirm this is the problem... I know there are a few thread that explain how to change/reset the passwords for Zimbra's MySQL... Though i'll need to search for that.

    Any advice from anybody would be greatly appreciated!!!

    On a side note... i too am able to have documents(wiki) working but there are a few bugs with editing... but that is another issue for another topic.

  6. #6
    brian is offline Project Contributor
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    This appears to be a bug in the /opt/zimbra/libexec/zmlogger for MacOSX. This prevents syslog data from being parsed and inserted into the database.
    The following...
    Code:
    if ($platform =~ /^MAC/) {
      $logregex = qr/(^.{15}) \d+\.\d+\.\d+\.\d+ (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
    } else {
      $logregex = qr/(^.{15}) (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
    }
    should be
    Code:
    $logregex = qr/(^.{15}) (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
    Bug 10917 was filed to track this issue.

  7. #7
    rewster is offline New Member
    Join Date
    Jan 2006
    Posts
    4
    Rep Power
    9

    Default Hate to be a nag

    does this mean that my instances of MySQL are actually functioning fine? or do I still have to reset the Passwords for the Logger/MySQL?

    Perhaps i have missed something... but in order issue any command line, one would have to authenticate as a the user "zimbra". Is it ok to change the password for the user zimbra via the Netinfo CLI or OS GUI? or is the a zimbra command which should be used instead?

    Thanks
    -a

  8. #8
    brian is offline Project Contributor
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    running zmloggerinit most likely borked your logger install. You are going to have to manually find and kill the mysql logger process, delete the logger db and rerun zmloggerinit.

    Code:
    host: su - zimbra
    host:~ zimbra$ ps -auxw | grep my.logger | grep -v grep | awk '{print $2}' | xargs kill
    host:~ zimbra$ rm -rf logger/db
    host:~ 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
    * 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
    * Changing mysql zimbra user password
    * Changed zimbra mysql user password
    After that edit libexec/zmlogger and make the changes from the previous post and restart everything.

  9. #9
    techmeisterv is offline Junior Member
    Join Date
    Aug 2006
    Posts
    8
    Rep Power
    8

    Default

    I have the same problem but when I followed the commands and this is what I got, any ideas why it can't connect to the MySQL server?:

    Code:
    * Creating required directories
    * Creating database in /opt/zimbra/logger/db/data
    * Starting logger_mysql server
    * Loading schema /opt/zimbra/db/loggerdb.sql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    * 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: 'Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)'
    Check that mysqld is running and that the socket: '/opt/zimbra/logger/db/mysql.sock' exists!
    * Changing mysql zimbra user password
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)
    **** PASSWORD CHANGE FAILED



    Quote Originally Posted by brian
    running zmloggerinit most likely borked your logger install. You are going to have to manually find and kill the mysql logger process, delete the logger db and rerun zmloggerinit.

    Code:
    host: su - zimbra
    host:~ zimbra$ ps -auxw | grep my.logger | grep -v grep | awk '{print $2}' | xargs kill
    host:~ zimbra$ rm -rf logger/db
    host:~ 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
    * 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
    * Changing mysql zimbra user password
    * Changed zimbra mysql user password
    After that edit libexec/zmlogger and make the changes from the previous post and restart everything.

  10. #10
    brian is offline Project Contributor
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    Make sure all the mysql logger processes are killed off first and verify that you really deleted the logger db directory. If both of those are done then you should have no problem rerunning the zmloggerinit script.

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. Logger service randomly quits
    By Leesbian in forum Administrators
    Replies: 3
    Last Post: 07-12-2007, 04:47 AM
  2. Logger Issues After Upgrade
    By xtreme-one in forum Administrators
    Replies: 9
    Last Post: 04-01-2007, 12:12 PM
  3. Problems sending/receiving and logger issues
    By kcolgan in forum Installation
    Replies: 0
    Last Post: 09-26-2006, 01:18 AM
  4. Post Upgrade Issues - Logger berserk?
    By Coilcore in forum Administrators
    Replies: 1
    Last Post: 03-03-2006, 04:08 PM
  5. Post install - new service installation (logger)?
    By gmorchio in forum Installation
    Replies: 3
    Last Post: 11-18-2005, 09:42 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
  •