A Grafana Dashboard for Zimbra Collaboration

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
User avatar
jorgedlcruz
Zimbra Alumni
Zimbra Alumni
Posts: 2782
Joined: Thu May 22, 2014 4:47 pm

Re: A Grafana Dashboard for Zimbra Collaboration

Post by jorgedlcruz »

Hello,
I did edit the script on GitHub, can you please confirm you have all the rest of the data properly?
Jorge de la Cruz https://jorgedelacruz.es
Systems Engineer at Veeam Software https://www.veeam.com/
yves.vogl
Posts: 6
Joined: Thu Oct 20, 2016 11:06 pm

Re: A Grafana Dashboard for Zimbra Collaboration

Post by yves.vogl »

This is so awesome. Thank you!
User avatar
jorgedlcruz
Zimbra Alumni
Zimbra Alumni
Posts: 2782
Joined: Thu May 22, 2014 4:47 pm

Re: A Grafana Dashboard for Zimbra Collaboration

Post by jorgedlcruz »

You're welcome !! I hope you like it and you find it useful !!

Cheers
Jorge de la Cruz https://jorgedelacruz.es
Systems Engineer at Veeam Software https://www.veeam.com/
User avatar
jasggomes
Advanced member
Advanced member
Posts: 90
Joined: Sat Sep 13, 2014 12:59 am
Location: Lisbon, PT
ZCS/ZD Version: Release 8.7.11.GA.1854.UBUNTU14.64
Contact:

Re: A Grafana Dashboard for Zimbra Collaboration

Post by jasggomes »

Hi Jorge,

Hope all is ok with you, getting this on my new server :

Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 946, <> line 2118.
zimbra-stats received=26
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 947, <> line 2118.
zimbra-stats delivered=69
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 948, <> line 2118.
zimbra-stats forwarded=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 949, <> line 2118.
zimbra-stats deferred=1
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 950, <> line 2118.
zimbra-stats bounced=5
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 951, <> line 2118.
zimbra-stats rejected=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 952, <> line 2118.
zimbra-stats reject_warnings=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 953, <> line 2118.
zimbra-stats held=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 954, <> line 2118.
zimbra-stats discarded=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 955, <> line 2118.
zimbra-stats bytes_received=525
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 956, <> line 2118.
zimbra-stats bytes_delivered=1691
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 957, <> line 2118.
zimbra-stats senders=11
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 958, <> line 2118.
zimbra-stats sending_hosts_domains=6
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 959, <> line 2118.
zimbra-stats recipients=14
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 960, <> line 2118.
zimbra-stats recipient_hosts_domains=4

This new server is ubuntu 16.04 old is 14.04.

Going to copy the .pl from old server , but just to let you know about this.

Regards and stay sharp.
mplaksin
Posts: 3
Joined: Thu Apr 26, 2018 1:27 pm

Re: A Grafana Dashboard for Zimbra Collaboration

Post by mplaksin »

Hello,
Its any way to export the total number of accounts to the influxdb, to make a graph?. I have multiple zmbox.
rosole
Posts: 31
Joined: Thu Jul 05, 2018 4:45 pm

Re: A Grafana Dashboard for Zimbra Collaboration

Post by rosole »

Hello.

I've got isssue executing file zimbra_pflogsumm.pl:

sudo -u telegraf /opt/zimbra/common/bin/zimbra_pflogsumm.pl /var/log/zimbra.log
/opt/zimbra/common/bin/zimbra_pflogsumm.pl: 2: /opt/zimbra/common/bin/zimbra_pflogsumm.pl: Syntax error: newline unexpected

in /var/log/syslog got:

Error in plugin [inputs.exec]: exec: fork/exec /opt/zimbra/common/bin/zimbra_pflogsumm.pl: exec format error for command '/opt/zimbra/common/bin/zimbra_pflogsumm.pl -d today /var/log/zimbra.log'

And of course i do not have any statistics in Grafana.

Have anyone got this errors?

Thank you.
phoenix
Ambassador
Ambassador
Posts: 27272
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

Re: A Grafana Dashboard for Zimbra Collaboration

Post by phoenix »

It works fine for me, have you tried running it manually?

Code: Select all

[root@zcs ~]# /opt/zimbra/common/bin/zimbra_pflogsumm.pl -d today /var/log/zimbra.log
zimbra-stats received=42 
zimbra-stats delivered=52 
zimbra-stats forwarded=0 
zimbra-stats deferred=0 
zimbra-stats bounced=0 
zimbra-stats rejected=2 
zimbra-stats reject_warnings=0 
zimbra-stats held=0 
zimbra-stats discarded=0 
zimbra-stats bytes_received=456150
zimbra-stats bytes_delivered=935
zimbra-stats senders=13 
zimbra-stats sending_hosts_domains=12 
zimbra-stats recipients=11 
zimbra-stats recipient_hosts_domains=7 
[root@mail01 ~]# 
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
rosole
Posts: 31
Joined: Thu Jul 05, 2018 4:45 pm

Re: A Grafana Dashboard for Zimbra Collaboration

Post by rosole »

Hello.

root@zimbra:~# /opt/zimbra/common/bin/zimbra_pflogsumm.pl -d today /var/log/zimbra.log
/opt/zimbra/common/bin/zimbra_pflogsumm.pl: line 1: syntax error at marker `newline'
/opt/zimbra/common/bin/zimbra_pflogsumm.pl: line 1: `<!DOCTYPE html>'

Thank you for help.
phoenix
Ambassador
Ambassador
Posts: 27272
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

Re: A Grafana Dashboard for Zimbra Collaboration

Post by phoenix »

In that case I can only assume the error message is correct and the script file is corrupt. Move your current copy aside and download the one from the repo and try that, I've just done that again and there's nothing wrong with the script.
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
rosole
Posts: 31
Joined: Thu Jul 05, 2018 4:45 pm

Re: A Grafana Dashboard for Zimbra Collaboration

Post by rosole »

Hello.

Indeed, i've downloaded broken files.
Now files seems ok but when i put command:

/opt/zimbra/common/bin/zimbra_pflogsumm.pl -d today /var/log/zimbra.log

then got:

Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 831, <> line 2555.
zimbra-stats received=12
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 832, <> line 2555.
zimbra-stats delivered=36
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 833, <> line 2555.
zimbra-stats forwarded=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 834, <> line 2555.
zimbra-stats deferred=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 835, <> line 2555.
zimbra-stats bounced=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 836, <> line 2555.
zimbra-stats rejected=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 837, <> line 2555.
zimbra-stats reject_warnings=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 838, <> line 2555.
zimbra-stats held=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 839, <> line 2555.
zimbra-stats discarded=0
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 840, <> line 2555.
zimbra-stats bytes_received=241253
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 841, <> line 2555.
zimbra-stats bytes_delivered=722
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 842, <> line 2555.
zimbra-stats senders=9
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 843, <> line 2555.
zimbra-stats sending_hosts_domains=5
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 844, <> line 2555.
zimbra-stats recipients=1
Redundant argument in printf at /opt/zimbra/common/bin/zimbra_pflogsumm.pl line 845, <> line 2555.
zimbra-stats recipient_hosts_domains=1

I think, it's not ok...

And now i've got in 0 for zimbra (before was null):
Attachments
1.PNG
1.PNG (73 KiB) Viewed 37646 times
Post Reply