[SOLVED] Stats stop working, after date/time change by mistake

[bart]

HI everyone.

I have the problem that stats in admin interface stop working, after a date/time change by mistake 4 moth later that today.. I correct the date , restart the server, but the graph shifts and not showing data.

any ideas that is possible to reset all the stats and start again from zero? or how can i correct this?

thanks in advance.

[bart]

Hi, I found the source of the mistake, the files located in /opt/zimbra/logger/db/work has the date 2 moth after today, I changed the date to today, but stats don't update, if I delete those files, and restart zimbra, those files are created automatically? How can I clear all the data and generate all the stats again?

thanks in advance.

[phoenix]

Run zmloggerinit, that will clear ALL your data and reinitialise the logger.

[bart]

i did su - zimbra and run, i recive this error
/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

and now logger stop working !

help me please...


thanks in advance

[phoenix]

Please update you profile with the output of zmcontrol -v

The wiki and the forums both have details of this problem and it's resolution, do a search and see what gems are there.

MySql Password - Zimbra :: Wiki
Resetting LDAP & MySQL Passwords - Zimbra :: Wiki

[bart]

ok, thanks,

I solve this in that way.

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

Code:
ps auxww | grep mysql
Stop any processes...

to restart stats db

rm -rf logger/db
/opt/zimbra/libexec/zmloggerinit


but, now execute zmqstats and zmgengraph, the graph are generated but blank, no errors.

i have to wait? to the data ?

thanks.

[phoenix]

You should wait for 24hrs to see if the graphs generate any data, if they don't post again.

[bart]

I wait 24 hours and nothing, the graph don't update. Remenber that I restart the stats from scratch.

can you help me with this issue ?


thanks in advance,

best regards.
B.

[jholder]

ok, thanks,

I solve this in that way.

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

Code:
ps auxww | grep mysql
Stop any processes...

to restart stats db

rm -rf logger/db
/opt/zimbra/libexec/zmloggerinit


but, now execute zmqstats and zmgengraph, the graph are generated but blank, no errors.

i have to wait? to the data ?

thanks.

What was the output of zmloggerinit?

[bart]

hi ,zmloggerinit don't report errors.
I run manually as root /opt/zimbra/libexec/zmqstat and /opt/zimbra/libexec/zmgengraphs and the graph are now updated ! so... i have a cron problem maybe? how ofthen the stats are aupdated by default?

thanks for the help.!
regards.
B.