emtpy statistics charts in the administrative console

[k3rmit]

Hi everybody,

my server statistics charts have been empty since the day i moved the /var/log folder for space issues and linked /var/log to the real folder.

I checked for permissions and so on and everything is fine. In fact zimbra correctly logs everything. It's just the graphing script that doesn't work.

Any suggestion on how to fix or debug this?

Thanks in advance for any help


Albe

[uxbod]

Do you get any error messages if you run

su - zimbra
/opt/zimbra/libexec/zmgengraphs

Once that is run do you see any graphs ?

Would you also update your profile with the following output so we know which version of ZCS you are running

su - zimbra
zmcontrol -v

[k3rmit]

thanks for the quick reply, i've updated my profile.

i forgot to mention in the previous post that i did try the graph generation command with no success... and no error messages.

[uxbod]

Originally Posted by k3rmit

In fact zimbra correctly logs everything. It's just the graphing script that doesn't work.

Do you mean to the flat files or to the MySQL database ?

[k3rmit]

i'm talking about the flat files. the logger service is up and running: how do i check if it is logging correctly?

[uxbod]

su - zimbra
logmysql
use zimbra_logger;
select * from mta_aggregate
where date_format(period_start,"%Y%m%d") = date_format(now(),"%Y%m%d");

[k3rmit]

damn...

last entry is very old, exactly the date were my graphs stop.

How am i supposed to fix this now?

Thanks a lot again...

[uxbod]

Check in /opt/zimbra/log/mysql_error.log for any error messages and you can also run a

check table mta_aggregate

Perform that for each of the tables found using

show tables

and if any have errors then just run

repair table {table name}

[k3rmit]

sorry but it took a while... there were errors in the mta table.

nonetheless it still isn't logging.. i've restarted the logger service to no avail..

any further suggestion?


thanks..

[phoenix]

It takes a while for the changes and graphs to appear, has it been 24hrs since you fixed the tables?