Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

20 Jul 2007


      On Fri 20 Jul 2007, Nico -telmich- Schottelius wrote:
...
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.
Yes. I already fixed that in CVS. 1.1.7 should be out today.

-- 

Peter Nixon
http://peternixon.net/