Hello,
I am trying to implement a Total Time Limit Solution/ Scratch Card
solution where an account "expires" or is blocked after the Total session
time is used. Tried to do this with the sqlcounter module and
noresetcounter. The setup seems ok, but I have some problems with the
rlm_sql module when it reads the Max-All-Session values from the
radgroupcheck table. (ana a few other values....)
Anyone experienced the same problem?
I am using freeradius-0.8.1 and postgresql 7.1
Thanks in advance!
Otto
Debug from radiusd:
rad_recv: Access-Request packet from host 127.0.0.1:32865, id=69,
length=63
User-Name = "vvthy"
User-Password = "5XYHn9A"
Service-Type = Authenticate-Only
NAS-IP-Address = 127.0.0.1
NAS-Port-Type = Wireless-802.11
modcall: entering group authorize
rlm_realm: No '@' in User-Name = "vvthy", looking up realm NULL
rlm_realm: No such realm NULL
modcall[authorize]: module "suffix" returns noop
rlm_sqlcounter: Entering module authorize code
rlm_sqlcounter: Could not find Check item value pair
modcall[authorize]: module "noresetcounter" returns noop
radius_xlat: 'vvthy'
rlm_sql (sql): sql_set_user escaped user --> 'vvthy'
radius_xlat: 'SELECT id,UserName,Attribute,Value,Op FROM radcheck WHERE
Username = 'vvthy' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 1
rlm_sql_postgresql: query: SELECT id,UserName,Attribute,Value,Op FROM
radcheck WHERE Username = 'vvthy' ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'vvthy' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
rlm_sql_postgresql: query: SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'vvthy' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
rlm_sql: The 'op' field for attribute 'Max-All-Session = 3600' is NULL, or
non-existent.
rlm_sql: You MUST FIX THIS if you want the configuration to behave as you
expect.
radius_xlat: 'SELECT id,UserName,Attribute,Value,Op FROM radreply WHERE
Username = 'vvthy' ORDER BY id'
rlm_sql_postgresql: query: SELECT id,UserName,Attribute,Value,Op FROM
radreply WHERE Username = 'vvthy' ORDER BY id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value
FROM radgroupreply,usergroup WHERE usergroup.Username = 'vvthy' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql_postgresql: query: SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value
FROM radgroupreply,usergroup WHERE usergroup.Username = 'vvthy' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql_postgresql: Status: PGRES_TUPLES_OK
rlm_sql_postgresql: affected rows =
rlm_sql: The 'op' field for attribute 'Session-Timeout = 3600' is NULL, or
non-existent.
rlm_sql: You MUST FIX THIS if you want the configuration to behave as you
expect.
rlm_sql: The 'op' field for attribute 'Idle-Timeout = 360' is NULL, or
non-existent.
rlm_sql: You MUST FIX THIS if you want the configuration to behave as you
expect.
rlm_sql: The 'op' field for attribute 'Max-All-Session = 3600' is NULL, or
non-existent.
rlm_sql: You MUST FIX THIS if you want the configuration to behave as you
expect.
rlm_sql (sql): Pairs do not match for user [vvthy]
rlm_sql (sql): Released sql socket id: 1
modcall[authorize]: module "sql" returns notfound
modcall: group authorize returns noop
auth: No authenticate method (Auth-Type) configuration found for the
request: Rejecting the user
auth: Failed to validate the user.
Delaying request 3 for 1 seconds
Finished request 3
Going to the next request
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
