APMSQL is not starting up properly and the apmsqlserver.out shows following messages
Completed Starting APM SQL
SQL Error occured while establishing connection with APMSQL Connections could not be acquired from the underlying database!
org.teiid.jdbc.TeiidSQLException: TEIID20020 Error establishing socket to host and port: <host>:54321. Reason: Connection refused (Connection refused)
SQLException: Connections could not be acquired from the underlying database!
Release : 10.7.0
Component :
This was not related to the HF84 installation but a pre-existing configuration error.
The authorization defined in the apmsql-server-jetty-config.xml was configured to use a token rather than a user id BUT the password property was incorrectly defined - type was not set - even though password is not used.
<Set name="driverClass">org.teiid.jdbc.TeiidDriver</Set>
<Set name="jdbcUrl">jdbc:teiid:apm_base@mm://<host>:54321</Set>
<Set name="user"><password></Set>
<Set name="password" type=""></Set>
Corrected the structure of the apmsql-server-jetty-config.xml file to define the type as String
<Set name="driverClass">org.teiid.jdbc.TeiidDriver</Set>
<Set name="jdbcUrl">jdbc:teiid:apm_base@mm://myhostname:54321</Set>
<Set name="user"><password></Set>
<Set name="password" type="String"></Set>