Zimbra :: Forums - View Single Post

rewster · #11 (**permalink**) 09-25-2006, 06:14 PM

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

Code:

secure:~ andrew$ su zimbra
Password:

then shut down all of zimbra

Code:

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

Code:

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:

Code:

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

Code:

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:

Code:

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)

Code:

#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

Code:

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