I am trying to install confluence on my ubuntu 20.04 server, the very same way I already did a couple of months ago on my ubuntu 18.04 server.
This time, however, I can't seem to get past the database setup in the wizard. Every time it crashes with a HTTP-500 and a screen full of stack traces. The top of the error messages look like this:
Type Exception Report
Message 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]: Bean instantiation via constructor failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class com.atlassian.confluence.impl.hibernate.ConfluenceLocalSessionFactoryBean
Beschreibung The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
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]: Bean instantiation via constructor failed; nested exception is java.lang.NoClassDefFoundError: Could not initialize class com.atlassian.confluence.impl.hibernate.ConfluenceLocalSessionFactoryBean org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1771) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593) org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:515) org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:320) org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:318) org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:204)
Which does not help me at all tracking down the issue.
In the postgres log I can also see:
2020-10-25 16:31:42.719 CET [206067] LOG: database system is ready to accept connections
2020-10-25 16:34:44.663 CET [206368] confluence@confluence ERROR: relation "attachments" does not exist at character 22
2020-10-25 16:34:44.663 CET [206368] confluence@confluence STATEMENT: select count(*) from ATTACHMENTS
2020-10-25 16:34:44.675 CET [206368] confluence@confluence ERROR: relation "bodycontent" does not exist at character 22
2020-10-25 16:34:44.675 CET [206368] confluence@confluence STATEMENT: select count(*) from BODYCONTENT
2020-10-25 16:34:44.675 CET [206368] confluence@confluence ERROR: relation "content" does not exist at character 22
2020-10-25 16:34:44.675 CET [206368] confluence@confluence STATEMENT: select count(*) from CONTENT
2020-10-25 16:34:44.676 CET [206368] confluence@confluence ERROR: relation "cwd_application" does not exist at character 22
2020-10-25 16:34:44.676 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_application
2020-10-25 16:34:44.678 CET [206368] confluence@confluence ERROR: relation "cwd_directory" does not exist at character 22
2020-10-25 16:34:44.678 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_directory
2020-10-25 16:34:44.679 CET [206368] confluence@confluence ERROR: relation "cwd_group" does not exist at character 22
2020-10-25 16:34:44.679 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_group
2020-10-25 16:34:44.679 CET [206368] confluence@confluence ERROR: relation "cwd_user" does not exist at character 22
2020-10-25 16:34:44.679 CET [206368] confluence@confluence STATEMENT: select count(*) from cwd_user
2020-10-25 16:34:44.680 CET [206368] confluence@confluence ERROR: relation "links" does not exist at character 22
2020-10-25 16:34:44.680 CET [206368] confluence@confluence STATEMENT: select count(*) from LINKS
2020-10-25 16:34:44.681 CET [206368] confluence@confluence ERROR: relation "notifications" does not exist at character 22
2020-10-25 16:34:44.681 CET [206368] confluence@confluence STATEMENT: select count(*) from NOTIFICATIONS
2020-10-25 16:34:44.682 CET [206368] confluence@confluence ERROR: relation "os_propertyentry" does not exist at character 22
2020-10-25 16:34:44.682 CET [206368] confluence@confluence STATEMENT: select count(*) from OS_PROPERTYENTRY
2020-10-25 16:34:44.683 CET [206368] confluence@confluence ERROR: relation "pagetemplates" does not exist at character 22
2020-10-25 16:34:44.683 CET [206368] confluence@confluence STATEMENT: select count(*) from PAGETEMPLATES
2020-10-25 16:34:44.684 CET [206368] confluence@confluence ERROR: relation "spacepermissions" does not exist at character 22
2020-10-25 16:34:44.684 CET [206368] confluence@confluence STATEMENT: select count(*) from SPACEPERMISSIONS
2020-10-25 16:34:44.685 CET [206368] confluence@confluence ERROR: relation "spaces" does not exist at character 22
2020-10-25 16:34:44.685 CET [206368] confluence@confluence STATEMENT: select count(*) from SPACES
Now, I have tried several combinations of:
With each iteration:
Yet the result is always the same. The installer accepts the licence, I enter the database credentials, and after a while, I get the error above.
So this leaves me unable to complete the setup. I would be happy if someone could help me resolve this.
you will have to logon to the db
psql -d wikidb
create the tables
then create table table1();
Hello @Patrick Fial !
As I understand, setting up Confluence is not working as intended.
With the details you gave us, I can start to make some recommendations. Here we go:
- Confluence 7.8 supports only two versions of PostgreSQL – 9.6 and 10. Try to install Confluence only when paired with one of those versions.
- You need to make sure to drop the database created for the previous attempt at starting Confluence before trying again (if you intend to use the same name for the database as before).
- You need to check if the user used to connect Confluence to the database has enough permissions on the database.
Here we have some documentation:
Let us hear from you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, thanks for the feedback. Regarding your tips:
1) As stated in the initial post, I have tried with a postgresql 10 database
2) I have dropped the database with each new attempt
3) The user/db was created like this:
postgres@myhost:~$ createuser --interactive
Enter name of role to add: confluence
Shall the new role be a superuser? (y/n) n
Shall the new role be allowed to create databases? (y/n) y
Shall the new role be allowed to create more new roles? (y/n) n
postgres@myhost:~$ createdb -O confluence confluence
postgres@myhost:~$
Afterwards I have set the password for user `confluence`.
Is there any additional postgresql settings necessary?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.