Proble with an Accounting query
Try connecting to the postgresql database with the same user/pass and from the same host as freeradius. Check access rights to the database. -- Groeten, Regards, Salutations, Thor Spruyt M: +32 (0)475 67 22 65 E: thor.spruyt@telenet.be W: www.thor-spruyt.com www.salesguide.be www.telenethotspot.be ----- Original Message ----- From: Santiago Balaguer García To: freeradius-users@lists.freeradius.org Sent: Wednesday, July 20, 2005 7:37 PM Subject: Postgres problem I am migrating mu MySQL DB to Postgres. My authentication ios OK, but the accounting query insertion fails with the following error: rlm_sql_postgresql: Status: PGRES_FATAL_ERROR rlm_sql_postgresql: affected rows = rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning SQL_DOWN rlm_sql (sql): failed after re-connect rlm_sql (sql): Couldn't insert SQL accounting START record - ERROR: relation "radacct_radacctid_seq" does not exist I create all tables in the database RADIUS. Could you help me someone? Qué hacer en tu ciudad por la tarde y por la noche. No te lo pierdas en MSN Entretenimiento - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
participants (2)
-
Santiago Balaguer García -
Thor Spruyt