[RADIATOR] Migrating a Radiator+Radmin server

[Michael Bellears]

I think I may have found the problem.

"older" version of SQL used:

'TYPE=MyISAM'

"new" version of SQL uses: 

ENGINE=MYISAM

On the "new" server, it complained about our old radmin dbase dump file, as it use "TYPE" - So, I did a find/replace of "TYPE" -> "ENGINE" - Unaware there was "other" lines that had "Type"...hence NASTYPE was changed by the find/replace to NASENGINE....Im just in the process of reimporting (Post a more "accurate" find/replace....fingers crossed all works ok :)

 



-----Original Message-----
From: Heikki Vatiainen [mailto:hvn at open.com.au] 
Sent: Wednesday, 4 November 2015 7:55 AM
To: Michael Bellears; radiator at open.com.au
Subject: Re: [RADIATOR] Migrating a Radiator+Radmin server

On 11/03/2015 11:13 PM, Michael Bellears wrote:
> Thanks - absolutely no mods here....the migration page does mention quite a few mods to tables etc....perhaps it was in an older upgrade?

I took a look at the older Radmin releases too and there's no NASENGINE there. Also, the latest version does not have NASENGINE either. Engine does remind me a bit of MySQL DB engines, though.

When upgrading you should step upgrade. Currently, AuthRADMIN.pm in Radiator and Radmin goodies directory are the same, so there's no need to copy them.

> What would be your suggestion be?

I would try doing step upgrade from 1.10. There appears to be no DB step between versions 1.13 and 1.14.

> Ie: It has an "other" version section:
> 
> Other versions
> In order to upgrade between any other versions, you will need to dump your current database, install the new software and then reload your old data:

I would not do this yet but try the steps first.

Thanks,
Heikki

--
Heikki Vatiainen <hvn at open.com.au>

Radiator: the most portable, flexible and configurable RADIUS server anywhere. SQL, proxy, DBM, files, LDAP, NIS+, password, NT, Emerald, Platypus, Freeside, TACACS+, PAM, external, Active Directory, EAP, TLS, TTLS, PEAP, TNC, WiMAX, RSA, Vasco, Yubikey, MOTP, HOTP, TOTP, DIAMETER etc. Full source on Unix, Windows, MacOSX, Solaris, VMS, NetWare etc.