Configure PostgreSQL database for Horizon 8 events

To store log events, Omnissa Horizon (formely known as VMware Horzon) supports MS-SQL, Oracle and PostgreSQL database platforms.

To keep costs under control, you can eliminate the need for a Windows license by using the PostgreSQL database solution on a Linux OS.

 

Install PostgreSQL database on Linux Ubuntu

In this example, the PostgreSQL database will be installed on Linux Ubuntu OS.

SSH the Ubuntu server with an account with root permissions.

 

Install the PostgreSQL package.

# sudo apt install postgresql

 

Start the service.

# sudo systemctl restart postgresql

 

To run PostgreSQL after rebooting the server, enable the PostgreSQL service.

# sudo systemctl enable postgresql

 

Check the system status.

# sudo systemctl status postgresql

 

Configure PostgreSQL

By default, the postgres user is created during the installation with the postgres role.

Connect the PostgreSQL prompt as a user with appropriated privileges with the following command:

# sudo -u postgres psql

 

Assign the postgres user a new password.

postgres=# ALTER USER postgres WITH PASSWORD '!Password00';

 

Create a new user and assign a password.

postgres=# CREATE USER horizon_admin WITH LOGIN PASSWORD '!Password00';

 

Exit the PostgreSQL prompt.

postgres=# \q

 

 

Edit the file /etc/postgresql/14/main/pg_hba.conf and add the Connection Server IP addresses under the IPv4 local connection.

Replace peer with password

# Connection Servers
host all all 192.168.10.95/24 md5
host all all 192.168.10.96/24 md5

# sudo vi /etc/postgresql/14/main/pg_hba.conf

 

 

Edit the file etc/postgresql/14/main/postgresql.conf and change the line as follows:

#listen_addresses = ‘localhost’
listen_addresses = ‘*’

# sudo vi /etc/postgresql/14/main/postgresql.conf

 

Restart the PostgreSQL service.

# sudo systemctl restart postgresql

 

Connect the PostgreSQL database prompt once again.

# sudo -u postgres psql

 

Create a new database.

postgres=# CREATE DATABASE horizondb;

 

Grant the permissions to the previously created database.

postgres=# GRANT ALL PRIVILEGES ON DATABASE horizondb TO horizon_admin;

 

Exit the PostgreSQL prompt.

postgres=# \q

 

Configure the database in horizon

Access the Horizon console and access the Event Configuration section. Click Edit.

 

Enter the configuration settings specifying PostgreSQL as Database Type. Click OK to save the configuration.

 

The Event Database has been configured successfully.

 

Using the PostgreSQL database running on a Linux OS to store Omnissa Horizon events, allows to save money because a Windows license is no longer required.

from StarWind Blog https://ift.tt/p9woivc
via IFTTT