Hello Nikolay, Monday, October 01, 2001, 10:27:12 PM, you wrote:
>>
>> If I define it in in radcheck or radgroupcheck tables FreeRADIUS
>> says:
NPR> [skip]
>>
>> rlm_sql: Pairs do not match [test]
>>
NPR> You must wrote 'Simultaneous-Use = 1' into radreply (radgroupreply) also.
Ok. I did as you say. But the result was same. :(
rad_recv: Access-Request packet from host 192.168.1.1:3052, id=55, 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 = 65
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 =
Simultaneous-Use = 1
Simultaneous-Use = 1
Framed-IP-Address = 192.168.2.1
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 =
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 r1 port 65)
auth: Failed to validate the user.
Login incorrect: [test] (from nas r1 port 65)
Sending Access-Reject of id 55 to 192.168.1.1:3052
Finished request 2
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 2 ID 55 with timestamp 3bb96702
Nothing to do. Sleeping until we see a request.
Best regards,
Sergey mailto:[EMAIL PROTECTED]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
