Experimental Physics and
Industrial Control System

 

From: Kasemir, Kay

Date: 2023-06-30 21:04

To: lzfneu at live.com

CC: tech-talk at aps.anl.gov

Subject: Re: [EXTERNAL] Re: Re: Question about fetching history data from MySQL by using phoebus

Hi:

 

> The error messages to connect MySQL 5.7.12 on server side (192.168.1.230) with lib/ -java-8.0.30.jar are shown below:

Cannot connect to jdbc:mysql://192.168.1.230/archive as root

…

Caused by: javax.net.ssl.SSLHandshakeException: Remote host terminated the handshake.

 

 

One step forward, one step back.

You have a valid jdbc:mysql:… connection string, it’s using the lib/mysql-connector-java-8.0.30.jar to establish a network connection to your mysql server.

So all is fine as far as Java/CS-Studio/Phoebus/your jdbc:mysql:… connection string are concerned.

 

But then the mysql-connector client lib fails to agree with your MySQL server on some SSL handshake detail.

So now it’s a MySQL problem, where I really have no immediate solution, but the good news is that there’s a large world-wide MySQL user base out way beyond EPICS/CS-Studio where you can look for help.

 

Now we’ve seen similar issues before, in that case a new mysql-connector client library required “CLIENT_PLUGIN_AUTH” which was not supported by older MySQL servers (5.1.73), see https://github.com/ControlSystemStudio/phoebus/issues/1409

Eventually we updated to mysql-connector-java-8.0.30.jar which is relatively new (~1 year old, since March there’s 8.0.33). Your MySQL server version 5.7.12 is way old (2016), so maybe they are simply incompatible.

 

Things you can try: Look at the MySQL server side. Maybe there’s a way to disable SSL, which may not be desirable for a production setup, but gets you going for initial tests.

 

Since right now your client (ca. 2022) is much newer than the server (ca. 2016), use a newer MySQL or MariaDB version.

 

Or change to an older client side. You can fetch them from https://search.maven.org/artifact/mysql/mysql-connector-java . But note that simply replacing the file lib/mysql-connector-java-8.0.30.jar with for example an older lib/mysql-connector-java-5.1.45.jar doesn’t work. It’s not sufficient to simply place a *.jar file in the lib folder, the exact name also needs to be listed in the META-INF/MANUFEST.MF file that’s inside the product.jar, which you can’t conveniently edit. To test other mysql-connector jar file versions, it’s thus much easier to keep the currently used name. Just copy them into the lib folder by using the name mysql-connector-java-8.0.30.jar. For example, get a mysql-connector-java-5.1.45.jar, rename it to mysql-connector-java-8.0.30.jar and then copy that into the lib folder, replacing the one that’s there.

 

-Kay

References:

Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk

Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk

Re: Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk

RE: Question about fetching history data from MySQL by using phoebus CAOUEN Loic via Tech-talk

Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk

Re: Question about fetching history data from MySQL by using phoebus neu lzf via Tech-talk

Re: Re: Question about fetching history data from MySQL by using phoebus lzfneu--- via Tech-talk

Re: [EXTERNAL] Re: Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk

Navigate by Date:

Prev: Record process when restore using autosave 吴煊 via Tech-talk

Next: interrupt read data in int32Driver example timesir via Tech-talk

Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024 

Navigate by Thread:

Prev: Re: [EXTERNAL] Re: Re: Question about fetching history data from MySQL by using phoebus Kasemir, Kay via Tech-talk

Next: has anyone used ADPICam in a docker? Lee L. Yang via Tech-talk

Index: 1994  1995  1996  1997  1998  1999  2000  2001  2002  2003  2004  2005  2006  2007  2008  2009  2010  2011  2012  2013  2014  2015  2016  2017  2018  2019  2020  2021  2022  <2023>  2024