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

Could not start my jira server now

ajeecai

It used to work fine but some days ago it doesn't ( could not recall what change we made), you see see as following capture:

To clarify, my data is mysql 5.7. I have checked dbconfig.xml, the user name password is correct.

When I manually connect to mysql database with command line from jira server, it says "ERROR 1129 (HY000): Host '172.19.0.1' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'"

Then I go to mysql server and mysqladmin flush-hosts, the connection still could not be established, get the same error.

But in mysql server, use command "mysql -u mydbuser -p", enter password, it is ok and could see jiradb database.

Please help asap.

Thanks

Accepted answers

ajeecai

OK I understand now.

I have set Jira/confluence server communicating with mysql over SSL, but later the SSL certificate is out of date but I didn't notice. Jira or confluence won't accept expired or invalid certificate and refuse to continue. It seems confluence quickly retries numerous times ("mysqladmin flush-hosts" won't help because hit threshold in one second) so that mysql considers it as some attack and let it into blacklist.

This is proved in this packet capture:

refer to

https://community.atlassian.com/t5/Jira-Software-questions/WARN-Establishing-SSL-connection-without-server-s-identity/qaq-p/1015860

https://confluence.atlassian.com/confkb/getting-establishing-ssl-connection-without-server-s-identity-verification-is-not-recommended-warning-messages-in-the-logs-973502769.html

After fixing (remember stopping jira/confluence and "mysqladmin flush-hosts" db), it works now Another solution is to renew certificate.

All comments

edwin vasquez_f9df79

Hello @ajeecai

If it functions like MS SQL, have you tried rebooting have you tried restarting that service or instance? Any ports being blocked potentially?

ajeecai

Hi,

My database is MySql, no MS SQL. And yes, I tried to reboot many times but it doesn't help. I don't think it is blocked by port. As I did wireshark capture, the connection is OK but MySql returns server error, the content is simple: blocked because of many connection errors; unblock with 'mysqladmin flush-hosts