Thraex Software
Updating from Sirid 1.14 to 1.15

These instructions consern users who have initially installed Sirid version 1.14 or older.

Starting from version 1.15 Sirid uses JBoss 3.2.1 and Tomcat 4.1.24 instead of the old 2.4.10 and 3.2.4 versions. The new versions should provide better performance and support for newer standards (e.g. HTTP/1.1). The performance gain varies from 0 to 70 percent depending on the situation.

The standard Sirid update only updates the Sirid application, not the JBoss and Tomcat servers. For this reason, if you want to update JBoss and Tomcat, you will need to reinstall Sirid. These instructions guide you through the process of migrating your existing data into the new installation.
The actual Sirid application will continue to work also with the older versions of JBoss and Tomcat, so if you are satisfied with your system as it is now, there is no need to follow the instructions on this page.

  1. Update Sirid to version 1.15 using the built-in Update tool
  2. Shut down Sirid (from Control Panel -> Administrator tools -> Services - not using the Shutdown Sirid -shortcut)
  3. Backup the existing database contents: Execute <SiridInstallDir>\dump_db.bat (<SiridInstallDir>/dump_db.sh). This will create a file named DB_date_and_time.zip into the backup directory specified in sirid.conf (C:\Sirid\backup or /usr/sirid/backup by default). Extract database.txt from the zip.
  4. Move the database contents (database.txt) and the attachments directory (<SiridInstallDir>\jboss\bin\upload or <SiridInstallDir>/jboss/bin/upload) away from the Sirid directory
  5. If you're using Windows and you installed Sirid using the Windows installer, you will need to uninstall the old version of Sirid at this point. It is, however, recommended that you skip this step and install Sirid into some other machine following the instructions below to verify that the database contents can be successfully imported. After that you can repeat the following steps on the actual Sirid server machine.
    Users running Linux or using the "Linux / Unix installer" on Windows don't need to uninstall the old version, just make sure to install the new version into different directory if you continue without uninstalling.
    Rest of the instructions concern the new installation. Note especially that you should not erase the contents of the old Sirid database (at least not before you have verified that the database backup can be successfully imported).
  6. Download appropriate Sirid installer from here and install it normally. Do not open Sirid in browser after the installation is complete.
  7. Download database cleanup script from here. Store the file to C:\ (/home/root/). You can naturally save the file anywhere you wish but the instructions assume that the file is located in the preceding folder.
  8. After the installation is complete start correct SQL interpreter: In Windows open command prompt (cmd.exe) and type either
    c:\sirid\mysql\bin\mysql sirid
    or
    c:\sirid\psql\bin\psql sirid sirid
    depending on whether you installed MySQL or PostgreSQL.
  9. Type
    \. C:\cleanup.sql
    or
    \i C:\cleanup.sql
    depending on whether you're using MySQL (the former) or PostgreSQL (the latter). In Linux you should write either
    \. /home/root/cleanup.sql
    or
    \i /home/root/cleanup.sql
    respectively.
  10. Copy database.txt into C:\ (or /home/root/) and type
    \. C:\database.txt
    or
    \i C:\database.txt
    depending on whether you're using MySQL (the former) or PostgreSQL (the latter). In Linux you should write either
    \. /home/root/database.txt
    or
    \i /home/root/database.txt
    respectively. If everything goes well you should see a long list of "Query OK, 0 rows affected" or similar lines. If you see any errors please send email to support@thraexsoftware.com stating the error text and we will give further instructions.
  11. Move contents the attachments directory (upload) into <SiridInstallDir>\content\upload (<SiridInstallDir>/content/upload). The "content" and "upload" folders may not exist and you should create them in that case.
  12. All data should now have been successfully migrated into the new installation. You can now open Sirid in browser and verify that everything seems to be in order and that you can download the attachments.