----- Original Message -----
From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 23, 2002 1:56 PM
Subject: a bug or a problem ?
I´m using freeradius server 0.7 and mysql
The SQL Connection is OK !
but on /usr/local/radiusd/bin/radtest dyego 123 localhost 0 nervermind
the debug says:
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: 2
query: SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username =
'dyego' ORDER BY id
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.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,radgroupche
ck.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,radgrouprep
ly.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,radgrouprep
ly.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
rlm_sql: Pairs do not match [dyego]
rlm_sql: Released sql socket id: 2
modcall[authorize]: module "sql" returns notfound
modcall: group authorize returns ok
auth: No authenticate method (Auth-Type) configuration found for the
request: Rejecting the user
auth: Failed to validate the user.
The error is :
rlm_sql: check items
Password = "123"
rlm_sql: reply items
rlm_sql: Pairs do not match [dyego]
In SQL database i insert :
insert into usergroup (username,groupname) values ('dyego','geral');
insert into radcheck (username,attribute,value) values
('dyego','Password','123');
is it a bug ? or configuration problem ?
-------------------------------------------------------------------------
++ 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
