Personal tools
You are here: Home → GRIA Documentation → Documentation 5.1 → Reference Manuals → OGSA-DAI User Guide → GRIA OGSA-DAI Service → Database Server Configuration
 

3.3. Database Server Configuration

Up one level
Instructions on setting up MySQL or PostgreSQL for use with the GRIA OGSA-DAI Service

Database Server Configuration

These instructions are of relevance to users who want to use the GRIA OGSA-DAI service with MySQL or PostgreSQL back-ends (and for other RDBMS). If you have a different database back-end, please see the service developers' guide.

Database Drivers

Before configuring your database server(s) on the OGSA-DAI service you must install the correct JDBC driver(s) into the webapp. The JDBC drivers must be placed into library directory of the GRIA OGSA-DAI service webapp:
<path to Tomcat>/webapps/gria-ogsadai-service/WEB-INF/lib
Instructions are provided here for MySQL and PostgreSQL, but other drivers may also be used.

Installing the MySQL driver

  1. Download the MySQL JDBC connecter from the homepage: http://www.mysql.com/products/connector/j/
  2. Extract the .jar file from the downloaded package (eg. mysql-connector-java-3.1.13-bin.jar)
  3. Copy the .jar to the webapp lib directory.

Installing the PostgreSQL driver

  1. Download the PostgreSQL JDBC driver from the homepage: http://jdbc.postgresql.org
  2. Copy the downloaded .jar to the webapp lib directory.

Note that users of PostgreSQL need to follow special instructions when creating new tables in databases created by the OGSA-DAI service.

The Configuration Tool

After installing the GRIA OGSA-DAI service and performing the initial service configuration, you will be asked to perform the database configuration. This involves giving details of the database server on which you want new databases and users to be created.

The database configuration tool is accessed by clicking the "OGSA-DAI Service" link on the service webpage, located at http://<servername>:8080/gria-ogsadai-service.

A screenshot of the form used to enter the database details is shown below:

Database Details

The Database type and Database URL fields provide the type and address of the database server. The server specified here is used when a user requests the creation of a new database.

The Database URL field should contain the JDBC URL of the database server. This JDBC URL should not contain a database name, and should be of the following format:

  • jdbc:mysql://host[:port]/
  • jdbc:postgresql://host[:port]/

The System database field specifies which database on the RDBMS to connect to when adding/removing databases and users.

The Database credentials fields should give the username and password of a database user who has permission to create and drop databases and users.

Username Details

If the GRIA OGSA-DAI service is used to create new databases it will also create three database users with appropriate permissions. The "Username prefix" field give you the opportunity to customise the naming scheme used for these automatically generated users.

Usernames are assembled as follows:
<prefix><unique number><suffix>

The suffix is defined elsewhere.

Next: Access Control Previous: Installation