I turn on the sqltrace, it seems the queries are all right, but why I still
goet access-reject? Is there anyone can help? Thanks.
rad_recv: Access-Request packet from host 127.0.0.1:1025, id=76, length=55
User-Name = "test1"
Password = "g\013\227\202)\303\232YmB\034$\244\351\335v"
NAS-IP-Address = 255.255.255.255
NAS-Port-Id = "10"
rlm_sql: Reserving sql socket id: 4
SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'test1'
ORDER BY id
Password = "testpass"
SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupche
ck.Value FROM radgroupcheck,usergroup WHERE usergroup.Username = 'test1' AND
usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id
SELECT id,UserName,Attribute,Value FROM radreply WHERE Username = 'test1'
ORDER BY id
Reply-Message = "hello"
SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgrouprep
ly.Value FROM radgroupreply,usergroup WHERE usergroup.Username = 'test1' AND
usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id
rlm_sql: Released sql socket id: 4
Sending Access-Reject of id 76 to 127.0.0.1:1025
Reply-Message = "hello"
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Henry Su
Sent: Thursday, October 11, 2001 3:19 PM
To: [EMAIL PROTECTED]
Subject: RE: an oracle authentication questions...
Thanks Victor. I found the message:
http://lists.cistron.nl/pipermail/freeradius-users/2001-September/002196.htm
l, but it did not help, after I change the code and try it again.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Henry Su
Sent: Thursday, October 11, 2001 12:08 PM
To: [EMAIL PROTECTED]
Subject: RE: an oracle authentication questions...
Could you please be more specific, I could not find which thread it is.
Thanks.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of victor
Sent: Thursday, October 11, 2001 12:25 AM
To: [EMAIL PROTECTED]
Subject: Re: an oracle authentication questions...
It seems to be the problem with the garbage in the rows returned in rlm_sql
module.
read the September message archive (25.09.2001). There you can find some
useful info.
Vic
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
