Hi everybody,
I've been using sqlcounter with mysql for a while without a problem (thanks to developers). Now, I want to use it with an external database/table, I mean to check the quota time from another personal table. As I undertand, it should work by only specifying a new sql module, and pointing the sqlcounter's sqlmod-inst into it. However when try to do that, it does not work, the rlm_sqcounter steps seem ok (cf. the part of log below in debug mod), but I do not find any corresponding mysql query. So, is it possible to do that ? If yes, what might be wrong in my config ? Thanks in advance, -- part of my config -- # # Configuration for the SQL module. # sql sql_simrad { # Database type # Current supported are: rlm_sql_mysql, rlm_sql_postgresql, rlm_sql_iodbc, rlm_sql_oracle driver = "rlm_sql_mysql" # Connect info server = "ntp" login = "myuser" password = "mypassword" # Database table configuration radius_db = "simrad" ... } ... # # sql counter configuration ... sqlcounter sqlcounter_monthly_simrad { counter-name = SQL-Monthly-Session-Time check-name = SQL-Max-Monthly-Session-Time sqlmod-inst = sql_simrad key = User-Name query = "SELECT SUM(SessionTime) FROM simacct WHERE UserName='%{%k}'" reset = monthly } -- here is the output of the radius server -- rlm_sqlcounter: Entering module authorize code sqlcounter_expand: 'SELECT SUM(SessionTime) FROM simacct WHERE UserName='%{User-Name}'' radius_xlat: 'SELECT SUM(SessionTime) FROM simacct WHERE UserName='do-risika'' sqlcounter_expand: '%{sql_simrad:SELECT SUM(SessionTime) FROM simacct WHERE UserName='do-risika'}' radius_xlat: '' rlm_sqlcounter: (Check item - counter) is greater than zero rlm_sqlcounter: Authorized user do-risika, check_item=108000, counter=0 rlm_sqlcounter: Sent Reply-Item for user do-risika, Type=Session-Timeout, value=108000 modcall[authorize]: module "sqlcounter_monthly_simrad" returns ok @+ -- DouRiX \\\|/// ___ \\ - - // ____ ___ __ | _ oOOo_@ @_oOOo| _ \(_) \/ / | | | |/ _(_) | | | |_| ) |\ / | |_| | (_) | |_| | _ <| |/ \ |____/ \___/ \_Ooooo| \_\_/_/\_\ f u cn rd ths u r usng unx ooooO ) / ( ) (_/ \ ( \_) [Stupid questions are better than stupid mistakes. --Japanese proverb] - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html