Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence incorrectly reporting embedded database

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."

1 answer

0 votes
AnnWorley Atlassian Team Jun 08, 2018

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:

Screen Shot 2018-06-08 at 4.17.27 PM.pngA 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?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

Share your Confluence Cloud experience for a chance to win $500!

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

293 views 5 14
Read article

Community Events

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

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you