ok, well I tried editing the sql query to no avail, which I suppose is not
surprising since after looking through the authentication and authorization
functions in rlm_sql.c I can't see anything about processing any other
attribute apart from username and password.
Can I take it that Login-Time can't be implemented with the MySQL backend
without a rewrite of those functions?
Thanks,
Paul
-----Original Message-----
From: Paul Foxton [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 11:07
To: [EMAIL PROTECTED]
Subject: Login-Time attribute read from MySQL
Hi,
I've finally got freeradius working ok with a MySQL backend now, but I would
ideally like to be able
to set the Login-Time check attribute in the database table so I can update
it dynamically.
I notice the sql SELECT query for the authentication check is as follows
(from debug output):
SELECT Value, Attribute FROM radcheck WHERE UserName = 'username' AND (
Attribute = 'Password' OR Attribute = 'Crypt-Password') ORDER BY Attribute
DESC
I presume that since the Login-Time attribute is an authentication check one
that it should be entered into the radcheck table - so my question is this.
If I alter the sql query in sql.conf to read something like
SELECT Value, Attribute FROM radcheck WHERE USerName = 'user' AND (
Attribute = 'Password' OR Attribute = 'Crypt-Password' OR Attribute =
'Login-Time') ORDER BY Attribute DESC
and recompile the module will this be enough for freeradius to do its
calculation and return the Set-Timeout attribute or would I need to edit a
bit deeper to get it to work?
Or am I barking up the wrong tree entirely?
Thanks,
Paul
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
