Which IIQ version are you inquiring about?
8.4
Please share any images or screenshots, if relevant.
Please share any other relevant files that may be required (for example, logs).
Share all details about your problem, including any error messages you may have received.
This is a followup question to an earlier thread (Need help/direction for Migrating existing IdentityIQ instance from MSSQL to RDS/MySQL DB - #3 by officialamitguptaa). I think that earlier thread is getting too long and I have a specific question, so I hope it is ok to make this new question, specifically about the iiq.properties file and the create_identityiq_tables-8.4.mysql SQL script file:
When the create_identityiq_tables-8.4.mysql SQL Script is run, it creates 3 databases and 3 (actually 6) users in the MySQL database:
- identityiq
- identityiqah
- identityiqPlugin
and, the PASSWORDS for each of those 3 users is set to the same value as the database name, i.e.:
- password for identityiq is “identityiq”
- password for identityiqah is "identityiqah
- password for identityiqPlugin is “identityiqPlugin”
but in the iiq.properties file, there is ONLY ONE EACH of the “dataSource.username” and “dataSource.password” properties.
So I was wondering how that is supposed to work?
Is there a way to specify multiple “dataSource.username” and “dataSource.password” in the iiq.properties file, and if so, how can we do that?
Thanks,
Jim
EDIT: I think I just figured out the answer to my question.
In the iiq.properties, there are actually 3 sets of .username and .password properties:
dataSource.username
dataSource.password
dataSourceAccessHistory.username
dataSourceAccessHistory.password
pluginsDataSource.username
pluginsDataSource.password
!!!