Missing Stats Message Count / Message Volume

[rhostager]

I have had this problem from the start. This server is running on Fedora Core 4 and running Zimbra OS 4.0.3. This server has followed the upgrade path for quite some time. I feel that there is some configuration issue that has carried through all the upgrades.

All statistics(spam/virus, disk, quota) show except Message Count and Message Volume both system-wide and for the individual server. The logmysql db has data in everything except mta and mta_aggregate, which are both empty.

logprocess.out has no errors.

swatch.out shows:
*** swatch version 3.1.1 (pid:6052) started at Thu Nov 2 08:04:56 PST 2006

logswatch.out shows:
*** logswatch version 3.1.1 (pid:5299) started at Thu Nov 2 08:04:47 PST 2006

swatch and logswatch are both running.

I hate to do a clean install to fix this as it would be a nightmare to add all the users back in and not loose mail.

Any ideas on how to fix this?

- Rob

[keynet]

I've had a similar problem since the beginning, now updated to 4.0.3 (OSS) on SuSe 10. I get a whole set of .csv files with lots of stats in /opt/zimbra/log, there are no logprocess errors, but I get "data not yet available" under all of the server stats on the web GUI and no graphs.

Originally I didn't have the logger running, then started it, now I get ticks against all the status, but still no stats though I feel sure they are being generated. I've also checked the database, (following thread "no data in server statistics") and see all the stats actually in the db. But no GUI stats or graphs :-( Any ideas?

Originally Posted by rhostager

I have had this problem from the start. This server is running on Fedora Core 4 and running Zimbra OS 4.0.3. This server has followed the upgrade path for quite some time. I feel that there is some configuration issue that has carried through all the upgrades.

All statistics(spam/virus, disk, quota) show except Message Count and Message Volume both system-wide and for the individual server. The logmysql db has data in everything except mta and mta_aggregate, which are both empty.

logprocess.out has no errors.

- Rob

[phoenix]

Did you search the forums, this has been covered many times and one of the 'fixes' may apply. How about this one for instance, any use?

[rhostager]

I have read through the forums and followed every thread on this subject. I have done the corrections suggested but to no avail.

I initially thought that the problem was in the zmlogprocess script. After taking a look at the script I now suspect that the problem is in swatch or logswatch.

When I send some messages through the sever, they do not seem to show up in the raw_logs. That would explain why mta and mta_aggregate are empty.

The amavis and disk info seem to process just fine.

- Rob

[keynet]

I did spend a long time searching threads, but your post didn't show up
Anyway, your fix worked for me, thanks.

Originally Posted by phoenix

Did you search the forums, this has been covered many times and one of the 'fixes' may apply. How about this one for instance, any use?

[multicast]

Hey Guys,

I'm having the same issue as well... All the other stats are updating but message count/Volume.

Anyone have any ideas?

Multicast

[phoenix]

Originally Posted by multicast

I'm having the same issue as well... All the other stats are updating but message count/Volume

Anyone have any ideas?

.Did you try the answer in the post immediately above yours? If not then what, exactly, have you tried to fix it?

[multicast]

Hey Bill,

Yep tried that and the output was correct as you showed it should be so I didn't have to fix the location. The graphs are there, they show old data as it was working for a time then it stopped.

I've deleted my logger files and reset it with the loggerinit which worked great. The Disk, Spam, Quota information is all updated correctly and the system status is as well. Only the Message Count/Volume is not getting updated. The system almost looks like it's not parsing the right log files or something else is amiss.

I'm open to any other ideas.

Cyrus

[multicast]

Hi Bill,

Here is the ouput of my logprocess.out:
Processing mta entries from 0
Found 2 messages
Inserted 2 rows
Saving ID 0
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 124901
Found 197 entries
Saving ID 125337
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 124407
Found 39 entries
Saving ID 125323
Deleting processed zimbramon logs from raw_logs...Done

That is what is making me think that it isn't seeing the logs... Though in the zimbra.log I see tons of Postfix logging information so I know its there...

Cyrus

[multicast]

Anyone have any ideas here?

Oh and a little more info this is what I get when I do:

mysql> select * from mta_aggregate;
Empty set (0.00 sec)

I also tried this:
mysql> select distinct(host) from mta_aggregate;
Empty set (0.00 sec)

Thanks gang.