Hi!! I was setting up the sqlcounter module and I needed to set the group parameter in the radgroupcheck table in order to set the limit values for sqlcounter. I found out that sql module doesn't work correctly. I set the read_groups parameter in the sql.conf file to 'yes' and despite that the sql module doesn't make the group processing. During the statrup procedure I don't see any info about that parameter no matter it set to 'yes' or 'no'. And then there is no processing during Request servicing in the authorize section:
here is the radius output for sql module: sql: driver = "rlm_sql_mysql" sql: server = "localhost" sql: port = "" sql: login = "radius" sql: password = "radiustz81" sql: radius_db = "radius2_0" sql: sqltrace = yes sql: sqltracefile = "/var/log/radiusd/sqltrace.sql" sql: readclients = no sql: deletestalesessions = yes sql: num_sql_socks = 5 sql: sql_user_name = "%{Stripped-User-Name:-%{User-Name:-DEFAULT}}" sql: default_user_profile = "" sql: nas_query = "SELECT id, nasname, shortname, type, secret FROM nas" sql: authorize_check_query = ....(sql queries) ER BY priority" sql: connect_failure_retry_delay = 60 sql: simul_count_query = "" sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0" sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply, date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}', '%S')" sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /" rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked rlm_sql (sql): Attempting to connect to [EMAIL PROTECTED]:/radius2_0 rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 rlm_sql_mysql: Starting connect to MySQL server for #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_mysql #1 rlm_sql_mysql: Starting connect to MySQL server for #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_mysql #2 rlm_sql_mysql: Starting connect to MySQL server for #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_mysql #3 rlm_sql_mysql: Starting connect to MySQL server for #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_mysql #4 rlm_sql_mysql: Starting connect to MySQL server for #4 rlm_sql (sql): Connected new DB handle, #4 Module: Instantiated sql (sql) authorize section from radiusd.conf: authorize { preprocess auth_req_log digest suffix sql daily expiration logintime pap auth_req_log daily_sqlcounter } And request processing by sql module: radius_xlat: 'tomix' rlm_sql (sql): sql_set_user escaped user --> 'tomix' rlm_sql (sql): Reserving sql socket id: 4 radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'tomix' ORDER BY id' rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'tomix' ORDER BY id rlm_sql (sql): User found in radcheck table radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'tomix' ORDER BY id' rlm_sql_mysql: query: SELECT id, UserName, Attribute, Value, op FROM radreply WHERE Username = 'tomix' ORDER BY id rlm_sql (sql): Released sql socket id: 4 modcall[authorize]: module "sql" returns ok for request 0 rlm_counter: Entering module authorize code rlm_counter: Could not find Check item value pair I kindly ask for your help Bests -Tomasz - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html