Follow these instructions to install Tornado on other database systems such as mySQL, PostgreSQL, DB2, Oracle, SQLServer etc
Tornado server uses ansi-92 standard SQL calls so should work fine with most ansi-92 standard databases.
Set up the database server
Follow the database manufacturers instructions to set up the server. Be sure to carefully note any usernames and passwords, along with any special setup if you need to access the server on a different host to where Tornado is running.
Install Tornado Server
Run the installer and install Tornado. This is usually done by double clicking the installer jar file, or typing 'java -jar TornadoServerInstall.jar' at the command prompt. Start Tornado server to ensure it works OK after the install. Note: this will be working with the internal hsqldb database.
JDBC
Get a copy of the JDBC driver software from the databse manufacturer and copy the jar file to the [tornado_install]/jdbc directory. Note some databases (eg DB2) may require some binary software installed on the host where Tornado will be running as well as the jar file.
Create the system database
Using the query tool that came with your database software (eg psql for postgres or msql for mysql) create a database called 'puakma' and tables as per the table definition. Table definition files are found in the config directory and are named datadef.xxsqlxx. There may not be the exact file for your platform there, so make changes as appropriate to get it working on your platform.
puakma.config
Next edit the [tornado_install]/config/puakma.config file and add the correct database settings, for example:
SystemDBURL=jdbc:mysql://localhost:3306/
SystemDriverClass=com.mysql.jdbc.Driver
SystemUser=dbuser
SystemPW=dbpassword
Locate the AddIns= line and remove 'puakma.addin.db.HSQLDB' from the list of addins to load at server startup. This will stop hsqldb internal database loading at server startup.
Populate the system database
Start a command prompt and change to the [tornado_install]/bin directory. Edit setupdb.bat with your jdbc driver settings, save and exit, then execute the batch file from the command prompt. This should populate the system tables from the .pmx files in the [tornado_install]/temp directory. At the same time it will create a SysAdmin user and password.
Start Tornado
Start Tornado Server in the usual way using [tornado_install]/bin/pmastart or from a menu shortcut. Start your web browser and go to http://yourserver/system/admin.pma. This should display a login screen where you can enter SysAdmin and the password to log in.
If you forgot the password, start the database query tool and clear the password from the SysAdmin user. "UPDATE PERSON SET Password='' WHERE Alias='SysAdmin'". Try to log in again using SysAdmin with no password. You can then set a new password in the /system/admin.pma by clicking on the "People" tab and editing the SysAdmin user.
