Re: Troubleshooting a JDBC connection

Looks like Lee's googling is better than mine -- I guess that's why he's the president. GoDaddy blocks direct access to the port. The SSH workaround sounds really cool, but they block SSH too.

I'd really like to get at the db from Eclipse, but it looks like I'll have to settle for phpMySqlAdmin for now.


--- On Fri, 7/25/08, Justis Peters <[email protected]> wrote:

> From: Justis Peters <[email protected]>
> Subject: Re: [Juglist] Troubleshooting a JDBC connection
> To: "Java Users Group" <[email protected]>
> Date: Friday, July 25, 2008, 4:46 PM
> Robert (the OP),
> 
> What you probably want is SSH port forwarding. Can you get
> an SSH 
> connection to the host? If so, you want to run something
> along the lines 
> of this:
>   ssh -L 3306:localhost:3306 myuser-SPXQTMr/SINWk0Htik3J/[email protected]
> 
> That will take all traffic that is directed at port 3306 on
> your local 
> computer and send it to localhost:3306 on the remote host 
> (somehost.com). Then, you can point eclipse to an instance
> of mysql 
> which appears to be running on localhost, even though
> it's remote. If 
> you build this tunnel often, you might consider automating
> this 
> connection and having it fork into the background.
> 
> These articles appear decent, if you want some more
> details:
>   http://www.securityfocus.com/infocus/1816
>  
> http://www.onlamp.com/pub/a/onlamp/excerpt/ssh_11/index3.html
>   
> http://www.ssh.com/support/documentation/online/ssh/adminguide/32/Port_Forwarding.html
> 
> Kind regards,
> Justis Peters
> 
> T.A. Nguyen wrote:
> > The other things is about hosted environment is that
> if your database
> > happen to be on the same server, you should always use
> the "localhost".  9
> > out of 10 time, most of the localhost ports are NOT
> blocked.
> >
> > Regards,
> > T.A. Nguyen
> > CN Consulting Inc.
> > 2821 Brentwood Rd, Raleigh, NC 27604
> > Tel: 919-427-9540
> > Fax: 818-827-1728
> > http://www.linkedin.com/in/nguyenta
> >
> >
> >   
> >> The simple method that Richard describe, I used
> that everyday.  Same with
> >> most TCP/IP port connectivity.  If you can get
> there, there is a
> >> connection.  I would do the telnet check first, it
> that not working then
> >> check your FIREWALL (local and gateway machines)
> settings to make sure
> >> that port isn't being blocked in anyway. 
> Temporary disabling your
> >> personal firewall to test is also another way.
> >>
> >> good luck,
> >> T.A. Nguyen
> >> http://www.LinkedIn.com/in/nguyenta
> >>
> >>
> >>     
> >>> 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
> >>>>         
> >
> >
> > _______________________________________________
> > Juglist mailing list
> > [email protected]
> > http://trijug.org/mailman/listinfo/juglist_trijug.org
> >
> >
> >   
> 
> 
> _______________________________________________
> Juglist mailing list
> [email protected]
> http://trijug.org/mailman/listinfo/juglist_trijug.org