By default, the connection uses the username insight and password insight. You may want to change this password as an additional security measure.
- To change the password for the Xpress Insight user, start the PostgreSQL database console by opening a command window and entering the following: %XPRESSDIR%\insight\db\pgsql\bin\psql insightdb postgres.
- Enter the command ALTER ROLE to change the password.
For example, to set the password to
ficoxpress enter:
ALTER ROLE insight WITH PASSWORD 'ficoxpress';
- Exit the PostgreSQL database console by entering: \q
- Update the data source with the new password. Open the file <installdir>\insight\server\wildfly-x.y.z\standalone\configuration\standalone.xml (where x.y.z represents the version, subversion, and patch numbers) in a text editor and locate the definition of the insightdb data source, which should look similar to the following:
<xa-datasource jndi-name="java:/com.fico.xpress.insight.db" pool-name="com.fico.xpress.insight.db" enabled="true" use-ccm="false" statistics-enabled="true">
<xa-datasource-property name="ServerName">localhost</xa-datasource-property>
<xa-datasource-property name="PortNumber">5432</xa-datasource-property>
<xa-datasource-property name="DatabaseName">insightdb</xa-datasource-property>
<xa-datasource-class>org.postgresql.xa.PGXADataSource</xa-datasource-class>
<driver>postgresql</driver>
<xa-pool>
<min-pool-size>96</min-pool-size>
<max-pool-size>384</max-pool-size>
<interleaving>false</interleaving>
<pad-xid>false</pad-xid>
<wrap-xa-resource>false</wrap-xa-resource>
</xa-pool>
<security>
<user-name>insight</user-name>
<password>insight</password>
</security>
- Change the security section of the data-source definition to include the new password. For example:
<security>
<user-name>insight</user-name>
<password>ficoxpress</password>
</security>
|
|
Important The database local connections must be set to md5 in order for this password challenge to be effective. For more see
Securing the PostgreSQL Database.
|
|
|
Note If you secure the password for
com.fico.xpress.insight.db, you should also update the credentials for
com.fico.xpress.insight.mirrordb and
com.fico.xpress.insight.dmndb.
|
- Save this file and restart the Xpress Insight Server to apply the new configuration.
Important The database local connections must be set to md5 in order for this password challenge to be effective. For more see Securing the PostgreSQL Database.
Note If you secure the password for com.fico.xpress.insight.db, you should also update the credentials for com.fico.xpress.insight.mirrordb and com.fico.xpress.insight.dmndb.