Hello freeradius-users, How can I define Simultaneous-Use = 1 i SQL Schema? If I define it in in radcheck or radgroupcheck tables FreeRADIUS says:
rad_recv: Access-Request packet from host 192.168.1.1:4353, id=201, length=56
User-Name = "test"
Password = "PM\436v`K\342r\231i\312\033\230\362\352n"
NAS-IP-Address = 192.168.1.1
NAS-Port = 1
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
modcall[authorize]: module "suffix" returns ok
rlm_sql: Reserving sql socket id: 4
radius_xlat: 'test'
sql_escape in: 'test'
sql_escape out: 'test'
sql_set_user: escaped user --> 'test'
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username =
'test' ORDER BY id'
rlm_postgresql Status: PGRES_TUPLES_OK
sql_postgresql: affected rows =
Password = "Test6523"
Password = "Test6523"
Simultaneous-Use = 1
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value
FROM radgroupcheck,usergroup WHER
E usergroup.Username = 'test' AND usergroup.GroupName = radgroupcheck.GroupName ORDER
BY radgroupcheck.id'
rlm_postgresql Status: PGRES_TUPLES_OK
sql_postgresql: affected rows =
radius_xlat: 'SELECT id,UserName,Attribute,Value FROM radreply WHERE Username =
'test' ORDER BY id'
rlm_postgresql Status: PGRES_TUPLES_OK
sql_postgresql: affected rows =
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value
FROM radgroupreply,usergroup WHER
E usergroup.Username = 'test' AND usergroup.GroupName = radgroupreply.GroupName ORDER
BY radgroupreply.id'
rlm_postgresql Status: PGRES_TUPLES_OK
sql_postgresql: affected rows =
Framed-Protocol = PPP
Framed-Protocol = PPP
Service-Type = Framed-User
Framed-Protocol = PPP
Service-Type = Framed-User
Framed-MTU = 1500
Framed-Protocol = PPP
Service-Type = Framed-User
Framed-MTU = 1500
Cisco-AVPair = "ip:addr-pool=default"
rlm_sql: Released sql socket id: 4
rlm_sql: Pairs do not match [test]
modcall[authorize]: module "sql" returns notfound
modcall: group authorize returns ok
auth: type Local
>auth: No Password configured for the user
>No Password configured for the user: [test] (from nas nas-1 port 1)
>auth: Failed to validate the user.
>Login incorrect: [test] (from nas r1 port 65)
Sending Access-Reject of id 201 to 192.168.1.1:4353
Finished request 0
Going to the next request
Best regards,
Sergey mailto:[EMAIL PROTECTED]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
