Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-20 Thread Peter Nixon
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 b

Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-20 Thread Nico -telmich- Schottelius
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

Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-13 Thread Peter Nixon
On Fri 13 Jul 2007, Peter Nixon wrote: > 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: > > > > Hello! > > > > > > > > I tried to move our current freeradius 0.9.3 with mysql to a new > > > > mac

Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-13 Thread 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

Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-13 Thread Peter Nixon
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: > > > Hello! > > > > > > I tried to move our current freeradius 0.9.3 with mysql to a new > > > machine running either 1.1.3 or 1.1.6 with postgresql. >

Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-13 Thread Nico Schottelius
Peter Nixon [Fri, Jul 13, 2007 at 12:57:32PM +0300]: > On Fri 13 Jul 2007, Nico Schottelius wrote: > > Hello! > > > > I tried to move our current freeradius 0.9.3 with mysql to a new machine > > running either 1.1.3 or 1.1.6 with postgresql. > > > > Converting the data was no big deal. > > > > But

Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-13 Thread Peter Nixon
On Fri 13 Jul 2007, Nico Schottelius wrote: > Hello! > > I tried to move our current freeradius 0.9.3 with mysql to a new machine > running either 1.1.3 or 1.1.6 with postgresql. > > Converting the data was no big deal. > > But then I recognized that the sql.conf has wrong quoting for postgresql >

Re: Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-13 Thread tnt
Check against the current schema: http://wiki.freeradius.org/Postgres_DDL_script Ivan Kalik Kalik Informatika ISP Dana 13/7/2007, "Nico Schottelius" <[EMAIL PROTECTED]> piše: >Hello! > >I tried to move our current freeradius 0.9.3 with mysql to a new machine >running either 1.1.3 or 1.1.6 with

Upgrading from 0.9.3 to 1.1.3 or 1.1.6

2007-07-13 Thread Nico Schottelius
Hello! I tried to move our current freeradius 0.9.3 with mysql to a new machine running either 1.1.3 or 1.1.6 with postgresql. Converting the data was no big deal. But then I recognized that the sql.conf has wrong quoting for postgresql (was mysql specific). Corrected that. But now I've another