Upgrading from 0.9.3 to 1.1.3 or 1.1.6

[Nico -telmich- Schottelius]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20070713/97cdbde8/attachment.pgp>