Try removing your racheck for attribute 'Auth-Type'
Specifing a Password as an attribute in the sql db
'kinda' defaults auth-type to local unless you also
put things in the DEFAILT entry in the users file.
Rob
On Sunday 05 August 2001 09:56, you wrote:
> 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
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
