Since you are using mysql, and the default date is part of the
create_tables....sql file, you could ofcourse change the user table from a cron job:
-------
#!/bin/sh
today=`date +"%Y-%m-%d 00:00:00"`
mysql -e "alter table users change last_login last_login datetime default
\"$today\" not null;" dbmail
-------
I dont think this is possible with postgresql, though.
Jacques Beaudoin wrote:
I am the mail administrator for my school board since 1995.
Dbmail is my 3 mail system.
I converted my users from pegasus mail to uwimap to dbmail.
and been draging some unuse accounts.
Dbmail give me "at last" via a mysql query a easy way to know the accounts
that are not being used since a long time.
Thats great.
So now that 3 mounts have gone by since my conversion to dbmail
i can delete all those 2,200 1979 accounts that nobody are using.
Well yes and no because when we create a new account it also
gets the 1979 creation date.
And if via a script i delete all those 1979 accounts i mite
delete some "unuse new accounts".
My request is could we have via a parameter in dbmail-adduser
the chance to change the default 1979 date to the day the
account was created and/or to another date.
Bien à vous
Jacques Beaudoin
Agent d'administration
Les services des technologies
de l'information et des communications
Commission scolaire de la Pointe de l'Île
Montréal, Québec, Canada
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
