php-windows Digest 16 Mar 2010 03:31:44 -0000 Issue 3774
Topics (messages 29952 through 29954):
Re: [PHP-DB] Cannot connect to MySQL
29952 by: Pierre Joye
29953 by: Venkat Raman Don
Re: [PHP-DB] Re: Online PHP-Mysql Meeting
29954 by: Gunawan Wibisono
Administrivia:
To subscribe to the digest, e-mail:
php-windows-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-windows-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-wind...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
On Sun, Mar 7, 2010 at 4:36 PM, Gunawan Wibisono <landavi...@gmail.com> 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
--- End Message ---
--- Begin Message ---
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:landavi...@gmail.com]
Sent: Sunday, March 07, 2010 7:37 AM
To: php-wind...@lists.php.net; php...@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
<don.ra...@microsoft.com>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:les...@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
>
> <?php
> 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..
--- End Message ---
--- Begin Message ---
thx...
I looking forward to have another tutorial
On Tue, Mar 16, 2010 at 10:28 AM, win.a <win....@gmail.com> wrote:
> Good idea! i'll join
>
> All you best
> ------------------------
> What we are struggling for ?
> The life or the life ?
>
>
>
>
> On Tue, Mar 16, 2010 at 10:47 AM, Gunawan Wibisono <landavi...@gmail.com>
> wrote:
> > dear sir..
> > I can't assure.. I will not busy at that time
> > perhaps we should think off-line meting like in forum or this milis
> >
> > i think.. the first we can do is to build tutorial.. Like I posted
> earlier..
> > I create tutor in Youtube.. I use Movie Maker and camstudio
> > *the sound is not include
> > plus in youtube.. we can text it (using annotation) soo the reader have
> > knowledge about it
> >
> > how about this.. for you all have something to share.. please share and
> all
> > document will be put in someone place.. then we can read it.. If someone
> > capable to build as movie... Please do soo
> >
> > reading is hard this day.. but if you give the movie.. HOWTO.. is help a
> lot
> >
> > On Mon, Mar 15, 2010 at 7:39 PM, nagendra prasad
> > <nagendra802...@gmail.com>wrote:
> >
> >> Hi All,
> >>
> >> I am really happy that these many people are interested in online
> meeting.
> >> I
> >> had thought about 2 ways to how to roll out this meeting.
> >>
> >> 1. First the person who is teaching a topic can make a presentation with
> >> audio or he can directly make a video of his topic and share it with
> >> others.
> >> After watching the presentation/video we can have a FAQ meeting about
> each
> >> and every topic. We can create a group in yahoo messenger and let ppl
> come
> >> their and ask questions about each topic.
> >>
> >> OR
> >>
> >>
> >> 2. We can fix a time and use some online presentation tool available on
> the
> >> net for free to roll out this meeting.
> >>
> >>
> http://www.google.com/#hl=en&source=hp&q=free+online+presentation+tool&aq=f&aqi=&aql=&oq=&fp=22b4dcbb1403dc0f
> >>
> >> If someone has any other idea please reply to this mail.
> >>
> >> Best,
> >> Guru
> >>
> >
> >
> >
> > --
> > 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..
--- End Message ---
