Installing EMS HA with Postgres HA using Bitnami Docker

[NamND]

Hello everyone,
I'm having an issue with installing EMS HA with PostgreSQL HA using Bitnami Docker. I followed the installation guide, but I encountered an installation error at step 4.b.ii, as shown in the attached image.
Has anyone faced this issue before and can help me resolve it?

OS: Ubuntu 24.04 LTS

EMS: 7.4.3

https://docs.fortinet.com/document/forticlient/7.4.3/ems-administration-guide/109604/installing-ems-...

Thanks.

Unpacking python3.10 virtual env
using provided predefined_allowed_hosts
2025-04-23T17:50:17.553Z INFO installutils/installutils.go:211 Start installutils
2025-04-23T17:50:17.553Z INFO installutils/installutils.go:381 UpdateEMSInstanceID(), installdir=/opt/forticlientems/conf
2025-04-23T17:50:17.553Z DEBUG installutils/installutils.go:1004 goEMS.conf path = /opt/forticlientems/conf/goEMS.conf, connector.conf path = /opt/forticlientems/conf/connector.conf
2025-04-23T17:50:17.588Z DEBUG manager/pqdb.go:160 Initializing first connection
2025-04-23T17:50:17.588Z DEBUG manager/pqdb.go:123 No specific connection string for DB fcm. Connection string will be built from template
2025-04-23T17:50:17.588Z DEBUG manager/db.go:139 Stats for DB [fcm] => Open connections: 1, In Use: 1, Idle: 0
2025-04-23T17:50:17.608Z ERROR installutils/installutils.go:383 unable to update Uid in the section ems in connector.conf: retrieving instance_id from system_info: query row on fcm
Failed query: SELECT CAST(instance_id AS VARCHAR(50)) FROM system_info;
Error: ERROR: relation "system_info" does not exist (SQLSTATE 42P01)
dpkg: error processing package forticlientems (--configure):
installed forticlientems package post-installation script subprocess returned error exit status 2
Processing triggers for install-info (7.1-3build2) ...
Processing triggers for libc-bin (2.39-0ubuntu8.4) ...
Processing triggers for ufw (0.36.2-6) ...
Processing triggers for man-db (2.12.0-4build2) ...
Processing triggers for postgresql-common (277.pgdg24.04+1) ...
Building PostgreSQL dictionaries from installed myspell/hunspell packages...
Removing obsolete dictionary files:
Processing triggers for php8.3-cli (8.3.6-0ubuntu0.24.04.4) ...
Processing triggers for libapache2-mod-php8.3 (8.3.6-0ubuntu0.24.04.4) ...
Errors were encountered while processing:
forticlientems
needrestart is being skipped since dpkg has failed
E: Sub-process /usr/bin/dpkg returned an error code (1)
root@ems01:~# ^C

[Anthony_E]

Hello,

Thank you for using the Community Forum. I will seek to get you an answer or help. We will reply to this thread with an update as soon as possible.

Thanks,

[Anthony_E]

Hello,

We are still looking for someone to help you.

We will come back to you ASAP.

Thanks,

[Anthony_E]

Hello,

Could you please have a look at these steps?:

To install EMS HA with Postgres HA using Bitnami Docker, follow these steps:

1. Prepare Machines: Set up four Ubuntu machines: two for Postgres DB hosts and two for EMS hosts. If using cloned virtual machines for EMS hosts, execute the following commands on the cloned machine: ```bash sudo rm /etc/machine-id sudo rm /var/lib/dbus/machine-id sudo systemd-machine-id-setup
2. Gain Root Privileges: Log in to the shell with root privileges by running: `bash sudo -i ` - Perform all subsequent steps with root privileges.
3. Configure Postgres HA Cluster: Load the EMS Postgres Bitnami Docker image on both Postgres DB host nodes: 1. Install Docker: ```bash apt install docker.io
4.  Download the Postgres Docker image `forticlientems_postgres-ha.tar.gz` from the Fortinet Support site.
5. Load the Docker image: ```bash docker load -i forticlientems_postgres-ha.tar.gz ` These steps will help you set up EMS in a high availability configuration with Postgres databases also in an HA configuration using Bitnami Docker.

[Edward_LU]

可參考該原廠文件 https://docs.fortinet.com/document/forticlient/7.4.4/ems-ha-deployment-guide/109604/ems-nodes-in-ha-...
這邊的指令我已有測試過，指令格式應該是有誤
./forticlientems_7.4.4.2034.F.bin -- --db_host "<ip/fqdn node 1>,<ip/fqdn node 2>" --db_user postgres --db_pass postgres --skip_db_install --allowed_hosts '*' --enable_remote_https

建議改成用以下方式輸入 即可解決

sudo ./forticlientems_7.4.4.2034.F.amd64.bin -- \

--db_host "<ip/fqdn node 1>,<ip/fqdn node 2>" \

--db_user postgres \

--db_pass ‘postgres’ \

--skip_db_install \

--allowed_hosts '*' \

--enable_remote_https

[maskasuba]

I went the CloudNativePostgreSQL way, but not had a need for a multi-cluster yet, but the CNPG one ticked all the boxes for my needs and having read the documentation, wouldn't really use anything else if I could avoid it.