Unable to mysql data base JDBC channel error

[former_member192238]

Hello Experts,

From PI i am trying to connect MYSQL database yesturday it worked fine but to day i am facing a new issue as below i check with my data base people they are able to connect the data base.

Error during database connection to the database URL 'jdbc:mysql://xxxxxxx/sglnet' using the JDBC driver 'com.mysql.jdbc.Driver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection with the registered driver. com.mysql.jdbc.Driver returns: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection timed out STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection timed out at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:116) at com.sap.aii.adapter.jdbc.JDBC2XI.connectDB(JDBC2XI.java:1466) at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:330) at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:523) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:280) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago.. : com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection timed out STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection timed out at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at com.sap.aii.adapter.jdbc.sql.DriverManager.getConnection(DriverManager.java:116) at com.sap.aii.adapter.jdbc.JDBC2XI.connectDB(JDBC2XI.java:1466) at com.sap.aii.adapter.jdbc.JDBC2XI.invoke(JDBC2XI.java:330) at com.sap.aii.af.lib.scheduler.JobBroker$Worker.run(JobBroker.java:523) at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) at java.security.AccessController.doPrivileged(Native Method) at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:182) at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:280) ** END NESTED EXCEPTION ** Last packet sent to the server was 0 ms ago

Please throw some light on the issue any help is high

Regards

Praveen Reddy

[Former Member]

Hi,

Check with your network team, network conenction between PI and Data base not working , Network team have to open Data base system ports inorder connect PI System.

Talk to Basis or system administrators and check whether your PI server is located within firewall or not. If not then ask them to enable the connectivity

please go through below thread,

regards,

ganesh.

[former_member192238]

Hi,

Net work team has confirmed that network issues are there .

Regards

Praveen