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

Question

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 · Answer

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.

Kimberly McKinnis · Answer

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 · Answer

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.