Confluence throws an error after I keyed in all the data for the database page during set-up. Help?

[Deleted user]

So... I am trying to get a docker confluence and a docker mysql to communicate.
I set up the database, created a user and changed my.cnf according to https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html.

I didn't do the step 1 though, mostly due to the fact that I don't have any installation wizard.

Then I start up the docker for confluence, I already changed the image to let it work with Oracle JDK according to https://confluence.atlassian.com/confkb/update-the-confluence-docker-image-to-use-oracle-jdk-829062521.html

I also did this,

"docker cp mysql-connector-java-5.1.45-bin.jar myconfluence:/opt/atlassian/confluence/confluence/WEB-INF/lib",

which was required because of the change to Oracle. 

Next, did this in an attempt to get rid of permission-related bugs

• docker exec -it myconfluence /bin/bash
• chmod -R 755 /opt/atlassian
• chmod -R 755 /var/atlassian 

I go to my confluence setup, went to the database page and keyed in the relevant information to link it to the docker mysql. 

I think it worked partially because the database wasn't empty when I checked it again. The problem is that the whole page just crashed. 

The message given to me by the setup page is 

• com.atlassian.spring.container.ComponentNotFoundException: Failed to find component: Error creating bean with name 'i18NBean' defined in class path resource [i18NContext.xml]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [com.atlassian.confluence.util.i18n.I18NBean]: Factory method 'getI18NBean' threw exception; nested exception is java.util.concurrent.CompletionException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantedTransactionManager' defined in class path resource [databaseSubsystemContext.xml]: Invocation of init method failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'tenantedLocalSessionFactoryBean5' defined in class path resource [productionDatabaseContext.xml]: Invocation of init method failed; nested exception is java.lang.IllegalStateException: premature SessionFactory initialisation, Hibernate properties have not yet been persisted in confluence.cfg.xml

while a "docker logs myconfluence" gave me some 

• Caused by: com.atlassian.confluence.tenant.VacantException: Confluence is vacant, a call to tenanted [public abstrac t org.hibernate.Session org.hibernate.SessionFactory.getCurrentSession() throws org.hibernate.HibernateException] is not allowed.

at the bottom of the error report.

I've googled around and saw that vacant is usually due to the hostname. I /bin/bash into the docker confluence and ran this

• ping `cat /etc/hostname`

I 've got some legit results, no packets loss. So now I have no idea why it is vacant.

The most infuriating thing I guess is that I actually set up the whole thing once, but it was months ago and I forgot what I did. I recall encountering into such issues before and it was only after a series of hacks and what-not then it barely works. Another irritating part I guess is that docker Jira and docker mysql works beautifully but Confluence and mysql became like this...

I'm trying to not hack now, and hoping that the community can help me out. Thanks for reading this ranty post. :D

[AnnWorley · Accepted solution]

My theory is the database (hibernate) directives are not being saved to the confluence.cfg.xml file in the root of the Confluence Home directory for one reason or another, probably file system permissions. I am basing this on the error:

Hibernate properties have not yet been persisted in confluence.cfg.xml

Chmod 755 that you ran allows everyone to read and execute the file, but only the file owner is allowed to write to the file as well. The OS user running the Confluence setup needs to be the owner in that case.

It seems possible that your database connection parameters were cached, and used to create the tables in the db, but then to finalize the setup and write to the config file was not possible.

Please try the setup again ensuring the OS user running Confluence is the owner of the Confluence files. One strategy is to open up the permissions completely during setup, then lock them down afterward.

[Deleted user]

omigod, that solves it. I was looking all over the place! I just have to change 

chmod -R 755 /opt/atlassian
chmod -R 755 /var/atlassian

to 
chmod -R 777 /opt/atlassian
chmod -R 777 /var/atlassian

and now I got access to the load content page! Thank you so much! Man, I see that you are part of the Atlassian Team? You all are so quick and efficient! Thanks once again!

[AnnWorley]

Really appreciate the kind words, and thanks for circling back to let the Community know what worked. :)