Database access from NAT network

[Sarah Reichelt]

Hi Devin,

The problem shouldn't be your home router - it only blocks incoming 
stuff.
It is very strange that your connection attempt worked a couple of 
times. I would suspect either the firewall settings on your OS X 
server, the firewall settings on the work router (if any) or the 
privileges settings on the MySQL server itself.

When you grant privileges to the MySQL server, you have to specify the 
IP address the person will be connecting from. This can be a single 
address, a range, a subnet or set to allow connection from anywhere. 
Have a look at this to see if that could be the problem.

Cheers,
Sarah

On 18 Apr 2005, at 9:44 AM, Devin Asay wrote:

> 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
> Humanities Technology and Research Support Center
> Brigham Young University
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>