Setting up your Database

Celoxis requires a database to store data. The database must be configured before you start the installation process. Sample instructions for each software is given below. Instructions are based on the default settings and often vary from version to version and from platform to platform. It is not feasible for us to cover all cases so please consult your database administrator for any setup, security or performance questions. Creating and configuring databases is beyond the scope of our support services.

In a nutshell, Celoxis needs a database instance and a privileged database user account that create, query, modify, and delete tables, indices, constraints, etc. and their definitions. We recommend that you do not share the database instance and this database with any other application.

  1. Allow Postgresql to accept TCP/IP connections:
    1. Open postgresql.conf. On Linux, you can find it most likely in /var/lib/pgsql/data while on Microsoft Windows, it is easily accessible from pgAdmin ▸ File ▸ postgresql.conf.
    2. Uncomment the line (if not already) listen_addresses = '*' i.e. it should not have # as the prefix.
    3. Save the file and exit.
  2. Allow connections from your local network:
    1. Open pg_hba.conf On Linux, you can find it most likely in /var/lib/pgsql/data while on Microsoft Windows, it is easily accessible from pgAdmin ▸ File ▸ pg_hba.conf.

    2. Assuming your network address is 192.168.0.0 and network mask is 255.255.255.0, add the following lines to that file. If Celoxis will be running on the same server as your Postgresql server, then you only need the first line below.

      local all all trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 192.168.0.0 255.255.255.0 trust
    3. Save the file and exit.
    4. Restart Postgresql. (On Linux, run: sudo service postgresql restart, while on Microsoft Windows choose Stop service and then Start service from All Programs > Postgresql

  3. Create a database user with name celoxis with a password. Note this down, you will be asked for this during installation.

    Use the createuser command as shown below:

    $ createuser celoxis
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
CREATE ROLE
$
    1. Open pgAdmin.
    2. Expand the appropriate PostgreSQL server node.
    3. Right-click Login/Group Roles and select Create > Login/Group Role.
    4. In the Généralités tab, enter the role name as: celoxis
    5. In the Definition tab, enter and confirm a password.
    6. Note down the username and password, as they will be required during the Celoxis installation.
    7. Ensure that the Account Expires field is empty.
    8. Go to the Privileges tab.
    9. Enable the following options:
      • Can login?
      • Superuser
    10. Click Save.

  4. Create a database with UNICODE character encoding with celoxis as its owner. The database name should be the same as specified in your license request.

    Use the createdb command as shown below:

    $ createdb -E UNICODE -U celoxis celoxis
CREATE DATABASE
$
    1. Open pgAdmin.
    2. Expand the appropriate PostgreSQL server node.
    3. Right-click Databases and select Create > Database.
    4. Enter the database name exactly as specified in your Celoxis License Request.
    5. From the Owner dropdown, select: celoxis
    6. Go to the Definition tab.
    7. Set Encoding to: UTF8
    8. Click Save to create the database.
Enable TCP/IP for SQL Server
  1. Open SQL Server Configuration Manager from the Windows Start Menu.
  2. Navigate to: SQL Server Network Configuration > Protocols for SQLEXPRESS
  3. Right-click TCP/IP and select Enable.
Restart the SQL Server Service
  1. From the Windows Start Menu, search for Services.
  2. Open the Services application.
  3. Scroll down and locate: SQL Server (SQLEXPRESS)
  4. Right-click the service and select Restart.
Create a Database User
  1. Open SQL Server Management Studio.
  2. Connect to your SQL Server Database Engine.
  3. In Object Explorer, expand the server and right-click Security.
  4. Select New > Login.
  5. Enter the login name as: celoxis
  6. Select SQL Server authentication.
  7. Windows authentication should not be used for this database user.
  8. Enter and confirm a password.
  9. Note down the username and password, as they will be required during the Celoxis installation.
  10. Uncheck Enforce password policy.
  11. Click OK to create the login.
Create the Database
  1. In SQL Server Management Studio, right-click Databases.
  2. Select New Database.
  3. Enter the database name exactly as specified in your Celoxis License Request.
  4. Set the database owner to: celoxis
  5. Click Options in the left panel.
  6. From the Collation dropdown, select: Latin1_General_100_CI_AS
  7. Click OK to create the database.
  • Create a database with UTF8 character encoding. The database name should be the same as specified in your license request.
  • Create a database user. Grant this user all permissions on the database. Also, give this user unlimited quota for tablespace users.