Prepare SailPoint IIQ for database
set-up
As part of the initial setup for
Sailpoint IdentityIQ, a database configuration is required. The configuration
for DB need changes in the iiq.properties file
which is located in the %your-drive%\tomcat\webapps\iiq\WEB-INF\classes\iiq.properties
The table below lists the most commonly edited values.
|
Database Type
|
Determined by which database section is uncommented.
(default: MySQL)
|
|
dataSource.username
|
Username to use when connecting to the database (default:
root)
|
|
dataSource.password
|
Encrypted password to use when connecting to the database.
(default: root) Note: generated using the iiq encrypt command
|
|
dataSource.url
|
Defines the host name, port and database to connect to.
(default: use the standard port on localhost, database name = identityiq )
|
|
dataSource.driverClassName
|
Defines the driver to use when connecting to the database
(default: com.mysql.jdbc.Driver)
|
Below a snippet of the iiq.properties file for MySQL
dataSource.username = root
dataSource.password = 1:xDikd6BMwY+LL9iXETAjBg==
##### MySQL 5 ##### ##
URL Format: dataSource.url = jdbc:mysql://:/?useServer
PrepStmts=true&tinyInt1isBit=true&useUnicode=true&characterEncoding=utf8
dataSource.url =
jdbc:mysql://localhost:3306/identityiq?useServerPrepStmts=true
&tinyInt1isBit=true&useUnicode=true&characterEncoding=utf8
dataSource.driverClassName = com.mysql.jdbc.Driver
