http://wiki.freeradius.org/SQL_HOWTO#Populating_SQL
See also sqlcounters and Expiration attribute. Ivan Kalik Kalik Informatika ISP Dana 8/12/2008, "Matthew Carriere" <[EMAIL PROTECTED]> piše: >So I was taking a look at the schema's provided on Github. Can someone >narrow down for me what the workflow of provisioning a user would look >like? >Specifically what I need to do is authorize/de-authorize users using a >timestamp. So what I am thinking is: > >1. I would provision users in my Rails application. >2. Authenticated users would then be added to or looked up in a FreeRadius >server schema (table?) >3. FreeRadius users would need to 'timeout' or expire. Is this possible >programatically? Would I have to run a sweep outside of FreeRadius to expire >users? > >Does the mere presence of a user in a specific FreeRadius schema allow its >access or does it make it 'available' to be given access? If that's the case >how would I give them access programatically. I suspect there is another >authorization table or something of the sort. > >Thanks again for the help. > >Matthew. > > >On Thu, Dec 4, 2008 at 1:15 PM, <[EMAIL PROTECTED]> wrote: > >> >Has anyone done this before in any language? >> >> I've done it in ASP.NET (C#), php and perl (on separate occasions). You >> actually have dialup admin (php) included with the server. That is not >> under active development. daloRadius is (you will find the developer >> lurking on this list). >> >> >Any potential issues to >> >watch out for? >> >> Not much. Changes from version to version might require application >> alterations. Schema, attributes, operators are not set in stone. >> >> Ivan Kalik >> Kalik Informatika ISP >> >> - >> List info/subscribe/unsubscribe? See >> http://www.freeradius.org/list/users.html >> > > > >-- >Matthew Carriere >[EMAIL PROTECTED] > > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

