Hi All, our database admin says everything is good, but we're getting this issue in the logs.
2020-04-27 14:49:54 SEVERE [wait-for-component] org.apache.tomcat.jdbc.pool.ConnectionPool.init Unable to create initial connections of pool. java.sql.SQLException: Access denied for user 'appian_md_owner'@'10.170.0.74' (using password: NO)
We're not sure why the message is saying "NO" for using password. If anyone has seen and solved this before, let us know.
Thanks,Jeff.
2020-04-27 14:49:54 SEVERE [wait-for-component] org.apache.tomcat.jdbc.pool.ConnectionPool.ini t Unable to create initial connections of pool. java.sql.SQLException: Access denied for user 'appian_md_owner'@'10.170.0.74' (using p assword: NO)
Discussion posts and replies are publicly visible
OK, so it turns out that the variable names in the connection string in tomcatresources.xml are case sensitive. At some point during the config process I had changed it from "password" to "PASSWORD" and that is why the app was not picking it up and using it.