Delete old email accounts

[alipour66m]

hello
is there a way to delete old email accounts from directadmin?
I have a webmail server with over 100.000 accounts (in directadmin imap)
I need really help

 

[zEitEr]

Hello,

Do you need to delete them all?

You should

1. remove information about email accounts from /etc/virtual/<domain.com>/passwd
2. remove folders from /home/<username>/imap/<domain.com>/

 

[alipour66m]

How to find old and unused email account?
for example an email account that had not beed used over 6 months?

 

[zEitEr]

Analyze logs /var/log/maillog for that period if you have them, and see in what accounts nobody logged that long.


To make it easier to check last login date you might want to use this solution: http://www.dovecot.org/list/dovecot/2011-January/056320.html

 

[alipour66m]

Thank you
but how to use
http://www.dovecot.org/list/dovecot/2011-January/056320.html

can you please help me with .sh or some ssh codes?

 

[zEitEr]

Currently I don't need it for myself and that's hardly needed by other users of directadmin. So if you want me to write scripts please send me a PM for a quote.

 

[alipour66m]

I have an idea
I can find emails account from
cat /var/log/maillog | grep imap-login:\ Login | sed -e 's/.*Login: user=<\(.*\)>, method=.*/\1/g' | sort | uniq
and then insert them to a database daily

I need help in two step
1) above code find every email , how to change it to find today email logins
2) how to write a line to insert them in database?

tnank you

 

[unihostbrasil]

Hello,

We use an own script that identifies unused accounts (with very old emails in the imap "/new" folder) and send an e-mail to the account admin and an general report to server admin. It's very useful to keep the server clean. I'll post it soon.

 

[alipour66m]

thank you
I'm waiting for it ...

 

[unihostbrasil]

We have released the script to check for inactive and overquota accounts.
Sorry for the delay.

Complete info here:

http://forum.directadmin.com/showthread.php?t=51135