RAdmin migration instructions

This document provides instructions on how to migrate from earlier versions of RAdmin to the current one.

Caution!

We recommend that you back up your Radmin database before migrating.

 

Version 1.15, 1.16, 1.17 or 1.18 to 1.19

Version 1.19 includes one new permission in the database to control setting the static password (PIN) on Digipass tokens

  • Unpack the new 1.19 distribution into a work area.
  • Copy Sql.pm from Radmin/Sql.pm in your old distribution to Radmin/Sql.pm in your new 1.19 distribution.
  • Copy Paths.pm from Radmin/Paths.pm in your old distribution to Radmin/Paths.pm in your new 1.19 distribution.
  • Run perl createdb.pl goodies/upgrade-1.18-1.19.dat
  • As root, run perl install.pl -d -n -v This will do a dry-run and shows what installation would do. It allows you to verify that RAdmin files are installed to the same place on the web server as they were previously installed.
  • As root, run perl install.pl -d This will install the RAdmin files to the same place on the web server as they were previously installed.
  • The above procedures will establish one new permission for setting static password (PIN) for Digipass tokens for the admin profiles Everything and Staff. Check that the permissions for your admin profiles are as as required.
Version 1.13 or 1.14 to 1.15

Version 1.15 adds 6 new pages, 3 new tables and 3 new configuration parameters for supporting unusual requirements and a schema changes for database tables which allow longer usernames and passwords and new password hash functions. The new RADCOMMANDAUDIT table can be used to record Tacacs commands executed by opertors on Tacacs capable routers. The RADGROUPAUTH table can be used to store User Group/Device Group authorisation rules. At present, only listing of these tables is supported, not editing. The new RADOATH table is used for storing OATH tokens which can be used for OTP or two-factor authentication.

  • Unpack the new 1.15 distribution into a work area.
  • Copy Sql.pm from Radmin/Sql.pm in your 1.13 or 1.14 distribution to Radmin/Sql.pm in your new 1.15 distribution.
  • Copy Paths.pm from Radmin/Paths.pm in your 1.13 or 1.14 distribution to Radmin/Paths.pm in your new 1.15 distribution.
  • Run perl createdb.pl -create RADCOMMANDAUDIT:RADGROUPAUTH:RADOATH goodies/upgrade-1.14-1.15.dat This will create the new tables without destroying any existing data.
  • Update the schema column definitions. This step is not necessary if you do not need to, for example, store long password hashes in RAdmin DB. Note: If you have local DB schema modifications, you must port these modifications to Radmin/Schema.pm. Be sure to upgrade all instances of this file to avoid destroying any data.
    • Run perl createdb.pl -dump > /tmp/radmin-database-dump.dat This will dump data from RAdmin database into a temporary file which will be used to import data back to the database after the schema update.
    • Run perl createdb.pl -create -dropfirst /tmp/radmin-database-dump.dat. This will drop and recreate database tables with an updated schema and import data back to the database. After running the command, the temporary file should be deleted by running a command rm /tmp/radmin-database-dump.dat
  • As root, run perl install.pl -d. This will reinstall the RAdmin files to the same place on the web server as they were previously installed.
Version 1.12 to 1.13

Version 1.13 adds one new table and 1 new configuration parameter for supporting Yubikey tokens. There are several new private cgi-bin scripts.

  • Unpack the new 1.13 distribution into a work area.
  • Copy Sql.pm from Radmin/Sql.pm in your 1.12 distribution to Radmin/Sql.pm in your new 1.13 distribution.
  • Copy Paths.pm from Radmin/Paths.pm in your 1.12 distribution to Radmin/Paths.pm in your new 1.13 distribution.
  • Run perl createdb.pl -create RADYUBIKEY goodies/upgrade-1.12-1.13.dat This will create the new table without destroying any existing data.
  • As root, run perl install.pl -d This will reinstall the RAdmin files to the same place on the web server as they were previously installed.
Version 1.11 to 1.12

Version 1.12 adds one new table and 2 new configuration parameters for controlling RAdmin-authenticated Admin User sessions.

  • Unpack the new 1.12 distribution into a work area.
  • Copy Sql.pm from Radmin/Sql.pm in your 1.11 distribution to Radmin/Sql.pm in your new 1.12 distribution.
  • Copy Paths.pm from Radmin/Paths.pm in your 1.11 distribution to Radmin/Paths.pm in your new 1.12 distribution.
  • Run perl createdb.pl -create RADADMINSESSION goodies/upgrade-1.11-1.12.dat This will create the new table without destroying any existing data.
  • As root, run perl install.pl -d This will reinstall the RAdmin files to the same place on the web server as they were previously installed.
Version 1.10 to 1.11

Version 1.11 includes some new permissions in the database to control operations on Digipass tokens

  • Unpack the new 1.11 distribution into a work area.
  • Run perl createdb.pl goodies/upgrade-1.10-1.11.dat
  • As root, run perl install.pl -d This will install the RAdmin files to the same place on the web server as they were previously installed.
  • The above procedures will establish new permissions for administering Digipass tokens for the admin profiles Everything and Staff. Check that the permissions for your admin profiles are as as required.
Version 1.8 to Version 1.9

Version 1.9 adds 1 new table: RADDIGIPASS for managing VASCO Digipass tokens (www.vasco.com), and allocating tokens to users etc. Support for Digipass tokens is optional, but if you enable it, it requires the Authen::Digipass module, included with Raditor 3.10 or later.

  • Unpack the new 1.9 distribution into a work area.
  • Copy Sql.pm from Radmin/Sql.pm in your 1.8 distribution to Radmin/Sql.pm in your new 1.9 distribution.
  • Copy Paths.pm from Radmin/Paths.pm in your 1.8 distribution to Radmin/Paths.pm in your new 1.9 distribution.
  • Run perl createdb.pl -create RADDIGIPASS goodies/upgrade-1.8-1.9.dat This will create the new table without destroying any existing data.
  • As root, run perl install.pl -d This will reinstall the RAdmin files to the same place on the web server as they were previously installed.
Version 1.6 to Version 1.7

Version 1.7 adds 2 new tables: RADSQLRADIUS and RADSQLRADIUSINDIRECT for managing Realm-based and CLID-based proxying, using SQL lookups. It also adds some permissions for managing access to those tables.

  • Unpack the new 1.7 distribution into a work area.
  • Copy Sql.pm from Radmin/Sql.pm in your 1.6 distribution to Radmin/Sql.pm in your new 1.7 distribution.
  • Copy Paths.pm from Radmin/Paths.pm in your 1.6 distribution to Radmin/Paths.pm in your new 1.7 distribution.
  • Run perl createdb.pl -create RADSQLRADIUS:RADSQLRADIUSINDIRECT:RADMINCONFDESCS:RADMINCONFIG goodies/upgrade-1.6-1.7.dat This will create the new tables and permissions required by 1.7 without destroying any existing data.
  • As root, run perl install.pl -d This will reinstall the RAdmin files to the same place on the web server as they were previously installed.
  • The above procedures will add permission for accessing the new tables to the admin profile Everything.
Version 1.5 to Version 1.6

Version 1.6 includes some new tables to support the new permissions system and the new optional subscriptions system.

  • Unpack the new 1.6 distribution into a work area.
  • Copy Sql.pm from Radmin/Sql.pm in your 1.5 distribution to Radmin/Sql.pm in your new 1.6 distribution.
  • Copy Paths.pm from Radmin/Paths.pm in your 1.5 distribution to Radmin/Paths.pm in your new 1.6 distribution.
  • Run perl createdb.pl -create RADPERMISSIONS:RADPROFILEPERMISSIONS:RADPRODUCTS:RADSUBSCRIPTIONS:RADAUTHLOG basicdb.dat There will be some errors reported. Ignore these. This will create the new tables required by 1.6 and populate them, without destroying any existing data.
  • As root, run perl install.pl -d This will reinstall the RAdmin files to the same place on the web server as they were previously installed.
  • The above procedures will establish new permissions for the admin profiles Everything and Staff. Other admin profiles will now have _no_ permissions. Check that the permissions for your admin profiles are as as required.
Version 1.4 to Version 1.5

Version 1.5 included minor changes to some previously unused database tables. You can install the upgrade to version 1.5 without having to recreate your database with these commands executed as root in your RAdmin work directory:

  • perl install.pl
  • perl createdb.pl -create RADATTRS:RADVALUES -dropfirst radattrs.dat
  • copy goodies/AuthRADMIN.pm to your Radiator installation

These commands will leave your existing database untouched, but it will recreate and populate the previously unused tables RADATTRS and RADVALUES.

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:

  • cd to distribution directory of your current version
  • perl createdb.pl -dump >/tmp/radmin.dat
  • cd to distribution directory of your new version
  • follow full installation instructions for your new version
  • perl createdb.pl /tmp/radmin.dat