Applicable to:
- Plesk for Linux
Question
In the menu Subscriptions > example.com > Statistics (or just Statistics in Power User view), a big amount of POP3/IMAP traffic is shown.
Although, only one mail account is configured in the domains which belong to this subscription.
How to verify POP3/IMAP traffic statistics manually?
Answer
Note: the script takes mail statistics from /var/log/maillog* files. To make it showing statistics for the last month, adjust maillog rotation in /usr/local/psa/etc/logrotate.conf
-
Connect to the server using SSH.
-
Check if the utility
bcis installed on the server:# command -V bc
bc is /bin/bcIf the following output is returned,
bcshould be installed as per the following steps:# command -V bc
/bin/command: line 2: command: bc: not found-
For RHEL-based operating systems (CentOS, RHEL, CloudLinux):
# yum install bc
-
For Debian and Ubuntu:
# apt install bc
-
-
Download the script and unpack it:
# wget https://support.plesk.com/hc/en-us/article_attachments/360010836453/verify_pop3_imap_stats.tar.gz
# tar -zxvf verify_pop3_imap_stats.tar.gz -
Execute the script:
# ./verify_pop3_imap_stats.sh
-
Connect to the server via SSH.
-
Download the script and unpack it:
# wget https://plesk.zendesk.com/hc/article_attachments/360011194774/courier_traffic.tar.gz
# tar zxf courier_traffic.tar.gz -
Run the script with desired start and end dates and a domain name, if required
# ./courier_traffic.py --start 15-08 --end 22-08 --domain example.com --unit MB /var/log/maillog
Note: To see all available options run the script with
-hoption:./courier_traffic.py -h
Comments
3 comments
Is it possible to do the calculation for a period of time. On the web interface statistics does not have a time frame. How can we verify that using db and/or CLI
@Ops-team
In the Plesk interface, the traffic statistics are shown per-month (e.g in August, the statistics for this month are shown, the same for September, October etc.).
You can verify POP3/IMAP statistics in the Plesk database for the particular day(s) using the query like this:
==========
plesk db "select sum(pop3_imap_in+pop3_imap_out) from DomainsTraffic where date='2018-08-21' AND dom_id in (select id from domains where name='example.com')"
==========
The same is applicable to other columns in the table DomainsTraffic.
Could you also provide a script for SMTP traffic please?
Please sign in to leave a comment.