sqlcounter_expire_on_login module

[tonimanel]

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 radacct 		 WHERE UserName='%{User-Name}' 		 ORDER BY
acctstarttime 		 LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) 		 FROM radacct 		 WHERE UserName='sa373YIMET' 		 ORDER BY
acctstarttime 		 LIMIT 1;
sqlcounter_expand:  '%{sql:SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) 		 FROM radacct 		 WHERE UserName='sa373YIMET' 		 ORDER BY
acctstarttime 		 LIMIT 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 radacct 		 WHERE UserName='sa373YIMET' 		 ORDER BY
acctstarttime 		 LIMIT 1; -> SELECT TIME_TO_SEC(TIMEDIFF(NOW(),
acctstarttime)) 		 FROM radacct 		 WHERE UserName='sa373YIMET' 		 ORDER BY
acctstarttime 		 LIMIT 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 radacct 		 WHERE UserName='sa373YIMET' 		 ORDER BY
acctstarttime 		 LIMIT 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.