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

[Kimberly McKinnis]

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.

[Daniel Borcherding]

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"

[RianA]

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?

[Kimberly McKinnis]

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.

[Kimberly McKinnis]

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.

[Daniel Borcherding]

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.