UTM 5.3-001 upgrade to version 5.3-002 user manual

1. Stop all UTM5 system components (UTM5 core, UTM5 RADIUS server, UTM5 RFW, etc.)

2. Backup all the configuration files from /netup/utm5/

3. Make sure you have an up to date SQL database and detailed traffic information backup copies. If you don't have those backup copies, backup you SQL database (one might use e.g. mysqldump or pg_dump utilities) and make sure you can restore the database from that backup.

4. Uninstall the old version of UTM5
In GNU/Linux OS, using RPM use the following command:
rpm -e utm-5
If you are using FreeBSD, try:
pkg_delete utm5

5. Install the new version of UTM5
In GNU/Linux OS, using RPM try:
rpm -ihv --nodeps utm5-3.002.i386.rpm
In FreeBSD OS, use:
pkg_add utm5-3.002.tgz

6. Update the database structure
If you are using MySQL database, use the following command:
mysql -f UTM5 < /netup/utm5/UTM5_MYSQL_update.sql
If you are using PostgreSQL use:
psql -f /netup/utm5/UTM5_PG_update.sql -d UTM5

7. Update the database indexes
For MySQL database use:
mysql -f UTM5 < /netup/utm5/UTM5_indexes.sql
For PostgreSQL use:
psql -f /netup/utm5/UTM5_indexes.sql -d UTM5

Note! This operation might take A LOT of time. One might use table archiving before updating the database indexes to speedup the process.

8. When upgrading from build 5.3-001 or older, after unpacking the distributives, updating configuration files and the database structure (just before launching the UTM5 core for the first time), you have to convert the parameters of previously implemented service cost recalculation into the currently used charge policy parameters. This can be done with the automatic converter utility, which comes with the UTM5 distributives. Use the following command to launch the converter:

/netup/utm5/bin/block_conv -v old_version_of_UTM5
Where old_version_of_UTM5 is:
007 for version 5.2.1-007 and updates
008 for version 5.2.1-008 and updates
009 for version 5.2.1-009 and updates (default value)
5.3 for version 5.3-001 and updates (virtually the same as 009)

The converter will then show the conversion parameters and prompt for confirmation that those parameters are correct.

9. In case you want to use the utm5_dhcpd module you have to:
- renew the license (if you plan commercial use of the module, in other case the module will operate in demo mode)
- edit /netup/utm5/dhcpd5.cfg configuration file and add:
a) current UTM5 database access parameters
b) current UTM5 core access parameters (via Stream protocol)
c) list of network interfaces
- add a system user for the utm5_dhcpd service if needed. The default user is "dhcp", with password "dhcp", access is allowed from 127.0.0.1. This user is added only after initializing a new database.

10. Launch the UTM5 components (UTM5 core, UTM5 RADIUS, UTM5 RFW, etc.)