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."
Please double check the system information page on your instance under "database information". The page is at Confluence Admin>System Information or <base_URL>/admin/systeminfo.action:
A decisive source of truth is the file <confluence_home>/confluence.cfg.xml. (The <confluence_home> directory is the path defined in the following file: <confluence_install>/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:
I look forward to hearing what you find.
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?
Take our 5-minute survey to win a $500 Visa gift card! Are you currently using Confluence Cloud? We want to hear from you! Fill out this quick survey about your Confluence Cloud experience so we ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event