Confluence incorrectly reporting embedded database

Question

Hi there. I'm running Confluence Server 6.8.0. When I installed it (on top of a Ubuntu 16.04 distro), I stood up two servers - one for Confluence and another as a database server (MySQL) and off I went. I got it working and created content. When the evaluation was up I bought a starter license.

Everything has been great, but Confluence keeps telling me that I am running an embedded database. I am not. There is nothing like $confluence-home/database to speak of. I've confirmed a database for Confluence exists on my database server. In short: I'm really confused and looking for a reason why Confluence might incorrectly report I have an embedded database. Thanks in advance for any guidance.

For reference, here's the message the instance health check gives me:

"Confluence is using the H2 embedded database. You should migrate to a supported database to ensure your data is safe."

Matthew Mulligan · Answer

Hi Ann,

Thank you very much for your help. I do not have a property of "hibernate.connection.url" defined in confluence.cfg.xml. There is no property with that name listed. However, I see a reference to H2, specifically in the property, "hibernate.connection.driver_class." After looking over the System Information page, I see references and a path to an H2 database now:

Database Connection URL:  jdbc:h2:tcp://localhost:9092//var/atlassian/application-data/confluence/database/h2db

So, for whatever reason, it appears that I am using the embedded database. Am I mistaken? I must have glossed over it. I'm sorry about that. I will have to follow the how-to articles to migrate the database, correct?

AnnWorley · Answer

Hi Matthew, Please double check the system information page on your instance under "database information". The page is at Confluence Admin>System Information or /admin/systeminfo.action: A decisive source of truth is the file /confluence.cfg.xml. (The directory is the path defined in the following file: /confluence/WEB-INF/classes/confluence-init.properties) All the database settings are in there so you can check whether the database URL is pointing at the MySQL database as you intend. The line to look for is: YOUR_DB_URL I look forward to hearing what you find. Thanks, Ann