1 Topic by nicolasfo (edited by nicolasfo 2016-11-17 17:26:00)

  • nicolasfo
  • Member
  • Offline
  • From: Lille - France
  • Registered: 2010-10-13
  • Posts: 167

Topic: Get stats from iRedAdmin Pro - Zabbix

==== Required information ====
- iRedMail version (check /etc/iredmail-release): 0.9.5-1
- Linux/BSD distribution name and version: Debian 8
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? Yes
- Related log if you're reporting an issue:
====
Hello there,
I'd like to know how iRedAdmin Pro is getting stats displayed on the index : 
- Mails Received
- Mails Sent
- Virus
- Quarantined

- Number of domains
- Number of users
- Number of aliases
- Stored emails (number and size)

Is there a command I can have to get all those informations ?
I'd like to make Zabbix have access to those informations.

Thanks

Nicolas

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Get stats from iRedAdmin Pro - Zabbix

This is done by SQL query, not exported via RESTful API yet.

3 Reply by nicolasfo (edited by nicolasfo 2016-11-17 18:42:26)

  • nicolasfo
  • Member
  • Offline
  • From: Lille - France
  • Registered: 2010-10-13
  • Posts: 167

Re: Get stats from iRedAdmin Pro - Zabbix

Hello,

Here's Zabbix template for iRedMail for those interested.
Use :

  • Upload "zabbix_iredmail_stats.sh" in "/etc/zabbix" folder on the mail server

  • Change the vmail password in "zabbix_iredmail_stats.sh" - SQLUSRPSSWD

  • Create the file "/etc/zabbix/domains" blank, chmod 666

  • Import the template and link it to your mail server host

Available stats :

  • IredMail Infos : Domains count, IredMail version, Mailboxes count

  • Messages count : Per domains messages count, Total messages count

  • Size count : Per domain Size count, Total size count

Template created with versions :

  • Zabbix 3.2 (but should work on previous versions)

  • Debian 8 x64 mail server

  • IredMail 0.9.5-1 (but should work on previous versions)

If you find a bug, let me know.

Nicolas

Post's attachments

template_zabbix_iredmail.xml 15.85 kb, 86 downloads since 2016-11-17 

zabbix_iredmail_stats.sh 3 kb, 93 downloads since 2016-11-17 

You don't have the permssions to download the attachments of this post.

4 Reply by ZhangHuangbin

  • ZhangHuangbin
  • ZhangHuangbin
  • iRedMail Developers
  • Offline
  • Registered: 2009-05-06
  • Posts: 31,088

Re: Get stats from iRedAdmin Pro - Zabbix

Thanks very much for sharing. smile

5 Reply by nicolasfo

  • nicolasfo
  • Member
  • Offline
  • From: Lille - France
  • Registered: 2010-10-13
  • Posts: 167

Re: Get stats from iRedAdmin Pro - Zabbix

You're welcome wink