You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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.
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"
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
👋 Hi there, a few of us at Atlassian would love to learn about how you use "space settings" functionality in Confluence. A facelift to the space settings is long overdue and we want to start with im...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.