We have a need to set up a userid on job scheduler for MySQL. We are receiving the following error. Can you tell us what is expected for this message, we tried several different url’s and the XXX5R url IP address.

thanks

Wed Aug 17, 2011 12:44 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6509

Please google for
Jdbc mysql url

All links on the first page with results provide some examples

Wed Aug 17, 2011 1:06 pm

owensjim

Joined: 08 Aug 2011Posts: 49

We are still having issues trying to connect. We have tried several different versions of the URL and receive the same message.
I have not located the jdbc.log that was referenced in a previous post. The Debug log does not show any messages.

We have traced turned on.

Suggestions??

Fri Aug 19, 2011 1:36 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6509

":thin:" is not needed in the URL. I'm not sure where you picked that. Just googled for "jdbc mysql url" and all top results returned for my search show the same thing

jdbc:mysql://[host][,failoverhost...][:port]/[database]

I'm happy to help you to build the complete URL, but cannot do as all your screenshots blank the actual server name

Fri Aug 19, 2011 1:48 pm

owensjim

Joined: 08 Aug 2011Posts: 49

I took out thing, the connection failed with lots of the following information:

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(N

here is the connection that I attempted:

Fri Aug 19, 2011 3:42 pm

SysOpSite Admin

Joined: 26 Nov 2006Posts: 6509

It looks like you have a firewall blocking database connections from the scheduler system on port 3306

To verify that hypothesis, on the system running 24x7, open command prompt and execute telnet nas5r 3306 If you get connection failed error, the port is not reachable. If you get something else, please let us know.

Fri Aug 19, 2011 4:15 pm

owensjim

Joined: 08 Aug 2011Posts: 49

we could not telnet to the port. will get with our systems folks about the firewall suggestion and go forward.