Hi everybody,
I have been looking for how to solve this: A user log in to freeradius, and
after the first login, exactly one day later the access should to expire.
Example:
User: 'aaa' - 1 day (24hours).
First login: 2012-04-02 12:00:00
Expires on: 2012-04-03 12:00:00
I have enabled sqlcounter_expire_on_login module, when user log in first
time, there are not uses (radacct is empty for this user) but,
sqlcounter_expire_on_login's query returns empty set value, not returns a
valid value (for example 0) so, when freeradius check the return, says this:
(freeradius -X output)
rlm_sqlcounter: Entering module authorize code
sqlcounter_expand: 'SELECT TIME_TO_SEC(TIMEDIFF(NOW(), acctstarttime))
FROM radacct WHERE UserName='%{User-Name}' ORDER BY
acctstarttime
LIMIT 1;'
[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) FROM radacctWHERE
UserName='%{User-Name}' ORDER BY
acctstarttimeLIMIT 1; - SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) FROM radacctWHERE
UserName='sa373YIMET' ORDER BY
acctstarttimeLIMIT 1;
sqlcounter_expand: '%{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) FROM radacctWHERE
UserName='sa373YIMET' ORDER BY
acctstarttimeLIMIT 1;}'
[expire_on_login] sql_xlat
[expire_on_login] expand: %{User-Name} - sa373YIMET
[expire_on_login] sql_set_user escaped user -- 'sa373YIMET'
[expire_on_login] expand: SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) FROM radacctWHERE
UserName='sa373YIMET' ORDER BY
acctstarttimeLIMIT 1; - SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) FROM radacctWHERE
UserName='sa373YIMET' ORDER BY
acctstarttimeLIMIT 1;
rlm_sql (sql): Reserving sql socket id: 3
[expire_on_login] SQL query did not return any results
rlm_sql (sql): Released sql socket id: 3
[expire_on_login] expand: %{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) FROM radacctWHERE
UserName='sa373YIMET' ORDER BY
acctstarttimeLIMIT 1;} -
rlm_sqlcounter: No integer found in string
++[expire_on_login] returns noop
Anybody could tell me how can I do to solve it?
I hope your answers.
Thank you very much.
Best regards,
Antonio.
--
View this message in context:
http://freeradius.1045715.n5.nabble.com/sqlcounter-expire-on-login-module-tp5682512.html
Sent from the FreeRadius - User mailing list archive at Nabble.com.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html