Expiring passwords and alert

[mouncef]

HI all,

This might be a newbie question for most of you, I'm using proftpd with mysql, the way it works is users authenticate to the FTP server through a mysql DB. This database contains 2 tables "proftpd_users" and "proftpd_groups".
The proftpd_users table has the following fields:
uid, gid, username, password, firstname, lastname, homedir and count.
The proftpd_groups table has the following fields:
groupname, gid, members.

What I want to do is expire the users passwords every 90 days and send an email notification to them.
I thought about adding 3 more fields to the proftpd_users, pass_date, warn and the other expire:
pass_date ------> the date the password was created/changed.
warn ------> days before password expires that user is warned.
expire ------> absolute date for expiration.

and somehow have a php script check the date and warn the users a few days before the password expires.

Thank you for your time.

[[deleted]]

Why three fields? all you need is the date on which the password was last updated.
From that you can calculate the other dates.

Then you can use a crontab (search the forum, search the net) to start a script every day to see which passwords are about to expire and to expire those passwords that have not been changed after 90 days.