 |
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.
- Update Sirid to version 1.15 using the built-in Update tool
- Shut down Sirid (from Control Panel -> Administrator tools -> Services - not using the Shutdown Sirid -shortcut)
- 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.
- Move the database contents (database.txt) and
the attachments directory
(<SiridInstallDir>\jboss\bin\upload or
<SiridInstallDir>/jboss/bin/upload) away from the Sirid
directory
- 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).
- Download appropriate Sirid installer from here
and install it normally. Do not open Sirid in browser after
the installation is complete.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
|
 |