To store log events, Omnissa Horizon (formely known as VMware Horizon) 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.
|
1 |
# sudo apt install postgresql |
Start the service.
|
1 |
# sudo systemctl restart postgresql |
To run PostgreSQL after rebooting the server, enable the PostgreSQL service.
|
1 |
# sudo systemctl enable postgresql |
Check the system status.
|
1 |
# 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:
|
1 |
# sudo -u postgres psql |
Assign the postgres user a new password.
|
1 |
postgres=# ALTER USER postgres WITH PASSWORD '!Password00'; |
Create a new user and assign a password.
|
1 |
postgres=# CREATE USER <em>horizon_admin</em> WITH LOGIN PASSWORD '!Password00'; |
Exit the PostgreSQL prompt.
|
1 |
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
|
1 2 3 4 5 |
# 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:
|
1 2 3 4 |
#listen_addresses = ‘localhost’ listen_addresses = ‘*’ # sudo vi /etc/postgresql/14/main/postgresql.conf |
Restart the PostgreSQL service.
|
1 |
# sudo systemctl restart postgresql |
Connect the PostgreSQL database prompt once again.
|
1 |
# sudo -u postgres psql |
Create a new database.
|
1 |
postgres=# CREATE DATABASE <em>horizondb;</em> |
Grant the permissions to the previously created database.
|
1 |
postgres=# GRANT ALL PRIVILEGES ON DATABASE <em>horizondb</em> TO <em>horizon_admin</em>; |
Exit the PostgreSQL prompt.
|
1 |
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.
