Peter Nixon [Fri, Jul 13, 2007 at 02:25:37PM +0300]:
On Fri 13 Jul 2007, Nico Schottelius wrote:
Peter Nixon [Fri, Jul 13, 2007 at 12:57:32PM +0300]:
On Fri 13 Jul 2007, Nico Schottelius wrote:
So, perhaps the port is broken.
Yep
Ok, will contact the fbsd maintainer for it.
I attached pg_dump -s -U pgsql radius from the new server that imported the old schema.
Can you also post the error messages for the queries that are failing.
I've only the following messages, as I've tested it with switching our router to use this raidiusd and switched back after some seconds of seeing problems. This is truely not the best test method, perhaps you can recommened some better one to me, so I can test all features and possible problems before? So, here are the errors: -------------------------------------------------------------------------------- radius_xlat: '/var/log/radius/sqltrace.sql' rlm_sql (sql): Reserving sql socket id: 0 rlm_sql_postgresql: query: INSERT into "radacct" ??("AcctSessionId", "AcctUniqueId", "UserName", "Realm", "NASIPAddress", "NASPortId", "NASPortType", "AcctStartTime", "AcctAuthentic", ??"ConnectInfo_start", "CalledStationId", "CallingStationId", "ServiceType", "FramedProtocol", "FramedIPAddress", "AcctStartDelay", "XAscendSessionSvrKey") ??values('000001EA', '1f8e637fb0a07662', 'chdsysa8', '', '62.65.128.149', ??'2', 'Virtual', ('2007-07-11 17:17:45'::timestamp - '0'::interval), 'Local', '', ??'', '62.65.128.15', 'NAS-Prompt-User', '', ??NULLIF('', '')::inet, '0', '') 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): Attempting to connect rlm_sql_postgresql #0 rlm_sql (sql): Connected new DB handle, #0 rlm_sql_postgresql: query: INSERT into "radacct" ??("AcctSessionId", "AcctUniqueId", "UserName", "Realm", "NASIPAddress", "NASPortId", "NASPortType", "AcctStartTime", "AcctAuthentic", ??"ConnectInfo_start", "CalledStationId", "CallingStationId", "ServiceType", "FramedProtocol", "FramedIPAddress", "AcctStartDelay", "XAscendSessionSvrKey") ??values('000001EA', '1f8e637fb0a07662', 'chdsysa8', '', '62.65.128.149', ??'2', 'Virtual', ('2007-07-11 17:17:45'::timestamp - '0'::interval), 'Local', '', ??'', '62.65.128.15', 'NAS-Prompt-User', '', ??NULLIF('', '')::inet, '0', '') 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: column "XAscendSessionSvrKey" of relation "radacct" does not exist radius_xlat: 'UPDATE "radacct" ??SET "AcctStartTime" = ('2007-07-11 17:17:45'::timestamp - '0'::interval), "AcctStartDelay" = '0', ??"ConnectInfo_start" = '' WHERE "AcctSessionId" = '000001EA' AND "UserName" = 'chdsysa8' ??AND "NASIPAddress" = '62.65.128.149' AND "AcctStopTime" IS NULL' radius_xlat: '/var/log/radius/sqltrace.sql' rlm_sql_postgresql: query: UPDATE "radacct" ??SET "AcctStartTime" = ('2007-07-11 17:17:45'::timestamp - '0'::interval), "AcctStartDelay" = '0', ??"ConnectInfo_start" = '' WHERE "AcctSessionId" = '000001EA' AND "UserName" = 'chdsysa8' ??AND "NASIPAddress" = '62.65.128.149' AND "AcctStopTime" IS NULL rlm_sql_postgresql: Status: PGRES_COMMAND_OK rlm_sql_postgresql: affected rows = 0 rlm_sql (sql): Released sql socket id: 0 modcall[accounting]: module "sql" returns ok for request 4 modcall: leaving group accounting (returns ok) for request 4 Sending Accounting-Response of id 232 to 62.65.128.149 port 1646 Finished request 4 Going to the next request --- Walking the entire request list --- Waking up in 6 seconds... --- Walking the entire request list --- Cleaning up request 4 ID 232 with timestamp 4694f499 Nothing to do. Sleeping until we see a request. --------------------------------------------------------------------------------
The schema has changed quite a bit since those days, AND you have converted from MySQL so almost your entire schema is currently non-default.
Well, I could easily migrate again, if there's a better way to extract data from mysql and insert into a clean postgres-structure. Nico -- Think about Free and Open Source Software (FOSS). http://nico.schottelius.org/documentations/foss/the-term-foss/ PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C