RE: Unable to authenticate freeradius using PostgreSQL

2006-11-29 Thread Ross McOwat
as simple as that. -Original Message- From: [EMAIL PROTECTED] org [mailto:[EMAIL PROTECTED] eradius.org] On Behalf Of Alan DeKok Sent: 28 November 2006 16:53 To: FreeRadius users mailing list Subject: Re: Unable to authenticate freeradius using PostgreSQL Ross McOwat [EMAIL PROTECTED] wrote

RE: Unable to authenticate freeradius using PostgreSQL

2006-11-29 Thread Ross McOwat
PROTECTED] org [mailto:[EMAIL PROTECTED] eradius.org] On Behalf Of Ross McOwat Sent: 29 November 2006 10:53 To: FreeRadius users mailing list Subject: RE: Unable to authenticate freeradius using PostgreSQL OK, I've made progress. I now appear to be connecting to my Postgres database, as I'm

Re: Unable to authenticate freeradius using PostgreSQL

2006-11-29 Thread Kevin Bonner
On Wednesday 29 November 2006 05:52, Ross McOwat wrote: radius_xlat: 'SELECT id, UserName, Attribute, Value, Op #?authorize_check_query = ' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql_postgresql: query: SELECT id, UserName, Attribute, Value, Op #?authorize_check_query =

RE: Unable to authenticate freeradius using PostgreSQL

2006-11-29 Thread Ross McOwat
] eradius.org] On Behalf Of Kevin Bonner Sent: 29 November 2006 16:16 To: FreeRadius users mailing list Subject: Re: Unable to authenticate freeradius using PostgreSQL On Wednesday 29 November 2006 05:52, Ross McOwat wrote: radius_xlat: 'SELECT id, UserName, Attribute, Value, Op

Re: Unable to authenticate freeradius using PostgreSQL

2006-11-29 Thread Kevin Bonner
On Wednesday 29 November 2006 10:36, Ross McOwat wrote: All sorted! I copied a fresh-install postgresql.conf file from another server, and bingo, all is working fine. Must have made a mistake while editing this file - note to self, make copies of the file BEFORE editing it! Thanks for

Re: Unable to authenticate freeradius using PostgreSQL

2006-11-28 Thread Kevin Bonner
On Tuesday 28 November 2006 11:00, Ross McOwat wrote: Other tables are empty. Running freeradius in debug mode, the following output is given when attempting an authentication request using NTRadPing: That output is very brief for debug mode. You are using the -X flag, right? If not, do so

RE: Unable to authenticate freeradius using PostgreSQL

2006-11-28 Thread Ross McOwat
is starting to hurt now! Ross -Original Message- From: [EMAIL PROTECTED] org [mailto:[EMAIL PROTECTED] eradius.org] On Behalf Of Kevin Bonner Sent: 28 November 2006 16:40 To: FreeRadius users mailing list Subject: Re: Unable to authenticate freeradius using PostgreSQL On Tuesday 28

Re: Unable to authenticate freeradius using PostgreSQL

2006-11-28 Thread Alan DeKok
Ross McOwat [EMAIL PROTECTED] 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

Re: Unable to authenticate freeradius using PostgreSQL

2006-11-28 Thread 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: