Confluence failed to establish a connection to your database

Question

Hi,

After Confluence (6.14.2 server) restart, I have got the following message error in the browser:

"Confluence failed to establish a connection to your database"

I have also fetched catalina.out log. I don't see any attach button here.

Thanks,

Dragan

James Bullock · Answer

Absent an obvious, direct error message, you gotta narrow this down among the dbms running, credentials / availability in the dbms, reachability via network, or Confluence configuration.

* Run a db connecting tool (psql if postgres) on the db hosting node, first at all, then as the user who owns the Confluence database.* Once in, confirm what's there: users, databases, permissions.

* Do the same with psql (or etc.) where Confluence runs.* Ideally, run the client tool as the user the Confluence app runs under.* If the Confluence user can't reach the database, try a different user.

* If those can't reach, check network & port availability: ping the dbms node, send  to the dbms connection port.

Bad credentials in the Confluence app config only makes sense if connection otherwise works. The problem could be as simple as "restart" didn't include the dbms, and the credentials are fine. Or the dbms is up, and the credentials are fine but the "restart" took out your network conectivity.

Vickey Palzor Lepcha · Answer

What database is it trying to connect to ?

Shankar Asam {Appfire} · Answer

Hi Dragan,

It look like confluence is unable to talk to your database. Pls verify the DB configuration in confluence.cfg.xml file in home directory. Also check if your confluence is able to connect to your database and its port (check firewalls for blockage). Also, check more logs in atlassian-confluence.log file.

Please see this article for further help

-Shankar