PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) -> established connection failed because connect

Hi,

I have recently upgrade to 64 bit Intel i7 computer running Windows 7
Ultimate 64 bit.
I have setup PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) with success.
phpinfo() shows the MySQL extension loaded, but when I try to use
mysql_connect( $host, $user, $password ) in a PHP script I get following
error:

PHP Warning: mysql_connect() [ href='function.mysql-connect'>function.mysql-connect]: [2002] A
connection attempt failed because the connected party did not (trying to
connect via tcp://localhost:3306) in C:\inetpub\wwwroot\old\index.php on
line 29

PHP Warning: mysql_connect() [ href='function.mysql-connect'>function.mysql-connect]: A connection
attempt failed because the connected party did not properly respond after a
period of time, or established connection failed because connected host has
failed to respond.

in C:\inetpub\wwwroot\old\index.php on line 29
PHP Fatal error: Maximum execution time of 30 seconds exceeded in
C:\inetpub\wwwroot\old\index.php on line 29

- - - - - - - - - - - -

I have search on the Internet for a solution for this but without any luck.
Any ideas?

Regards,
Summi




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) -> establishedconnection failed because conn

Sumarliði Einar Daðason wrote:

> I have setup PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) with success.
> phpinfo() shows the MySQL extension loaded, but when I try to use
> mysql_connect( $host, $user, $password ) in a PHP script I get following
> error:
>
> PHP Warning: mysql_connect() [ > href='function.mysql-connect'>function.mysql-connect]: [2002] A
> connection attempt failed because the connected party did not (trying to
> connect via tcp://localhost:3306) in C:\inetpub\wwwroot\old\index.php on
> line 29
>
> I have search on the Internet for a solution for this but without any luck.
> Any ideas?

Yes, first check that MySQL is actually listening on port 3306
("Netstat" should do that trick), and, if it is, try turning your
firewall off. What is the value of $host?

KDK



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) -> established connection failed because con

Hi Kevin,

- MySQL 5.1 (64bit) is listening at port 0.0.0.0:3306
- MySQL 4.1 (32bit) is listening at port 0.0.0.0:3307
- When running MySQL command via PHP (CMD or browser) I get =
127.0.0.1:3306
Established
- I can connect to MySQL via CMD or MySQL Administrator GUI.
- PHP (32bit) loads php_mysql.dll
- php.ini works 100%
- All Firewalls are disabled on LAN

- Is this a PHP bug or am I getting crazy? ;-) =20
- Is there a 64bit of PHP who is assumed ok for develope machine with
firewalls?

Regards,
Summi

-----Original Message-----
From: Kevin Kinsey [mailto:kdk@daleco.biz]=20
Sent: 4. apr=EDl 2010 01:02
To: Sumarli=F0i Einar Da=F0ason
Cc: php-general@lists.php.net
Subject: Re: [PHP] PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) ->
established connection failed because connected host has failed to =
respond

Sumarli=F0i Einar Da=F0ason wrote:

> I have setup PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) with
success.
> phpinfo() shows the MySQL extension loaded, but when I try to use=20
> mysql_connect( $host, $user, $password ) in a PHP script I get=20
> following
> error:
>=20
> PHP Warning: mysql_connect() [ > href=3D'function.mysql-connect'>function.mysql-connect]: [2002] A=20
> connection attempt failed because the connected party did not (trying =

> to connect via tcp://localhost:3306) in=20
> C:\inetpub\wwwroot\old\index.php on line 29
>=20
> I have search on the Internet for a solution for this but without any
luck.
> Any ideas?

Yes, first check that MySQL is actually listening on port 3306 =
("Netstat"
should do that trick), and, if it is, try turning your firewall off. =
What
is the value of $host?

KDK






--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) -> established connection failed because con

Hi Kevin,

Thank you for your assistance. I finally gave up and let my self to =
default
Microsoft Installation for IIS7.5+PHP+MySQL.

Everything runs fine on my developer machine - and that was my main goal =
-
so I'm fine.

However, after about 48 hours of search, I was not able to find to how =
to do
this manually - and it shock me (as a open source fan). At least, my =
Linuxs'
servers are still intact.

Ps. there is still snowing here in Iceland (heat -15°C in wind) and a
volcano eruption that is growing. :)

Thanks for your help,
Summi

-----Original Message-----
From: SED [mailto:sed@sed.is]=20
Sent: 4. apr=EDl 2010 10:06
To: 'Kevin Kinsey'
Cc: php-general@lists.php.net
Subject: RE: [PHP] PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) ->
established connection failed because connected host has failed to =
respond

Hi Kevin,

- MySQL 5.1 (64bit) is listening at port 0.0.0.0:3306
- MySQL 4.1 (32bit) is listening at port 0.0.0.0:3307
- When running MySQL command via PHP (CMD or browser) I get =
127.0.0.1:3306
Established
- I can connect to MySQL via CMD or MySQL Administrator GUI.
- PHP (32bit) loads php_mysql.dll
- php.ini works 100%
- All Firewalls are disabled on LAN

- Is this a PHP bug or am I getting crazy? ;-) =20
- Is there a 64bit of PHP who is assumed ok for develope machine with
firewalls?

Regards,
Summi

-----Original Message-----
From: Kevin Kinsey [mailto:kdk@daleco.biz]
Sent: 4. apr=EDl 2010 01:02
To: Sumarli=F0i Einar Da=F0ason
Cc: php-general@lists.php.net
Subject: Re: [PHP] PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) ->
established connection failed because connected host has failed to =
respond

Sumarli=F0i Einar Da=F0ason wrote:

> I have setup PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) with
success.
> phpinfo() shows the MySQL extension loaded, but when I try to use=20
> mysql_connect( $host, $user, $password ) in a PHP script I get=20
> following
> error:
>=20
> PHP Warning: mysql_connect() [ > href=3D'function.mysql-connect'>function.mysql-connect]: [2002] A=20
> connection attempt failed because the connected party did not (trying =

> to connect via tcp://localhost:3306) in=20
> C:\inetpub\wwwroot\old\index.php on line 29
>=20
> I have search on the Internet for a solution for this but without any
luck.
> Any ideas?

Yes, first check that MySQL is actually listening on port 3306 =
("Netstat"
should do that trick), and, if it is, try turning your firewall off. =
What
is the value of $host?

KDK






--
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 (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) -> established connection failed because con

-----Original Message-----
From: SED [mailto:sed@sed.is]=20
Sent: Sunday, April 04, 2010 11:48 AM
To: 'SED'
Cc: php-general@lists.php.net
Subject: RE: [PHP] PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) ->
established connection failed because connected host has failed to =
respond

Hi Kevin,

Thank you for your assistance. I finally gave up and let my self to =
default
Microsoft Installation for IIS7.5+PHP+MySQL.

Everything runs fine on my developer machine - and that was my main goal =
-
so I'm fine.

However, after about 48 hours of search, I was not able to find to how =
to do
this manually - and it shock me (as a open source fan). At least, my =
Linuxs'
servers are still intact.

Ps. there is still snowing here in Iceland (heat -15°C in wind) and a
volcano eruption that is growing. :)

Thanks for your help,
Summi

-----Original Message-----
From: SED [mailto:sed@sed.is]=20
Sent: 4. apr=EDl 2010 10:06
To: 'Kevin Kinsey'
Cc: php-general@lists.php.net
Subject: RE: [PHP] PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) ->
established connection failed because connected host has failed to =
respond

Hi Kevin,

- MySQL 5.1 (64bit) is listening at port 0.0.0.0:3306
- MySQL 4.1 (32bit) is listening at port 0.0.0.0:3307
- When running MySQL command via PHP (CMD or browser) I get =
127.0.0.1:3306
Established
- I can connect to MySQL via CMD or MySQL Administrator GUI.
- PHP (32bit) loads php_mysql.dll
- php.ini works 100%
- All Firewalls are disabled on LAN

- Is this a PHP bug or am I getting crazy? ;-) =20
- Is there a 64bit of PHP who is assumed ok for develope machine with
firewalls?

Regards,
Summi

-----Original Message-----
From: Kevin Kinsey [mailto:kdk@daleco.biz]
Sent: 4. apr=EDl 2010 01:02
To: Sumarli=F0i Einar Da=F0ason
Cc: php-general@lists.php.net
Subject: Re: [PHP] PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) ->
established connection failed because connected host has failed to =
respond

Sumarli=F0i Einar Da=F0ason wrote:

> I have setup PHP (32 bit) on IIS7.5 and MySQL 5.1.45 (64 bit) with
success.
> phpinfo() shows the MySQL extension loaded, but when I try to use=20
> mysql_connect( $host, $user, $password ) in a PHP script I get=20
> following
> error:
>=20
> PHP Warning: mysql_connect() [ > href=3D'function.mysql-connect'>function.mysql-connect]: [2002] A=20
> connection attempt failed because the connected party did not (trying =

> to connect via tcp://localhost:3306) in=20
> C:\inetpub\wwwroot\old\index.php on line 29
>=20
> I have search on the Internet for a solution for this but without any
luck.
> Any ideas?

Yes, first check that MySQL is actually listening on port 3306 =
("Netstat"
should do that trick), and, if it is, try turning your firewall off. =
What
is the value of $host?

KDK






--
PHP General Mailing List (http://www.php.net/) To unsubscribe, visit:
http://www.php.net/unsub.php





--=20
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