Installation of the Client Server Architecture

From OCAD 12 Wiki - English
Jump to: navigation, search

This function is only available in the OCAD Enterprise Edition.

Installation of the PostgreSQL Server

To use OCAD 12 Enterprise with the Client Server Module a database server is required. Therfore an installation of PostgreSQL with Version 9.1 or above is needed. On the PostgreSQL Download page binary packages for different plattforms can be found. http://www.postgresql.org/download/

PostgreSQL Server Setup

After downloading and installing the package the PostgreSQL Server must be configured to allow connections from your local area network or the internet. To enable this the file postgresql.conf in your data folder must be edited with your favorite editor.

The Value listen_addresses must be set to your local IP or * to listen to any IP on the system.

As a second step, your local network must be set to allow connections to the postgresql server. This is defined in the pg_hba.conf in your data folder. Also open this file with your favorite editor. To allow a certain network enter the following line:

host  all all 192.168.1.0/24  password

This allows all host on the network 192.168.1.0/24 (means all IP's with 192.168.1.1-192.168.1.254) are allowed to connect by password.

After all changes the PostgreSQL Service must be restarted. On a Windows system under Service manager on Linux with service postgresql-9.1 restart or /etc/init.d/postgresql-9.1 restart,on FreeBSD /etc/rc.d/postgresql-9.1 restart.

Installation in OCAD

After successfully installing the PostgreSQL server OCAD Cient Server Architecture Setup can be executed. In order do setup a new server the so called initial setup must be used. This creates the databases and users needed to connect to the PostgreSQL server with OCAD Enterprise.



Back to the Client Server Architecture page.