Unable to Connect to Database Due to Database Authentication
Symptoms
Symptoms include:
- The JIRA context fails to initialize.
- The browser displays
HTTP Status 404 - The requested resource is not available.
Application logs contain the following error:
2007-09-25 10:51:39,623 Thread-1 ERROR [atlassian.jira.service.DefaultServiceManager] Could not configure services:
org.ofbiz.core.entity.GenericDataSourceException: Unable to esablish a connection with the database. (Cannot create PoolableConnectionFactory (Login failed for user 'jirauser'.))
at org.ofbiz.core.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:239)
at org.ofbiz.core.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:318)
at org.ofbiz.core.entity.GenericDAO.selectListIteratorByCondition(GenericDAO.java:1024)
Cause
The credentials used to login to the DBMS are invalid, don't exist or are missing sufficient permissions to connect.
Resolution
- Verify the username and password used in the JDBC driver definition.
- Ensure that the DBMS user exists and the permissions granted are sufficient.
If you're trying to connect to a MS SQL database that is running on a port that is not the default (non-standard), please take a look through this MSDN blog on tips for making application connectivity work.
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.