nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Accepted answers

Rudy Holtkamp

Have you taken a look at the logs?

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

All comments

Rudy Holtkamp

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;

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

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 ...