The Xpress Insight server accesses the database through a standard data source named com.fico.xpress.insight.db. By default it will connect using the username insight and password insight , but 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 insight
- 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-9.0.1.Final\standalone\configuration\standalone.xml 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">
<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>
<driver>postgresql</driver>
<security>
<user-name>insight</user-name>
<password>insight</password>
</security>
</xa-datasource>
- 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>
- Save this file and restart the Xpress Insight Server to apply the new configuration.
