---
title: Configurations on the System Configuration Manager
slug: kronpam-reference-guide-3-9-0/configurations-on-the-system-configuration-manager
docTags: 
createdAt: 2024-11-28T10:18:25.620Z
---

1. Navigate t&#x6F;**&#x20;Administration** > **System Configuration Manage**r and set the following parameters:

| **Parameter Name**              | **Parameter Value**                                                                                                                                                                                                                                                                                                                 | **Encryption**       |
| ------------------------------- | ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | -------------------- |
| **device.database.driver\_n**   | Database driver for external database connection<br />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. <br />E.g\:device.database.url\_0 = jdbc\:postgresql://10.10.10.10:5432/databasename                                                                                                                                                                                                      |                      |
| **device.database.user\_n**     | External database username                                                                                                                                                                                                                                                                                                          |                      |

