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