MySQL Forums
Forum List  »  MySQL Workbench

JDBC Connection
Posted by: Guy Thomas
Date: November 21, 2018 03:14AM

So I am attempting to connect to MySql version 8 using a Google App Script.
I can connect to the Database with various other means without a problem.
Using a script - it fails to connect every time... two other IT professionals of my acquaintance have been involved with me on this now and still cant get it working...

NOTE: My Windows firewall software is configured to allow ALL connections via port 3306.

I note in the Workbench under Server variables/ Networking Stats... each time I run the script to connect to the database.. I see 'Connections' and 'Aborted_Connects' increment by one each time. Where can I interrogate the logs to find out EXACTLY why the connections are being aborted...?


In an attempt to get this working I have set the following in My.INI :

skip-name-resolve
port = 3306
mysql_firewall_mode = off

If I check the Server log I see with each connection attempt:
'IP Address__.__.__.__ could not be resolved. No such host is known'

1) Given that I have 'skip-name-resolve' stated in the .ini file, why am I seeing this error?

I have cleared the LOG file, restarted the service and attempted to connect 3x times... log is shown below.. does this give anyone any ideas why I am having all this trouble...?? Thanks in advance for any help you can give. I am desperate to get this working (and running out of time...)


2018-11-21T09:12:07.946772Z 0 [Warning] [MY-000076] [Server] option 'shared_memory': boolean value '' was not recognized. Set to OFF.

2018-11-21T09:12:07.946916Z 0 [Warning] [MY-000081] [Server] option 'read_buffer_size': unsigned value 0 adjusted to 8192.

2018-11-21T09:12:07.946939Z 0 [Warning] [MY-000081] [Server] option 'read_rnd_buffer_size': unsigned value 0 adjusted to 1.

2018-11-21T09:12:07.947126Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2018-11-21T09:12:07.953788Z 0 [System] [MY-010116] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe (mysqld 8.0.13) starting as process 2976

2018-11-21T09:12:11.865322Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.

2018-11-21T09:12:12.012564Z 0 [System] [MY-010931] [Server] C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqld.exe: ready for connections. Version: '8.0.13' socket: '' port: 3306 MySQL Community Server - GPL.

2018-11-21T09:12:12.053318Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060

2018-11-21T09:12:30.458575Z 8 [Warning] [MY-010055] [Server] IP address '173.194.100.162' could not be resolved: No such host is known.

2018-11-21T09:12:32.945671Z 9 [Warning] [MY-010055] [Server] IP address '173.194.100.97' could not be resolved: No such host is known.

2018-11-21T09:12:35.247980Z 10 [Warning] [MY-010055] [Server] IP address '173.194.100.164' could not be resolved: No such host is known.

Options: ReplyQuote


Subject
Views
Written By
Posted
JDBC Connection
60
November 21, 2018 03:14AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.