Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: problem with logger

  1. #1
    Join Date
    Feb 2009
    Location
    Roeselare Belgium
    Posts
    7
    Rep Power
    6

    Default problem with logger

    I would like to start logger but it won't start.

    Here's what happened:

    Code:
    zimbra@server:/root$ zmcontrol status
    Host server.homelinux.org
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
                    zmlogswatchctl is not running
            mailbox                 Running
            mta                     Running
            snmp                    Running
            stats                   Running
    zimbra@server:/root$ zmlog
    zmloggerctl     zmlogswatchctl
    zimbra@server:/root$ zmlogswatchctl start
    Starting logswatch...done.
    zimbra@server:/root$ zmloggerctl start
    Starting mysqld...done.
    Starting logswatch...logswatch is already running.
    zimbra@server:/root$ zmcontrol status
    Host server.homelinux.org
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
            mailbox                 Running
            mta                     Running
            snmp                    Running
            stats                   Running
    zimbra@server:/root$ logmysql.server start
    Starting mysqld...done.
    zimbra@server:/root$ zmcontrol status
    Host server.homelinux.org
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
            mailbox                 Running
            mta                     Running
            snmp                    Running
            stats                   Running
    zimbra@server:/root$
    i followed this wiki

    Code:
    zimbra@server:/root$ logmysql.server start
    Starting mysqld...done.
    zimbra@server:/root$ cat /opt/zimbra/logger/db/mysql.pid
    cat: /opt/zimbra/logger/db/mysql.pid: No such file or directory
    But there is no solution on the wiki.

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

    Default

    Whick version and release of ZImbra is this? Please update your forum profile with the output of the following:

    Code:
    zmcontrol -v
    Shutdown Zimbra and see if there are any zimbra processes still running with
    Code:
    ps aux | grep zimbra
    If there are processes running then kill them all and you can restart zimbra, let me know if that fixes the problem? If that does you'll need to make another change to fix it permanently.

    If that's not the problem what errors do you see in the log files
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    Join Date
    Feb 2009
    Location
    Roeselare Belgium
    Posts
    7
    Rep Power
    6

    Default

    thank you for your reply,

    No running processes found.

    just these:
    Code:
    zimbra   14525  0.0  0.3   7136  1924 pts/0    S    20:11   0:00 su zimbra
    zimbra   14526  0.0  0.3   4640  2044 pts/0    S+   20:11   0:00 bash
    root     18786  0.0  0.1   3004   756 pts/1    R+   21:44   0:00 grep zimbra
    there were some errors:
    Code:
    /opt/zimbra/logger/mysql/libexec/mysqld: Can't change dir to '/opt/zimbra/logger/db/data/' (Errcode: 2)
    090205 21:48:06 [ERROR] Aborting
    
    090205 21:48:06 [Note] /opt/zimbra/logger/mysql/libexec/mysqld: Shutdown complete
    
    STOPPING server from pid file /opt/zimbra/logger/db/mysql.pid
    090205 21:48:06  mysqld ended
    090205 21:48:06  mysqld ended
    so i made the directory.
    following the next error:

    Code:
    zimbra@server:/root$ tail /opt/zimbra/log/logger_mysql_error.log
    InnoDB: The error means mysqld does not have the access rights to
    InnoDB: the directory.
    InnoDB: File name ./ibdata1
    InnoDB: File operation call: 'create'.
    InnoDB: Cannot continue operation.
    STOPPING server from pid file /opt/zimbra/logger/db/mysql.pid
    090205 21:52:57  mysqld ended
    090205 21:52:57  mysqld ended
    So I'm at this point now.

  4. #4
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    Try running this as root:

    Code:
    /opt/zimbra/libexec/zmfixperms

  5. #5
    Join Date
    Feb 2009
    Location
    Roeselare Belgium
    Posts
    7
    Rep Power
    6

    Default

    Code:
    root@server:~# /opt/zimbra/libexec/zmfixperms
    root@server:~# su zimbra
    zimbra@server:/root$ logmysql.server
    Usage: /opt/zimbra/bin/logmysql.server start|stop|restart|reload|status
    zimbra@server:/root$ logmysql.server start
    Starting mysqld...done.
    zimbra@server:/root$ zmcontrol status
    Host server.homelinux.org
            ldap                    Running
            logger                  Stopped
                    logmysql.server is not running
            mailbox                 Running
            mta                     Running
            snmp                    Running
            stats                   Running
    zimbra@server:/root$

    Not working.

  6. #6
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    Check /opt/zimbra/log/mysql_error.log

  7. #7
    Join Date
    Feb 2009
    Location
    Roeselare Belgium
    Posts
    7
    Rep Power
    6

    Default

    Code:
    Version: '5.0.67-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
    090213 13:05:21 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown
    
    090213 13:05:21  InnoDB: Starting shutdown...
    090213 13:05:24  InnoDB: Shutdown completed; log sequence number 0 10861166
    090213 13:05:24 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete
    
    090213 13:05:24  mysqld ended
    
    090213 13:06:02  mysqld started
    090213 13:06:02 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    090213 13:06:02 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    090213 13:06:02  InnoDB: Started; log sequence number 0 10861166
    090213 13:06:02 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
    Version: '5.0.67-log'  socket: '/opt/zimbra/db/mysql.sock'  port: 7306  Source distribution
    this is the output.

  8. #8
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    Can you tell us the size of these files?

    /var/log/zimbra.log

    /opt/zimbra/logger/db/data/zimbra_logger/*

    From the looks of the log you posted MySQL appears to be starting properly.

    I assume you haven't altered your logger my.cnf.

  9. #9
    Join Date
    Jun 2009
    Posts
    3
    Rep Power
    6

    Default

    Quote Originally Posted by fizi View Post
    Can you tell us the size of these files?

    /var/log/zimbra.log

    /opt/zimbra/logger/db/data/zimbra_logger/*

    From the looks of the log you posted MySQL appears to be starting properly.

    I assume you haven't altered your logger my.cnf.
    Does anyone have solution for this kind of problem? I am trying for a few days to resolve the same problem, but with no success. Exactly same errors, and same version of Zimbra.

    Any idea is welcome

  10. #10
    Join Date
    Jun 2009
    Posts
    3
    Rep Power
    6

    Default

    why not reinstall the log service?

Similar Threads

  1. Debian installation of 4.5.10 with logger problem
    By firefox32 in forum Installation
    Replies: 3
    Last Post: 11-30-2007, 05:28 AM
  2. Replies: 3
    Last Post: 09-05-2007, 06:25 AM
  3. Multi-server install - logger problem
    By mrfileio in forum Administrators
    Replies: 1
    Last Post: 11-29-2006, 05:53 AM
  4. problem with logger and mailbox
    By pepe27 in forum Installation
    Replies: 1
    Last Post: 04-05-2006, 07:43 AM
  5. mysql logger problem
    By dijichi2 in forum Administrators
    Replies: 7
    Last Post: 01-09-2006, 01:26 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
  •