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."
Hi Matthew,
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:
<property name="hibernate.connection.url">YOUR_DB_URL</property>
I look forward to hearing what you find.
Thanks,
Ann
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.