Stats don't update

[dijichi2]

debian 4.0_rc1 install, the stats graphs hadn't updated since mid july. looking at /opt/zimbra, it turns out there are two areas for rrd and associated graphs, /opt/zimbra/logger/db/work and /opt/zimbra/zimbramon/rrdtool/work. the zimbramon area hadn't been updated since aug 11 and running zmgengraphs didn't update it, although the zimbra_core package referred to two gif files in there so can't have been completely redundant. running zmgengraphs does however update /opt/zimbra/logger/db/work rrd and gif files although these were clearly not the graphs being displayed through the admin interface. moving the zimbramon dir out of the way and symlinking the logger directory however seems to have done the trick and now i get up to date graphs in the admin interface.

looking at another rhel4 installation i updated a few days ago it looks like a similar thing has happened - the zimbramon/rrdtool/work hasn't been updated since the 4.0_rc1 update was applied a few days ago, and it looks like the graphs also haven't updated since this update, and the admin interface is showing the graphs from the old directory.

bug 10093 filed

[dijichi2]

sorry, forgot to clarify the hack:

mv /opt/zimbra/zimbramon/rrdtool/work /opt/zimbra/zimbramon/rrdtool/work.disabled
ln -s /opt/zimbra/logger/db/work /opt/zimbra/zimbramon/rrdtool

[dijichi2]

hmm, unfortunately the lovely new mail quota page has stopped working: bug 10095, and the x-axis scaling is still wrong on debian: bug 10094.

[Doug_M]

I've just upgraded to 4.0 RC1. We'll see if that makes a difference. But I'm not holding my breath.

[Doug_M]

Nope, still no stats.

[dijichi2]

which bit of the stats aren't working? the daily report? the admin interface graphs? is there data going into the logger? rrd files being udpated?

[scottnelson]

Originally Posted by layer3guru

Has anyone had any luck with this at all. Scott I would like to know exactly what you are doing because I zmcontrol stop and start and killl the tail and I still get blank reports.

You are fully stopping, killing the tail processes and then restarting right?

I am running 3.1.4 so, keep that in mind.

I haven't done or replaced anything wacky but I have stopped these two processes in zimbra cron:

su zimbra
crontab -e

insert # in front of:

/opt/zimbra/libexec/zmlogprocess > /tmp/logprocess.out 2>&1
and
/opt/zimbra/libexec/zmgengraphs >> /tmp/gengraphs.out 2>&1

then, zmcontrol stop
wait a minute after everything says it's stopped.
Then ps -ef | grep tail
kill whatever it finds. ( will be owned by zimbra )
Then zmcontrol start
wait another minute or so, then do the below manually in the order below:

/opt/zimbra/libexec/zmlogprocess > /tmp/logprocess.out 2>&1
/opt/zimbra/libexec/zmgengraphs >> /tmp/gengraphs.out 2>&1

wait 10 minutes and then run again in order shown.
Then logout from web admin screen ( if logged in ) and then login again.

Did the graphs update?

If not,

more /tmp/logprocess.out
and
more /tmp/gengraphs.out

Any noticable errors?

Scotty

[Doug_M]

Scotty, tried it out, the graphs didn't update and there are no errors /tmp/...out.

dijich2, I get the daily report emails but the graphs haven't updated since the first 48 hours. The log files are being written to frequently. The rrd files (all of them) haven't been updated since August 5th. What are they?

Regards,
Doug

[scottnelson]

Can you attach a screenshot of:

su zimbra
crontab -l > zimbracrontab
more zimbracrontab

Any other changes/alterations made?
Anything unusual in /opt/zimbra/log/zimbra.log or var/log/messages ?

<shrug> I am not appeartly having the same issue as you so, not really sure what to have you look at next.

In my crontab I made two following two mods:
At 1245 I run /opt/zimbra/libexec/zmlogprocess > /tmp/logprocess.out 2>&1

and at 0200 I run /opt/zimbra/libexec/zmgengraphs >> /tmp/gengraphs.out 2>&1

That's it for me really. Nothing else is altered in the zimbrauser crontab other than those two items.

Every morning at 0600 or so, I:
su zimbra
zmcontrol stop
kill all of the tail stuff if still running/hung then
zmcontrol start

done

[Doug_M]

I'm sorry, I'm going on two month trip (navy) and I'll have to get back to this in November. Thanks everyone for all the help so far.

Regards,
Doug