Hi, I am attempting to use PostgreSQL 7.2.3 as a backend for FR 0.8. I have used MySQL before but have very little experience with PostgreSQL.
It looks like it connects just fine: rlm_sql (sql): Driver rlm_sql_postgresql (module rlm_sql_postgresql) loaded and linked rlm_sql (sql): Attempting to connect to radius@localhost:/radius rlm_sql (sql): starting 0 rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql (sql): starting 1 rlm_sql (sql): Attempting to connect rlm_sql_postgresql #1 rlm_sql (sql): Connected new DB handle, #1 rlm_sql (sql): starting 2 rlm_sql (sql): Attempting to connect rlm_sql_postgresql #2 rlm_sql (sql): Connected new DB handle, #2 rlm_sql (sql): starting 3 rlm_sql (sql): Attempting to connect rlm_sql_postgresql #3 rlm_sql (sql): Connected new DB handle, #3 rlm_sql (sql): starting 4 rlm_sql (sql): Attempting to connect rlm_sql_postgresql #4 rlm_sql (sql): Connected new DB handle, #4 Module: Instantiated sql (sql) but when I through a query at it: rlm_sql (sql): sql_set_user escaped user --> 'username' radius_xlat: 'SELECT id,UserName,Attribute,Value,Op FROM radcheck WHERE Usernam e = 'username' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 3 rlm_sql_postgresql: query: SELECT id,UserName,Attribute,Value,Op FROM radcheck W HERE Username = 'username' ORDER BY id rlm_sql_postgresql: PostgreSQL Query failed Error: no connection to the server rlm_sql_getvpdata: database query error rlm_sql (sql): SQL query error; rejecting user rlm_sql (sql): Released sql socket id: 3 modcall[authorize]: module "sql" returns fail This looks to me like the connection is being lost somewhere (or maybe not established). Obviously the username has been changed to protect the innocent. If I copy and paste the query into psql I get the expected results. I have read over the documentation, and the error that is being thrown looks like it is coming from the PostgreSQL library. I have even searched on google but didn't find the exact error that I am receiving. Any ideas? Michael ---------------------------------------------------------------------- Michael J. Hartwick, VE3SLQ [EMAIL PROTECTED] Hartwick Communications Consulting (519) 396-7719 Kincardine, ON, CA http://www.hartwick.com ---------------------------------------------------------------------- - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
