Unable to authenticate freeradius using PostgreSQL

Alan DeKok aland at deployingradius.com
Tue Nov 28 17:52:56 CET 2006


"Ross McOwat" <ross.mcowat at 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



More information about the Freeradius-Users mailing list