MySQL Connection in SLD, B1IF

[dlevinson21]

Hello,

I am trying to connect to a MySQL database in the SLD, B1IF v1. Current attempt uses J.AnySystem, using:

Driver: com.mysql.jdbc.Driver

URL: jdbc:mysql://mysqlIP:3306/db_name

I have added the mysql-connector-java-8.0.7-dmr-bin.jar file to:

C:\Program Files (x86)\sap\SAP Business One Integration\IntegrationServer\Tomcat\webapps\B1iXcellerator\WEB-INF\lib

The response I am getting is:

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

This connection also requires SSL, and I don't know where/how to add the .pem files. Any guidance or assistance would be greatly appreciated.

Thanks.

[nidhisingh14]

Hi dlevinson21

Please provide screenshot about details which you configured for SLD category anysystem.

Kind Regards
Nidhi Singh
SAP Business One Support

[dlevinson21]

Here's a (edited) SLD screenshot:

And for good measure, here's a (edited) ODBC connection that does connect:

What I don't know how to do is use the Key and Cert on the SLD connection.

Thanks,

Daniel

[waqas_majeed1993]

Dear Daniel,
Did you find the solution of this.I am also getting the same error.

[dlevinson21]

Hello,

Not exactly, our outside consultant (Vision 33) was able to solve the issue, but they did not tell me how.

Daniel