Cant create new Space (or Space with Template)

[Manuel Henny]

Hi,

i made a fresh installation of Confluence Server. It seems that all is working except creating a new space (Ein unbekannter Serverfehler ist aufgetreten. (An unknown server error has occurred.))

If i try to add a new space with template, it loads endless - with no error.

Health Check is all green.

[Rudy Holtkamp · Accepted solution]

Have you taken a look at the logs?

<Confluence data dir>/Confluence/logs/atlassian-confluence.log

[Manuel Henny]

Okay, i think i got it ...

REFERENCES command denied to user 'confluence'@'localhost' for table 'confluence.AO_54C900_CONTENT_BLUEPRINT_AO'

but if i try to fix it;

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on <JIRADB>.* TO '<USERNAME>'@'<JIRA_SERVER_HOSTNAME>' IDENTIFIED BY '<PASSWORD>';
flush privileges;

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY '<PASSWORD>'' at line 1

i tryed the "

GRANT ALL ON

but this isnt working....

[Rudy Holtkamp]

Does this give an error too:

GRANT REFERENCES ON jira_db.* TO jira_user@'localhost' IDENTIFIED BY 'jira_user_pwd';

And replace jira_db, jira_user and jira_user_pwd, but leave all quotes.

And restart Confluence afterward.

[Manuel Henny]

okay, solved it :)

stopped and restarted sql, confluence, server several times ... and now it works ... :)