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 

[ajeecai · Accepted solution]

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. 

[Vickey Palzor Lepcha]

Is everything fine with the MySQL Driver that you must be using ?

[edwin vasquez]

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

I don't know what causes too many connection error,  and "mysqladmin flush-hosts -h localhost -p" in MySQL server doesn't help. 

Thanks

[edwin vasquez]

Does MySQL contain other databases? If so, Are other servers able to connect it properly?