1 Topic by szabek

  • szabek
  • Member
  • Offline
  • Registered: 2017-01-24
  • Posts: 7

Topic: Get quarantined email number from database

==== Required information ====
- iRedMail version (check /etc/iredmail-release): v0.9.7
- Linux/BSD distribution name and version: ubunut 16.04.4
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): Mysql
- Web server (Apache or Nginx): Apache
- Manage mail accounts with iRedAdmin-Pro? yes
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hi,
I would like to check quarantined email number via nagios from mysql. What I have to check for this?

Thank you,
Szabolcs

----

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 quarantined email number from database

Query the "amavisd.quarantine" table.

if you want to get the sql commands executed by iRedAdmin-Pro, try to enable logging in MySQL for general sql commands, then check the log file. FYI:
http://www.iredmail.org/docs/debug.mysql.html

3 Reply by szabek

  • szabek
  • Member
  • Offline
  • Registered: 2017-01-24
  • Posts: 7

Re: Get quarantined email number from database

Thank you! I don't no, why I did not check table structure...

ZhangHuangbin wrote:

Query the "amavisd.quarantine" table.

if you want to get the sql commands executed by iRedAdmin-Pro, try to enable logging in MySQL for general sql commands, then check the log file. FYI:
http://www.iredmail.org/docs/debug.mysql.html