Categories

Attention: This configuration is intended for experienced users/system administrators. Currently, only PostgreSQL 12 is supported.

Postgres configuration

To connect Daminion to an existing PostgreSQL server, you need to allow network connections on the computer where PostgreSQL is installed.

To do this, add the server’s IP address to the postgres.conf configuration file.

The default paths to the postgres.conf and hba.conf files are as follows:
Windows: C:/ProgramData/PostgreSQL/Data/
Linux: /etc/postgresql/12/main/

Open postgres.conf:

#----------------------------------
# CONNECTIONS AND AUTHENTICATION
#----------------------------------

# - Connection Settings -
listen_addresses = '*' # what IP address(es) to listen on;

Change ‘*’ to the IP address of your PostgreSQL server, for example:

listen_addresses = '192.168.1.88' # what IP address(es) to listen on;

Save the file.

Now, you need to allow external access. To do this, add the following lines to the hba.conf configuration file:
# IPv4 local connections:

host all all 0.0.0.0/0 md5
host all all ::/0 md5

If you have trouble finding the path to the configuration file, you can connect to the database and execute the following queries:

SHOW "config_file";
SHOW "hba_file";

Restart the PostgreSQL server and try to connect from the command line:

psql -h 192.168.1.88 -U postgres

If it connects successfully, proceed further. If not, check your firewall settings.

Daminion Server configuration

Now, in the catalog configuration, you need to specify your PostgreSQL server.
To do this, stop Daminion Server, open Notepad as an administrator, and open the catalogs.config file located at C:\Program Files\Daminion Software\Daminion Server.

Change “databaseServer=”localhost”” to “databaseServer=”the IP address of your PostgreSQL server”” in each catalog.

If a non-standard port was used on the server or if the login and password were changed, you should also update them in each catalog entry:

 

databasePort="Server port number"
databaseUser="Database username"
databasePassword="Database password"

Save the configuration file and start the server. Catalogs specified in catalogs.config will be automatically created in the PostgreSQL database.

Limitations:

Currently, setting up and creating catalogs through the control panel will not work. Creating and editing catalogs should be done through catalogs.config.

To create a new catalog, copy the line with an existing catalog and replace its parameters, for example:

Change  <Catalog catalogName=”NetCatalog”  to  <Catalog catalogName=”NetCatalog1″.

The catalog name must be unique and always new.

 

thumbnailsStorePath="C:\ProgramData\Daminion Software\Daminion Server\Thumbnails\NetCatalog"

Replace it with

 thumbnailsStorePath="C:\ProgramData\Daminion Software\Daminion Server\Thumbnails\NetCatalog1"

– Create this folder manually.

Save your settings and restart the server. The new catalog should appear in the list of catalogs.

Note backup and restoration of catalogs will not be available, this should be done on the PostgreSQL server itself!