First Web Install on Confluence on create Admin Account

[pascal]

A system error has occurred — our apologies!

For immediate troubleshooting, consult our knowledge base for a solution.

If you would like to receive support from Atlassian's support team, ask your Confluence administrator to create a support issue on Atlassian's support system with the following information:

1. a description of your problem and what you were doing at the time it occurred
2. a copy of the error and system information found below
3. a copy of the application logs (if possible).

Your Confluence administrator can use the support request form to create a support ticket which will include this information.

We will respond as promptly as possible.
Thank you!

Return to site homepage…

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 'confluencedb.cwd_application_attribute' doesn't exist
    at jdk.internal.reflect.GeneratedConstructorAccessor314.newInstance(Unknown Source)

Stack Trace:[hide]

com.atlassian.core.exception.InfrastructureException: Failed to create default group: confluence-users
	at com.atlassian.confluence.setup.actions.SetupAdministrator.createDefaultGroups(SetupAdministrator.java:89)
	at com.atlassian.confluence.setup.actions.SetupAdministrator.execute(SetupAdministrator.java:55)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:168)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)

[Alexis Robert]

Hi @pascal , 

this is probably caused by the MySQL user permissions not being set correctly, as the error message states that Confluence is unable to create a group :

caused by: org.hibernate.exception.SQLGrammarException: could not execute statement

I would recommend dropping the database and going through the setup one more time, and making sure to follow the instructions on this page to set the correct MySQL permissions : https://confluence.atlassian.com/doc/database-setup-for-mysql-128747.html

Let me know if this helps, 

--Alexis