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; } } }

failed to connect to mysql database

jingru h barr

I try to switch jira from h2 -> mysql

mysql version is 5.7.19

jira version is -> 7.11

my database setup without issue with correct grant...

CREATE DATABASE jiradb CHARACTER SET utf8 COLLATE utf8_bin;
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,REFERENCES,ALTER,INDEX on JIRADB.* TO jirasa@iiaabqzwebap01d.ia.doi.net IDENTIFIED BY 'passwordishere';
flush privileges;

I use the mysql-java connector mysql-connector-java-8.0.11.jar

my jira server is on iiaabqzwebap01d.ia.doi.net

I keep getting this following error to configure the db...

2018-07-25 09:32:27,644 JIRA-Bootstrap ERROR [c.a.config.bootstrap.DefaultAtlassianBootstrapManager] Could not successfully test your database:
java.sql.SQLSyntaxErrorException: Access denied for user 'jirasa'@'iiaabqzwebap01d.ia.doi.net' to database 'jiradb'

this is the show grant result from mysql

SHOW GRANTS FOR jirasa@iiaabqzwebap01d.ia.doi.net;

| GRANT USAGE ON *.* TO 'jirasa'@'iiaabqzwebap01d.ia.doi.net' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER ON `JIRADB`.* TO 'jirasa'@'iiaabqzwebap01d.ia.doi.net' |

so... please assist further

Accepted answers

All comments

Lennart

@jingru h barrcheck your mysql-logs.

From what i see here the issue might be related to your my.cnf configuration:

Comment out following lines.

<span>#</span><span>bind-address           </span><span>=</span> <span>127.0.0.1</span>
<span>#</span><span>skip-networking</span>

If you do not find skip-networking line, add it and comment out it.

jingru h barr

try... still does not work

Lennart

Have you checked your MySQL logs?

Would be helpful to see them for the timeframe you try to connect from jira

jingru h barr

yes... nothing shown....

Lennart

No text

jingru h barr

no... I am not using MariaDB.. MariaDB is only installed on the JIRA application as mysql client to test that jirasa account to ensure I could connect from JIRA server to MySQL DB. that is only to test connection only to show you my DB account was set without issue and connection is OK between JIRA application server and MySQL DB server.

The following screenshot is straight out from MySQL DB server.

[root@iiahermysql002d ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 23
Server version: 5.7.19 MySQL Community Server (GPL)

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select version();
+-----------+
| version() |
+-----------+
| 5.7.19 |
+-----------+
1 row in set (0.02 sec)

jingru h barr

Hello..... Are you working on my issue?

Again, I am not using MariaDB.. I am using MySQL. I need to resolve this issue soon..

Lennart

Hey @jingru h barr, here didn't connect to the database here, only to the host.

What happens, connecting to the database from your JIRA-server (still using the mysql / mariadb - client)?

[root@iiaabqzwebap01d ~]# mysql -u jirasa -h iiahermysql002d.ia.doi.net -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 9
Server version: 5.7.19 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> select version();
+-----------+
| version() |
+-----------+
| 5.7.19 |
+-----------+
1 row in set (0.00 sec)

//edit: And please keep in mind: We're not the official atlassian support but mostly atlassian customers who just fell in love with the atlassian ecosystem and try to support each other. We all got our daily jobs, too and don't follow any SLAs here.

In case you're in hurry and want to reach out to the atlassian support-staff - take this way: https://support.atlassian.com/contact/#/

Nic Brough -Adaptavist-

You say

Access denied for user 'jirasa'@'iiaabqzwebap01d.ia.doi.net' to database 'jiradb'

That can be quite a complex problem to resolve, depending on the database in use

Rough example - I like PostGres because it mostly works. But I utterly despise the access control (and all the other settings) in the pg_ config files, it's poorly explained, a weak model and in 99% of cases only works by luck or guesswork, leaving massive security holes. It's even worse than Jira's default permissions which need to be taken out and shot to put them out of our misery

But, I digress. The problem is you have a login that does not work from the Jira server to the database server. The permission grant you give in your question looks right. You can log in from (somewhere else?) on the command line. But not from the Jira server. The Jira server is recording an authentication failure. So, you need to look at the database server to see why it is refusing access to Jira.

jingru h barr

I don't agree your suggestion. The database accepts the connection from JIRA application to mySQL db via mariaDB client. The real issue is "java.sql.SQLSyntaxErrorException"... Do you see "SQLSyntax".....

here is the URL connection defined in dbconfig.xml....

<jdbc-datasource>
<url>jdbc:mysql://iiahermysql002d.ia.doi.net:3306/jiradb?useSSL=false</url>
<driver-class>com.mysql.cj.jdbc.Driver</driver-class>
<username>jirasa</username>
<password>itispasswordinfohere</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1</validation-query>

so.... if this definition is not right.. please kindly advise.

Nic Brough -Adaptavist-

It's irrelevant if you agree or not, the error message in the question is clear - Access denied for user 'jirasa'@'iiaabqzwebap01d.ia.doi.net' to database 'jiradb'

Either you're using the wrong credentials, or the user has not been given the right permission.

jingru h barr

How do I turn on debug on JIRA?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server