sql module doesn't use read_groups parameter

tzieleniewski tzieleniewski at o2.pl
Thu Feb 8 10:36:41 CET 2007


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 radius at localhost:/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








More information about the Freeradius-Users mailing list