Re: mysql_connect does not connect

On Thursday 16 September 2004 05:06, Sam Hobbs wrote: > It is my understanding that the firewall is not supposed to be relevant. I It is our experience at my employer that the firewall in XP-SP2, as well as other firewalls that are available, are very relevant. > have not seen anything saying it is supposed to be. We also have not seen any documentation about "problems" with such things after installing SP2, but we have problems. Things that worked before don't work any more, especially client side things. Our three small Windoze servers have given our Windoze administrator more than enough work recently. > If it is true that it > is not supposed to be relevant, then simply saying it is just causes > confusion. If you had said that the firewall is not supposed to be > relevant, but try disabling it anyway, then I would say that I am totally > able to think like that too. It is reasonable to try things like that to > diagnose a bug. flame blocked by firewall..... > If you can find something in the MySQL documentation saying that the > firewall needs to be disabled eventhough the server and client are the same > system, then that would sure help. I am not asking you to; I am saying that > that is what would help. SP2 is so new that its effects are still being evaluated by a lot of people. At the moment, I think the best place to get information about its effects is forums like this one. Formal documentation will be updated in time as more experience is gained. The info I got from our Windows admin is that with SP2, the MS SQL server on one machine was apparenty unaffected, but the MySQL on another was. Dropping the MS Firewall in SP2 allowed connections again. Client side, SP2 has caused nothing but problems for us to the point where we as administrators are now saying to our users "it was working before you installed SP2, and after you installed SP2 it stopped working, so it's your problem". IE is especially problematic, and when someone calls up and says they have a problem with IE and have installed SP2, our response is that we no longer support IE and tell the users to install Mozilla, and if they still have problems when they try Mozilla, they can call us back. We haven't heard from any of them again, and our help desk girls have always been able to quickly sort out the problems users have when they first try Mozilla. I looked back in this thread and saw that you used Zone Alarm as a firewall. You need to allow MySQL connections to localhost, and that regardless of which firewall you use. If you filter such connections out, PHP scripts will not be able to connect to your MySQL server. This is because PHP makes a TCP connection to the MySQL server, also when it is running on the same machine as you PHP/Apache (at least this is my understanding). You can of course continue refuse all external (that is not from localhost) connections to whatever service is running on your machine. I think something to this effect has already been said in this thread, but at the moment I don't want to search for the post. While the flame war in this thread has been amusing to read, it's amusement value for me has more or less run out. My impression is that you still don't have the thing working, and the only solution left is to configure your firewall to allow connections to your MySQL server from localhost. If you would do this, and it works, please post to the list to reflect this. My experience as an administrator tells me with a 99% certainty that this is your problem. regards Markus