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 pgAdminFilepostgresql.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 pgAdminFilepg_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 program.
    2. Open the appropriate server node for this database.
    3. Right click Login Roles and choose New Login Role...
    4. Enter celoxis as the name and optionally enter a password. Ensure that Account expires is empty.
    5. Select the Can create database objects option from Role Privileges.
    6. Click OK.
  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 program.
    2. Open the appropriate server node for this database.
    3. Right click on the Databases node and choose New Database...
    4. Enter the correct database name, pick celoxis as the owner and choose UTF-8 as the encoding.
    5. Click OK.

To create a database and a database user, you need to login as sa (the database administrator user).

Enable TCP/IP
  1. Go to Microsoft SQL Server from your Start programs menu and open Configuration Tools > SQL Server Configuration Manager.
  2. Select the node SQL Server Network Configuration > Protocols for MSSQLSERVER
  3. Right-click on the TCP/IP node and select Enable
  4. Restart the SQL Server service (Right click on SQL Server from the SQL Server Services and click Restart)
Create a database
  1. Open the SQL Server Management Studio.
  2. Right click the Database node and click New Database...
  3. Enter the same database name as specified in your license request.
  4. Select celoxis as the owner.
  5. Choose SQL_Latin1_General_CP1_CI_AS as the Collation (available from the Options page on the left)
  6. Click OK.
Create a database user
  1. Right click on the Security node of the database created and click New > Login.
  2. Enter login name as celoxias.
  3. Choose SQL server authentication. Windows authentication will not work.
  4. Enter a password. Note the user name and password down as you will be asked for this later during installation.
  5. Uncheck the Enforce password policy.
  6. Click OK.
  • 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.