Opentext Documentum 21.2 PostgreSQL Install Guide

Opentext has released a new version of Documentum. Probably the most noticeable new features are:

  • Tomcat is now (again) the application server used for JMS
  • This change has decrease the size of the download and the docker images
  • New experimental worflow manager
  • D2 available without installer

This is a step-by-step guide to install Documentum 21.2 in an Ubuntu Linux environment with PostgreSQL 12.

Environment

Host:
Windows 10 x64 8GB RAM
VMware Workstation Player 16

Guest:
Ubuntu Server 20.04 LTS x64 25GB HD 4GB RAM 2 cores
PostgreSQL 12
Documentum 21.2

VM Creation

Mount the Ubuntu Server DVD image, boot the machine and follow the steps. You can choose to let EasyInstall do the work for you. I used minimal package install to save resources, named the machine dctm212, configured the network and created a dmadmin user. You can use the installer to install docker and/or PostgreSQL too.

OS Configuration

  • Install required packages:

dmadmin@dctm212:/opt/documentum/sw$ sudo apt install net-tools tcl rng-tools expect xterm

PostgreSQL Configuration

  • Install required packages:

dmadmin@dctm212:~$ sudo apt -y install postgresql postgresql-contrib

  • Enable and start the PostgreSQL service:

dmadmin@dctm212:~$ systemctl start postgresql
dmadmin@dctm212:~$ sudo systemctl enable postgresql

  • Configure the postgres user:

dmadmin@dctm212:~$ sudo passwd postgres
New password:
Retype new password:
passwd: password updated successfully

dmadmin@dctm212:~$ sudo -u postgres psql postgres
psql (12.5 (Ubuntu 12.5-0ubuntu0.20.04.1))
Type “help” for help.

postgres=# password postgres
Enter new password:
Enter it again:
postgres=# exit

  • Configure PostgreSQL:

dmadmin@dctm212:~$ sudo vi /etc/postgresql/12/main/postgresql.conf
listen_addresses = ‘*’
port = 5432

dmadmin@dctm212:~$ sudo vi /etc/postgresql/12/main/pg_hba.conf
host all all 127.0.0.1/32 md5
host all all ::/128 md5
host all all dctm212 md5

  • Restart PostgreSQL service to apply the changes:

dmadmin@dctm212:~$ sudo systemctl restart postgresql

phpPgAdmin Configuration

  • Install required packages:

dmadmin@dctm212:~$ sudo apt install -y phppgadmin

  • Configure phpPgAdmin:

dmadmin@dctm212:~$ sudo vi /etc/apache2/conf-available/phppgadmin.conf
#Require local

dmadmin@dctm212:~$ sudo vi /etc/phppgadmin/config.inc.php
$conf[‘extra_login_security’] = false;

  • Restart httpd service to apply the changes:

dmadmin@dctm212:~$ sudo /etc/init.d/apache2 restart

Now you should be able to login to the console from http://dctm212/phppgadmin/.

ODBC Configuration

  • Install required packages:

dmadmin@dctm212:~$ sudo apt install unixodbc unixodbc-dev odbc-postgresql

  • Configure .ini files:

dmadmin@dctm212:~$ sudo vi /etc/odbc.ini
[MyPostgres]
Description=PostgreSQL
Driver=PostgreSQL
Database=postgres
Servername=dctm212
UserName=postgres
Password=dmadmin
Port=5432
Protocol=12
ReadOnly=No
RowVersioning=No
ShowSystemTables=No
ShowOidColumn=No
FakeOidIndex=No
UpdateableCursors=Yes
DEBUG=Yes

dmadmin@dctm212:~$ sudo vi /etc/odbcinst.ini
[PostgreSQL]
Driver = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
Driver64 = /usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
Setup64 = /usr/lib/x86_64-linux-gnu/odbc/libodbcpsqlS.so
FileUsage = 1

  • Test the connection:

dmadmin@dctm212:~$ isql -v MyPostgres
+—————————————+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+—————————————+
SQL>

Documentum server

  • Create folders:

dmadmin@dctm212:~$ sudo mkdir -p /opt/documentum/sw && mkdir -p /opt/documentum/product/21.2
dmadmin@dctm212:~$ sudo chown -R dmadmin.dmadmin /opt/documentum

  • Install openJDK 11.0.10 (remember to remove “anon” from the list of disabled algorithms or the installer will fail to connect to the repository)

[dmadmin@dctm212cs]$ wget https://github.com/AdoptOpenJDK/openjdk11-upstream-binaries/releases/download/jdk-11.0.10%2B9/OpenJDK11U-jdk_x64_linux_11.0.10_9.tar.gz
[dmadmin@dctm212cs]$ tar xvf OpenJDK11U-jdk_x64_linux_11.0.10_9.tar.gz && mv openjdk-11.0.10_9/ /opt/documentum/

  • Set up environment variables:

dmadmin@dctm212:/opt/documentum$ vi ~/.bash_profile
DOCUMENTUM=/opt/documentum
export DOCUMENTUM

DOCUMENTUM_SHARED=$DOCUMENTUM
export DOCUMENTUM_SHARED

DM_HOME=$DOCUMENTUM/product/21.2
export DM_HOME

DM_JMS_HOME=$DOCUMENTUM/tomcat9.0.43
export DM_JMS_HOME

POSTGRESQL_HOME=/usr/lib/postgresql/12
export POSTGRESQL_HOME

JAVA_HOME=/opt/documentum/openjdk-11.0.10_9
export JAVA_HOME

JAVA_TOOL_OPTIONS=”-Djava.locale.providers=COMPAT,SPI”
export JAVA_TOOL_OPTIONS

PATH=$PATH:$DM_HOME/bin:$POSTGRESQL_HOME/bin:$HOME/.local/bin:$HOME/bin:$JAVA_HOME/bin
export PATH

LC_ALL=C
export LC_ALL

LD_LIBRARY_PATH=$POSTGRESQL_HOME/lib:$DM_HOME/bin:$LD_LIBRARY_PATH
export LD_LIBRARY_PATH

  • Reserve ports for services:

dmadmin@dctm212:~$ sudo vi /etc/services
dctm212 50000/tcp # dctm 21.2 repo
dctm212_s 50001/tcp # dctm 21.2 repo

  • Configure limits.conf:

dmadmin@dctm212:~$ sudo vi /etc/security/limits.conf
dmadmin – core -1

  • Run the installer:

dmadmin@dctm212:/opt/documentum/sw$ chmod 777 serverSetup.bin
dmadmin@dctm212:/opt/documentum/sw$ ./serverSetup.bin

Docbroker and repository

  • Create the tablespace file for the repository (dctm212):

dmadmin@dctm212:/opt/documentum/sw$ su –
root@dctm212:~# su – postgres
-bash-4.2$ mkdir /var/lib/postgresql/12/main/db_dctm212_dat.dat
-bash-4.2$ exit
root@dctm212:~# exit

  • Run the configurator:

dmadmin@dctm212:/opt/documentum/product/21.2/install$ ./dm_launch_server_config_program.sh

And after the install, you can check the “new” JMS:

One thought on “Opentext Documentum 21.2 PostgreSQL Install Guide

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.