Troubleshooting Tip: Changing IP Address via configFSM.sh Results in 'Connection Timed Out'

[koolishami]

Description	This article provides a step-by-step guide for troubleshooting issues encountered when changing the IP address of a FortiSIEM appliance using configFSM.sh. Specifically, it addresses the error: unable to connect to database: connection to server at "<old_IP>", port 5432 failed: Connection timed out.
Scope	FortiSIEM v7.x+.
Solution	Important: Before proceeding, ensure a snapshot of the virtual machine is taken for recovery purposes. This error typically occurs due to misconfiguration during the IP address change process, particularly when moving the IP from one interface to another. Reference Article: Technical Tip: How to change IP address of a FortiSIEM appliance Follow these steps to resolve the issue: Verify IP Address Assignment. Run the following commands to verify the current IP address configuration: ifconfig ip a The output should display the new IP address if the related article's steps were followed. Update the New IP Address in Configuration Files. /etc/hosts. Add or edit the host file with the new IP and hostname: NEW_IP hostname PostgreSQL Database. Run these commands to update the database records: psql -U phoenix phoenixdb -c "update ph_sys_server set ip_addr='NEW_IP' where id='1';" psql -U phoenix phoenixdb -c "update ph_health_status set host_ip='NEW_IP';" psql -U phoenix phoenixdb -c "update ph_sys_conf set value='https://NEW_IP/svn' where property like 'svn_url%';" phoenix_config.txt. Search for references for the old and new IPs: cat /opt/phoenix/config/phoenix_config.txt | grep 'OLD_IP' cat /opt/phoenix/config/phoenix_config.txt | grep 'NEW_IP' --> Should not return any output. Edit phoenix_config.txt to replace all occurrences of SERVER_HOST and server_host with NEW_IP: vim /opt/phoenix/config/phoenix_config.txt License Configuration. Update the license configuration: phLicenseTool --hostip NEW_IP Restart Services. Stop and restart Java processes: killall -9 java phtools --start all Check the status of all processes: phstatus Following these steps should resolve the connection timeout issue and ensure proper functionality after the IP address change.