Logger service issues

[rewster]

For those that read this later... and are like me and enjoy a step by step... here is what i did to fix my problem with the logger not working: [special thanks to brian for digging out the bug]

First auth as the user zimbra

secure:~ andrew$ su zimbra
Password:

then shut down all of zimbra

secure:~ zimbra$ zmcontrol stop
Host mydomain.com
        Stopping mta...Done
        Stopping spell...Done
        Stopping snmp...Done
        Stopping antivirus...Done
        Stopping antispam...Done
        Stopping imapproxy...Done
        Stopping mailbox...Done
        Stopping logger...Done
        Stopping ldap...Done
secure:~ zimbra$

make sure all instances of MySQL are not running

ps auxww | grep mysql

Stop any processes... or you can use activity viewer to quit the mysql processes (nice GUI for us still learning the CLI)

then rebuild the Logger DB, Directory, and info with this command:

secure:~ zimbra$ libexec/zmloggerinit

Should get the result you see in previous post

Now lets fix the Logging format to work with Mac OS... We'll need to auth as a root user to change the file at /opt/zimbra/libexec/zmlogger
I (andrew) am a admin on this machine so i can use "sudo" to work as root

secure:~ zimbra$ exit
exit
secure:~ andrew$ sudo pico /opt/zimbra/libexec/zmlogger
password:

you can use what ever text editor you like... but i am fairly novice and pico works just fine for me.

While editing /opt/zimbra/libexec/zmlogger find the following section:

if ($platform =~ /^MAC/) {
  $logregex = qr/(^.{15}) \d+\.\d+\.\d+\.\d+ (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
} else {
  $logregex = qr/(^.{15}) (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
}

and change it into this (we are just commenting out the problem areas)

#if ($platform =~ /^MAC/) {
  #$logregex = qr/(^.{15}) \d+\.\d+\.\d+\.\d+ (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
#} else {
  $logregex = qr/(^.{15}) (\S+) ([^[]+)\[(\d+)\]: (.*)$/o;
#}

exit and save the file (don't rename it)

Start the services back up... don't forget to change back zimbra user

secure:~ andrew$ su zimbra
Password:
secure:~ zimbra$ zmcontrol start
Host secure.acronymenterprises.com
        Starting ldap...Done.
        Starting logger...Done.
        Starting mailbox...Done.
        Starting antispam...Done.
        Starting antivirus...Done.
        Starting snmp...Done.
        Starting spell...Done.
        Starting mta...Done.
secure:~ zimbra$

Hopefully when you are done you should see this when you log into the WebAdmin section


It will take a while for the statistical images to populate since they work off of cron

[iomari]

I've done everything mentioned and still when I go to the Server Status page I get:

Server Status Data is not available: To see the server status, logger service must be installed.

BTW, I'm using SLES 10 and Zimbra verson 4.03.

Thanks

[skralg]

Make sure that all the files in /opt/zimbra/log are owned by zimbra.

cd /opt/zimbra/log
chown zimbra.zimbra *


jon

[tlxreed]

I tried the process outlined above. Now I get the following for zmcontrol status:

zimbra:~/log zimbra$ zmcontrol start
Host zimbra.zone.pphsso.org
Starting ldap...Done.
Starting logger...Done.
Starting mailbox...Done.
Starting antispam...Done.
Starting antivirus...Done.
Starting snmp...Done.
Starting spell...Done.
Starting mta...Done.
zimbra:~/log zimbra$ zmcontrol status
Host zimbra.zone.pphsso.org
antispam Running
antivirus Running
ldap Running
logger Stopped
logmysql.server is not running
zmlogswatchctl is not running
mailbox Running
mta Running
snmp Running
spell Running

[brian]

tlxreed,

Are there any errors in either of these 2 logs?

/opt/zimbra/log/logger_mysqld.log
/opt/zimbra/logger/db/data/.err

[tlxreed]

No errors that I see. I started the system up today. The .err log is blank.

The other log has:
061229 10:04:01 mysqld started
061229 10:04:01 [Warning] Setting lower_case_table_names=2 because file system $
061229 10:04:05 InnoDB: Started; log sequence number 0 43634
/opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 $

Otherwise, no change.

antispam Running
antivirus Running
ldap Running
logger Stopped
logmysql.server is not running
zmlogswatchctl is not running
mailbox Running
mta Running
snmp Running
spell Running

[blazeking]

Originally Posted by tlxreed

No errors that I see. I started the system up today. The .err log is blank.

The other log has:
061229 10:04:01 mysqld started
061229 10:04:01 [Warning] Setting lower_case_table_names=2 because file system $
061229 10:04:05 InnoDB: Started; log sequence number 0 43634
/opt/zimbra/logger/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/logger/db/mysql.sock' port: 7307 $

Otherwise, no change.

antispam Running
antivirus Running
ldap Running
logger Stopped
logmysql.server is not running
zmlogswatchctl is not running
mailbox Running
mta Running
snmp Running
spell Running

Sorry, I know I'm performing necromancy here, but I have this same problem. I followed rewster's instructions, but when I run the zmloggerinit, but I get the password errors that techmeisterv had. If I delete /opt/zimbra/logger, then run zmloggerinit, this is what I get:

Error: assertion '-x /opt/zimbra/logger/mysql/bin/mysql_install_db' failed

Any ideas?

[nishith]

Dear Sir,

I was having same problem in my zcs 5.0.5 version.(Open Source)

two services were not running that is :-

logmysql.server
mysql.server

Now,by using your post,I got solution of logmysql.server error. But,still mysql.server error is ther while typing "zmcontrol status" command.

Due to this error,I am getting errors on my web console.Below is the web console error.

server status data is not available. To see the server status,logger service must be installed.

Below is my zmcontrol status error.

antispam Running
antivirus Running
imapproxy Running
ldap Running
logger Running
mailbox Stopped
mysql.server is not running
mta Running
snmp Running
spell Running
stats Running


Kindly tell me what to do to bring up mysel.server service up.

Waiting,
Nishith.

[raghunr4u]

how everybody iam facing the problem when i am running this
[zimbra@mail ~]$ zmcontrol status
ost mail.powerapps.in
antispam Running
antivirus Running
imapproxy Running
ldap Running
logger Stopped
logmysql.server is not running
zmlogswatchctl is not running
mailbox Stopped
mysql.server is not running
mta Running
snmp Running
spell Running
stats Running

[uxbod]

If logger is not starting then it will more than likely be a DNS issue. Please post a new thread instead of one that is two years old.