Re: [Help-gnu-radius] Best Radius is GNU Radius ?

[Gerald]

On Wed, 12 Nov 2003, Zoup wrote:

> thank you very much , im greatful , but do you have anyidea about how i can
> tell mysql when user active for first time ?

Upon the first successful authentication make the accounting sql update
modify the start time for the account.

something like

| User | Pass | Date | Active |

When authentication is successful perform mysql functions to check if the
account has a start date yet and create one if there isn't already
something there. The first auth after 30 days can update Active = 'N'.

There's probably hundreds of better ways to do this, but the best place I
can think of to put the 30 day logic is in the sql auth and acct queries.

Gerald