SQL query error; rejecting user

Daniel Sandulescu daniel at sandulescu.ro
Mon Oct 11 15:38:05 CEST 2010


I upgraded to version 2.1.10 and now I have this erroare:

rad_recv: Access-Request packet from host 127.0.0.1 port 48934, id=235, 
length=116
        Service-Type = Framed-User
        Framed-Protocol = PPP
        User-Name = "phlander"
        CHAP-Challenge = 0x697c26c79cb6f40f57fbbbddb6bc63d8e805ee6a9b75
        CHAP-Password = 0x8c0a8927b6df3d0ac0c6f0cc6444b19ed9
        Calling-Station-Id = "00:42:15:11:24:57"
        NAS-IP-Address = 10.0.0.1
        NAS-Port = 0
# Executing section authorize from file /usr/local/etc/raddb/radiusd.conf
+- entering group authorize {...}
[chap] Setting 'Auth-Type := CHAP'
++[chap] returns ok
++[mschap] returns noop
rlm_sql (sql): Reserving sql socket id: 1
[sql]   expand:  ->
[sql] Error generating query; rejecting user
rlm_sql (sql): Released sql socket id: 1
++[sql] returns fail
Delaying reject of request 3 for 1 seconds
Going to the next request
Waking up in 0.9 seconds.
Sending delayed reject for request 3
Sending Access-Reject of id 235 to 127.0.0.1 port 48934
Waking up in 4.9 seconds.
Cleaning up request 3 ID 235 with timestamp +164
Ready to process requests.




----- Original Message ----- 
From: "Alan DeKok" <aland at deployingradius.com>
To: "FreeRadius users mailing list" <freeradius-users at lists.freeradius.org>
Sent: Monday, October 11, 2010 3:21 PM
Subject: Re: SQL query error; rejecting user


> Daniel Sandulescu wrote:
>>
>> Hello!
>> I got a erroarea following logging and do not know where to look.
>> Can someone ajunte me?
>
>  It means you've edited the default configuration, and broken it.
>
>>   modcall[authorize]: module "mschap" returns noop for request 0
>> radius_xlat:  ''
>
>  i.e. the SQL query is empty.  It shouldn't be empty.
>
>  You're also running 1.1.x.  I *strongly* suggest upgrading to 2.1.10,
> which was released last week.
>
>  Alan DeKok.
> -
> List info/subscribe/unsubscribe? See 
> http://www.freeradius.org/list/users.html
> 




More information about the Freeradius-Users mailing list