Logger service issues

[GadgetGuru]

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

[phoenix]

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?

[phoenix]

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

[lafonge]

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

[rewster]

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]

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...

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:

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

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.

[brian]

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...

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

should be

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

Bug 10917 was filed to track this issue.

[rewster]

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

[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.

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.

[techmeisterv]

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?:

* 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

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.

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.

[brian]

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.