Step 4: Create a Database for LXR

For performance reasons, LXR stores the references in a database. Presently, LXR cooperates with Postgresql, MySQL or Oracle, at your choice.

Creation

Database creation can only be done by a DB-user who has the privilege to create databases. Contact your site administrator if you can't or don't know how to proceed.

• Postgresql

  Create a user for LXR and give him the permission to create databases:

  $ createuser lxr

  Create a database for LXR:

  $ createdb -U lxr lxr
• MySQL

  Run MySQL as an administrator (often root) to create user lxr with right to create databases:

  $ mysql -u root -p Enter password: xxxx mysql> create user 'lxr'@'localhost' identified by 'lxrpassword'; mysql> exit It is more comfortable, less error-prone and requires less expertise to use phpMyAdmin to do that if you have it installed.
• Oracle

  There is no special step to create a database.

Configuration

DB table initialisation is done with interactive script initdb-config.sh. Default answer is shown uppercase. If it fits your need, just hit "return". Otherwise type your choice.

Notes:
1. In this example, the user accepted the default choices, which are adequate for the simple case of a single tree.
2. The user name must be the same as the one given above.
3. Remember your answers for database name, user and table prefix. They will be needed later.

If you answer yes, a DB table initialisation script is written in lxrconf.d/.

Multiple trees operation

Initialisation

The customised script is then processed by the database engine:

• Postgresql $ psql -U lxr lxr > \i lxrconf.d/initdb-postgres-custom.sql Just ignore the errors about unimplemented functions.
• MySQL $ mysql -u root -p < lxrconf.d/initdb-mysql-custom.sql Enter password: xxxx
• Oracle $ sqlplus SQL> @lxrconf.d/initdb-oracle-custom.sql;