Mail Server Using Postfix, Roundcube, Vimbadmin, and MySQL, reporting scripts

jamil.isayyed · 07-27-2012, 03:41 AM

Hello,

i have Mail server using Postfix, roundcube, vimbadmin and MySQL. what i want to do is to create a script report that gives:

1- the Mailbox Size, which i think i will use du -sh to find the size but also i want the qouta for each user and what is the space the the user still have.
2- the Amount of unread/read emails for each user. which i do not have any idea about how i can do it.
3- Last logon/access (if possible also by protocol POP3 or HTTP)

So any Help

TB0ne · 07-27-2012, 08:38 PM

Quote:

Originally Posted by jamil.isayyed

Hello,

i have Mail server using Postfix, roundcube, vimbadmin and MySQL. what i want to do is to create a script report that gives:

1- the Mailbox Size, which i think i will use du -sh to find the size but also i want the qouta for each user and what is the space the the user still have.
2- the Amount of unread/read emails for each user. which i do not have any idea about how i can do it.
3- Last logon/access (if possible also by protocol POP3 or HTTP)

So any Help

Help with what? If you want a script, write it. There are many scripting tutorials you can find on Google. We will be glad to help you with specific questions....so post them with your scripts

jamil.isayyed · 07-28-2012, 04:06 AM

Quote:

Originally Posted by TB0ne

Help with what? If you want a script, write it. There are many scripting tutorials you can find on Google. We will be glad to help you with specific questions....so post them with your scripts

i do not want a script, i am already writing it, my question is how i can find the number of read and unread message for each mailbox without invading the privacy and conditionality of there mail boxes is there a flag that i can monitor for each message or not.

and the second thing is how i can monitor there access is there another way than the log files, that each time somebody access his mail box to get the date and if possible the protocol and write it on other file?
these are my question i don't want any body to write any script on behalf of me, because i am already writing it.

diwljina · 07-28-2012, 04:21 AM

If it's maildir format, you can use find command to find all new folders in users directory and than count all files in them. Those are unread mails and those in cur folders are read. But I think this is already invading their privacy.

I don't think you can do anything else than monitor log file of POP3/IMAP service to find out about their access.

jamil.isayyed · 07-28-2012, 04:33 AM

but as i have seen in the new and cur folders there is some files in them contains more than one message, and we will not know what is in there mailboxes from data or the contents of the email, but i will use this script to know whose emails is active and whose not, is there any mailboxes that just take a space without being used....etc.

i have another question , in postfix i can put a quota to for all the mailboxes, put how i can put different quotas to different users??

diwljina · 07-28-2012, 04:56 AM

To my best knowledge, in maildir format one message is represented with one file.

http://qmail.org/man/man5/maildir.html

Code:

Each file in new is a newly delivered mail message.  The
          modification time of the file is the delivery date of the
          message.

I see what you are trying to accomplish, but new mail in mailboxes doesn't mean that account is active. New mails can be spam mails, or sender isn't aware that recipient isn't using that account any more. Best thing is to watch for logging.

As for quota per user, you can try with this:

Code:

virtual_mailbox_limit_inbox = yes
virtual_mailbox_limit = 1073741824
virtual_mailbox_limit_override = yes
virtual_mailbox_limit_maps = hash:/etc/postfix/vquota

In /etc/postfix/vquota:

Code:

# 300MB limit
username@example.com    314572800
username2@example.com   314572800
# 500MB limit
username3@example.com   524288000
# no limit
username4@example.com    0

But you need this patch:
http://vda.sourceforge.net/

jamil.isayyed · 07-28-2012, 05:01 AM

Thank you a lot you were very helpfull

chrism01 · 07-29-2012, 07:22 PM

For active accts, you need to watch outgoing email counts.