New Linux install of Confluence throws "permission denied for relation bandana" as soon as you begin jdbc database setup in web-UI

Everytime I open a ticket on our broken war install, it is suggested we move away from the war. So we did, but the new install on Linux, using the 64-bit bin installer, breaks during the web-based setup. I created a new database in Postgresql called confluencedb, and a new database user, confluenceuser, that owns confluencedb. When I tell the setup UI to connect via jdbc and enter in database credentials, it immediately directs me to a Server Error. We tried dropping the database and user and starting over, but the problem presents itself immediately on setup again.

The specific error appears in both the tomcat and postgresql log: UTC ERROR: permission denied for relation bandana

We are a loss. I did an export and a sqldump from the old install, but I'd like to complete the migration today so that we can finally upgrade.

5 answers

This widget could not be displayed.

Hello,

I found the following post that suggests that the tables inside your new DB may have been created with your old users permissions despite having a different owner.

http://mindlev.wordpress.com/2010/05/26/297/

You will the see the mitigation is to drop and recreate the database. After doing so run the following command to execute the dump as your new users

psql -d confluencedb -U confluenceuser -W < backup.sql

This should ensure that your tables are created with permissions for "confluenceuser"

This widget could not be displayed.

It seems that it might be related to the permission to that user in confluencedb. Did you try to overwrite the database? Could you please try to use different database? Will it behave the same way?

This widget could not be displayed.

Daniel: you are definitely on to something. I still don't understand the initial failure, but since I thought I had successfully dropped the db and user to try again, it sounds like your scenario is what happened here. Can you clarify for me though, what is "confluence_user" ? I wanted the permissions to be for just confluenceuser, which is new. That bit confused me.

This widget could not be displayed.

Daniel: you are definitely on to something. I still don't understand the initial failure, but since I thought I had successfully dropped the db and user to try again, it sounds like your scenario is what happened here. Can you clarify for me though, what is "confluence_user" ? I wanted the permissions to be for just confluenceuser, which is new. That bit confused me.

This widget could not be displayed.

Starbreiz,

That was a typo on my side. I was so used to typing out permissions as "confluence_user" that I gaffed. The statement i Included below should create permisions for "confluenceuser". I have edited my comment below to reflect that change. My appologies for this typo.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Tuesday in Confluence

Add-on evaluation with confluence templates

Atlassian market place contains number of Apps/Addons which improves the capability of out of the box Atlassian products. It is good to follow a plugin evaluation process before install add-ons. So t...

133 views 12 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you