Score:1

Google Cloud SSL connect failure between tomcat and MySQL

cn flag

Suddenly started getting this issue. Both webserver and MySQL server are within same Google Cloud account. Webserver is running tomcat with jdbc connection coming in as part of context.xml which creates connection pool at startup. This has been working fine for a few years. But this weekend it suddenly stopped linking to the database with

java.sql.SQLException: Cannot create PoolableConnectionFactory...

which ultimately is caused by

javax.net.ssl.SSLHandshakeException: No appropriate protocol

I've checked the certificates on the MySQL server and they are valid till 2029. I refreshed them anyway and still get same result. The only way to get it working again currently is to pass useSSL=false on the connection string which is not ideal.

If I connect from outside of the cloud i.e from my local machine to the MySQL data base I can connect without having to pass the useSSL=false flag.

Anyone any ideas what may have changed? Do the servers auto update java for example? If so what can be done to revert?

Thanks in advance

mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.