Confluence failed to establish a connection to your database

[Thomas Klement]

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

[Shankar Asam {Appfire}]

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

[Vickey Palzor Lepcha]

What database is it trying to connect to ?

[James Bullock]

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.

1. 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.
2. 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.