It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

errors when configure the system administrator account for this Confluence installation

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

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 

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

WX20200325-174344@2x.png

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

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.3.3
TAGS
Community showcase
Posted in Confluence

Lessons and Learnings: Six Months of Working Remote [Discussion]

Hey there, folks! For most of us, the past six months- yes, you read that right- have been a journey. More people than ever before have pivoted to working remotely, and navigating being on-scre...

6,539 views 5 6
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you