Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,296,489
Community Members
 
Community Events
165
Community Groups

Confluence 7.12.2 authentication plugin fails due to schema issue

Edited

Running 7.12.2 in the standard docker container, and I am unable to log in because an error occurs stating that a particular table in the confluence database doesn't exist.

The table does exist, but in the bitbucket schema.

There is no Confluence documentation that suggests how you can force Confluence to just look at the confluence schema and not any other schemas running on the database instance - the documentation just says "don't use the same schema".

So

1. How do I force Confluence just to look at it's own schema (parameters in server.xml or confluence.cfg.xml?

2. Why can't Atlassian list the parameters in confluence.cfg.xml, because it never used to be a requirement for this value to be forced?

3. Why can't Atlassian make sure their code actually checks the schema it should be using? The error actually says "Table 'confluencedb.AO_ED669C_IDP_CONFIG' doesn't exist" yet, it's obviously enumerating tables without checking the schema in the first place!

1 answer

Any luck with this? We're currently running into it now in 7.11.2. Funny thing is that it's happening in our non-prod environments while prod shows no sign of the issue (for now that is...)

Apologies for the extremely late reply - I didn't get any email notifications of a response. It's likely that you have resolved this, but if anyone else is having a similar issue, please check the confluence.cfg.xml file for the following property:

<property name="hibernate.default_schema">{dbname}</property>

If not, add it, replacing {dbname} with the name of your Confluence database.

Restart Confluence. I think that resolves the issue (it's been a while!)

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.12.2
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

1,031 views 18 28
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