spam graph

[padraig]

hi all,

my admin console spam graph is blank.
it has data for feb 07, but the i updated my Spam checking Settings to:
Kill percent: 66
Tag percent: 20
(defaults are 75/33)
not sure if this upset the graph any suggestions would be appreciated e.g.

[jholder]

What version of ZCS are you using? Is your logger running? Have you had to reinit it, or reinstall?

There is a known bug: http://bugzilla.zimbra.com/show_bug.cgi?id=14809
Which was recently reopened.

john

[scalper]

I have encountered this before..

My loggerdb went corrupt of somewhat reasons..

What's the output of zmlogprocess and zmgengraphs commands? any errors in /tmp/logprocess.out and /tmp/logswatch.out

I have trouble running zmlogprocess.. it claimed my db got errors

So, if the db is the problem.. you just reinit the db back again..

% su - zimbra
% rm -rf logger/db
% zmloggerinit

Hope that helps.

[padraig]

What version of ZCS are you using? 4.5.1
Is your logger running? yes
Have you had to reinit it, or reinstall? no

As a test did a full reinstall of 4.5.1 on a vmware system changed spam settings same result

[padraig]

Originally Posted by scalper

I have encountered this before..
My loggerdb went corrupt of somewhat reasons..
What's the output of zmlogprocess and zmgengraphs commands? any errors in /tmp/logprocess.out and /tmp/logswatch.out
I have trouble running zmlogprocess.. it claimed my db got errors
So, if the db is the problem.. you just reinit the db back again..
% su - zimbra
% rm -rf logger/db
% zmloggerinit
Hope that helps.

thanks for the reply,
no errors in /tmp/logprocess.out
/tmp/logswatch.out contains

*** logswatch version 3.1.1 (pid:4218) started at Wed Apr 18 13:24:03 IST 2007
Caught a SIGHUP -- sending a TERM signal to 4309
*** logswatch version 3.1.1 (pid:4218) started at Thu Apr 19 04:03:19 IST 2007
Caught a SIGHUP -- sending a TERM signal to 16583
*** logswatch version 3.1.1 (pid:4218) started at Fri Apr 20 04:03:20 IST 2007
Caught a SIGHUP -- sending a TERM signal to 917
*** logswatch version 3.1.1 (pid:4218) started at Sat Apr 21 04:03:12 IST 2007
Caught a SIGHUP -- sending a TERM signal to 27380
*** logswatch version 3.1.1 (pid:4218) started at Sun Apr 22 04:03:12 IST 2007
Caught a SIGHUP -- sending a TERM signal to 4643
*** logswatch version 3.1.1 (pid:4218) started at Mon Apr 23 04:02:46 IST 2007

will try the zmloggerinit on a vmware test server
is it possible to init just the spam graph

thanks again.
p.

[Cryophallion]

So, I am trying to run the commands here... and bash won't seem to let me.

It is giving me the errors:

-bash: zmloggerinit :command not found
Even if I am in the right directory, and can see the command file, I still can't run it. Any ideas?

[Cryophallion]

Originally Posted by Cryophallion

So, I am trying to run the commands here... and bash won't seem to let me.

It is giving me the errors:

-bash: zmloggerinit :command not found
Even if I am in the right directory, and can see the command file, I still can't run it. Any ideas?

So, I am an idiot. ./zmloggerinit did the trick.

However, I am getting errors running this:


* 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

I have run this as root and as zimbra. Is there a different way I should be doing this?

Thanks

[phoenix]

Originally Posted by Cryophallion

I have run this as root and as zimbra. Is there a different way I should be doing this?

Thanks

A quick search would have found this thread.

[kplau]

I used to have errors just like the first post of this thread.

Followed everything to the letter. Executed those commands as zimbra user, found zmloggerinit under libexec.. ran that. Before that I cleaned up all traces of hanged zimbra.. restarted the entire thing, graphs are generated but there's like zero data.. its like its not receiving any information at all? (and oh server status does not properly show unless i restarted everything..heh)

logprocess files and all looks fine.. no errors. Any ideas where I ought to start looking ?

edit : and oh yeah zmcontrol status shows everything as running. running latest zcs

[Cryophallion]

I did search, just obviously not for the right terms.

So, the problems continue. I tried several options:

zimbra@mail:~$ zmcontrol status
Host mail.majortheatre.com
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
zimbra@mail:~$ zmlogswatchctl start
zimbra@mail:~$ logmysql.server start
/opt/zimbra/bin/logmysql.server: line 89: syntax error: unexpected end of file
zimbra@mail:~$ cd libexec
zimbra@mail:~/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
zimbra@mail:~/libexec$

However, mysql.sock does exist.
I saw in another thread here that I should delete the mysql.sock file.

So I tried:
zimbra@mail:~/libexec$ cd /opt/zimbra/logger/db/
zimbra@mail:~/logger/db$ locate mysql.sock
/opt/zimbra/db/mysql.sock
/backup/opt/zimbra/db/mysql.sock
/backup/opt/zimbra/logger/db/mysql.sock
zimbra@mail:~/logger/db$ rm mysql.sock
rm: cannot lstat `mysql.sock': No such file or directory

So, it thinks it exists, but it doesn't. How do I create a new one?


Mysql in general works, as the mailbox is still working.

Edit: I forgot to mention I tried changing the password also, but that would fail too. Let me know if you would like me to post that session also.