Hi,i had a error with sql(freeradius-0.2,oracle).
select * from radcheck;
ID USERNAME ATTRIBUTE VALUE
10 lsz Auth-Type Local
11 lsz Password l1198001
select * from radreply;
ID USERNAME ATTRIBUTE VALUE
5 lsz Service-Type Framed-User
MESSAGES
[root@localhost sbin]# ./radiusd -x
Starting - reading configuration files ...
Module: Loaded SQL
rlm_sql: Driver rlm_sql_oracle loaded and linked
rlm_sql: Attempting to connect to [EMAIL PROTECTED]:/cdoa
rlm_sql: Connected new DB handle, #0
rlm_sql: Connected new DB handle, #1
rlm_sql: Connected new DB handle, #2
rlm_sql: Connected new DB handle, #3
rlm_sql: Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded realm
Module: Instantiated realm (suffix)
Module: Loaded files
Module: Instantiated files (files)
Module: Loaded preprocess
Module: Instantiated preprocess (preprocess)
Module: Loaded detail
Module: Instantiated detail (detail)
Module: Loaded System
Module: Instantiated unix (unix)
Module: Loaded radutmp
Module: Instantiated radutmp (radutmp)
Initializing the thread pool...
Listening on IP address *, ports 1812/udp and 1813/udp.
Ready to process requests.
rad_recv: Access-Request packet from host 10.99.10.12:1371, id=193, length=61
User-Name = "lsz"
Password = "Z\372Y\317\t\210\204\220\260\307+X\245\341MG"
Service-Type = Authenticate-Only
NAS-IP-Address = 10.99.10.12
NAS-Port = 0
rlm_sql: Reserving sql socket id: 4
SELECT id,UserName,Attribute,Value FROM radcheck WHERE Username = 'lsz' ORDER Bd
Auth-Type = Local
Auth-Type = Local
Password = "l1198001"
SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroud
SELECT id,UserName,Attribute,Value FROM radreply WHERE Username = 'lsz' ORDER Bd
Service-Type = Framed-User
SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroud
rlm_sql: Released sql socket id: 4
rlm_sql: Pairs do not match [lsz]
Sending Access-Reject of id 193 to 10.99.10.12:1371
-------------------------------
��ע�����ʣ��ֻ�������
http://enterprise.21cn.com/game/
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
