Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

errors when configure the system administrator account for this Confluence installation

dizhihao March 25, 2020

Oops - an error has occurred

when configure the system administrator account for this Confluence installation.  I choose 'Manage Users and Groups within Confluence'. 

 

Cause

com.atlassian.core.exception.InfrastructureException: Failed to create default group: confluence-users
    at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroups(SetupAdministrator.java:89)

caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute statement; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:230)

caused by: org.hibernate.exception.SQLGrammarException: could not execute statement
    at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence_db.cwd_application_attribute' doesn't exist
    at jdk.internal.reflect.GeneratedConstructorAccessor340.newInstance(Unknown Source)

2 answers

0 votes
Evan Underwood-Harley
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2020

Can you provide a full copy of the logs - atlassian-confluence.log 

In the database can you check if any other database tables are created?

Regards

Evan

dizhihao March 25, 2020 edited

Finally, confluence installed. MySQL charset might be "utf8 -- UTF-8 Unicode",  and sort might be "utf8_bin". Thank you for your good ideas.

0 votes
Evan Underwood-Harley
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 25, 2020
caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'confluence_db.cwd_application_attribute' doesn't exist

 

This suggests the database hasn't been setup correctly and all the required tables could not be created. Check the permissions on the database does your confluence database user have all the correct permissions on the database as per - https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

 

You may need to drop the database and re-create it as per the above link to get this working correctly.

 

Regards

Evan 

dizhihao March 25, 2020

I drop the db and re-created it, then re-install confluence, but the same question.

WX20200325-174344@2x.png

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.3.3
TAGS
atlassian, atlassian community events, ace, engineering, confluence feed, power of feed, atlassian ask me anything, atlassian confluence answers, ace rsvp, atlassian community events rsvp, atlassian magic

“How We Built This” ft. Atlassian Confluence Engineers

Meet the engineers who are making the Confluence magic happen at Atlassian ✨

RSVP now!
AUG Leaders

Upcoming Confluence Events