Tuesday, September 24, 2002, 10:30:43 AM
Menssagem Original:
KK> On Tue, 24 Sep 2002, Dyego Souza do Carmo wrote:
>> Monday, September 23, 2002, 6:39:50 PM
>>
>> Menssagem Original:
>>
>> DT> Dyego Souza do Carmo wrote:
>>
>> >> In SQL database i insert :
>> >>
>> >> insert into usergroup (username,groupname) values ('dyego','geral');
>> >>
>> >> insert into radcheck (username,attribute,value) values
>> >> ('dyego','Password','123');
>>
>> DT> I think that should be "User-Password" or "CHAP-Password", not "Password".
>>
>>
>> OK ... i change 'Password' to 'User-Password' and have problem too...
KK> Try also adding an op field with a value of ':=" in the password row.
KK> --
KK> Kostas Kalevras Network Operations Center
KK> [EMAIL PROTECTED] National Technical University of Athens, Greece
KK> Work Phone: +30 10 7721861
KK> 'Go back to the shadow' Gandalf
KK> -
KK> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
OH MY GOD !!! hehe... the error change :D
is a configuration problem ?
radius_xlat: 'dyego'
sql_set_user: escaped user --> 'dyego'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'dyego' ORDER BY id'
rlm_sql: Reserving sql socket id: 0
query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = 'dyego'
ORDER BY id
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'dyego' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id'
query: SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op
FROM radgroupcheck,usergroup WHERE usergroup.Username = 'dyego' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username =
'dyego' ORDER BY id'
query: SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = 'dyego'
ORDER BY id
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = 'dyego' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id'
query: SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op
FROM radgroupreply,usergroup WHERE usergroup.Username = 'dyego' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: check items
Password = "123"
rlm_sql: reply items
radius_xlat: 'SELECT Value,Attribute FROM radcheck WHERE UserName = 'dyego' AND (
Attribute = 'User-Password' OR Attribute = 'Password' OR Attribute = 'Crypt-Password'
) ORDER BY Attribute DESC'
query: SELECT Value,Attribute FROM radcheck WHERE UserName = 'dyego' AND ( Attribute
= 'User-Password' OR Attribute = 'Password' OR Attribute = 'Crypt-Password' ) ORDER BY
Attribute DESC
rlm_sql: Released sql socket id: 0
modcall[authorize]: module "sql" returns ok
modcall: group authorize returns ok
auth: type Local
auth: Failed to validate the user.
Login incorrect: [dyego/\302\004F\247\244\221\274E\031+\241\371\350\004\337\347] (from
client localhost port 0)
WARNING: Unprintable characters in the password. ? Double-check the shared secret
on the server and the NAS!
Delaying request 4 for 1 seconds
Finished request 4
Going to the next request
The Attribute field is 'User-Password' and the value is '123'
-------------------------------------------------------------------------
++ Dyego Souza do Carmo ++ Dep. Desenvolvimento
-------------------------------------------------------------------------
E S C R I B A I N F O R M A T I C A
-------------------------------------------------------------------------
The only stupid question is the unasked one (somewhere in Linux's HowTo)
Linux registred user : #230601
--
$ look into "my eyes"
look: cannot open my eyes
-------------------------------------------------------------------------
Reply: [EMAIL PROTECTED]
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
