Re: [PHP] mysql_connect does not connect

2004-09-22 Thread Jason Wong
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

2004-09-21 Thread Chris Dowell
[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

2004-09-20 Thread Jay Blanchard
[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

2004-09-20 Thread Steve Brown
 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

2004-09-20 Thread Carlos Souza
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

2004-09-19 Thread Sam Hobbs
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

2004-09-19 Thread Jason Davidson
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

2004-09-19 Thread Sam Hobbs
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

2004-09-19 Thread John Nichel
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

2004-09-19 Thread Jason Davidson
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

2004-09-18 Thread Sam Hobbs
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

2004-09-18 Thread Sam Hobbs
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

2004-09-18 Thread Sam Hobbs
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

2004-09-18 Thread Sam Hobbs
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

2004-09-18 Thread raditha dissanayake
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

2004-09-18 Thread Sam Hobbs
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

2004-09-18 Thread Jason Wong
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

2004-09-18 Thread Sam Hobbs
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

2004-09-18 Thread Daniel Schierbeck
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

2004-09-18 Thread Tom Rogers
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

2004-09-18 Thread Jason Davidson
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

2004-09-18 Thread Jason Davidson
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

2004-09-18 Thread Ed Lazor
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

2004-09-17 Thread 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, 
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

2004-09-17 Thread Sam Hobbs
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

2004-09-17 Thread Sam Hobbs
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

2004-09-17 Thread Sam Hobbs
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

2004-09-17 Thread Sam Hobbs
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

2004-09-17 Thread Sam Hobbs
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

2004-09-17 Thread John Holmes
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread John Nichel
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

2004-09-17 Thread raditha dissanayake
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

2004-09-17 Thread Steve Brown
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

2004-09-17 Thread Matthew Sims
 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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Matthew Sims
 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

2004-09-17 Thread Jay Blanchard
[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

2004-09-17 Thread John Nichel
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

2004-09-17 Thread John Nichel
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread John Nichel
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

2004-09-17 Thread Jason Wong
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Jason Wong
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

2004-09-17 Thread Jason Wong
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Jason Wong
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

2004-09-17 Thread John Holmes
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Andre Dubuc
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

2004-09-17 Thread John Nichel
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

2004-09-17 Thread Curt Zirzow
* 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

2004-09-17 Thread John Nichel
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

2004-09-17 Thread Curt Zirzow
* 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

2004-09-17 Thread Jennifer Goodie
-- 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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Curt Zirzow
* 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

2004-09-17 Thread Matthew Sims

 [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

2004-09-17 Thread Chris Gregors
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Chris Gregors
?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

2004-09-17 Thread Matthew Sims
 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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Greg Donald
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

2004-09-17 Thread Jay Blanchard
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

2004-09-17 Thread Greg Donald
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

2004-09-17 Thread Andre Dubuc
?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

2004-09-17 Thread Jay Blanchard
[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

2004-09-17 Thread John Nichel
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

2004-09-17 Thread Jason Wong
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread Jason Davidson
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

2004-09-17 Thread raditha dissanayake
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

2004-09-16 Thread Jason Wong
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

2004-09-16 Thread Markus Mayer
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

2004-09-16 Thread Chris Dowell
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

2004-09-16 Thread Jason Wong
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

2004-09-16 Thread John Nichel
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

2004-09-16 Thread Jason Davidson
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

2004-09-15 Thread 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 
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

2004-09-15 Thread Sam Hobbs
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

2004-09-15 Thread Jason Davidson
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

2004-09-15 Thread Greg Donald
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

2004-09-15 Thread Sam Hobbs
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

2004-09-15 Thread Sam Hobbs
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

2004-09-14 Thread Jason Davidson
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

2004-09-14 Thread Jason Davidson
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

2004-09-14 Thread Sam Hobbs
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

2004-09-14 Thread John Nichel
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

2004-09-14 Thread Sam Hobbs
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

2004-09-14 Thread Sam Hobbs
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

2004-09-14 Thread Jason Davidson
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

2004-09-14 Thread Chris Dowell
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

2004-09-14 Thread Sam Hobbs
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

2004-09-14 Thread Sam Hobbs
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

2004-09-14 Thread John Nichel
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

2004-09-14 Thread Jason Davidson
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



  1   2   >