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