#8 connection to mysql db from sistem i fail

[PETTINATO FILIPPO]

Connector JDBC on System I 7.3
/jvagate/lib/mysql-connector-j-8.0.31.jar

DataQ section

#### configure these properties

fill in the ip adresse or ip name of your as400

as400.system=LOCALHOST

this user is used for the DataQ connect

as400.user=*CURRENT

password for user connecting to dataQ

as400.password=*CURRENT

** RDBDIRE

Relational DB. . . . . . . . . . : UNOMAGLIA
Remot location :
Remot location . . . . . . . . : ARDPGM
Remot authentication method :
Program . . . . . . . . . . . : JDBCGATE
Library . . . . . . . . . . : JVAGATE
Interface level . . . . . . . : 1
Relational data base type . . . : REMOTE

example using MySQL

ard.url.UNOMAGLIA=jdbc:mysql://192.168.0.24/UNOMAGLIA
ard.driver.UNOMAGLIA=com.mysql.jdbc.Driver
ard.properties.UNOMAGLIA.user=FILPET
ard.properties.UNOMAGLIA.password=FILPET62

Pgm JVAGATE/JDBCGATE run under QCTL subsystem
UNOMAGLIA db on Mysql is online on server LINUX/Ubunt with last release
Ping to ip 192.168.0.24 from System I responds correctly.

From interactive SQL i execute:
CONNECT TO MYSQL ;
The connection fail with this message:
Eccezione connessione - SQLSTATE 08S01, SQLCODE -30060.

I don't understand where is the error.
Can you help me.

Thanks in advance
Filippo P.

P.S. This is the log generate from your application in debug mode.

2023-01-26 14:21:05,640 INFO [main] de.bender_dv.jvagate.communication.Receiver: GlobalProps loaded
2023-01-26 14:21:05,765 INFO [main] de.bender_dv.jvagate.communication.Receiver: connected to DTAQ DataQueue (system: AS400 (system name: 'LOCALHOST' user ID: 'CURRENT'):com.ibm.as400.access.AS400@71ee07d0 path: /QSYS.LIB/JVAGATE.LIB/JAVAQ.DTAQ):com.ibm.as400.access.DataQueue@d7ebc6cf
2023-01-26 14:21:15,766 INFO [main] de.bender_dv.jvagate.communication.Receiver: getOrder
2023-01-26 14:21:17,224 INFO [main] de.bender_dv.jvagate.communication.Receiver: getOrder
2023-01-26 14:21:17,224 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Sender: $$$$$ R040155 $$$$$
2023-01-26 14:21:17,225 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Sender: Event ARDPGM
2023-01-26 14:21:17,232 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Request: Event set to: ARDPGM
2023-01-26 14:21:17,234 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.application.ArdHandler: Request: de.bender_dv.jvagate.communication.Request@da434606
2023-01-26 14:21:17,236 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ArdInFormat: interfaceLevel: 1
2023-01-26 14:21:17,260 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ArdInFormat: inFormatName: ARCN0100
2023-01-26 14:21:17,260 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ArdInFormat: lengthOfInFormat: 106
2023-01-26 14:21:17,262 INFO [pool-1-thread-1] de.bender_dv.ardgate.application.ArdHandler: Format: ARCN0100 ArdGate Version: 2022-05-06
2023-01-26 14:21:17,288 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.application.FormatHandlerFactory: Name: ARCN0100
2023-01-26 14:21:17,298 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.GenericArFormat: outBufferSize: 16776559
2023-01-26 14:21:17,298 INFO [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.GenericArFormat: * UNOMAGLIA :2 *
2023-01-26 14:21:17,299 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: deviceName:
2023-01-26 14:21:17,299 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: modeName:
2023-01-26 14:21:17,299 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: remoteLoc: ARDPGM
2023-01-26 14:21:17,299 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: localLoc:
2023-01-26 14:21:17,300 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: remoteNetId:
2023-01-26 14:21:17,300 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: tpnName:
2023-01-26 14:21:17,300 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: productId: QSQ07030
2023-01-26 14:21:17,300 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: userId: QSECOFR
2023-01-26 14:21:17,301 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: password:
2023-01-26 14:21:17,301 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARCN0100Format: Level: 1
2023-01-26 14:21:17,308 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.database.ArdConnection: url: jdbc:mysql://192.168.0.24/UNOMAGLIA
2023-01-26 14:21:17,310 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.database.ArdConnection: driver: com.mysql.jdbc.Driver
2023-01-26 14:21:17,424 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.database.ArdConnection: Properties{user=FILPET, password=FILPET62}
2023-01-26 14:21:17,907 ERROR [pool-1-thread-1] de.bender_dv.ardgate.database.ArdConnection: failed!
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.
at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828)
at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at java.sql.DriverManager.getConnection(DriverManager.java:675)
at java.sql.DriverManager.getConnection(DriverManager.java:219)
at de.bender_dv.ardgate.database.ArdConnection.connectDatabase(ArdConnection.java:167)
at de.bender_dv.ardgate.database.ArdConnection.connect(ArdConnection.java:131)
at de.bender_dv.ardgate.application.ARCN0100Handler.getOutFormat(ARCN0100Handler.java:62)
at de.bender_dv.ardgate.application.ArdHandler.performWork(ArdHandler.java:45)
at de.bender_dv.jvagate.communication.Sender.run(Sender.java:109)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:825)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure</init>

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
at com.mysql.cj.NativeSession.connect(NativeSession.java:120)
at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:948)
at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:818)
... 13 more
Caused by: java.net.ConnectException: Un host remoto ha rifiutato il tentativo di un'operazione di connect. (Connection refused)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:380)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:236)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:218)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:403)
at java.net.Socket.connect(Socket.java:682)
at com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
at com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
... 16 more
2023-01-26 14:21:17,921 INFO [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLCode: -30060
2023-01-26 14:21:17,921 INFO [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLState: 08S01
2023-01-26 14:21:17,922 INFO [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.SqlcaBean: 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.
2023-01-26 14:21:17,922 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.SqlcaBean: sqlErrd3 0
2023-01-26 14:21:17,922 ERROR [pool-1-thread-1] de.bender_dv.ardgate.database.ArdConnection: QSECOFR not connected to UNOMAGLIA jdbc:mysql://192.168.0.24/UNOMAGLIA
2023-01-26 14:21:17,923 ERROR [pool-1-thread-1] de.bender_dv.ardgate.database.ArdConnection: SQLCode: 0 SQLState: 08S01
2023-01-26 14:21:17,923 ERROR [pool-1-thread-1] de.bender_dv.ardgate.database.ArdConnection: 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.
2023-01-26 14:21:17,923 ERROR [pool-1-thread-1] de.bender_dv.ardgate.application.ARCN0100Handler: failed!
de.bender_dv.ardgate.database.ConnectException: Connect to database failed
at de.bender_dv.ardgate.database.ArdConnection.connect(ArdConnection.java:149)
at de.bender_dv.ardgate.application.ARCN0100Handler.getOutFormat(ARCN0100Handler.java:62)
at de.bender_dv.ardgate.application.ArdHandler.performWork(ArdHandler.java:45)
at de.bender_dv.jvagate.communication.Sender.run(Sender.java:109)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:825)
2023-01-26 14:21:17,927 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Sender: connected to DataQueue (system: AS400 (system name: 'LOCALHOST' user ID: 'QSECOFR'):com.ibm.as400.access.AS400@71ee07d0 path: /QSYS.LIB/JVAGATE.LIB/R040155.DTAQ):com.ibm.as400.access.DataQueue@6212653b
2023-01-26 14:21:18,106 INFO [main] de.bender_dv.jvagate.communication.Receiver: getOrder
2023-01-26 14:21:18,106 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Sender: $$$$$ R040155 $$$$$
2023-01-26 14:21:18,107 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Sender: Event ARDPGM
2023-01-26 14:21:18,107 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Request: Event set to: ARDPGM
2023-01-26 14:21:18,107 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.application.ArdHandler: Request: de.bender_dv.jvagate.communication.Request@adb26163
2023-01-26 14:21:18,108 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ArdInFormat: interfaceLevel: 1
2023-01-26 14:21:18,108 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ArdInFormat: inFormatName: ARDI0100
2023-01-26 14:21:18,108 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ArdInFormat: lengthOfInFormat: 32
2023-01-26 14:21:18,108 INFO [pool-1-thread-1] de.bender_dv.ardgate.application.ArdHandler: Format: ARDI0100 ArdGate Version: 2022-05-06
2023-01-26 14:21:18,108 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.application.FormatHandlerFactory: Name: ARDI0100
2023-01-26 14:21:18,109 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.application.ARDI0100Handler: ARDI0100 [B@13d790a1
2023-01-26 14:21:18,110 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.GenericArFormat: outBufferSize: 16776639
2023-01-26 14:21:18,110 INFO [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.GenericArFormat: * UNOMAGLIA :2 ***
2023-01-26 14:21:18,111 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARDI0100Format: reserved:
2023-01-26 14:21:18,111 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.ARDI0100Format: disconnectType: 4
2023-01-26 14:21:18,111 ERROR [pool-1-thread-1] de.bender_dv.ardgate.application.ARDI0100Handler: failed!
java.lang.NullPointerException
at de.bender_dv.ardgate.application.ARDI0100Handler.getOutFormat(ARDI0100Handler.java:65)
at de.bender_dv.ardgate.application.ArdHandler.performWork(ArdHandler.java:45)
at de.bender_dv.jvagate.communication.Sender.run(Sender.java:109)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
at java.lang.Thread.run(Thread.java:825)
2023-01-26 14:21:18,112 INFO [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLCode: -596
2023-01-26 14:21:18,113 INFO [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.SqlcaBean: SQLState: 01002
2023-01-26 14:21:18,113 DEBUG [pool-1-thread-1] de.bender_dv.ardgate.pords2pojo.SqlcaBean: sqlErrd3 0
2023-01-26 14:21:18,114 INFO [pool-1-thread-1] de.bender_dv.jvagate.communication.Sender: connected to DataQueue (system: AS400 (system name: 'LOCALHOST' user ID: 'QSECOFR'):com.ibm.as400.access.AS400@71ee07d0 path: /QSYS.LIB/JVAGATE.LIB/R040155.DTAQ):com.ibm.as400.access.DataQueue@4d54e87c

[Dieter Bender]

from the ArdGate perspective, config seems to work. Your error seems to be related to your MySQL configuration or firewall settings. Try to connect to your MySQL database from anozjer box in the network using SQuirreL od DBeaver. Maybe you will find hints here:
https://stackoverflow.com/questions/6865538/solving-a-communications-link-failure-with-jdbc-and-mysql

Dieter

[Dieter Bender]

closed: no repsonse from creator!