|
MySQL
Windows
Installing MySQL for Windows is very easy. You can get an
easy to use Windows installer from here
(you will need to scroll down the page a little).
After you have installed MySQL run winmysqladmin.exe in
order to start the database server. You will also need to create database view and tables
before you can use MySQL with Sirid.
Linux
First you should verify that you don't already have MySQL
installed. To do this write
mysqladmin
version
The required version of MySQL is
3.23.
If
you don't have a proper version of MySQL installed you can get
the installation packages from here.
We recommend getting at least the server and client program
rpm files. After you have downloaded the files you can
install them by typing
rpm -iv
<filename>.rpm
Note that you must be logged on
as root. Before you can install the rpm files you may have
to give yourself appropriate rights for them using the chmod
command. The rpm creates appropriate entries so that MySQL
is started automatically during system startup.
After you have installed the server and client
programs you can, if you want to, change the default password (which is
empty) using the mysql_setpermission command.
You will also need to create database view and tables
before you can use MySQL with Sirid.
Unix & other platforms
You can obtain an installation package for virtually any
platforms from here.
We don't currently provide installation instructions for
platforms other than Windows and Linux.
PostgreSQL
Windows
PostgreSQL can be installed using the Cygwin installer which
can be found from here. The installation is
not quite as straightforward as the MySQL installation.
Linux & Unix
You can obtain PostgreSQL installation packages from here.
Installation instructions are available here.
Creating database view and tables
MySQL
First you must open a new shell window (command prompt). Next
go to the MySQL bin directory (cd
<mysqldir>\bin) if the binaries are not in
system path (in which case you can write the following
commands in any directory). Then you can create a new
database view using the command
mysqladmin create sirid
or if you have changed the default password
mysqladmin -p create sirid
Next you must create appropriate database tables. In order
to do that you must first download the creation
script for MySQL.
Save the file to C:\ or /home/username (or any other
convenient location) depending on your
operating system. Next start the mysql tool by writing
mysql
(if you have changed the password write mysql
-p). This should start the tool. Next write
connect sirid
and finally write
\. C:\sirid_mysql.sql
or
\. /home/username/sirid_mysql.sql
Executing the above command should result several Query Ok
lines to be printed on the screen. Now you have done everything required to prepare
MySQL to be used with Sirid. You can type \q in
order to close the mysql tool.
PostgreSQL
First you must open a new shell window. Next go to the PostgreSQL
bin directory (cd
<postgresqldir>/bin) if the binaries are not in
system path (in which case you can write the following
commands in any directory). Then create a new database
by writing
createdb sirid
Next connect to the database by writing
psql sirid
Finally you must create appropriate database tables. In
order to do that you must first download the creation
script for PostgreSQL. Save the file to /home/username
(or any other convenient location). Then execute the script
by writing
\i /home/username/sirid_generic.sql
in the psql tool. Now you have done everything required to
prepare PostgreSQL to be used with Sirid. You can type
\q in order to close the psql tool.
Important note: The Linux/Unix installer installs
JDBC driver for PostgreSQL 7.1.x. If you have different
version you must replace <SiridDir>/JBoss/lib/ext/pgjdbc2.jar with the
correct version from this address: http://jdbc.postgresql.org/download.html
Oracle
The database creation script for Oracle is available here.
|
