Re: [PHP] mysql_connect does not connect
On Wednesday 22 September 2004 03:43, Chris Dowell wrote: Sam Hobbs wrote: I am not assuming; that is why I am asking this question. You really can say the same thing except without the emotions. You can simply state the fact that as far as you know it is not a PHP problem. It really, really helps to keep in mind that it is better to simply state facts. That keeps things less emotional and generally keeps things at a more reasonable level. What is ironic is that our protagonist keeps urging everyone to stay rational and not go all emotional when throughout the thread he has repeatedly demonstrated that it was he who was irrational and emotional. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* QOTD: I'll listen to reason when it comes out on CD. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
[snippy] Sam Hobbs wrote: Um.. you do realize you have more problems than php not being able to connect to the database. This is the type of unproductive comment that causes problems. The only reason you are saying this is because you are desperate to make me wrong. You have exhausted reasonable comments and must resort to unreasonable ones. That sure is a problem here. [/snippy] On the contrary, Sam - yours is a comment that is more likely to cause problems - the inevitable backlash of hatred directed at you is founded solely in your mistaken assumption that you alone are correct. If that's truly the case, then why are you asking a bunch of feeble-minded jerks like ourselves for help? We have difficulty enough tying our shoelaces. Since you *have*, misguidedly or otherwise, chosen to come to this list for help, you could have the decency to thank everyone for their suggestions. You asked for our help and we're trying to supply it - if you've tried something already, even if we're just completely and utterly wrong, we've still taken time out of our day, solving our problems to pay our bills in order to help you solve yours. Will you at least have the courtesy to explain how you fixed the problem - that way we can avoid having this conversation again when someone else has the same issue. Cheers Chris p.s. I noticed that you also shouted down Rasmus in a post on the PHP Internals list. You say you're primarily a C++ programmer - would you try and tell Bjorn Stroustroup to shut up? I particularly like this, from that list: [snippy] This is possible and if so then I agree that it is not a php problem and there is not much more for php to do than to give a hint somewhere. [/do you know, some days I feel like a hairdresser] Especially given your reaction when Rasmus suggested exactly that [snippy once more] Rasmus Lerdorf [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I am not sure why you assume this to be a PHP problem. I thought I was being reasonable. I thought I was clear about saying I was not sure it is a PHP problem. I was trying to help by helping diagnose a problem. If it is not a problem then you could say so in a more reasonable manner. If you always react to people this way when they are trying to help then you will have an inferior product since you discourage people from helping. I am not assuming; that is why I am asking this question. You really can say the same thing except without the emotions. You can simply state the fact that as far as you know it is not a PHP problem. It really, really helps to keep in mind that it is better to simply state facts. That keeps things less emotional and generally keeps things at a more reasonable level. [/no more snippy] p.p.s I realise I haven't helped at all, but you're funny and I'm glad of the light relief you inadvertently provide. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql_connect does not connect
[snip] I definitely mind. I don't believe in rewarding bad behavior. It is reasonable to contribute to the productive development of solutions, but the attitude in this group is not productive. I have the impression that the real reason you want answers is so that you can continue in unproductive directions. [/snip] Sam, You have nmentioned the word 'insistance' many times in this thread, and the only one I found to be obstinate about things is you. Continue in unproductive directions? What is that about, sport? Rewarding bad behavior? Regardless of the fact that there might be several who could benefit from the solution (who had nothing to do with the folks you are so against right now) you are now the one exercizing unproductive behavior. JB -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
I definitely mind. I don't believe in rewarding bad behavior. It is reasonable to contribute to the productive development of solutions, but the attitude in this group is not productive. I have the impression that the real reason you want answers is so that you can continue in unproductive directions. Boy, for someone who has over 12k posts on some VC++ forum, you don't seem to have a positive and productive attitude here. Personally, I just think your an arogant ass. BTW, for those of you who can't read between the lines, this means it was a firewall issue. Egads! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Sam Hobbs wrote: Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Would you mind spilling the beans? I'm sure everyone is dying to know what the resolution of this thread is. I definitely mind. I don't believe in rewarding bad behavior. It is reasonable to contribute to the productive development of solutions, but the attitude in this group is not productive. I have the impression that the real reason you want answers is so that you can continue in unproductive directions. This is a totally foolish remark! You make yourself no better than the 'helpers' that 'don't help' you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Raditha Dissanayake [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam Hobbs wrote: I have posted over 12,000 messages in the CodeGuru.com Visual C++ forum, Do you have a life ? I hope the moderators protest posts such as this. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Sam Hobbs [EMAIL PROTECTED] wrote: Raditha Dissanayake [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam Hobbs wrote: I have posted over 12,000 messages in the CodeGuru.com Visual C++ forum, Do you have a life ? I hope the moderators protest posts such as this. i protest thats for sure, Raditha, please do not post rhetorical questions to the list :) Jason -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Would you mind spilling the beans? I'm sure everyone is dying to know what the resolution of this thread is. I definitely mind. I don't believe in rewarding bad behavior. It is reasonable to contribute to the productive development of solutions, but the attitude in this group is not productive. I have the impression that the real reason you want answers is so that you can continue in unproductive directions. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Sam Hobbs wrote: Raditha Dissanayake [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam Hobbs wrote: I have posted over 12,000 messages in the CodeGuru.com Visual C++ forum, Do you have a life ? I hope the moderators protest posts such as this. Moderators? You're in the land of anarchy here. ;) -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
uh huh.. was it your firewall :) :) it was wasnt it.. im so bad, im so bad it hurts, but i solved your problem, so come on, a cookie or something..pat on the head, or how about, thanks for helping. Jason Sam Hobbs [EMAIL PROTECTED] wrote: Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Would you mind spilling the beans? I'm sure everyone is dying to know what the resolution of this thread is. I definitely mind. I don't believe in rewarding bad behavior. It is reasonable to contribute to the productive development of solutions, but the attitude in this group is not productive. I have the impression that the real reason you want answers is so that you can continue in unproductive directions. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Curt Zirzow [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] * Thus wrote Sam Hobbs: And the relevant portion of that says external access, which is not applicable here. I do not see anything else on that page that is relevant. what is relevant? only the last one? :sigh: I don't know. Ask them, not me. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Curt Zirzow [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Um.. you do realize you have more problems than php not being able to connect to the database. This is the type of unproductive comment that causes problems. The only reason you are saying this is because you are desperate to make me wrong. You have exhausted reasonable comments and must resort to unreasonable ones. That sure is a problem here. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Being obstinate and contrarian does nothing to help resolve your problem. This is more unnecessary and unproductive comments. Since you did not have something relevant and productive to say the best thing to do is say nothing. I hope the moderators agree. Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? You paraphrased version is not accurate. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Steve Brown [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam, if you wouldn't mind answering a question: are you still unable to connect to your mysql server? I am able to connect now. I'm sorry that you feel its a time-consuming process. I'm sorry that you are confused about the involvement of the firewall. I'm sorry that you feel you know better than everyone on this list. Just try this and prove us wrong. The problem is that people's insistance. It was people's reaction when I said I thought it was not relevant. There was a lot of stuff said that was unnecessary. People could have simply said to try it, without the criticism. To the extent that I was wrong, the apporopriate thing to do is to state whatever facts are relevant and then give me a chance to use that information. I have posted over 12,000 messages in the CodeGuru.com Visual C++ forum, and about 99% of the messages were efforts to help people. I know that there are people that will not listen. When a person will not listen, it is a big mistake to insult them. The attitude in this group would cause a serious flame war if someone were truly not listening. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Sam Hobbs wrote: I have posted over 12,000 messages in the CodeGuru.com Visual C++ forum, Do you have a life ? -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 128 KB | with progress bar. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Matthew Sims [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You should check as XP SP2 firewall is turned on by default. http://support.microsoft.com/default.aspx?kbid=842242 Saying You should check assumes I did not check. I did check. I said as far as I know it is off. I am sorry that that does not state explicitly that I checked, but if I had not checked it then I would have stated explicitly that I did not. What I meant is that I don't see anything saying that the firewall is on. When I go to whereever it is that the firewall is configured, it is off. The only reason I am confused is because there are events in the security log complaining about use of some ports and I don't understand that. The messages seem to be produced in spite of the Windows firewall being off. I did explicitly turn off the Windows firewall soon after installing ZoneAlarm over two years ago and again after SP2 was installed. Note that XP has always had a firewall, it just has been improved and made reasonably useful in SP2. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Saturday 18 September 2004 21:04, Sam Hobbs wrote: Steve Brown [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam, if you wouldn't mind answering a question: are you still unable to connect to your mysql server? I am able to connect now. Would you mind spilling the beans? I'm sure everyone is dying to know what the resolution of this thread is. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Of course there's no reason for it, it's just our policy. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
That is the type of comment that causes problems. Reasonable and knowledgable people know it is not true and saying it just causes problems. Of course, many people would advise to just ignore comments such as that and I will in the future. I just want to make it clear for the benefit of others that this is the type of comments that has caused problems. Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Sam Hobbs wrote: Steve Brown [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Sam, if you wouldn't mind answering a question: are you still unable to connect to your mysql server? I am able to connect now. I'm sorry that you feel its a time-consuming process. I'm sorry that you are confused about the involvement of the firewall. I'm sorry that you feel you know better than everyone on this list. Just try this and prove us wrong. The problem is that people's insistance. It was people's reaction when I said I thought it was not relevant. There was a lot of stuff said that was unnecessary. People could have simply said to try it, without the criticism. To the extent that I was wrong, the apporopriate thing to do is to state whatever facts are relevant and then give me a chance to use that information. I have posted over 12,000 messages in the CodeGuru.com Visual C++ forum, and about 99% of the messages were efforts to help people. I know that there are people that will not listen. When a person will not listen, it is a big mistake to insult them. The attitude in this group would cause a serious flame war if someone were truly not listening. I'm SO not listening to you... ;) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re[2]: [PHP] mysql_connect does not connect
Hi All, I don't normally bother with these kind of meaningless threads as they waste valuable electrons but I did find this interesting http://www.urban75.com/Mag/troll.html PS This is not a dig at you Jason, it's just your post is the only one I didn't delete :) -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Re[2]: [PHP] mysql_connect does not connect
I may be unnaturally ugly (to the extent my mother cried when she held me), and so i have a little extra hair here and there.. and my hands are like hams.. but im no troll :P :P Jason Tom Rogers [EMAIL PROTECTED] wrote: Hi All, I don't normally bother with these kind of meaningless threads as they waste valuable electrons but I did find this interesting http://www.urban75.com/Mag/troll.html PS This is not a dig at you Jason, it's just your post is the only one I didn't delete :) -- regards, Tom -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
oh booh, i replied to that, explicitly detailing you can simply allow an open port for mysql rather than drop the whole firewall. Yes this type of comment cuases problems, or in your case, fixes your problem... at least your mysql connection one. so are you saying im unreasonable, and unknowledgable, me, the person who although blasted with a few emails, telling me i dont understand how localhost works, had the correct solution to your problem .. thanks sam, glad to be of service. BTW, good posts on PHP Internals, have you noticed that the whole world is irrelevent and unreasonable, well, except for you Jason Sam Hobbs [EMAIL PROTECTED] wrote: That is the type of comment that causes problems. Reasonable and knowledgable people know it is not true and saying it just causes problems. Of course, many people would advise to just ignore comments such as that and I will in the future. I just want to make it clear for the benefit of others that this is the type of comments that has caused problems. Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql_connect does not connect
This has got to be one of the funniest threads I've seen on the PHP list in a really long time. However, unless someone can come up with more humorous replies, I vote that it be killed. -Ed -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: Saturday, September 18, 2004 10:35 AM To: Sam Hobbs; [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect oh booh, i replied to that, explicitly detailing you can simply allow an open port for mysql rather than drop the whole firewall. Yes this type of comment cuases problems, or in your case, fixes your problem... at least your mysql connection one. so are you saying im unreasonable, and unknowledgable, me, the person who although blasted with a few emails, telling me i dont understand how localhost works, had the correct solution to your problem .. thanks sam, glad to be of service. BTW, good posts on PHP Internals, have you noticed that the whole world is irrelevent and unreasonable, well, except for you Jason Sam Hobbs [EMAIL PROTECTED] wrote: That is the type of comment that causes problems. Reasonable and knowledgable people know it is not true and saying it just causes problems. Of course, many people would advise to just ignore comments such as that and I will in the future. I just want to make it clear for the benefit of others that this is the type of comments that has caused problems. Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The firewall is relevant depending on your circumstances. In any case it would take you all of one minute to disable your firewall to test out this wild far out suggestion. At the most you would have lost one minute but you would have either: - gained the satisfaction of saying I told you the firewall was irrelevant, now go away and stop wasting my time with your ridiculous suggestions or - you would have found the cause of your problem It definitely takes more than a minute. It takes nearly a minute just to logoff one user and I often have another user, the Administrator account, also logged in. If the Administrator account is not lgged in already, then I must log in to it to shutdown ZoneAlarm. Then the system must shutdown and restart. While that is happening, I must unplug the cable modem to ensure I get nothing from/to the outside, but that can be done in parrallel with system shutdown. However I must stay at the system while this is happening; I prefer to unplug the cable after the system disconnects from the modem. Then I must log in to at least one account and start a few things, such as Apache. Relatively speaking, Apache starts immediatley, so it is not very relevant, but it does take time for my system to start. Then after the test I must restart ZoneAlarm, restart the system and be sure to plug the modem back in while the system starts. The whole operation is likely to take nearly a half hour at least. Contrast that with the number of posts you have made denying that the firewall could be a problem, and stating adamantly that you will not do such-and-such a thing because it is 'not supposed' to happen like that. The problem is all the people that persist in saying the same thing. I am smart enough to think of the things being suggested. It is the type of thing that is very easy to suggest. I get frustrated by people suggesting things just because they are easy to suggest. Therefore when people make a suggestion that is more likely to be relevant it is difficult for me to determine which ones are worthwhile. And again, I am able to think of things such as eliminating the firewall as a possibility. It is okay for people to suggest that, but unless they can show me something that clearly says it is relevant, then they won't accomplish anything by insisting. One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. The most important thing is that unless people give me a clear explanation of what they are saying, it is useless to insist. I don't mind a suggestion as much as it is the insisting that causes problems. Therefore from my point of view, it is the insistance by others that keep the discussion going (in useless directions). There is one person in particular that tries too hard to help and then when I politely say I am getting too much help I get criticized. That is not a productive attitude. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Markus Mayer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] It is our experience at my employer that the firewall in XP-SP2, as well as other firewalls that are available, are very relevant. Thank you. I have not seen anything that states that explicitly. I doubt that SP2 makes a difference; the main reason I mentioned it is just to be thorough. I am nearly certain that the XP firewall, including the XP-SP2 version, is turned off. 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. Supposedly there is something that is about 30 pages that lists hundreds of incompatibility problems. Therefore it is likely that most of the don't work any more problems are identified by Microsoft. flame blocked by firewall. Then ignore it. Just calling it a flame is likely to add fuel. I prefer to limit the discussion to facts, which is not happening in this discussion. The word flame is usually an unnecessary emotional expression 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. Again, I doubt that SP2 is actually relevant, especially if I am correct that I am not using the firewall. If I am correct that it is not relevant, then dwelling on it is the type of thing causes confuson about what is usefull I am not aware of any problem caused by SP2 except that it makes a little more work for me due to it's increased security and ti complains about a few things that I see no reason for it to complain about. I hope that if it is causing a problem I will be able to determine that but so far I have no reason to believe SP2 is relevant here. 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. Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. 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. Again, it is unproductive to repeat the same thing over and over. When someone repeats it, I have a tendency to respond to that. We have now gotten to the point where the discussion is unproductive. It
Re: [PHP] mysql_connect does not connect
It is innacuracies such as this that make it difficult for me to pursue the useful suggestions. Chris Dowell [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] All this is irrelevant; while you're still trying to use MySQL 5 with mysql_connect() instead of mysqli_connect(), it WILL NEVER WORK Sort that out first before you start worrying about firewalls - you can't test the firewall if you can't ever have a successful test case. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] IIRC the OP did have a successful test case when connecting from the mysql client. Yes, I did get it to work. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
John Nichel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The MySQL functions work fine in php5. It just doesn't support all the features available in MySQL = 4.1.0. Unlike php4, support for MySQL isn't bundled in php5, but when enabled, it works. Thank you. I will try to remember that everything you say is very likely to be useful and accurate. As far as I can remember, all that I had to do to enable the mysql extension is to uncomment the line for the extension in php.ini and add php to my path. However I had problem initially and it was caused by the (Windows) registry entry that also specifies the path (to php.ini?), so for new installations that registry entry might be important too. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] IIRC the OP did have a successful test case when connecting from the mysql client. For whomever is interested, see my mess(ages) in the php internals. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Fw: [PHP] mysql_connect does not connect
Sam Hobbs [EMAIL PROTECTED] wrote in message One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. You are correct about that. Personally, I not satisfied with the level of support I get from the people paid to monitor this list and help me out when I have a problem, either. Just imagine if the people on this list were volunteers and just trying to help... good god, that'd be horrible, wouldn't it? ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
The last paragraph refers to me :) and im quite proud of it now, ive printed some of your emails out, and i keep them around, they really do make me smile, not becuase im so much an a$$hole, but becuase, youve already said, that altering your firewall allowed you to connect. Which not so coincidently, i suggested in the beginning. You call it a guess, an uneducated blunder maybe, whatever helps you sleep at night PS.. takes you half hour to drop your firewall.. sheesh,.. and for note, and honestly, for your benefit, SP2 _will_ enable a _new_ firewall on your computer, unless youve configured otherwise, there is a new security center that will complain if your firewall is not enabled, have you seen this complaint? J Sam Hobbs [EMAIL PROTECTED] wrote: Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The firewall is relevant depending on your circumstances. In any case it would take you all of one minute to disable your firewall to test out this wild far out suggestion. At the most you would have lost one minute but you would have either: - gained the satisfaction of saying I told you the firewall was irrelevant, now go away and stop wasting my time with your ridiculous suggestions or - you would have found the cause of your problem It definitely takes more than a minute. It takes nearly a minute just to logoff one user and I often have another user, the Administrator account, also logged in. If the Administrator account is not lgged in already, then I must log in to it to shutdown ZoneAlarm. Then the system must shutdown and restart. While that is happening, I must unplug the cable modem to ensure I get nothing from/to the outside, but that can be done in parrallel with system shutdown. However I must stay at the system while this is happening; I prefer to unplug the cable after the system disconnects from the modem. Then I must log in to at least one account and start a few things, such as Apache. Relatively speaking, Apache starts immediatley, so it is not very relevant, but it does take time for my system to start. Then after the test I must restart ZoneAlarm, restart the system and be sure to plug the modem back in while the system starts. The whole operation is likely to take nearly a half hour at least. Contrast that with the number of posts you have made denying that the firewall could be a problem, and stating adamantly that you will not do such-and-such a thing because it is 'not supposed' to happen like that. The problem is all the people that persist in saying the same thing. I am smart enough to think of the things being suggested. It is the type of thing that is very easy to suggest. I get frustrated by people suggesting things just because they are easy to suggest. Therefore when people make a suggestion that is more likely to be relevant it is difficult for me to determine which ones are worthwhile. And again, I am able to think of things such as eliminating the firewall as a possibility. It is okay for people to suggest that, but unless they can show me something that clearly says it is relevant, then they won't accomplish anything by insisting. One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. The most important thing is that unless people give me a clear explanation of what they are saying, it is useless to insist. I don't mind a suggestion as much as it is the insisting that causes problems. Therefore from my point of view, it is the insistance by others that keep the discussion going (in useless directions). There is one person in particular that tries too hard to help and then when I politely say I am getting too much help I get criticized. That is not a productive attitude. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP] mysql_connect does not connect
Cheers on that, this thread has become amusement, that is payment enough Jason John Holmes [EMAIL PROTECTED] wrote: Sam Hobbs [EMAIL PROTECTED] wrote in message One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. You are correct about that. Personally, I not satisfied with the level of support I get from the people paid to monitor this list and help me out when I have a problem, either. Just imagine if the people on this list were volunteers and just trying to help... good god, that'd be horrible, wouldn't it? ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP] mysql_connect does not connect
John Holmes wrote: Sam Hobbs [EMAIL PROTECTED] wrote in message One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. You are correct about that. Personally, I not satisfied with the level of support I get from the people paid to monitor this list and help me out when I have a problem, either. Just imagine if the people on this list were volunteers and just trying to help... good god, that'd be horrible, wouldn't it? ---John Holmes... Damn, it's going to be hard to tell the John's apart on this list soon. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP] mysql_connect does not connect
John Holmes wrote: Sam Hobbs [EMAIL PROTECTED] wrote in message One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. You are correct about that. Personally, I not satisfied with the level of support I get from the people paid to monitor this list and help me out when I have a problem, either. Just imagine if the people on this list were volunteers and just trying to help... good god, that'd be horrible, wouldn't it? John I think you should be fired. By skimming a few posts I have gathered that sam knows a lot more than you or the other john or chris (or the other chris) or curt et al. My appologies to the people I haven't mentioned by name but you will be getting your letters of termination shortly. ---John Holmes... -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 128 KB | with progress bar. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
snip lots of garbage OK, I'm going to jump in and try and take a stab at this. Sam, if you wouldn't mind answering a question: are you still unable to connect to your mysql server? I'll also add that your understanding of firwalls is lacking. Regardless of where your server is (local or remote), there is still a client-server relationship happening. If you are trying to connect to localhost/127.0.0.1 (use the latter as previously recommended), your system is acting as the server. ANY consumer firewall (free or otherwise) is going to block incoming packets not related to an already established connection, regardless of where they originate. Lots of consumer firewalls are going filter traffic on localhost because lots of vicious spyware out there are starting to install daemons on systems then rewiriting the HOSTS files to pull ads from the localhost rather then hitting the marketers servers. If you don't believe me, google for spyware HOSTS file. To assume that your firewall (ZoneAlarm, XP, or otherwise) is not in play here is false. At this point, you need to disable the firewall completely (just for testing) and/or find a way to open the MySQL port (port 3306) on localhost to incoming traffic in your firewall. I know that you don't think this is the problem, but the only way you are going to know is if you try. I'm sorry that you feel its a time-consuming process. I'm sorry that you are confused about the involvement of the firewall. I'm sorry that you feel you know better than everyone on this list. Just try this and prove us wrong. Steve -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Markus Mayer [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] It is our experience at my employer that the firewall in XP-SP2, as well as other firewalls that are available, are very relevant. Thank you. I have not seen anything that states that explicitly. I doubt that SP2 makes a difference; the main reason I mentioned it is just to be thorough. I am nearly certain that the XP firewall, including the XP-SP2 version, is turned off. You should check as XP SP2 firewall is turned on by default. http://support.microsoft.com/default.aspx?kbid=842242 A lot of programs are affected by this...possibly MySQL, too? Anyways, I'm telling my friends and family to steer clear of SP2 upgrade till the dust settles and the kinks are worked out. -- --Matthew Sims --http://killermookie.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP] mysql_connect does not connect
Im not a john, but to add to confusion we could all sign with 'J' Jason John Nichel [EMAIL PROTECTED] wrote: John Holmes wrote: Sam Hobbs [EMAIL PROTECTED] wrote in message One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. You are correct about that. Personally, I not satisfied with the level of support I get from the people paid to monitor this list and help me out when I have a problem, either. Just imagine if the people on this list were volunteers and just trying to help... good god, that'd be horrible, wouldn't it? ---John Holmes... Damn, it's going to be hard to tell the John's apart on this list soon. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP] mysql_connect does not connect
John Holmes wrote: Sam Hobbs [EMAIL PROTECTED] wrote in message One problem is that I get answers that are not accurate, so it is difficult to know which ones are accurate. You are correct about that. Personally, I not satisfied with the level of support I get from the people paid to monitor this list and help me out when I have a problem, either. Just imagine if the people on this list were volunteers and just trying to help... good god, that'd be horrible, wouldn't it? John I think you should be fired. By skimming a few posts I have gathered that sam knows a lot more than you or the other john or chris (or the other chris) or curt et al. My appologies to the people I haven't mentioned by name but you will be getting your letters of termination shortly. ---John Holmes... -- Raditha Dissanayake. I still haven't received my (small) paycheck for last week. -- --Matthew Sims --http://killermookie.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: Fw: [PHP] mysql_connect does not connect
[snip] Im not a john, but to add to confusion we could all sign with 'J' [/snip] I'm down with that Jay -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Steve Brown wrote: snip lots of garbage OK, I'm going to jump in and try and take a stab at this. Sam, if you wouldn't mind answering a question: are you still unable to connect to your mysql server? I'll also add that your understanding of firwalls is lacking. Regardless of where your server is (local or remote), there is still a client-server relationship happening. If you are trying to connect to localhost/127.0.0.1 (use the latter as previously recommended), your system is acting as the server. ANY consumer firewall (free or otherwise) is going to block incoming packets not related to an already established connection, regardless of where they originate. Lots of consumer firewalls are going filter traffic on localhost because lots of vicious spyware out there are starting to install daemons on systems then rewiriting the HOSTS files to pull ads from the localhost rather then hitting the marketers servers. If you don't believe me, google for spyware HOSTS file. To assume that your firewall (ZoneAlarm, XP, or otherwise) is not in play here is false. snip This is why I originally said that the firewall shouldn't matter...coming from the *nix world, it doesn't. Even if I close off port 3306 with iptables/ipchains, it's still going to allow local connections, since the request is coming from, and going too localhost. I guess with Windows, you need to close internal and external connections to be save. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: Fw: [PHP] mysql_connect does not connect
Jay Blanchard wrote: [snip] Im not a john, but to add to confusion we could all sign with 'J' [/snip] I'm down with that Jay Don't you worry, YOU'RE already on 'THE LIST'. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Hey, the reason it doesnt come in to play for you in linux, is becuase mysql by default will connect through a unix socket, and not over tcpip. The unix socket is a connection thru the filesystem and not the network. Also, in linux, there is a virtual device for lopback, and the firewall i dont beleive has any effect on the loopback device. In windows however, depending on what version, mysql will connect using tcp/ip, unless told otherwise, in this case, Sam supplied localhost to his connect function, which tells mysql explicitly to use the network over a named pipe. Jason John Nichel [EMAIL PROTECTED] wrote: Steve Brown wrote: snip lots of garbage OK, I'm going to jump in and try and take a stab at this. Sam, if you wouldn't mind answering a question: are you still unable to connect to your mysql server? I'll also add that your understanding of firwalls is lacking. Regardless of where your server is (local or remote), there is still a client-server relationship happening. If you are trying to connect to localhost/127.0.0.1 (use the latter as previously recommended), your system is acting as the server. ANY consumer firewall (free or otherwise) is going to block incoming packets not related to an already established connection, regardless of where they originate. Lots of consumer firewalls are going filter traffic on localhost because lots of vicious spyware out there are starting to install daemons on systems then rewiriting the HOSTS files to pull ads from the localhost rather then hitting the marketers servers. If you don't believe me, google for spyware HOSTS file. To assume that your firewall (ZoneAlarm, XP, or otherwise) is not in play here is false. snip This is why I originally said that the firewall shouldn't matter...coming from the *nix world, it doesn't. Even if I close off port 3306 with iptables/ipchains, it's still going to allow local connections, since the request is coming from, and going too localhost. I guess with Windows, you need to close internal and external connections to be save. ;) -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Davidson wrote: Hey, the reason it doesnt come in to play for you in linux, is becuase mysql by default will connect through a unix socket, and not over tcpip. The unix socket is a connection thru the filesystem and not the network. Also, in linux, there is a virtual device for lopback, and the firewall i dont beleive has any effect on the loopback device. In windows however, depending on what version, mysql will connect using tcp/ip, unless told otherwise, in this case, Sam supplied localhost to his connect function, which tells mysql explicitly to use the network over a named pipe. Jason Windows doesn't have a loopback device? Ye Gods, what were they thinking -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Friday 17 September 2004 23:23, Sam Hobbs wrote: Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] IIRC the OP did have a successful test case when connecting from the mysql client. Yes, I did get it to work. It would help in diagnosing your problem if you told us what connection parameters you used when connecting with the mysql client that made it work? Also did you perform those dozen tests I outlined in a previous post. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Insults are effective only where emotion is present. -- Spock, Who Mourns for Adonais? stardate 3468.1 */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Windows likely has some sort of loopback device, but i dunno how it works Ive also come accross people complaining that SP2 has funked up local connections for various server/clients. However, ive seen firewalls cuase problems for mysql on both windows and linux, so ya.. who knows... Sam knows.. apparently. :) Jason John Nichel [EMAIL PROTECTED] wrote: Jason Davidson wrote: Hey, the reason it doesnt come in to play for you in linux, is becuase mysql by default will connect through a unix socket, and not over tcpip. The unix socket is a connection thru the filesystem and not the network. Also, in linux, there is a virtual device for lopback, and the firewall i dont beleive has any effect on the loopback device. In windows however, depending on what version, mysql will connect using tcp/ip, unless told otherwise, in this case, Sam supplied localhost to his connect function, which tells mysql explicitly to use the network over a named pipe. Jason Windows doesn't have a loopback device? Ye Gods, what were they thinking -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Another test you might do , is use something like tcpdump to snif your network to see exactly how its attempting to connect, then you could ascertain on your own (as you dont beleive me) if mysql is connecting over the network or through the filesystem. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:23, Sam Hobbs wrote: Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] IIRC the OP did have a successful test case when connecting from the mysql client. Yes, I did get it to work. It would help in diagnosing your problem if you told us what connection parameters you used when connecting with the mysql client that made it work? Also did you perform those dozen tests I outlined in a previous post. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Insults are effective only where emotion is present. -- Spock, Who Mourns for Adonais? stardate 3468.1 */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Saturday 18 September 2004 02:30, Jason Davidson wrote: Hey, the reason it doesnt come in to play for you in linux, is becuase mysql by default will connect through a unix socket, and not over tcpip. The unix socket is a connection thru the filesystem and not the network. Also, in linux, there is a virtual device for lopback, and the firewall i dont beleive has any effect on the loopback device. In windows however, depending on what version, mysql will connect using tcp/ip, unless told otherwise, in this case, Sam supplied localhost to his connect function, which tells mysql explicitly to use the network over a named pipe. Further food for thought. How you originally phrased the GRANT command in mysql will (potentially) affect your ability to connect. For example grant all on database.* to [EMAIL PROTECTED] identified by 'passwd'; is different to grant all on database.* to [EMAIL PROTECTED] identified by 'passwd'; and require that you use different connection parameters (at least under Linux). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* It is through symbols that man consciously or unconsciously lives, works and has his being. -- Thomas Carlyle */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Friday 17 September 2004 22:56, Sam Hobbs wrote: It definitely takes more than a minute. It takes nearly a minute just to logoff one user and I often have another user, the Administrator account, also logged in. If the Administrator account is not lgged in already, then I must log in to it to shutdown ZoneAlarm. Then the system must shutdown and restart. While that is happening, I must unplug the cable modem to ensure I get nothing from/to the outside, but that can be done in parrallel with system shutdown. However I must stay at the system while this is happening; I prefer to unplug the cable after the system disconnects from the modem. Then I must log in to at least one account and start a few things, such as Apache. Relatively speaking, Apache starts immediatley, so it is not very relevant, but it does take time for my system to start. Then after the test I must restart ZoneAlarm, restart the system and be sure to plug the modem back in while the system starts. The whole operation is likely to take nearly a half hour at least. Correct me if I'm wrong but on my (Win98) system disabling ZoneAlarm is a simple matter of a few clicks. No need to restart Windows or anything (Your mouse has moved, you need to restart Windows for the changes to take effect). Doesn't your version of ZoneAlarm have options which allows you to quickly and simply DISABLE all internet access and ENABLE all internet access (in reality disable ZoneAlarm)? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* How untasteful can you get? */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
From: Jason Davidson [EMAIL PROTECTED] hehehe.. im actually looking forward to reading responses on this thread.. Whatever happened to those monthly stat posts? most posts, most posts per thread, etc...?? Who was doing that? I haven't seen one in a while. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Im not sure who was doing that. i missed that stuff i think. Jason John Holmes [EMAIL PROTECTED] wrote: From: Jason Davidson [EMAIL PROTECTED] hehehe.. im actually looking forward to reading responses on this thread.. Whatever happened to those monthly stat posts? most posts, most posts per thread, etc...?? Who was doing that? I haven't seen one in a while. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Amazing how long that thread is -- must be a record. Seems to be classic case of 'ignore-the-obvious' or 'my-mind-is-made-up. Don't-confuse-me-with-facts'. Perhaps I should start a new thread: [PHP} Can't get NULL to output anything! hehe Andre On Friday 17 September 2004 03:11 pm, Jason Davidson wrote: hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
John Holmes wrote: From: Jason Davidson [EMAIL PROTECTED] hehehe.. im actually looking forward to reading responses on this thread.. Whatever happened to those monthly stat posts? most posts, most posts per thread, etc...?? Who was doing that? I haven't seen one in a while. ---John Holmes... I was looking for one the other day. Curt used to do something with the stats a while back (I think), but someone else was doing it recently. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
* Thus wrote Sam Hobbs: And the relevant portion of that says external access, which is not applicable here. I do not see anything else on that page that is relevant. what is relevant? only the last one? :sigh: Curt -- The above comments may offend you. flame at will. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
John Holmes wrote: From: Jason Davidson [EMAIL PROTECTED] hehehe.. im actually looking forward to reading responses on this thread.. Whatever happened to those monthly stat posts? most posts, most posts per thread, etc...?? Who was doing that? I haven't seen one in a while. ---John Holmes... Bill Doerrfeld http://marc.theaimsgroup.com/?l=php-generalm=108359755823417w=2 STFA!!! ;) Okay, someone else's turn to hijack the thread. hehe -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
* Thus wrote Sam Hobbs: I appreciate your attempts to help, but you must understand that when attempts to help just cause time to be wasted, then it might be appropriate :sigh: Curt -- The above comments may offend you. flame at will. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
-- Original message from John Holmes : -- Whatever happened to those monthly stat posts? most posts, most posts per thread, etc...?? Who was doing that? I haven't seen one in a while. ---John Holmes... Bill Doerrfeld http://marc.theaimsgroup.com/?a=9211645541r=1w=2 STFA!!! :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
HAHAHA, this thread is awsome though, you all must admit the humor involved here. I hope this thread continues for a couple more days. or here is an idea for a thread {PHP} globals.asp wont set my php vars [EMAIL PROTECTED] wrote: Amazing how long that thread is -- must be a record. Seems to be classic case of 'ignore-the-obvious' or 'my-mind-is-made-up. Don't-confuse-me-with-facts'. Perhaps I should start a new thread: [PHP} Can't get NULL to output anything! hehe Andre On Friday 17 September 2004 03:11 pm, Jason Davidson wrote: hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
* Thus wrote Sam Hobbs: Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The firewall is relevant depending on your circumstances. In any case it would take you all of one minute to disable your firewall to test out this wild far out suggestion. At the most you would have lost one minute but you would have either: - gained the satisfaction of saying I told you the firewall was irrelevant, now go away and stop wasting my time with your ridiculous suggestions or - you would have found the cause of your problem It definitely takes more than a minute. It takes nearly a minute just to logoff one user and I often have another user, the Administrator account, ... I must restart ZoneAlarm, restart the system and be sure to plug the modem back in while the system starts. The whole operation is likely to take nearly a half hour at least. Um.. you do realize you have more problems than php not being able to connect to the database. Curt -- The above comments may offend you. flame at will. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
[PHP} Can't get NULL to output anything! hehe Andre Check your firewall. -- --Matthew Sims --http://killermookie.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql_connect does not connect
This whole thread has degraded to the point of: YHBT. YHL. HAND. and I'm not helping it. -Original Message- From: Curt Zirzow [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 2:33 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect * Thus wrote Sam Hobbs: I appreciate your attempts to help, but you must understand that when attempts to help just cause time to be wasted, then it might be appropriate :sigh: Curt -- The above comments may offend you. flame at will. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php smime.p7s Description: S/MIME cryptographic signature
Re: [PHP] mysql_connect does not connect
hahahaha, what can i do in 30 minutes... hmm.. install almost any linux distro, most windows distros.. i could disbaled and enable my firewall about 180 times i could read just one of the long winded emails how i obsfuscate the thread with irrelevant solutions and wild suggestions of inaccuracy...sorry .. i had to .. Jason Curt Zirzow [EMAIL PROTECTED] wrote: * Thus wrote Sam Hobbs: Jason Wong [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The firewall is relevant depending on your circumstances. In any case it would take you all of one minute to disable your firewall to test out this wild far out suggestion. At the most you would have lost one minute but you would have either: - gained the satisfaction of saying I told you the firewall was irrelevant, now go away and stop wasting my time with your ridiculous suggestions or - you would have found the cause of your problem It definitely takes more than a minute. It takes nearly a minute just to logoff one user and I often have another user, the Administrator account, ... I must restart ZoneAlarm, restart the system and be sure to plug the modem back in while the system starts. The whole operation is likely to take nearly a half hour at least. Um.. you do realize you have more problems than php not being able to connect to the database. Curt -- The above comments may offend you. flame at will. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql_connect does not connect
?php if ( date(l) == Friday) { echo get_defn(STFA); } else { echo Not today eh!\n; } function get_defn($string) { if ( $string == STFA) $i = mt_rand(0,3); switch($i) { case 0: return search the fucking archives\n; case 1: return Star Trek Fan Association\n; case 2: return Stay The Fuck Away\n; case 3: return Surface Treatment and Finishing of Aluminum\n; default:return search the fucking archives\n; } } ? :^) too many free cycles. -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 2:10 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect -- Original message from John Holmes : -- Whatever happened to those monthly stat posts? most posts, most posts per thread, etc...?? Who was doing that? I haven't seen one in a while. ---John Holmes... Bill Doerrfeld http://marc.theaimsgroup.com/?a=9211645541r=1w=2 STFA!!! :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
HAHAHA, this thread is awsome though, you all must admit the humor involved here. I hope this thread continues for a couple more days. or here is an idea for a thread {PHP} globals.asp wont set my php vars Firewall. -- --Matthew Sims --http://killermookie.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
that takes the cake. :D :D J Matthew Sims [EMAIL PROTECTED] wrote: [PHP} Can't get NULL to output anything! hehe Andre Check your firewall. -- --Matthew Sims --http://killermookie.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Fri, 17 Sep 2004 13:34:18 -0700 (PDT), Matthew Sims [EMAIL PROTECTED] wrote: Check your firewall. I would but I don't have 30 minutes to spare. Too busy walking my lizard.. or something. -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql_connect does not connect
Did you just top post? Top posting === evil; -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 3:14 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect HAHAHA, this thread is awsome though, you all must admit the humor involved here. I hope this thread continues for a couple more days. or here is an idea for a thread {PHP} globals.asp wont set my php vars [EMAIL PROTECTED] wrote: Amazing how long that thread is -- must be a record. Seems to be classic case of 'ignore-the-obvious' or 'my-mind-is-made-up. Don't-confuse-me-with-facts'. Perhaps I should start a new thread: [PHP} Can't get NULL to output anything! hehe Andre On Friday 17 September 2004 03:11 pm, Jason Davidson wrote: hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Fri, 17 Sep 2004 14:41:28 -0600, Chris Gregors [EMAIL PROTECTED] wrote: This whole thread has degraded to the point of: YHBT. YHL. HAND. and I'm not helping it. Well.. could you at least not top post while you're not helping.. Trying to keep this dignified and stuff. :) -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
?php function logic($logic, find_some) { if($TopPosting === evil)($email['JayBlanchard'] == TopPosted) { switch ($logic) : case None : print You've just TopPosted; break; case True : print TopPosting != evil; $TopPosting = good; return(); break; case False : print TopPosting is your friend!; $TopPosting = evil; if ($TopPosting === evil'){ $TopPosting = None; } exit; break; endswitch; } else { print Says who??; } } Thanks for the input, Jay! I prefer top posting since you get the answer first, then the question (iff you're interested enough to scroll down -- sigh -- I'm too lazy :) Andre On Friday 17 September 2004 05:08 pm, you wrote: Did you just top post? Top posting === evil; -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 3:14 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect HAHAHA, this thread is awsome though, you all must admit the humor involved here. I hope this thread continues for a couple more days. or here is an idea for a thread {PHP} globals.asp wont set my php vars [EMAIL PROTECTED] wrote: Amazing how long that thread is -- must be a record. Seems to be classic case of 'ignore-the-obvious' or 'my-mind-is-made-up. Don't-confuse-me-with-facts'. Perhaps I should start a new thread: [PHP} Can't get NULL to output anything! hehe Andre On Friday 17 September 2004 03:11 pm, Jason Davidson wrote: hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net
RE: [PHP] mysql_connect does not connect
[snip] Thanks for the input, Jay! I prefer top posting since you get the answer first, then the question (iff you're interested enough to scroll down -- sigh -- I'm too lazy :) [/snip] .siht ekil rewsna dluohs I nehT -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
How do I sync an Oracle and MSSQL database on an AIX system remotely from Windows '95? p.s. I found this email address on the php website, which means I've been to the php website, therefore this is a php question. Don't you dare flame me. Jay Blanchard wrote: Did you just top post? Top posting === evil; -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 3:14 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect HAHAHA, this thread is awsome though, you all must admit the humor involved here. I hope this thread continues for a couple more days. or here is an idea for a thread {PHP} globals.asp wont set my php vars [EMAIL PROTECTED] wrote: Amazing how long that thread is -- must be a record. Seems to be classic case of 'ignore-the-obvious' or 'my-mind-is-made-up. Don't-confuse-me-with-facts'. Perhaps I should start a new thread: [PHP} Can't get NULL to output anything! hehe Andre On Friday 17 September 2004 03:11 pm, Jason Davidson wrote: hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Oh yeah, trimming posts is bad. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Saturday 18 September 2004 05:17, Greg Donald wrote: Well.. could you at least not top post while you're not helping.. Trying to keep this dignified and stuff. :) I think everybody who is anybody who had a point to make has already done so. Can we bury this thread now? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* news: gotcha */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] mysql_connect does not connect
what is top posting Jay Blanchard [EMAIL PROTECTED] wrote: Did you just top post? Top posting === evil; -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 3:14 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect HAHAHA, this thread is awsome though, you all must admit the humor involved here. I hope this thread continues for a couple more days. or here is an idea for a thread {PHP} globals.asp wont set my php vars [EMAIL PROTECTED] wrote: Amazing how long that thread is -- must be a record. Seems to be classic case of 'ignore-the-obvious' or 'my-mind-is-made-up. Don't-confuse-me-with-facts'. Perhaps I should start a new thread: [PHP} Can't get NULL to output anything! hehe Andre On Friday 17 September 2004 03:11 pm, Jason Davidson wrote: hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
haha John Nichel [EMAIL PROTECTED] wrote: How do I sync an Oracle and MSSQL database on an AIX system remotely from Windows '95? p.s. I found this email address on the php website, which means I've been to the php website, therefore this is a php question. Don't you dare flame me. Jay Blanchard wrote: Did you just top post? Top posting === evil; -Original Message- From: Jason Davidson [mailto:[EMAIL PROTECTED] Sent: Friday, September 17, 2004 3:14 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [PHP] mysql_connect does not connect HAHAHA, this thread is awsome though, you all must admit the humor involved here. I hope this thread continues for a couple more days. or here is an idea for a thread {PHP} globals.asp wont set my php vars [EMAIL PROTECTED] wrote: Amazing how long that thread is -- must be a record. Seems to be classic case of 'ignore-the-obvious' or 'my-mind-is-made-up. Don't-confuse-me-with-facts'. Perhaps I should start a new thread: [PHP} Can't get NULL to output anything! hehe Andre On Friday 17 September 2004 03:11 pm, Jason Davidson wrote: hehehe.. im actually looking forward to reading responses on this thread.. funny stuff. Jason Jason Wong [EMAIL PROTECTED] wrote: On Friday 17 September 2004 23:21, Sam Hobbs wrote: Again, it is okay to say this once but it is not useful to keep insisting. I am smart enough to be aware of the possibility and if and when other possibilities have been exahausted I would have tried the possibility of disabling the firewall or whatever. Insisting upon it from others is not productive; it is more likley to polarize me in the opposite direction and get us to where we are now. It is the emotional commentary that is most unproductive. I try to explain (unemotionally and in a reasonable manner) that I don't need the additional assertion that I must try something and the response to that becomes emotional. Being obstinate and contrarian does nothing to help resolve your problem. Time for another: [quote from a Sam Hobbs post in reply to Jason Davidson] It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. [quote] Would I be correct if I paraphrased the above as: The wrong way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall might be blocking your attempts to connect to mysql. Try disabling it. [SH] Yeah and what makes you think that? I KNOW the firewal has nothing to do with it. Get real (and go away). The right way to get Sam Hobbs to try something that might help in solving his problem: [JD] The firewall has nothing to do with your problem. But try disabling it anyway. [SH] Yeah that sounds reasonable. Thanks, I'll try that. How silly is that? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* If money can't buy happiness, I guess you'll just have to rent it. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Oh yeah, trimming posts is bad. -- By-Tor.com It's all about the Rush http://www.by-tor.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jay Blanchard wrote: [snip] Thanks for the input, Jay! I prefer top posting since you get the answer first, then the question (iff you're interested enough to scroll down -- sigh -- I'm too lazy :) [/snip] .siht ekil rewsna dluohs I nehT did you do that with strrev() or type it out by hand? -- Raditha Dissanayake. http://www.radinks.com/sftp/ | http://www.raditha.com/megaupload Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 128 KB | with progress bar. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Thursday 16 September 2004 11:06, Sam Hobbs wrote: It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. The firewall is relevant depending on your circumstances. In any case it would take you all of one minute to disable your firewall to test out this wild far out suggestion. At the most you would have lost one minute but you would have either: - gained the satisfaction of saying I told you the firewall was irrelevant, now go away and stop wasting my time with your ridiculous suggestions or - you would have found the cause of your problem Contrast that with the number of posts you have made denying that the firewall could be a problem, and stating adamantly that you will not do such-and-such a thing because it is 'not supposed' to happen like that. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* Did it ever occur to you that fat chance and slim chance mean the same thing? Or that we drive on parkways and park on driveways? */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
All this is irrelevant; while you're still trying to use MySQL 5 with mysql_connect() instead of mysqli_connect(), it WILL NEVER WORK Sort that out first before you start worrying about firewalls - you can't test the firewall if you can't ever have a successful test case. Cheers Chris Markus Mayer wrote: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Thursday 16 September 2004 17:52, Chris Dowell wrote: All this is irrelevant; while you're still trying to use MySQL 5 with mysql_connect() instead of mysqli_connect(), it WILL NEVER WORK Sort that out first before you start worrying about firewalls - you can't test the firewall if you can't ever have a successful test case. IIRC the OP did have a successful test case when connecting from the mysql client. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general -- /* You need tender loving care once a week - so that I can slap you into shape. - Ellyn Mustard */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Chris Dowell wrote: All this is irrelevant; while you're still trying to use MySQL 5 with mysql_connect() instead of mysqli_connect(), it WILL NEVER WORK Sort that out first before you start worrying about firewalls - you can't test the firewall if you can't ever have a successful test case. Cheers Chris The MySQL functions work fine in php5. It just doesn't support all the features available in MySQL = 4.1.0. Unlike php4, support for MySQL isn't bundled in php5, but when enabled, it works. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
i am in total agreeance of this post. Sinse the 'flame' war is primarily between me and everyone else, especially sam hobbes, (not the first time either), no more contributiuons to this thread from me. I hope it gets resolved, and i hope it gets posted as much so others can search the archive of this thread for solutions. If anyone actually wants to discuss, and not argue, over the relevance of a firewall in this sitiution, please start a new thread. Jason Markus Mayer [EMAIL PROTECTED] wrote: 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
I appreciate your attempts to help, but you must understand that when attempts to help just cause time to be wasted, then it might be appropriate to not appreciate the help. Then when I try to explain that you are not helping, you make comments such as this, trying to blame me. If I am the only person you do this to, then I can live with it. If however you do this to others, then I hope you are told by others that you are trying too hard to help and that you resort to insulting others when you don't help. Perhaps there is some validity to what you are saying, but you are also saying some things that are not valid, which makes it difficult or impossible to determine what is valid. I do try to tell you in reasonably polite and useful ways that much of what you say is not helpful. Obviously I need to just ignore your help instead. Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] There is an issue with sp2 and loopback, you can argue all you like, but many have had this problem, and many have resolved it. Mysql will not connect through udp, it will use tcp. If you supply a hostname in your connect function, it will use tcpip to connect over a port, if oyu dont supply a hostname, or i beleive put a '.' in its place, it will attempt to connect through a named pipe which doesnt use the network. In the time you spend writing this email, you could have attemped a suggested solution. A little more acceptance to help would gain a lot more respect from me, not that you probably care about others respect. And for further note, for the sake of discussion, as you have mentioned to me on a certain forum. A firewall can absolutely interfere with a connection to mysql even if you are using localhost, if, and only if, that connection is being done over tcpip, which in unix, is rarely, but in windows, is not all that rare. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Greg Donald [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I lost track of who the original poster was, but anyway... Why not disconnect from the internet, turn off all the firewalls, and then see if it works. If it doesn't then post some error messages and code for what's being tried and failing. I am the original poster. The reason I avoid doing things like that is because it is a guess. It should not be necessary; the firewal should not be relevant. Sometimes people suggest things that are not likely to be a solution but are easy to suggest. However I also believe in being methodical and in verifying assumptions. It does help to eliminate possilities. Something that has not been mentioned is that I am using versions that are not fully tested, so it is possible that there are bugs. Apparently something is trying to use the internet that is not supposed to. If I am correct, then it is difficult to say what I should try except that I should eliminate possibilities in the manner you say. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Good day, im glad you seem to have resolved your problem, i shall comment on your comments. Sam Hobbs [EMAIL PROTECTED] wrote: I appreciate your attempts to help, but you must understand that when attempts to help just cause time to be wasted, then it might be appropriate to not appreciate the help. Its no waste of time to attempt a solution, if it doesnt work, youve eliminated that solution. That is one step closer. Then when I try to explain that you are not helping, you make comments such as this, trying to blame me. If I am the only person you do this to, then I can live with it. If however you do this to others, then I hope you are told by others that you are trying too hard to help and that you resort to insulting others when you don't help. Im bashing my head on the wall now Perhaps there is some validity to what you are saying, but you are also saying some things that are not valid, which makes it difficult or impossible to determine what is valid. I do try to tell you in reasonably polite and useful ways that much of what you say is not helpful. Obviously I need to just ignore your help instead. Now that you have figured out, that it is possible its your firewall, which, many, and i think you claimed before was impossible, what exactly makes you sure i said anything invalid. Now that my rant is done, i made it clear, that i i have solved a problem with your EXACT error msg before. That makes this not a guess, but an educated and experienced suggestion. and yes, all forms of help on this form are as such. Yup, im an a$$hole , i dont like being completely shutdown by people requesting help, when i take the time to impart some experience... J Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] There is an issue with sp2 and loopback, you can argue all you like, but many have had this problem, and many have resolved it. Mysql will not connect through udp, it will use tcp. If you supply a hostname in your connect function, it will use tcpip to connect over a port, if oyu dont supply a hostname, or i beleive put a '.' in its place, it will attempt to connect through a named pipe which doesnt use the network. In the time you spend writing this email, you could have attemped a suggested solution. A little more acceptance to help would gain a lot more respect from me, not that you probably care about others respect. And for further note, for the sake of discussion, as you have mentioned to me on a certain forum. A firewall can absolutely interfere with a connection to mysql even if you are using localhost, if, and only if, that connection is being done over tcpip, which in unix, is rarely, but in windows, is not all that rare. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
On Wed, 15 Sep 2004 15:06:11 -0700, Sam Hobbs [EMAIL PROTECTED] wrote: I am the original poster. The reason I avoid doing things like that is because it is a guess. It should not be necessary; the firewal should not be relevant. Sometimes people suggest things that are not likely to be a solution but are easy to suggest. Yeah, seeing how we don't have physical access to your system that's all you will get is guesses and suggestions. If you want definative answers, hire a consultant, bring them to your pc, and pay them to fix it. However I also believe in being methodical and in verifying assumptions. It does help to eliminate possilities. Something that has not been mentioned is that I am using versions that are not fully tested, If you wanted us to know what versions of software you are using, no one is stopping you from saying so. so it is possible that there are bugs. Since when does fully tested mean bug free? Apparently something is trying to use the internet that is not supposed to. If I am correct, then it is difficult to say what I should try except that I should eliminate possibilities in the manner you say. You obviously know what's best Sam.. Good luck. -- Greg Donald http://gdconsultants.com/ http://destiney.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Greg Donald [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Yeah, seeing how we don't have physical access to your system that's all you will get is guesses and suggestions. If you want definative answers, hire a consultant, bring them to your pc, and pay them to fix it. I have posted many thousands (literally) messages in another forum trying to help people. So most of the time the roles are reversed. I know when others are guessing. In that forum, the few times that I asked questions, I got many guesses that were a waste of time. One way of defining a guess is something that I am able to think of myself. If you wanted us to know what versions of software you are using, no one is stopping you from saying so. I did! You just want to be critical! Since when does fully tested mean bug free? When I say untested, I mean that the developers of the software have defined these versions as being untested. It is their definition; there are also production versions of the software that is considered to be adequately tested. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Now that you have figured out, that it is possible its your firewall, which, many, and i think you claimed before was impossible, what exactly makes you sure i said anything invalid. It is my understanding that the firewall is not supposed to be relevant. I have not seen anything saying it is supposed to be. 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. 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Windows XP Firewall, or any other firewall for that matter must be off. Jason Sam Hobbs [EMAIL PROTECTED] wrote: I have: PHP Version 5.0.1 MySQL 5.0.1 Apache 2.0.48 Winows XP Pro SP2 MySQL is working fine as best as I can see; I have tried the various samples in the MySQL manual and I have executed the myTest sample provided with MySQL. They all work. However I can't get mysql_connect to work; when I try: $conn = mysql_connect(localhost, root); I get: Warning: mysql_connect() [function.mysql-connect.chm]: Can't connect to MySQL server on 'localhost' (10061) The host and user should be correct; I have not changed anything such as that after installation. The password should still be blank. However I have tried many, many other combinations but nothing that works. Is 10061 an error code? I can't find it in the PHP documentation. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Also, a google on the error returns hundreds of results.. http://www.google.ca/search?hl=enie=UTF-8q=Can%27t+connect+to+++MySQL+server+on+%27localhost%27+%2810061%29btnG=Searchmeta= Jason Jason Davidson [EMAIL PROTECTED] wrote: Windows XP Firewall, or any other firewall for that matter must be off. Jason Sam Hobbs [EMAIL PROTECTED] wrote: I have: PHP Version 5.0.1 MySQL 5.0.1 Apache 2.0.48 Winows XP Pro SP2 MySQL is working fine as best as I can see; I have tried the various samples in the MySQL manual and I have executed the myTest sample provided with MySQL. They all work. However I can't get mysql_connect to work; when I try: $conn = mysql_connect(localhost, root); I get: Warning: mysql_connect() [function.mysql-connect.chm]: Can't connect to MySQL server on 'localhost' (10061) The host and user should be correct; I have not changed anything such as that after installation. The password should still be blank. However I have tried many, many other combinations but nothing that works. Is 10061 an error code? I can't find it in the PHP documentation. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. Jason Can someone else confirm that this is correct? For one thing, when I use MySQL directly outside of a web page, it works. The sample C program works. For another thing, I doubt very immensely that everyone using mysql_connect does not use a firewall. Even if anyone else does, I will not. It would have been quite unreasonable for the developers of PHP to develop software with that requirement, but I doubt it was. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Sam Hobbs wrote: Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. Jason Can someone else confirm that this is correct? It's not correct. For one thing, when I use MySQL directly outside of a web page, it works. The sample C program works. For another thing, I doubt very immensely that everyone using mysql_connect does not use a firewall. Even if anyone else does, I will not. It would have been quite unreasonable for the developers of PHP to develop software with that requirement, but I doubt it was. I don't know anything about WindowsXP or it's 'firewall', but you _may_ have to open the port for which you have MySQL running on. I haven't followed this thread, but if MySQL, and your php enabled webserver are on the same box, then your firewall doesn't come into play. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
John Nichel [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I don't know anything about WindowsXP or it's 'firewall', but you _may_ have to open the port for which you have MySQL running on. I haven't followed this thread, but if MySQL, and your php enabled webserver are on the same box, then your firewall doesn't come into play. Yes, this is all one system, so I sure thought that a firewall is not relevant. Thank you for saying so. I don't (should not) have the Windows XP firewall turned on; I use ZoneAlarm. This is extraneous relevance, but there is a possibility that the Windows XP firewall got turned on due to Windows XP SP2 (the latest big batch of fixes and upgrades for XP). I doubt it, though; I have checked and such. However to the extent that a firewall is not relevant, this is tnot relevant. Something that might be relevant is the possibility of some other new security feature installed by the XP SP2. If so, then many others will be encountering it in the future; SP2 was released to the public sometime in the last couple of months, probably less than a month ago. Even so, I am surprised that I am the first to say anything if that is the problem. Probably if that was a problem, other systems that were working would have been broken by SP2 and people would know that SP2 is the cause. Using that logic, it is unlikely that SP2 is the problem. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Also, a google on the error returns hundreds of results.. http://www.google.ca/search?hl=enie=UTF-8q=Can%27t+connect+to+++MySQL+server+on+%27localhost%27+%2810061%29btnG=Searchmeta= Yes, I could have searched more first. And yes, that search does get an abundance of results. However I see no solutions relevant to my problem. Many of the solutions say things such as that the extension is not installed or that MySQL is not installed. Many (close to half I think) of the results are pages that have the error, so the abundance of results indicates it is a prevalent problem that is often not easily solved. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
The webpage of coarse, is not local, regardless of where its hosted, so a firewall will come into play when trying to connect. You dont have disable it, i should have been specifc i suppose, you must allow for the mysql port to be open. :) Whats for others to confirm, try it yourself and see if it works. Jason Sam Hobbs [EMAIL PROTECTED] wrote: Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. Jason Can someone else confirm that this is correct? For one thing, when I use MySQL directly outside of a web page, it works. The sample C program works. For another thing, I doubt very immensely that everyone using mysql_connect does not use a firewall. Even if anyone else does, I will not. It would have been quite unreasonable for the developers of PHP to develop software with that requirement, but I doubt it was. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Sam Your problem probably does stem from the extension not being installed. You say you're using (IIRC) mySQL 4.1 This requires you to use the mysqli extension, not the mysql extension As you're on windows, it's probably just a case of uncommenting the extension=php_mysqli.dll line in your php.ini, but I'm not sure as I don't have much experience configuring PHP for windows. Anyway - as far as I can tell from what you've said, that's likely to be your problem - your timeout is occurring because the mysql extension cannot connect, not because of any firewall issues. From the manual entry on MySQL (http://www.php.net/mysql): This MySQL extension doesn't support full functionality of MySQL versions greater than 4.1.0. For that, use MySQLi. If you then look at the entry for MySQLi (http://www.php.net/mysqli), you'll see this: The mysqli extension allows you to access the functionality provided by MySQL 4.1 and above. Then this page (http://www.php.net/manual/en/install.windows.extensions.php) about installing extension on windows should get you the rest of the way. Cheers Chris Sam Hobbs wrote: Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Also, a google on the error returns hundreds of results.. http://www.google.ca/search?hl=enie=UTF-8q=Can%27t+connect+to+++MySQL+server+on+%27localhost%27+%2810061%29btnG=Searchmeta= Yes, I could have searched more first. And yes, that search does get an abundance of results. However I see no solutions relevant to my problem. Many of the solutions say things such as that the extension is not installed or that MySQL is not installed. Many (close to half I think) of the results are pages that have the error, so the abundance of results indicates it is a prevalent problem that is often not easily solved. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Also, a google on the error returns hundreds of results.. http://www.google.ca/search?hl=enie=UTF-8q=Can%27t+connect+to+++MySQL+server+on+%27localhost%27+%2810061%29btnG=Searchmeta= One thing I did find in the results is that at least one person had problems using (I think) phpMyAdmin. It supposedly uses mysql_connect. I am not aware of installing phpMyAdmin in my system, so I will try installing and using it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
The firewall I am using is ZoneAlarm, the free version. I am nearly certain that it does not allow specific ports to be opened, at least not for specific addresses. So if this were a requirement, probably many others would have that specific problem. However if nothing else works, I will try to look into this further when I have time. At the moment I must spend time on something else. Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] The webpage of coarse, is not local, regardless of where its hosted, so a firewall will come into play when trying to connect. You dont have disable it, i should have been specifc i suppose, you must allow for the mysql port to be open. :) Whats for others to confirm, try it yourself and see if it works. Jason Sam Hobbs [EMAIL PROTECTED] wrote: Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Windows XP Firewall, or any other firewall for that matter must be off. Jason Can someone else confirm that this is correct? For one thing, when I use MySQL directly outside of a web page, it works. The sample C program works. For another thing, I doubt very immensely that everyone using mysql_connect does not use a firewall. Even if anyone else does, I will not. It would have been quite unreasonable for the developers of PHP to develop software with that requirement, but I doubt it was. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Jason Davidson wrote: The webpage of coarse, is not local, regardless of where its hosted, so a firewall will come into play when trying to connect. You dont have disable it, i should have been specifc i suppose, you must allow for the mysql port to be open. :) Whats for others to confirm, try it yourself and see if it works. Jason You understanding of how this works is a bit off Jason. If you make a call to one of my web sites from your machine via a browser, the _only_ port I need to have open to the outside is 80 (or whatever port I have my web server running on), even if I make 1000 calls to a local db, but this has nothing to do with how the web server talks to MySQL. What is meant by local here, is that the MySQL db and web server are on the same machine. A firewall comes into play when your web browser requests a page from my web server, but does not come into play when that page has to connect to a local db before sending content to you. Your remote machine never talks to my local MySQL db. -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mysql_connect does not connect
Possible i should have checked your configurations, however, to itterate my point slightly, here is some documentation, you may find it usefull regardless of how you connect to your db. http://dev.mysql.com/doc/mysql/en/Can_not_connect_to_server.html Jason Sam Hobbs [EMAIL PROTECTED] wrote: Jason Davidson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Also, a google on the error returns hundreds of results.. http://www.google.ca/search?hl=enie=UTF-8q=Can%27t+connect+to+++MySQL+server+on+%27localhost%27+%2810061%29btnG=Searchmeta= One thing I did find in the results is that at least one person had problems using (I think) phpMyAdmin. It supposedly uses mysql_connect. I am not aware of installing phpMyAdmin in my system, so I will try installing and using it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php