Technical Note: How to rename an organization

Description

This article describes how to rename an organization name in FortiSIEM. This is currently not possible using the FortiSIEM UI. It must be directly changed in PostgreSQL.

Solution

Here is a step by step guide to change the organization name in PSQL. 

1. Log into FortiSIEM Supervisor through SSH as root user. 

2. Perform a backup of the CMDB.

/opt/phoenix/deployment/db_archiver.sh 

Verify that a new backup has been created

# ls /data/archive/cmdb/
  phoenixdb_2018-06-04T10-51-01

3. Log into psql by running the the following command:

# psql -U phoenix -d phoenixdb 

4. Run the following command in psql and replace <current name> with the organization's name which needs to be changed.

select id,name from ph_sys_domain where name='<current name>';

5. Note down the ID returned and run the following command to change the Organization's name.

update ph_sys_domain set name='<NEW NAME>' where id=<ID returned from #4>;

A response of UPDATE 1 which confirms one row has been updated. 

6. Verify the change by running this select statement:

select id,name from ph_sys_domain where id=<ID returned from #4>;

7. Exit out of psql

\q <enter>

8. Restart the application server (kill java service)

# killall -9 java