How to verify Plesk mail traffic statistics?

Created:

2016-11-16 12:39:51 UTC

Modified:

2017-04-24 12:16:02 UTC

0

Was this article helpful?


Have more questions?

Submit a request

How to verify Plesk mail traffic statistics?

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

Domain example.com in Plesk displays high amount of mail traffic. Although, according to the customer, only one mail account is configured for this domain.

Is there any possibility for the customer to verify the statistics manually?

Resolution

  1. Check traffic in psa database for a certain date:
    mysql> select sum(pop3_imap_in+pop3_imap_out)/1024/1024/1024 from DomainsTraffic where dom_id=854 and date='2015-05-20';
    +------------------------------------------------+

    | sum(pop3_imap_in+pop3_imap_out)/1024/1024/1024 |
    +------------------------------------------------+
    | 0.974370324053 |
    +------------------------------------------------+
    1 row in set (0.00 sec)

where dom_id is:

    mysql> select id from domains where name='example.com';
+-----+
| id |
+-----+
| 854 |
+-----+
1 row in set (0.00 sec)
  1. Check the size in maillog for the same date:

    # grep -rni pop3 /var/log/maillog | grep example.com | awk '/size=/{ split($13,a,"=") ; SUM += a[2] } END { print SUM/1024/1024/1042}'
    0.957525
  2. User email@example.com used all this traffic:

    # grep -rni pop3 /var/log/maillog | grep email@example.com | awk '/size=/{ split($13,a,"=") ; SUM += a[2] } END { print SUM/1024/1024/1042}'
    0.95634

    where email@example.com is the mail account configured for the domain.

  3. Unusual mail client behavior - it downloads all the content every time user logs on:

    # du -hs /var/qmail/mailnames/example.com/email/
    16M /var/qmail/mailnames/example.com/email

    18697:May 20 01:30:04 verwaltung dovecot: service=pop3, user=email@example.com, ip=[203.0.113.2]. Disconnected: Logged out rcvd=126, sent=14716141, top=6/6638, retr=6/14709266, del=0/6, size=14709146

According to all mentioned above, the statistic should be correct.

Have more questions? Submit a request
Please sign in to leave a comment.