Hello Peter, Peter Nixon [Fri, Jul 13, 2007 at 02:40:09PM +0300]: > Just a quick tip to get you started as I have to head out and may not have a > chance to reply until tomorrow: > > ALTER TABLE radacct ALTER acctinputoctets TYPE bigint; > > and > > ALTER TABLE radacct ADD XAscendSessionSvrKey VARCHAR(10);
Thank you! I am for safety now checking all values and recognized
that the schema shipped with 1.1.6 for postgres seems to be broken:
XAscendSessionSvrKey VARCHAR(10), <-----|
FramedProtocol VARCHAR(32), |
FramedIPAddress INET, |
AcctStartDelay BIGINT, | duplicated!
AcctStopDelay BIGINT, |
XAscendSessionSvrKey VARCHAR(10) <-----|
I'll post a update script as soon as I'm finished.
> Just go though your schema line by line and compare with the one in
> doc/examples/postgresql.sql running either one of those 2 commands (with the
> correct datatype and column name) until your schema looks like the default
> one. You should not lose any data in the process, but its a good idea to
> have a backup of you table in any case.
yep, doing that. will tell you whether it worked or not (should) later.
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
signature.asc
Description: Digital signature
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
