Configurations on the System Config Manager
Navigate to Administration > System Config Man. and set the following parameters:
Parameter Name | Parameter Value | Encryption |
|---|---|---|
device.database.driver_n | Database driver for external database connection Ex.: device.database.driver_0 = org.postgresql.Driverdev | ο»Ώ |
device.database.password_n | For external database passwords, the value should be entered as cleartext. | must be set as βyesβ |
device.database.source | Database IP addresses. Multiple values must be separated by β;β. Ex.: 10.10.10.10;20.20.20.20 | ο»Ώ |
device.database.sql_n | select ip_address as IP_ADDRESS ,hostname as HOSTNAME,element_type_id as ELEMENT_TYPE_ID ,dg_level_1 ,dg_level_2 ,dg_level_3 ,dg_level_4, dg_level_5,port,access_protocol from device_table ο The query format is important, dg_levels can be many, these columns define the tree structure. | ο»Ώ |
device.database.url_n | JDBC URL address for database connection. E.g: device.database.url_0 = jdbc:postgresql://10.10.10.10:5432/databasename | ο»Ώ |
device.database.user_n | External database username. | ο»Ώ |
ο»Ώ