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

Thread: [SOLVED] Logger not working

  1. #1
    marklindley's Avatar
    marklindley is offline Active Member
    Join Date
    Oct 2007
    Location
    Bishops Stortford
    Posts
    27
    Rep Power
    7

    Unhappy [SOLVED] Logger not working

    mmorse,

    I am trying to fix this error

    Message: Csfe service error
    Error code: service.FAILURE
    Method: ZmCsfeCommand.invoke
    Details:system failure: getting database logger connection

    I have followed one of the posts to fix the problem but I can't seem to run this command to fix the table.




    zimbra@mailserver:~$ cd ~/logger/db/data/zimbra_logger
    zimbra@mailserver:~/logger/db/data/zimbra_logger$ ~/logger/mysql-standard-5.0.26-pc-linux-gnu-i686-glibc23/bin/myisamchk -r service_status
    bash: /opt/zimbra/logger/mysql-standard-5.0.26-pc-linux-gnu-i686-glibc23/bin/myisamchk: No such file or directory
    zimbra@mailserver:~/logger/db/data/zimbra_logger$

    Thanks Mark


    BTW thanks for the other link

  2. #2
    marklindley's Avatar
    marklindley is offline Active Member
    Join Date
    Oct 2007
    Location
    Bishops Stortford
    Posts
    27
    Rep Power
    7

    Unhappy Logger not working

    Hi Guys,

    I have worked out how to run the repair on the db but this didn't fix the problem. I am still get the error below even though I ran the upgrade installation again. I have also tried some of the other solutions in the threds

    Message: Csfe service error
    Error code: service.FAILURE
    Method: ZmCsfeCommand.invoke
    Details:system failure: getting database logger connection



    Any help would be much appreciated.

    Thanks Mark

  3. #3
    marklindley's Avatar
    marklindley is offline Active Member
    Join Date
    Oct 2007
    Location
    Bishops Stortford
    Posts
    27
    Rep Power
    7

    Question Trying to reset mysql password

    Hi,

    I am following the wiki to reset the logger password but I am getting this error

    zimbra@mailserver:/etc/init.d$ logmysql mysql -D zimbra_logger -P 7307
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/zimbra/logger/db/mysql.sock' (2)


    Can anyone help please. The logger is driving me nuts. I can't get it to work.


    Thanks Mark

  4. #4
    marklindley's Avatar
    marklindley is offline Active Member
    Join Date
    Oct 2007
    Location
    Bishops Stortford
    Posts
    27
    Rep Power
    7

    Unhappy Logger not working

    Hi Guy's

    I have tried everything to get the logger running but I can't workout what to do next?

    zimbra@mailserver:/etc/init.d$ zmcontrol status
    Host mailserver.itismail.co.uk
    antispam Running
    antivirus Running
    ldap Running
    logger Stopped
    logmysql.server is not running
    mailbox Running
    mta Running
    snmp Running
    spell Running
    stats Running
    zimbra@mailserver:/etc/init.d$ ps auuxww | grep mysql
    root 29287 0.0 0.1 2468 1256 pts/0 S 15:16 0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.logger.cnf --external-locking --ledir=/opt/zimbra/logger/mysql/libexec
    zimbra 29328 0.0 1.8 99652 13404 pts/0 Sl 15:16 0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.logger.cnf --basedir=/opt/zimbra/logger/mysql --datadir=/opt/zimbra/logger/db/data --user=zimbra --pid-file=/opt/zimbra/logger/db/mysql.pid --skip-external-locking --port=7307 --socket=/opt/zimbra/logger/db/mysql.sock --external-locking
    zimbra 29722 0.0 0.2 2988 1524 pts/0 S 15:17 0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-file=/opt/zimbra/conf/my.cnf --external-locking --ledir=/opt/zimbra/mysql/libexec
    zimbra 29796 0.0 4.4 275288 33320 pts/0 Sl 15:17 0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt/zimbra/conf/my.cnf --basedir=/opt/zimbra/mysql --datadir=/opt/zimbra/db/data --pid-file=/opt/zimbra/db/mysql.pid --skip-external-locking --port=7306 --socket=/opt/zimbra/db/mysql.sock --external-locking
    zimbra 30436 0.0 0.4 4728 3264 pts/0 S 15:17 0:00 /usr/bin/perl -w /opt/zimbra/libexec/zmstat-mysql

    Thanks Mark

  5. #5
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    20

    Default

    This happen when you attempt to view statistics in the admin console?
    Could you post the links you've followed?

    Also see: Logger - Zimbra :: Wiki
    Have you tried zmloggerinit yet?
    This is a brand new setup so you have nothing to loose by doing so - it should create a new database and generate the necessary passwords
    Last edited by mmorse; 10-17-2007 at 08:22 AM.

  6. #6
    marklindley's Avatar
    marklindley is offline Active Member
    Join Date
    Oct 2007
    Location
    Bishops Stortford
    Posts
    27
    Rep Power
    7

    Default Still not working

    Hi mmorse

    I have tried a lot of threads ... here is the error.

    1. Resetting LDAP & MySQL Passwords - Zimbra :: Wiki
    2.Logger - Zimbra :: Wiki


    zimbra@mailserver:/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@mailserver:/root$


    Really lost on this, been working on it nearly 2 days now. I don't want to reinstall from fresh because I have add all of my domains and user accounts

    Thanks Mark

  7. #7
    mmorse's Avatar
    mmorse is offline Moderator
    Join Date
    May 2006
    Location
    USA
    Posts
    6,242
    Rep Power
    20

    Default

    wow I see you now have 3 threads on this - I'll consolidate them up in a bit

    ya, logger is a frustration to many, so don't give up - you can still run zimbra without logger (though you won't have any daily reports, server message statistics, and can't zmmsgtrace properly)

    This is not to be confused with the stats service - which might get renamed perfmon (Bug 20549 - rename stats service)

    (before doing this I assume you have no users connected, because well, your killing any running zimbra processes)

    sudo zimbra
    zmcontrol stop
    switch back to another user
    (use sudo as needed - I don't know if your root or not)
    ps auxww | grep zimbra
    ps auxww | grep mysql
    (kill any remaining processes on either of those)
    rm -rf /opt/zimbra/logger/db (maybe only db/data/ ?)
    zmloggerinit

  8. #8
    marklindley's Avatar
    marklindley is offline Active Member
    Join Date
    Oct 2007
    Location
    Bishops Stortford
    Posts
    27
    Rep Power
    7

    Default Same problem

    Carried out all of the steps but I still get the same problem :S




    root@mailserver:/opt/zimbra/logger# locate zmloggerinit
    /opt/zimbra/libexec/zmloggerinit
    /opt/zimbra/log/zmloggerinit.log
    root@mailserver:/opt/zimbra/logger# /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 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

    Thanks Mark

  9. #9
    marklindley's Avatar
    marklindley is offline Active Member
    Join Date
    Oct 2007
    Location
    Bishops Stortford
    Posts
    27
    Rep Power
    7

    Cool Nope .... didn't work

    root@mailserver:/opt/zimbra/logger# locate zmloggerinit
    /opt/zimbra/libexec/zmloggerinit
    /opt/zimbra/log/zmloggerinit.log
    root@mailserver:/opt/zimbra/logger# /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 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

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

    Default

    Do you have localhost adapter, and an localhost entry in your hosts file?

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 issues
    By GadgetGuru in forum Installation
    Replies: 20
    Last Post: 02-03-2011, 07:04 AM
  2. Zimbra Logger not working
    By jbella in forum Administrators
    Replies: 8
    Last Post: 12-14-2010, 03:38 PM
  3. Ubuntu VServer logger not working
    By cshepherd in forum Installation
    Replies: 12
    Last Post: 11-14-2006, 03:33 AM
  4. Logger not working in 4.0 RC1
    By jdell in forum Administrators
    Replies: 11
    Last Post: 08-24-2006, 07:50 PM
  5. Zimbra stoped working overnight
    By vlskip in forum Installation
    Replies: 32
    Last Post: 03-07-2006, 01:52 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
  •