Database access from NAT network

[Len Morgan]

MySQL uses port 3306 by default so if you don't have that port open on the network you're trying to connect to, you're going to have problems.  It's possible that the long delay is a DNS issue.  I don't use mySQL myself but lots of programs (ssh, ftp, etc) get really slow if DNS isn't working right.

I don't think there is anything you need to do on your end with your router unless you are blocking outgoing connections (not a common default setting).  As far as "what port does revdb process use", if it's talking to mySQL, it's going to use 3306 unless you tell it otherwise.

You might search for a port scanner to run from home and see if port 3306 is in fact open to the outside world.

I know this isn't much help but maybe it can get you started...

len morgan



> Hi, I'm having trouble accessing a MySQL database. I'm on OS X 10.3.8 
> and Rev 2.5/2.5.1.
>
> I am not able to access either of my MySQL servers at work from my home 
> network. They are both on MAC OS X servers on publc IP addresses. I can 
> reach them from home via SSH, FTP, AFP, HTTP and others. For example I 
> can SSH into a server and run the mysql command line process. But any 
> time I try to connect to a database through Rev, the request simply 
> hangs, with a spinning lollipop, for several minutes until I finally 
> get an error message " "
>
> Strangely enough, twice (out of maybe 12 tries) the database connected 
> successfully. The connection took a long time to establish, then each 
> query takes a similarly long time (5+ minutes.)
>
> Is the process simply timing out?
>
> Might there be ports closed that need to be open on my home router? 
> (What port do revdb processes use?)
> 
> Anybody give me any tips for how to configure my router (an SMC 
> Barricade G wireless router) to speed up/unblock or whatever access to 
> these db servers?
>
> Devin Asay