Re: Troubleshooting a JDBC connection

I found this:

http://blog.godaddyhosting.com/2007/03/07/mysql-41-and-50-for-shared-hosting.aspx#comment-321235

It says that, as of a bit over a year ago GoDaddy blocks the port.

BigLee


--- On Fri, 7/25/08, Richard O. Hammer <[email protected]> wrote:

> From: Richard O. Hammer <[email protected]>
> Subject: Re: [Juglist] Troubleshooting a JDBC connection
> To: "Java Users Group" <[email protected]>
> Date: Friday, July 25, 2008, 5:28 AM
> I have used telnet as a troubleshooting tool in cases where
> I knew the 
> protocol.  For instance in a DOS command prompt window I
> type:
> C:\>  telnet earthlink.net 25
> And then I can interact with Earthlink's SMTP server,
> which answers on 
> port 25, by typing SMTP commands.  It is possible to send
> email messages 
> this way if you know the SMTP.
> 
> Unfortunately I don't know any JDBC.  But I just tried
> 
> C:\>telnet secureserver.net 3306
> 
> and in response got
> 
> Connecting To secureserver.net...Could not open connection
> to the host, 
> on port 3306: Connect failed
> 
> Perhaps that port has no server answering, at least not
> connections from 
> my IP address.
> 
> 
> Rich Hammer
> 
> 
> Robert J. Cameron wrote:
> > On a personal project, I am using a MySQL database
> hosted by GoDaddy. I would really like to manipulate the
> database from my dev machine. I have tried the Eclipse
> plugins Quantum and EclipseSQL with no luck. Both appear to
> be timing out.
> > 
> > I have seen some speculation online that GoDaddy does
> not allow remote access to hosted databases, but no one I
> can find has said this definitively. (Wouldn't that
> manifest itself as "Connection Refused", not
> "Connection Timed Out"?) What I know for sure is
> that I'll get no help from them. They only support
> their online admin tool, which is OK, but I'd really
> like to do it all from Eclipse.
> > 
> > My connection string looks like this:
> > 
> > jdbc:mysql://p41mysql57.secureserver.net:3306/dbname
> > 
> > I've also tried:
> > 
> >
> jdbc:mysql://user:pass-0VCB3zs9OV+crqEuOn8uL5TO9Ttj0Xgd0e7PPNI6Mm0@public.gmane.org:3306/dbname
> > 
> > I've also tried not specifying the port number,
> since it's not clear what port they are using.
> > 
> > I feel like there's a lot of "stuff"
> between me and connecting to the database. I'd like to
> remove as many variables as possible and concentrate on the
> connection. Is there some sort of simple command-line
> utility that will let me play with the connection string
> and just let me see if I can connect? Anyone have any other
> troubleshooting ideas?
> 
> 
> _______________________________________________
> Juglist mailing list
> [email protected]
> http://trijug.org/mailman/listinfo/juglist_trijug.org