Cannot connect to MySQL

am 05.03.2010 15:33:36 von The Phantom

Hello=2C

First of all=2C I apologise if I do something wrong=2C because I'm new to t=
his weird system.

For test purposes=2C I have installed Apache 2.2.14 with PHP 5.3.1 and MySQ=
L 5.1.44 on Windows 7 Home Premium. However=2C whenever I try accessing MyS=
QL via PHP=2C I get the following error:

A connection attempt failed because the connected party did not properly re=
spond after a period of time=2C or established connection failed because co=
nnected host has failed to respond.

MySQL's command line client is still working fine. I think that PHP simply =
does not see MySQL=2C though the settings in php.ini seem to be correct. Ea=
rlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've tried tu=
rning off the antivirus=2C because sometimes it may cause timeouts=2C but i=
t didn't help. Can someone please help me fix this?
=20
____________________________________________________________ _____
Hotmail: Trusted email with powerful SPAM protection.
http://clk.atdmt.com/GBL/go/201469227/direct/01/=

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

Re: Cannot connect to MySQL

am 06.03.2010 15:21:43 von bedul

--001636e0b9c5224e880481228d35
Content-Type: text/plain; charset=ISO-8859-1

you install php, apache and mysql one-by-one?
how about try access other db (example: odbc)

On Fri, Mar 5, 2010 at 9:33 PM, The Phantom wrote:

>
> Hello,
>
> First of all, I apologise if I do something wrong, because I'm new to this
> weird system.
>
> For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and MySQL
> 5.1.44 on Windows 7 Home Premium. However, whenever I try accessing MySQL
> via PHP, I get the following error:
>
> 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.
>
> MySQL's command line client is still working fine. I think that PHP simply
> does not see MySQL, though the settings in php.ini seem to be correct.
> Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've tried
> turning off the antivirus, because sometimes it may cause timeouts, but it
> didn't help. Can someone please help me fix this?
>
> ____________________________________________________________ _____
> Hotmail: Trusted email with powerful SPAM protection.
> http://clk.atdmt.com/GBL/go/201469227/direct/01/
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
akan ada dimana mulut terkunci dan suara tak ada lagi..
saat itu gunakanlah HP untuk melakukan SMS!!
-> ini aliran bedul.. bukan aliran aneh.
tertawa sebelum tertawa didepan RSJ..

--001636e0b9c5224e880481228d35--

Re: Cannot connect to MySQL

am 06.03.2010 15:21:43 von bedul

Re: Cannot connect to MySQL

am 06.03.2010 17:27:41 von The Phantom

Yes=2C I've installed them one-by-one.

The only other DB type I should be able to use with PHP is SQLite=2C and it=
's working fine.
=20
____________________________________________________________ _____
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
http://clk.atdmt.com/GBL/go/201469229/direct/01/=

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

Re: Re: [PHP-DB] Cannot connect to MySQL

am 06.03.2010 18:00:55 von Lester Caine

Gunawan Wibisono wrote:
> Hello,
>
> First of all, I apologise if I do something wrong, because I'm new to this
> weird system.
>
> For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and MySQL
> 5.1.44 on Windows 7 Home Premium. However, whenever I try accessing MySQL
> via PHP, I get the following error:
>
> 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.
>
> MySQL's command line client is still working fine. I think that PHP simply
> does not see MySQL, though the settings in php.ini seem to be correct.
> Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've tried
> turning off the antivirus, because sometimes it may cause timeouts, but it
> didn't help. Can someone please help me fix this?

PHP does not come with any database enabled by default, so you will need to
enable one. For MySQL just look in php.ini for the line
;extension=php_mysql.dll
and remove the ';' at the front, and then restart Apache.
The first page you should create is

phpinfo();
?>

Which will list all the modules that are active ;)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php

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

RE: Re: [PHP-DB] Cannot connect to MySQL

am 06.03.2010 18:12:18 von Venkat Raman Don

Seems like IPV6 functionality of Windows and MySQL driver is not gelling we=
ll.

Please see http://bugs.php.net/bug.php?id=3D50172.
This is also discussed in MySQL forum at http://forums.mysql.com/read.php?5=
2,294772,294772#msg-294772.

Thanks,
Don.

-----Original Message-----
From: Lester Caine [mailto:lester@lsces.co.uk]=20
Sent: Saturday, March 06, 2010 9:01 AM
To: php-windows
Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

Gunawan Wibisono wrote:
> Hello,
>
> First of all, I apologise if I do something wrong, because I'm new to th=
is
> weird system.
>
> For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and MyS=
QL
> 5.1.44 on Windows 7 Home Premium. However, whenever I try accessing MySQ=
L
> via PHP, I get the following error:
>
> 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.
>
> MySQL's command line client is still working fine. I think that PHP simp=
ly
> does not see MySQL, though the settings in php.ini seem to be correct.
> Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've tri=
ed
> turning off the antivirus, because sometimes it may cause timeouts, but =
it
> didn't help. Can someone please help me fix this?

PHP does not come with any database enabled by default, so you will need to=
=20
enable one. For MySQL just look in php.ini for the line
;extension=3Dphp_mysql.dll
and remove the ';' at the front, and then restart Apache.
The first page you should create is

phpinfo();
?>

Which will list all the modules that are active ;)

--=20
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=3Dcontact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php

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

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

Re: Re: [PHP-DB] Cannot connect to MySQL

am 06.03.2010 18:50:26 von Pierre Joye

On Sat, Mar 6, 2010 at 6:12 PM, Venkat Raman Don
wrote:
> Seems like IPV6 functionality of Windows and MySQL driver is not gelling well.

It is not about working well together or not, it is not supported, as
explained numerous times in this list, the bug trackers (should be in
the documentation too). Either use the direct IP (127.0.0.1 for
localhost) or disable IPv6 names in your host files or altogether.

--
Pierre

@pierrejoye | http://blog.thepimp.net | http://www.libgd.org

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

Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

am 07.03.2010 16:36:58 von bedul

--00504502cbea112753048137b811
Content-Type: text/plain; charset=ISO-8859-1

sry.. this kinda other person problem
thx for your support and I kinda found this problem on other place.. Is
posible.. the problem in the windows 7?

On Sun, Mar 7, 2010 at 12:12 AM, Venkat Raman Don
wrote:

> Seems like IPV6 functionality of Windows and MySQL driver is not gelling
> well.
>
> Please see http://bugs.php.net/bug.php?id=50172.
> This is also discussed in MySQL forum at
> http://forums.mysql.com/read.php?52,294772,294772#msg-294772 .
>
> Thanks,
> Don.
>
>
> -----Original Message-----
> From: Lester Caine [mailto:lester@lsces.co.uk]
> Sent: Saturday, March 06, 2010 9:01 AM
> To: php-windows
> Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
>
> Gunawan Wibisono wrote:
> > Hello,
> >
> > First of all, I apologise if I do something wrong, because I'm new to
> this
> > weird system.
> >
> > For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and
> MySQL
> > 5.1.44 on Windows 7 Home Premium. However, whenever I try accessing
> MySQL
> > via PHP, I get the following error:
> >
> > 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.
> >
> > MySQL's command line client is still working fine. I think that PHP
> simply
> > does not see MySQL, though the settings in php.ini seem to be correct.
> > Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've
> tried
> > turning off the antivirus, because sometimes it may cause timeouts, but
> it
> > didn't help. Can someone please help me fix this?
>
> PHP does not come with any database enabled by default, so you will need to
> enable one. For MySQL just look in php.ini for the line
> ;extension=php_mysql.dll
> and remove the ';' at the front, and then restart Apache.
> The first page you should create is
>
> > phpinfo();
> ?>
>
> Which will list all the modules that are active ;)
>
>
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=contact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
akan ada dimana mulut terkunci dan suara tak ada lagi..
saat itu gunakanlah HP untuk melakukan SMS!!
-> ini aliran bedul.. bukan aliran aneh.
tertawa sebelum tertawa didepan RSJ..

--00504502cbea112753048137b811--

Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

am 07.03.2010 16:36:58 von bedul

Re: Re: [PHP-DB] Cannot connect to MySQL

am 07.03.2010 17:20:32 von Pierre Joye

On Sun, Mar 7, 2010 at 4:36 PM, Gunawan Wibisono wrote:
> sry.. this kinda other person problem
> thx for your support and I kinda found this problem on other place.. Is
> posible.. the problem in the windows 7?

No, php works fin on windows 7.

Cheers,
--
Pierre

@pierrejoye | http://blog.thepimp.net | http://www.libgd.org

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

Re: Re: [PHP-DB] Cannot connect to MySQL

am 07.03.2010 17:20:32 von Pierre Joye

Re: Cannot connect to MySQL

am 07.03.2010 17:24:24 von The Phantom

Finally! It is now working!

The only thing I had to do is uncomment 127.0.0.1 localhost in hosts!

Thank everyone for help!
=20
____________________________________________________________ _____
Hotmail: Free=2C trusted and rich email service.
http://clk.atdmt.com/GBL/go/201469228/direct/01/=

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

RE: Re: [PHP-DB] Cannot connect to MySQL

am 07.03.2010 20:15:00 von Venkat Raman Don

Hi,

Let me take a shot at explaining this in simple terms. Most of the Operatin=
g System today is building support for IPV6. IPV4 has its own set of limita=
tion and hence the world is moving to IPV6. I am not going to explain diffe=
rences between two, but for the sake of this discussion assume that they ar=
e different.

A close look at PHP MySQL driver code indicates that mysql_connect() functi=
on uses mysql_real_connect() to connect to MySQL. The API mysql_real_connec=
t() is an API which comes from MySQL dll (MySQL development team and is par=
t of MySQL database installation). So this means the support for IPV6 in PH=
P MySQL driver is not possible unless there is a support for IPV6 in MySQL =
database. So the limitation (or no support for IPV6 or whatever word may be=
used to describe this situation) is coming from MySQL database limitation.=
So now it is clear that this is not a PHP bug in the sense that nothing ca=
n be changed in PHP code base to fix it.

Let's move on to operating system concern now. A typical host file (irrespe=
ctive of OS) has two columns which contains the IP address and host name bi=
nding to it. In order to support both IPV4 and IPV6 (at least on Windows) l=
ocalhost is getting mapped to two IP addresses. There can be other reasons =
for mapping same localhost to multiple IP address. What is important is tha=
t, there is a case where we have multiple IP address pointing to same host =
name. A close inspection of MySQL code reveals that the function mysql_real=
_connect() actually tries to connect to only the first IP address returned =
for the hostname and if this fails, no further attempt to connect using oth=
er IP address associated with same host name is made. This can be fixed and=
I believe a patch is already lying in some development branch of MySQL and=
please follow MySQL release to know which version has this fix integrated.=
I do not have any idea about that. But an important thing is that this bug=
can surface on any OS where you have above condition satisfied for the hos=
t file. Yes WINDOWS, Ubuntu, Solaris all will and may get impacted. So this=
means that this is not a problem with Windows OS or for that reason any ot=
her OS.

Hope this explain things.

Thanks,
Don.

-----Original Message-----
From: Gunawan Wibisono [mailto:landavia81@gmail.com]=20
Sent: Sunday, March 07, 2010 7:37 AM
To: php-windows@lists.php.net; php-db@lists.php.net
Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

sry.. this kinda other person problem
thx for your support and I kinda found this problem on other place.. Is
posible.. the problem in the windows 7?

On Sun, Mar 7, 2010 at 12:12 AM, Venkat Raman Don
wrote:

> Seems like IPV6 functionality of Windows and MySQL driver is not gelling
> well.
>
> Please see http://bugs.php.net/bug.php?id=3D50172.
> This is also discussed in MySQL forum at
> http://forums.mysql.com/read.php?52,294772,294772#msg-294772 .
>
> Thanks,
> Don.
>
>
> -----Original Message-----
> From: Lester Caine [mailto:lester@lsces.co.uk]
> Sent: Saturday, March 06, 2010 9:01 AM
> To: php-windows
> Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
>
> Gunawan Wibisono wrote:
> > Hello,
> >
> > First of all, I apologise if I do something wrong, because I'm new to
> this
> > weird system.
> >
> > For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and
> MySQL
> > 5.1.44 on Windows 7 Home Premium. However, whenever I try accessing
> MySQL
> > via PHP, I get the following error:
> >
> > A connection attempt failed because the connected party did not proper=
ly
> > respond after a period of time, or established connection failed becau=
se
> > connected host has failed to respond.
> >
> > MySQL's command line client is still working fine. I think that PHP
> simply
> > does not see MySQL, though the settings in php.ini seem to be correct.
> > Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've
> tried
> > turning off the antivirus, because sometimes it may cause timeouts, bu=
t
> it
> > didn't help. Can someone please help me fix this?
>
> PHP does not come with any database enabled by default, so you will need =
to
> enable one. For MySQL just look in php.ini for the line
> ;extension=3Dphp_mysql.dll
> and remove the ';' at the front, and then restart Apache.
> The first page you should create is
>
> > phpinfo();
> ?>
>
> Which will list all the modules that are active ;)
>
>
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://lsces.co.uk/wiki/?page=3Dcontact
> L.S.Caine Electronic Services - http://lsces.co.uk
> EnquirySolve - http://enquirysolve.com/
> Model Engineers Digital Workshop - http://medw.co.uk//
> Firebird - http://www.firebirdsql.org/index.php
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--=20
akan ada dimana mulut terkunci dan suara tak ada lagi..
saat itu gunakanlah HP untuk melakukan SMS!!
-> ini aliran bedul.. bukan aliran aneh.
tertawa sebelum tertawa didepan RSJ..

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

RE: Re: [PHP-DB] Cannot connect to MySQL

am 07.03.2010 20:15:00 von Venkat Raman Don

Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL

am 16.03.2010 04:23:12 von bedul

--001636e1fbb084c2110481e2844a
Content-Type: text/plain; charset=ISO-8859-1

thx for your enlighment

On Mon, Mar 8, 2010 at 2:15 AM, Venkat Raman Don wrote:

> Hi,
>
> Let me take a shot at explaining this in simple terms. Most of the
> Operating System today is building support for IPV6. IPV4 has its own set of
> limitation and hence the world is moving to IPV6. I am not going to explain
> differences between two, but for the sake of this discussion assume that
> they are different.
>
> A close look at PHP MySQL driver code indicates that mysql_connect()
> function uses mysql_real_connect() to connect to MySQL. The API
> mysql_real_connect() is an API which comes from MySQL dll (MySQL development
> team and is part of MySQL database installation). So this means the support
> for IPV6 in PHP MySQL driver is not possible unless there is a support for
> IPV6 in MySQL database. So the limitation (or no support for IPV6 or
> whatever word may be used to describe this situation) is coming from MySQL
> database limitation. So now it is clear that this is not a PHP bug in the
> sense that nothing can be changed in PHP code base to fix it.
>
> Let's move on to operating system concern now. A typical host file
> (irrespective of OS) has two columns which contains the IP address and host
> name binding to it. In order to support both IPV4 and IPV6 (at least on
> Windows) localhost is getting mapped to two IP addresses. There can be other
> reasons for mapping same localhost to multiple IP address. What is important
> is that, there is a case where we have multiple IP address pointing to same
> host name. A close inspection of MySQL code reveals that the function
> mysql_real_connect() actually tries to connect to only the first IP address
> returned for the hostname and if this fails, no further attempt to connect
> using other IP address associated with same host name is made. This can be
> fixed and I believe a patch is already lying in some development branch of
> MySQL and please follow MySQL release to know which version has this fix
> integrated. I do not have any idea about that. But an important thing is
> that this bug can surface on any OS where you have above condition satisfied
> for the host file. Yes WINDOWS, Ubuntu, Solaris all will and may get
> impacted. So this means that this is not a problem with Windows OS or for
> that reason any other OS.
>
> Hope this explain things.
>
> Thanks,
> Don.
>
>
> -----Original Message-----
> From: Gunawan Wibisono [mailto:landavia81@gmail.com]
> Sent: Sunday, March 07, 2010 7:37 AM
> To: php-windows@lists.php.net; php-db@lists.php.net
> Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
>
> sry.. this kinda other person problem
> thx for your support and I kinda found this problem on other place.. Is
> posible.. the problem in the windows 7?
>
> On Sun, Mar 7, 2010 at 12:12 AM, Venkat Raman Don
> wrote:
>
> > Seems like IPV6 functionality of Windows and MySQL driver is not gelling
> > well.
> >
> > Please see http://bugs.php.net/bug.php?id=50172.
> > This is also discussed in MySQL forum at
> > http://forums.mysql.com/read.php?52,294772,294772#msg-294772 .
> >
> > Thanks,
> > Don.
> >
> >
> > -----Original Message-----
> > From: Lester Caine [mailto:lester@lsces.co.uk]
> > Sent: Saturday, March 06, 2010 9:01 AM
> > To: php-windows
> > Subject: Re: [PHP-WIN] Re: [PHP-DB] Cannot connect to MySQL
> >
> > Gunawan Wibisono wrote:
> > > Hello,
> > >
> > > First of all, I apologise if I do something wrong, because I'm new to
> > this
> > > weird system.
> > >
> > > For test purposes, I have installed Apache 2.2.14 with PHP 5.3.1 and
> > MySQL
> > > 5.1.44 on Windows 7 Home Premium. However, whenever I try accessing
> > MySQL
> > > via PHP, I get the following error:
> > >
> > > 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.
> > >
> > > MySQL's command line client is still working fine. I think that PHP
> > simply
> > > does not see MySQL, though the settings in php.ini seem to be correct.
> > > Earlier (before I upgraded to Windows 7 and PHP 5.3) it worked. I've
> > tried
> > > turning off the antivirus, because sometimes it may cause timeouts,
> but
> > it
> > > didn't help. Can someone please help me fix this?
> >
> > PHP does not come with any database enabled by default, so you will need
> to
> > enable one. For MySQL just look in php.ini for the line
> > ;extension=php_mysql.dll
> > and remove the ';' at the front, and then restart Apache.
> > The first page you should create is
> >
> > > > phpinfo();
> > ?>
> >
> > Which will list all the modules that are active ;)
> >
> >
> >
> > --
> > Lester Caine - G8HFL
> > -----------------------------
> > Contact - http://lsces.co.uk/wiki/?page=contact
> > L.S.Caine Electronic Services - http://lsces.co.uk
> > EnquirySolve - http://enquirysolve.com/
> > Model Engineers Digital Workshop - http://medw.co.uk//
> > Firebird - http://www.firebirdsql.org/index.php
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
> >
> > --
> > PHP Windows Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
>
> --
> akan ada dimana mulut terkunci dan suara tak ada lagi..
> saat itu gunakanlah HP untuk melakukan SMS!!
> -> ini aliran bedul.. bukan aliran aneh.
> tertawa sebelum tertawa didepan RSJ..
>

--
akan ada dimana mulut terkunci dan suara tak ada lagi..
saat itu gunakanlah HP untuk melakukan SMS!!
-> ini aliran bedul.. bukan aliran aneh.
tertawa sebelum tertawa didepan RSJ..

--001636e1fbb084c2110481e2844a--