Re: [RADIATOR] Migrating a Radiator+Radmin server

[Michael Bellears]

Ah - Just found one difference - NASTYPE appears to have been changed to 
NASENGINE in RADCLIENTLIST?

Found after running the error I received:

mysql> select NASIDENTIFIER,SECRET,DEFAULTREALM,NASTYPE,DUPINTERVAL from 
RADCLIENTLIST;
ERROR 1054 (42S22): Unknown column 'NASTYPE' in 'field list'





From: radiator-boun...@open.com.au [mailto:radiator-boun...@open.com.au] On 
Behalf Of Michael Bellears
Sent: Tuesday, 3 November 2015 7:06 PM
To: 'radiator@open.com.au'
Subject: [RADIATOR] Migrating a Radiator+Radmin server

Hi Everyone,

Migrating an old server -> New, and are having some issues with Radmin - Dump 
of the original mysql dbase, then import on the new server(After radiator and 
radmin install), Radmin works to an extent, but in some sections throws the 
following error:

A serious error has occurred:
Could not prepare and execute select 
NASIDENTIFIER,SECRET,DEFAULTREALM,NASTYPE,DUPINTERVAL from RADCLIENTLIST

But I can list all users, list service profiles etc - The "old" radmin version 
was 1.10, the new is 1.15 - Hoping there is a "simple" fix :)  (As I have 
looked at the table structure of RADCLIENTLIST on both the 1.10 ver and the 
1.15 version, and they "appear" the same.)


Cheers
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator

Re: [RADIATOR] Migrating a Radiator+Radmin server

[Heikki Vatiainen]

On 3.11.2015 11.13, Michael Bellears wrote:

> Ah – Just found one difference – NASTYPE appears to have been changed to
> NASENGINE in RADCLIENTLIST?

Hmm, are you sure this is not a local modification? I took a look at 
Radmin/Schema.pm and the only changes in RADCLIENTLIST seem to be 
related to lengths of some of the varchar type fields.

The migration instructions are here, but the changes are for different 
tokens and their management:

http://www.open.com.au/radmin/migration.html

Thanks,
Heikki

-- 
Heikki Vatiainen 

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.
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator

Re: [RADIATOR] Migrating a Radiator+Radmin server

[Heikki Vatiainen]

On 11/03/2015 11:13 PM, Michael Bellears wrote:
> Thanks - absolutely no mods herethe migration page does mention quite a 
> few mods to tables etcperhaps 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 

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.
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator

Re: [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 NASENGINEIm just in the process of reimporting (Post a more "accurate" 
find/replacefingers crossed all works ok :)

 



-Original Message-
From: Heikki Vatiainen [mailto:h...@open.com.au] 
Sent: Wednesday, 4 November 2015 7:55 AM
To: Michael Bellears; radiator@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 herethe migration page does mention quite a 
> few mods to tables etcperhaps 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 <h...@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.
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator