Page History

By default, Fedora comes configured to write binary resources (i.e. files) to the file system and RDF resources (i.e. objects) to a LevelDB database. It is often desirable to replace the LevelDB database with a different object store. As of 2016-03-04, the configuration for MySQL or PostgreSQL databases are available within the deployable Fedora war file.  Below For testing, a file-based objects database may be useful. However, for production installations, it is recommended to use a MySQL or PostgresSQL object store. Below are the steps to use MySQL or PostgreSQL instead of LevelDB.

MySQL

1. Install an instance of MySQL and create a database user account

2. Run Fedora with the following JAVA_OPTS:

   Code Block
   JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.modeshape.configuration=classpath:/config/jdbc-mysql/repository.json" JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.mysql.username=<username>" JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.mysql.password=<password>" JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.mysql.host=<default=localhost>" JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.mysql.port=<default=3306>"

   
   

Note, the fcrepo database must be manually created, the database and table used by ISPN are auto-but the tables will be automatically created.

PostgreSQL

1. Install PostgreSQL and create a database called ispn and fcrepo and a user account that can access it
2. Run Fedora with the following JAVA_OPTS:

JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.modeshape.configuration=classpath:/config/jdbc-postgresql/repository.json"
JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.postgresql.username=<username>"
JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.postgresql.password=<password>"
JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.postgresql.host=<default=localhost>"
JAVA_OPTS="${JAVA_OPTS} -Dfcrepo.postgresql.port=<default=5432>"

Note, the ispnfcrepo database must be manually created, but the tables will be automatically created.

JNDI Configuration

For both of the configurations above, you may alternatively use JNDI to connect to the MySQL or PostgreSQL databases.

...

<jdbc:data-source jndi-url="java:comp/env/jdbc/ispn"/>

Modeshape 5.x

Databases tested with the experimental Modeshape 5.0 branch:

• MySQL 5.5.49
• PostgreSQL 9.4 - 9.5

Database Setup

PostgreSQL

To create a new database and user in PostgreSQL, assuming a username of user1 and a password of xyz:

$ sudo -u postgres psql
> create database fcrepo;
> create user user1;
> alter user user1 password 'xyz';
> grant all privileges on database fcrepo to user1;
> \q