Password authentication failed for user
Symptoms
Bamboo fails to run the upgrade tasks and doesn't start. There are many error logs:
...
2012-06-12 17:07:23,859 FATAL [WrapperSimpleAppMain] [BootstrapLoaderListener] An error was encountered while bootstrapping Bamboo (see below):
Unable to bootstrap Bamboo: Failed to run pre-bootstrap upgrade tasks. Please contact Atlassian and https://support.atlassian.com
java.lang.IllegalStateException: Unable to bootstrap Bamboo: Failed to run pre-bootstrap upgrade tasks. Please contact Atlassian and https://support.atlassian.com
at com.atlassian.bamboo.setup.BootstrapLoaderListener.contextInitialized(BootstrapLoaderListener.java:63)
at org.eclipse.jetty.server.handler.ContextHandler.startContext(ContextHandler.java:633)
at org.eclipse.jetty.servlet.ServletContextHandler.startContext(ServletContextHandler.java:228)
at org.eclipse.jetty.webapp.WebAppContext.startContext(WebAppContext.java:1160)
at org.eclipse.jetty.server.handler.ContextHandler.doStart(ContextHandler.java:576)
at org.eclipse.jetty.webapp.WebAppContext.doStart(WebAppContext.java:492)
at org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:55)
...
2012-06-12 17:07:23,843 ERROR [WrapperSimpleAppMain] [AbstractUpgradeManager] java.sql.SQLException: Connections could not be acquired from the underlying database!
java.sql.SQLException: Connections could not be acquired from the underlying database!
at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at net.sf.hibernate.connection.C3P0ConnectionProvider.getConnection(C3P0ConnectionProvider.java:33)
...
However, the crucial error in the logs is this one:
2012-06-12 17:07:53,765 WARN [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] [BasicResourcePool] com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@d637d -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
org.postgresql.util.PSQLException: FATAL: password authentication failed for user "bamboouser"
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:291)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:108)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:66)
at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:125)
at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
at org.postgresql.jdbc3.Jdbc3Connection.<init>(Jdbc3Connection.java:24)
Cause
Bamboo cannot authenticate against the PostgreSQL database with the configured credentials.
Resolution
Please make sure that you are using correct credentials to connect to your PostgreSQL database. Shut down your Bamboo server and manually edit BAMBOO_HOME/bamboo.cfg.xml to use the correct username and password: "hibernate.connection.username" and "hibernate.connection.password". Also, verify that you are trying to connect to the correct database: "hibernate.connection.url".