errors when configure the system administrator account for this Confluence installation

[dizhihao]

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)

[Evan Underwood-Harley]

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]

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

[Evan Underwood-Harley]

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]

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