SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
MYSQL connection problem

 
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite View previous topic
View next topic
MYSQL connection problem
Author Message
owensjim



Joined: 08 Aug 2011
Posts: 49

Post MYSQL connection problem Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
Please google for
Jdbc mysql url

All links on the first page with results provide some examples
Wed Aug 17, 2011 1:06 pm View user's profile Send private message
owensjim



Joined: 08 Aug 2011
Posts: 49

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
":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 View user's profile Send private message
owensjim



Joined: 08 Aug 2011
Posts: 49

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

2011-08-19 14:55:37,839 [AWT-EventQueue-0] DEBUG com.softtreetech.jscheduler.ui.C.I.O0OO - testConnection():
com.softtreetech.jscheduler.common.SchedException: 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(N

here is the connection that I attempted:

Fri Aug 19, 2011 3:42 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
owensjim



Joined: 08 Aug 2011
Posts: 49

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

thanks
Fri Aug 19, 2011 4:26 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » 24x7 Scheduler, Event Server, Automation Suite All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.