autodele of inactive users

[gea]

hello

i am evaluating rc as webmailer for the students of our university.
every three years all of our users are changing and i am wondering if the mysql database is growing and growing or if there is a chance to auto-remove users for ex. after a specific time of inactivity.

i do not want to edit rc´s database. i also do not want to modify our ad domain for rc.

i prefer rc for being a complete standalone and independant system.


guenther

[Julius Caesar]

This can only be done by a query on the database. If you want I can to create the query for you.

[gea]

hello julius caesar

the point is: i do not want to edit the database(s) manually.
that should be an automated action by roundcube for example
at login or logout of first user every month.

i selected roundcube because its a standalone copy and run solution.
(copy ../httdocs, start apache, use sqlite or start mysql and ok)

it would be nice if it could also be set and forget.
webmailing is always temporary or mobile use with our users


greetings



guenther

[rosali]

You need a volunteer to write an embedded database maintenance script. The starting point is "users" table to get inactive accounts by the field "last_login" and then to wipe out all rows linked to the master key "user_id" in all roundcube database tables. Nice idea, but not on the top of my TODO's!

I recommend Rent A Coder: How Software Gets Done -- Home of the worlds' largest number of completed software projects