Re: Unable to authenticate freeradius using PostgreSQL

["Alan DeKok" <aland@deployingradius.com>]

"Ross McOwat" <ross.mcowat@first-utility.com> wrote:
> 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

  It looks like you haven't configured the SQL queries needed by the
server.  The "radius_xlat" line SHOULD be printing out the query it's
going to use.

  The default postgresql.conf has queries that work for Postgres.  Are
you using those, or have you edited the file?

  Alan DeKok.
--
  http://deployingradius.com       - The web site of the book
  http://deployingradius.com/blog/ - The blog