[SOLVED] no data available after zmsetservername

[shanlar]

Yesterday I ran zmsetservername and everything is working correctly except the server statistics are reporting "no data available". Under server status everything has a red X. Also, Mail Queues always returns 0 in the WebUI.

I have read up and down the boards since yesterday and still can not figure this one out, so I am reaching out now. Maybe someone can see something I am missing.

$ zmloggerctl status; echo $?; ps ax | grep zmlogger 
0
 5598 pts/2    S+     0:00 grep zmlogger
25146 ?        S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
25185 ?        S      0:00 zmlogger: zmrrdfetch: server

$ zmrrdfetch -c -f zmmtastats
Host: mail.newdomain.com

timestamp,mta_count,clam_events,mta_delay,mta_volume,filter_count,
1267476300,,,,,,
1267476600,,,,,,
1267476900,,,,,,
1267477200,,,,,,
1267477500,,,,,,
1267477800,,,,,,
1267478100,,,,,,
1267478400,,,,,,
1267478700,,,,,,
1267479000,,,,,,
1267479300,,,,,,
1267479600,,,,,,
1267479900,,,,,,
1267480200,,,,,,
1267480500,,,,,,
1267480800,,,,,,
1267481100,,,,,,



$ grep -w MTA /var/log/zimbra-stats.log 
Mar  2 04:10:09 mail zimbramon[23361]: 23361:info: MTA: mail.newdomain.com: filter_misc,clam_events,mta_delay,mta_volume,filter_virus,filter_count,mta_count,filter_spam,sendmail_events:: 0,1,2.24285714285714,963356,0,105,210,0,0 
Mar  2 04:20:12 mail zimbramon[2821]: 2821:info: MTA: mail.newdomain.com: filter_misc,clam_events,mta_delay,mta_volume,filter_virus,filter_count,mta_count,filter_spam,sendmail_events:: 0,2,0.439393939393939,249811,0,33,66,0,0 
Mar  2 04:30:13 mail zimbramon[15281]: 15281:info: MTA: mail.newdomain.com: filter_misc,clam_events,mta_delay,mta_volume,filter_virus,filter_count,mta_count,filter_spam,sendmail_events:: 0,1,0,0,0,0,0,0,0 
Mar  2 04:40:13 mail zimbramon[27659]: 27659:info: MTA: mail.newdomain.com: filter_misc,clam_events,mta_delay,mta_volume,filter_virus,filter_count,mta_count,filter_spam,sendmail_events:: 0,1,1.03603603603604,971598,0,111,222,0,0 
Mar  2 04:50:10 mail zimbramon[7713]: 7713:info: MTA: mail.newdomain.com: filter_misc,clam_events,mta_delay,mta_volume,filter_virus,filter_count,mta_count,filter_spam,sendmail_events:: 0,1,0.301075268817204,728688,0,93,186,0,0 
Mar  2 05:00:10 mail zimbramon[19831]: 19831:info: MTA: mail.newdomain.com: filter_misc,clam_events,mta_delay,mta_volume,filter_virus,filter_count,mta_count,filter_spam,sendmail_events:: 0,1,0.662162162162162,1062136,0,111,222,0,0 
Mar  2 05:10:10 mail zimbramon[31961]: 31961:info: MTA: mail.newdomain.com: filter_misc,clam_events,mta_delay,mta_volume,filter_virus,filter_count,mta_count,filter_spam,sendmail_events:: 0,1,2.39007092198582,901332,0,141,282,0,0 



$ tail /var/log/zimbra-stats.log 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: convertd: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: imapproxy: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: ldap: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: logger: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: mailbox: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: memcached: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: mta: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: snmp: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: spell: Running 
Mar  2 15:42:12 mail zimbramon[9358]: 9358:info: 2010-03-02 15:42:01, STATUS: mail.newdomain.com: stats: Running 



$ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats | head -20 
<GetLoggerStatsResponse xmlns="urn:zimbraAdmin">
  <hostname hn="mail.newdomain.com">
    <stats name="zmmtastats"/>
  </hostname>
</GetLoggerStatsResponse>



$ zmsoap -z GetLoggerStatsRequest stats/@name=zmmtastats @limit=1 | head -50 
<GetLoggerStatsResponse xmlns="urn:zimbraAdmin">
  <hostname hn="mail.newdomain.com">
    <stats name="zmmtastats"/>
  </hostname>
</GetLoggerStatsResponse>

[shanlar]

I perfomed an update frm 6.04 to 6.05 and it has fixed my Mail Queue issue. Server Statistics are still not working and displaying "no data available" though.

So close, yet I feel so far away...

[shanlar]

Alright was finally able to solve this. Though keep in mind the solution wipes all past statistics.

su - zimbra
zmloggerctl stop
rm -rf /opt/zimbra/logger/db/data/*
zmloggerctl start

Took about 10 minutes for Server Status to return check marks. Took about an hour for Server Statistics to start showing graph data.