On Wed, 13 Nov 2002 11:30:43 +0200 Squire Valakos Yorgos uttered the following:
> -----Original Message----- > From: Valakos Yorgos [mailto:valakosg@;ipnet.gr] > Sent: Wednesday, November 06, 2002 9:48 AM > To: '[EMAIL PROTECTED]' > Subject: Expiration date check > > Hello all and thanks for your help ! > > I have freeradius 0.7 running under SuSe linux 8.0 on intel platform ( I > have to remind to all of you that I am a newcomer to both the linux and > freeradius world ) so here is my question : What do I have to do to make > freeradius to check authorization requests against an expiration date ? > (If expiration date >= current date then allow access else deny) Is this > possible ? I have freeradius using MySql database for both > authentication and accounting. And one more minor ... I want to keep > start records on MySql s radius database s radacct table and stop > records on another table of the same database (which I named 'radstop') > I have altered sql.conf to match that and created radstop table in > radius database ( I actually copied and pasted radacct and renamed it ) > but freeradius is still writing both records in radacct table ......what > more do I have to do ? > > > Thanks again for your help and for that splendid software you ve made > for us ... Hi Yorgos It's nice to see other SuSE users using freeradius :-) Regarding the epiration date, I believe this is very easy to do, although I have not done it myself. I think a quick search through the archives will give you the answer. With the sql.conf problem, infact there is a mistake in the file (I am just about to update the CVS to fix it now). While the file has at the top: # If you want both stop and start records logged to the # same SQL table, leave this as is. If you want them in # different tables, put the start table in acct_table1 # and stop table in acct_table2 acct_table1 = "radacct" acct_table2 = "radacct" it never actually uses the variable "acct_table2" anywhere :-( What you need to do is find the line near the bottom (of sql.conf) starting with: accounting_stop_query = "UPDATE ${acct_table1} SET AcctStop .... and change to: accounting_stop_query = "UPDATE ${acct_table2} SET AcctStop .... Also you need to change: accounting_stop_query_alt = "INSERT into radacct (RadAcct .... to: accounting_stop_query_alt = "INSERT into ${acct_table2} (RadAcct That should fix that problem :-) Note: I will have some new SuSE 8.0 rpms for freeradius available as soon as freeradius 0.8 is released (Any minute/day now) at http://www.susesecurity.com/files/ Cheers -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc
msg10972/pgp00000.pgp
Description: PGP signature