-
Bug
-
Resolution: Tracked Elsewhere
-
Low
-
None
-
8.13.6, 8.16.1
-
8.13
-
3
-
Severity 3 - Minor
-
3
-
A new install of Jira fails to start due to missed tables.
Steps to Reproduce
- Environment:
MySql 8.0
JDBC 22
Jira 8.16.1 binary install
- Create a new database
- grant permission to an already existent user
- Run config.sh to configure jira_home location and configure JDBC connection
- Test connection -> It will be successful
- Start Jira
What was expected
Jira install and enter the setup mode
What had happened instead
Jira did not enter the setup mode and fail as the database is empty (can not find tables)
Workaround
- Delete all content of Jira home folder
- Drop Database, create new user, create new DB, and grant access:
drop database jiradb816; create user 'jira-816'@'localhost' IDENTIFIED BY 'jira-816'; CREATE DATABASE jiradb816 CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on jiradb816.* TO 'jira-816'@'localhost'; flush privileges;
- is related to
-
JRASERVER-72389 Reusing a mysql database user on a new database caused Jira setup to fail with Database is not empty message
-
- Closed
-
- mentioned in
-
Page Loading...
- relates to
-
HL-2564 Loading...