Database access from NAT network

[Devin Asay]

I realized I neglected to include the error revdb was returning: "Revdb 
Error: Lost connection to MySQL server during query."

Thanks, Sarah and Len, for your suggestions. I'll check those out. It 
may be that the university is blocking port 3306. (though that wouldn't 
explain why I was able to connect twice.)

Devin

On Apr 17, 2005, at 7:15 PM, Sarah Reichelt wrote:

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