Portal Properties: Format and Portal Customizations > Configuring Database Properties
  
Version 10.2.01P10
Configuring Database Properties
Several properties in the portal.properties file can be used to control and manage database access.
1. Edit the portal.properties file:
Linux:
/opt/aptare/portalconf/portal.properties
Windows:
C:\opt\aptare\portalconf\portal.properties
2. Update the following section, using the descriptions in Database Connection Properties as guidance:
#Database connection
db.driver=oracle.jdbc.driver.OracleDriver
db.url=jdbc:oracle:thin:@localhost:1521:scdb
db.user=portal
db.password=
db.password.encrypted=70TreIlp+FXfRmkJAQCm6A==
db.connection.max=25
db.connection.min=25
db.connection.expiration=5
db.ro_user_password=
db.ro_user_password.encrypted=L9xrj9FPxnK25+u
3. Restart the Tomcat Portal services.
Database Connection Properties
 
Property
Description
db.driver
This value is customized by the Portal installer and should not be modified.
db.url
This is the address where the IT Analytics database resides. Depends on what was entered during the installation. This may need to be modified when there is a host name change.
db.user
Use this property to change the DB User ID for logging in to access the database. The default value is portal.
db.password
db.password.encrypted=
Enter a password to be used with the DB user. The default value is portal. The password initially is stored in clear text, but after the restart of the Tomcat Portal services, the password is saved in the encrypted format and the clear text password is removed from portal.properties.
db.connection.max
Use this property to specify the maximum database connections allowed. The default value is 25.
db.connection.min
Use this property to specify the minimum number of database connections that the Portal can have. The default value is 25.
db.connection.expiration
When a Portal report initiates a long-running database query, this value (in minutes) establishes when the report will time out if the query takes too long to complete. The default value is 5.
db.ro_user_password
db.ro_user_password.encrypted=
Enter a password to be used with the DB read-only user. The default value is aptaresoftware123. The password initially is stored in clear text, but after the restart of the Tomcat Portal services, the password is saved in the encrypted format and the clear text password is removed from portal.properties.