PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 + Windows XP SP2)

[Jeff88]

Hi,

Good Day! I have problem in getting the PHP 5.2.6 to integrate with MYSQL 5.0.51b. I had done the following installations and configurations on Windows XP (SP2):

1. Installed APACHE 2.0.63 - running fine
2. Installed PHP 5.2.6 - running fine
3. Configured httpd.conf and php.ini - PHP and APACHE is talking. I had tested with phpinfo(), both PHP and APACHE info displayed
4. Installed MYSQL 5.0.51b - running fine
5. I had done the followings try to get PHP5 talking to MYSQL:
      a. uncommented extension=php_mysql.dll in php.ini
      b. It does not work, so I copied the libmysql.dll from MYSQL5 package to override the libmysql.dll in PHP package. It does not work either.
      c. Tested with the phpinfo() but no mysql info displayed

Can anyone help me on this? Thank you.

Regards
Jeff
     

[chris smith-9]

Jeff88 wrote:

> Hi,
>
> Good Day! I have problem in getting the PHP 5.2.6 to integrate with MYSQL
> 5.0.51b. I had done the following installations and configurations on
> Windows XP (SP2):
>
> 1. Installed APACHE 2.0.63 - running fine
> 2. Installed PHP 5.2.6 - running fine
> 3. Configured httpd.conf and php.ini - PHP and APACHE is talking. I had
> tested with phpinfo(), both PHP and APACHE info displayed
> 4. Installed MYSQL 5.0.51b - running fine
> 5. I had done the followings try to get PHP5 talking to MYSQL:
>       a. uncommented extension=php_mysql.dll in php.ini

Did you restart apache?

Stupid question I know but best to check.

Any errors in the apache logs?

Did you edit the right php.ini file? Look at the phpinfo() page and see
which file it's loading from.

--
Postgresql & php tutorials
http://www.designmagick.com/

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

[Jeff88]

jeff88 wrote:

chris smith-9 wrote:
>Did you restart apache?
>
>Stupid question I know but best to check.
>
>Any errors in the apache logs?
>
>Did you edit the right php.ini file? Look at the phpinfo() page and see
>which file it's loading from.

---

I did restart the Apache and even the pc. I edited the right php.ini file as this is the one and only one file residing in my system. phpinfo() also shows the right path where it should read from.

[Isaak Malik-3]

---------- Forwarded message ----------
From: Isaak Malik <isooik@...>
Date: Wed, May 14, 2008 at 4:07 PM
Subject: Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 +
Windows XP SP2)
To: Jeff88 <ckwoh88@...>


Make sure that you have httpd.conf correctly configured to load the php.ini
configuration.
Your httpd.conf should also contain the PHPIniDir setting.

If this doesn't solve your problem then copy PHP's libmysql.dll to the "bin"
directory of Your Apache installation.


On Wed, May 14, 2008 at 10:32 AM, Jeff88 <ckwoh88@...> wrote:

>
>
> jeff88 wrote:
> >
> > chris smith-9 wrote:
> >>Did you restart apache?
> >>
> >>Stupid question I know but best to check.
> >>
> >>Any errors in the apache logs?
> >>
> >>Did you edit the right php.ini file? Look at the phpinfo() page and see
> >>which file it's loading from.
> >
> > ---
> >
> > I did restart the Apache and even the pc. I edited the right php.ini file
> > as this is the one and only one file residing in my system. phpinfo()
> also
> > shows the right path where it should read from.
> >
> >
> --
> View this message in context:
> http://www.nabble.com/PHP-5.2.6-integrating-MYSQL-5.0.51b-on-APACHE-2.0.63-%2B-Windows-XP-SP2%29-tp17201936p17226151.html
> Sent from the Php - Database mailing list archive at Nabble.com.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --

Isaak Malik
Web Developer



--
Isaak Malik
Web Developer

[Jeff88]

I had done all that but not working either. Perhaps, I should described in details of what I had done so that you guys and gals can figure out for me where I had gone wrong.

a. Installed APACHE 2.0.63 using downloaded file "apache-2.0.63-win32-x86-no_ssl.msi" under "c:\webserver\apache group" directory. Tested with "localhost" on the browser and able to see the Apache test page.

b. Installed PHP 5.2.6 using downloaded file "php-5.2.6-win32" zip package under Windows Binaries section and extracted the files under PHP directory "c:\webserver\php"

c. Configured PHP.ini file by copying php.ini-recommended as php.ini and setting the followings:
    i. display_errors = On
    ii. log_errors = On
    iii. doc_root = c:\WebServer\Apache Group\Apache2\htdocs
    iv. extension_dir = C:\WebServer\PHP\ext

d. Did php -v on command prompt and some PHP and Zend Engine version displayed.

e. Configured httpd.conf file with the following settings:
    i. LoadModule php5_module  "c:/Webserver/php/php5apache2.dll"
    ii. AddType application/x-httpd-php .php
    iii. PHPIniDir "c:/WebServer/PHP/"
    iv. DirectoryIndex  index.html  index.php  index.html.var

f. Able to see PHP and APACHE info displayed when did a phpinfo(). Upto this stage, PHP and APACHE are talking

g. Installed MYSQL 5.0.51b using downloaded file "Windows ZIP/Setup.EXE (x86)" package under directory "c:\Webserver\MYSQL5" and tested with the command "mysql -u root -p".

h. Tried to configure PHP.ini file to talk to MYSQL where I am stuck! HELP!!
    i. uncommented extension=php_mysql.dll
    ii Restarted everything but not working, so I tried to be a hero by copying libmysql.dll from MYSQL    directory to the PHP directory, restarted everything but not working either. When I did a phpinfo() no mysql info displayed, only the php and apache info can be seen.

That's the end of my long story. Hope you guys and gals can figure things for me.

Isaak Malik-3 wrote:

---------- Forwarded message ----------
From: Isaak Malik <[e-mail]>
Date: Wed, May 14, 2008 at 4:07 PM
Subject: Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE 2.0.63 +
Windows XP SP2)
To: Jeff88 <[e-mail]>


Make sure that you have httpd.conf correctly configured to load the php.ini
configuration.
Your httpd.conf should also contain the PHPIniDir setting.

If this doesn't solve your problem then copy PHP's libmysql.dll to the "bin"
directory of Your Apache installation.


On Wed, May 14, 2008 at 10:32 AM, Jeff88 <[e-mail]> wrote:

>
>
> jeff88 wrote:
> >
> > chris smith-9 wrote:
> >>Did you restart apache?
> >>
> >>Stupid question I know but best to check.
> >>
> >>Any errors in the apache logs?
> >>
> >>Did you edit the right php.ini file? Look at the phpinfo() page and see
> >>which file it's loading from.
> >
> > ---
> >
> > I did restart the Apache and even the pc. I edited the right php.ini file
> > as this is the one and only one file residing in my system. phpinfo()
> also
> > shows the right path where it should read from.
> >
> >
> --
> View this message in context:
> http://www.nabble.com/PHP-5.2.6-integrating-MYSQL-5.0.51b-on-APACHE-2.0.63-%2B-Windows-XP-SP2%29-tp17201936p17226151.html
> Sent from the Php - Database mailing list archive at Nabble.com.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
Isaak Malik
Web Developer



--
Isaak Malik
Web Developer

[Isaak Malik-3]

Did you copy PHP's libmysql.dll to the Apache "bin" directory, restart
Apache and tried again?

Also add this to your httpd.conf file:
Loadfile "C:/php/php5ts.dll"

On Thu, May 15, 2008 at 9:48 AM, Jeff88 <ckwoh88@...> wrote:

>
> I had done all that but not working either. Perhaps, I should described in
> details of what I had done so that you guys and gals can figure out for me
> where I had gone wrong.
>
> a. Installed APACHE 2.0.63 using downloaded file
> "apache-2.0.63-win32-x86-no_ssl.msi" under "c:\webserver\apache group"
> directory. Tested with "localhost" on the browser and able to see the
> Apache
> test page.
>
> b. Installed PHP 5.2.6 using downloaded file "php-5.2.6-win32" zip package
> under Windows Binaries section and extracted the files under PHP directory
> "c:\webserver\php"
>
> c. Configured PHP.ini file by copying php.ini-recommended as php.ini and
> setting the followings:
>    i. display_errors = On
>    ii. log_errors = On
>    iii. doc_root = c:\WebServer\Apache Group\Apache2\htdocs
>    iv. extension_dir = C:\WebServer\PHP\ext
>
> d. Did php -v on command prompt and some PHP and Zend Engine version
> displayed.
>
> e. Configured httpd.conf file with the following settings:
>    i. LoadModule php5_module  "c:/Webserver/php/php5apache2.dll"
>    ii. AddType application/x-httpd-php .php
>    iii. PHPIniDir "c:/WebServer/PHP/"
>    iv. DirectoryIndex  index.html  index.php  index.html.var
>
> f. Able to see PHP and APACHE info displayed when did a phpinfo(). Upto
> this
> stage, PHP and APACHE are talking
>
> g. Installed MYSQL 5.0.51b using downloaded file "Windows ZIP/Setup.EXE
> (x86)" package under directory "c:\Webserver\MYSQL5" and tested with the
> command "mysql -u root -p".
>
> h. Tried to configure PHP.ini file to talk to MYSQL where I am stuck!
> HELP!!
>     i. uncommented extension=php_mysql.dll
>     ii Restarted everything but not working, so I tried to be a hero by
> copying libmysql.dll from MYSQL    directory to the PHP directory,
> restarted
> everything but not working either. When I did a phpinfo() no mysql info
> displayed, only the php and apache info can be seen.
>
> That's the end of my long story. Hope you guys and gals can figure things
> for me.
>
>
>
> Isaak Malik-3 wrote:
> >
> > ---------- Forwarded message ----------
> > From: Isaak Malik <isooik@...>
> > Date: Wed, May 14, 2008 at 4:07 PM
> > Subject: Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE
> 2.0.63
> > +
> > Windows XP SP2)
> > To: Jeff88 <ckwoh88@...>
> >
> >
> > Make sure that you have httpd.conf correctly configured to load the
> > php.ini
> > configuration.
> > Your httpd.conf should also contain the PHPIniDir setting.
> >
> > If this doesn't solve your problem then copy PHP's libmysql.dll to the
> > "bin"
> > directory of Your Apache installation.
> >
> >
> > On Wed, May 14, 2008 at 10:32 AM, Jeff88 <ckwoh88@...> wrote:
> >
> >>
> >>
> >> jeff88 wrote:
> >> >
> >> > chris smith-9 wrote:
> >> >>Did you restart apache?
> >> >>
> >> >>Stupid question I know but best to check.
> >> >>
> >> >>Any errors in the apache logs?
> >> >>
> >> >>Did you edit the right php.ini file? Look at the phpinfo() page and
> see
> >> >>which file it's loading from.
> >> >
> >> > ---
> >> >
> >> > I did restart the Apache and even the pc. I edited the right php.ini
> >> file
> >> > as this is the one and only one file residing in my system. phpinfo()
> >> also
> >> > shows the right path where it should read from.
> >> >
> >> >
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/PHP-5.2.6-integrating-MYSQL-5.0.51b-on-APACHE-2.0.63-%2B-Windows-XP-SP2%29-tp17201936p17226151.html
> >> Sent from the Php - Database mailing list archive at Nabble.com.
> >>
> >>
> >> --
> >> PHP Database Mailing List (http://www.php.net/)
> >> To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >> --
> > Isaak Malik
> > Web Developer
> >
> >
> >
> > --
> > Isaak Malik
> > Web Developer
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/PHP-5.2.6-integrating-MYSQL-5.0.51b-on-APACHE-2.0.63-%2B-Windows-XP-SP2%29-tp17201936p17247865.html
> Sent from the Php - Database mailing list archive at Nabble.com.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --

Isaak Malik
Web Developer

[Jeff88]

Had tried that just now, but not working.

Isaak Malik-3 wrote:

Did you copy PHP's libmysql.dll to the Apache "bin" directory, restart
Apache and tried again?

Also add this to your httpd.conf file:
Loadfile "C:/php/php5ts.dll"

On Thu, May 15, 2008 at 9:48 AM, Jeff88 <[e-mail]> wrote:

>
> I had done all that but not working either. Perhaps, I should described in
> details of what I had done so that you guys and gals can figure out for me
> where I had gone wrong.
>
> a. Installed APACHE 2.0.63 using downloaded file
> "apache-2.0.63-win32-x86-no_ssl.msi" under "c:\webserver\apache group"
> directory. Tested with "localhost" on the browser and able to see the
> Apache
> test page.
>
> b. Installed PHP 5.2.6 using downloaded file "php-5.2.6-win32" zip package
> under Windows Binaries section and extracted the files under PHP directory
> "c:\webserver\php"
>
> c. Configured PHP.ini file by copying php.ini-recommended as php.ini and
> setting the followings:
>    i. display_errors = On
>    ii. log_errors = On
>    iii. doc_root = c:\WebServer\Apache Group\Apache2\htdocs
>    iv. extension_dir = C:\WebServer\PHP\ext
>
> d. Did php -v on command prompt and some PHP and Zend Engine version
> displayed.
>
> e. Configured httpd.conf file with the following settings:
>    i. LoadModule php5_module  "c:/Webserver/php/php5apache2.dll"
>    ii. AddType application/x-httpd-php .php
>    iii. PHPIniDir "c:/WebServer/PHP/"
>    iv. DirectoryIndex  index.html  index.php  index.html.var
>
> f. Able to see PHP and APACHE info displayed when did a phpinfo(). Upto
> this
> stage, PHP and APACHE are talking
>
> g. Installed MYSQL 5.0.51b using downloaded file "Windows ZIP/Setup.EXE
> (x86)" package under directory "c:\Webserver\MYSQL5" and tested with the
> command "mysql -u root -p".
>
> h. Tried to configure PHP.ini file to talk to MYSQL where I am stuck!
> HELP!!
>     i. uncommented extension=php_mysql.dll
>     ii Restarted everything but not working, so I tried to be a hero by
> copying libmysql.dll from MYSQL    directory to the PHP directory,
> restarted
> everything but not working either. When I did a phpinfo() no mysql info
> displayed, only the php and apache info can be seen.
>
> That's the end of my long story. Hope you guys and gals can figure things
> for me.
>
>
>
> Isaak Malik-3 wrote:
> >
> > ---------- Forwarded message ----------
> > From: Isaak Malik <[e-mail]>
> > Date: Wed, May 14, 2008 at 4:07 PM
> > Subject: Re: [PHP-DB] PHP 5.2.6 integrating MYSQL 5.0.51b on APACHE
> 2.0.63
> > +
> > Windows XP SP2)
> > To: Jeff88 <[e-mail]>
> >
> >
> > Make sure that you have httpd.conf correctly configured to load the
> > php.ini
> > configuration.
> > Your httpd.conf should also contain the PHPIniDir setting.
> >
> > If this doesn't solve your problem then copy PHP's libmysql.dll to the
> > "bin"
> > directory of Your Apache installation.
> >
> >
> > On Wed, May 14, 2008 at 10:32 AM, Jeff88 <[e-mail]> wrote:
> >
> >>
> >>
> >> jeff88 wrote:
> >> >
> >> > chris smith-9 wrote:
> >> >>Did you restart apache?
> >> >>
> >> >>Stupid question I know but best to check.
> >> >>
> >> >>Any errors in the apache logs?
> >> >>
> >> >>Did you edit the right php.ini file? Look at the phpinfo() page and
> see
> >> >>which file it's loading from.
> >> >
> >> > ---
> >> >
> >> > I did restart the Apache and even the pc. I edited the right php.ini
> >> file
> >> > as this is the one and only one file residing in my system. phpinfo()
> >> also
> >> > shows the right path where it should read from.
> >> >
> >> >
> >> --
> >> View this message in context:
> >>
> http://www.nabble.com/PHP-5.2.6-integrating-MYSQL-5.0.51b-on-APACHE-2.0.63-%2B-Windows-XP-SP2%29-tp17201936p17226151.html
> >> Sent from the Php - Database mailing list archive at Nabble.com.
> >>
> >>
> >> --
> >> PHP Database Mailing List (http://www.php.net/)
> >> To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >> --
> > Isaak Malik
> > Web Developer
> >
> >
> >
> > --
> > Isaak Malik
> > Web Developer
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/PHP-5.2.6-integrating-MYSQL-5.0.51b-on-APACHE-2.0.63-%2B-Windows-XP-SP2%29-tp17201936p17247865.html
> Sent from the Php - Database mailing list archive at Nabble.com.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
Isaak Malik
Web Developer

[simonclur]

PHP v5.2.6 requires to the php_mysql.dll (v5.2.6) dll to connect to
MySql.

It appears the PHP v5.2.6 .msi installation package apparently does not
copy the new php_mysql.dll into the ./ext directory as it is supposed
to.

Download the .zip version of php v5.2.6 and copy the php_mysql.dll file
from the zip archive to your /php/ext folder and make sure the following
line in your php.ini file is uncommented.

extension=php_mysql.dll

If you're having problems with "Unable to initialize module" for
php_mysql.dll then you have copied an incorrect version from a previous
or later release of php.

The php_mysql.dll file properties should show the following version
information for the dll:
File version: 5.2.6
Created: 11 January 2006 18h15

Jeff88 wrote:

Hi,

Good Day! I have problem in getting the PHP 5.2.6 to integrate with MYSQL 5.0.51b. I had done the following installations and configurations on Windows XP (SP2):

1. Installed APACHE 2.0.63 - running fine
2. Installed PHP 5.2.6 - running fine
3. Configured httpd.conf and php.ini - PHP and APACHE is talking. I had tested with phpinfo(), both PHP and APACHE info displayed
4. Installed MYSQL 5.0.51b - running fine
5. I had done the followings try to get PHP5 talking to MYSQL:
      a. uncommented extension=php_mysql.dll in php.ini
      b. It does not work, so I copied the libmysql.dll from MYSQL5 package to override the libmysql.dll in PHP package. It does not work either.
      c. Tested with the phpinfo() but no mysql info displayed

Can anyone help me on this? Thank you.

Regards
Jeff