Thanks Paul for your reply I will use your exemple to update the last login date after i add a user.
But i would prefer something like today=`date +"%Y-%m-%d 00:00:00"` dbmail-adduser -l $today ...etc I read the dbmail database for reporting but i rather let dbmail-adduser do the updates. 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 Selon Paul J Stevens <[EMAIL PROTECTED]>: > 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 > _______________________________________________ > Dbmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail >
