Help, I am getting this weird error: ```Communicat...
# box-products
o
Help, I am getting this weird error:
Copy code
Communications link failure The last packet successfully received from the server was 1 milliseconds ago. The last packet sent successfully to the server was 1 milliseconds ago.
I am able to migrate install, up, down, uninstall the database successfully via the Coldbox CLI so my database credentials are set up and a link is established I presume. Any ideas? UPDATE: Going into the server admin, Datasources-><Datasource> and just clicking update with no setting being changed fixes the issue. However this has to be done every time so it's not a real fix but, a workaround. Also with not having to change anything in the datasources setting, it only confirms that my .env file's database credentials are in fact correct.
e
Is this Lucee and are you passing the right class:
com.mysql.cj.jdbc.Driver
? I’ve found that using the old driver will fail from cfconfig but Lucee’s admin will fix it.
b
@Ookma-Kyi Please provide the FULL stack trace all the way to the bottom. That's not the root cause, it's just a wrapper exception.
o
b
@Ookma-Kyi None of that is a java stacktrace
It's just the CF tag stack, but this is a java error coming from java so we need the actual stack trace
o
Sorry about that I'm very new to this. How do I get a java stack trace?
b
It's part of the error, You usually just copy it from the screen to your clipboard
You've given us not many details so it's hard to imagine what you're seeing on your screen right now or where this error is displaying
A screenshot would go a long way here
o
@bdw429s
b
@Ookma-Kyi I believe the java stack trace is in the "exception details" frame
o
b
@Ookma-Kyi The answer is at the bottom in the last "caused by"
Copy code
Caused by: javax.net.ssl.SSLHandshakeException: No appropriate protocol (protocol is disabled or cipher suites are inappropriate)
I would research how to set up SSL connections to MySQL or how to disable SSL entirely
o
That doesn't really explain why if I manually update it in the server admin, without changing anything in the dataset settings it starts working funtil the server is closed
b
It tells you that the datasource definition is changing from the scenario that works to the scenario that doesn't work. Find it. Fix it.