Unable to authenticate freeradius using PostgreSQL

[Kevin Bonner]

On Tuesday 28 November 2006 11:53, Ross McOwat wrote:
> Hi Kevin,
>
> I am running debug with the -X flag - in this instance, I only included
> the output I thought relevant (probably a mistake).  Complete output
> from the radius authentication request (with 3 attempts set) is as
> follows:
>
> radius_xlat:  'ROSStest4'
> rlm_sql (sql): sql_set_user escaped user --> 'ROSStest4'
> radius_xlat:  ''
> rlm_sql (sql): Reserving sql socket id: 4
> rlm_sql (sql): SQL query error; rejecting user
> rlm_sql (sql): Released sql socket id: 4
>   modcall[authorize]: module "sql" returns fail for request 0

My guess is that you have an empty SQL query which is causing this to fail.  
Are any queries blank in your rlm_sql section of the debug output?  Can you 
post the config dump in debug mode, or perhaps just the rlm_sql config 
section?

Kevin Bonner
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20061128/7ad051a8/attachment.pgp>