Mail Server Using Postfix, Roundcube, Vimbadmin, and MySQL, reporting scripts
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 :D |
Quote:
|
Quote:
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. |
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. |
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?? |
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 As for quota per user, you can try with this: Code:
virtual_mailbox_limit_inbox = yes Code:
# 300MB limit http://vda.sourceforge.net/ |
Thank you a lot you were very helpfull
|
For active accts, you need to watch outgoing email counts.
|
All times are GMT -5. The time now is 07:57 PM. |