PHP/MySQL + IIS

I am running a custom setup that the workgroup here needs to run.
IIS6 with Windows Server 2K3. PHP install was a little tricky but
only required the Environment Path to include C:\PHP\ and use the
php.ini in the PHP dir.

The htdocs directory is located on the D:\

I also installed MySQL on the D:\ and have the PATH variable for that
as well.
However, MySQL will not configure with PHP (as shown through the
phpinfo() );
C:\PHP\ext has all required files. php.ini has all of the comments.
Things just don't seem to work correctly.

I was just wondering if anybody had any luck with this setup and if
it's just me going crazy, or I'm doing something totally wrong. It's
been a breeze with Apache/MySQL/PHP on my local computer - however IIS
has been on heck of a pain. This has gone on for awhile now and I
definitely need to have this running soon.

Here're some test files:

http://survey.csdarch.com/phpinfo.php (lack of mysql functionality )
http://survey.csdarch.com/mysql.php (doesn't fully compile, weird.)

Re: PHP/MySQL + IIS

On Mon, 13 Aug 2007 21:42:45 +0200, Miyagi
wrote:

> I am running a custom setup that the workgroup here needs to run.
> IIS6 with Windows Server 2K3. PHP install was a little tricky but
> only required the Environment Path to include C:\PHP\ and use the
> php.ini in the PHP dir.
>
> The htdocs directory is located on the D:\
>
> I also installed MySQL on the D:\ and have the PATH variable for that
> as well.
> However, MySQL will not configure with PHP (as shown through the
> phpinfo() );
> C:\PHP\ext has all required files. php.ini has all of the comments.
> Things just don't seem to work correctly.
>
> I was just wondering if anybody had any luck with this setup and if
> it's just me going crazy, or I'm doing something totally wrong. It's
> been a breeze with Apache/MySQL/PHP on my local computer - however IIS
> has been on heck of a pain. This has gone on for awhile now and I
> definitely need to have this running soon.


1. php_mysql.dll must be enabled inside of php.ini.
2. libmysql.dll is included in the Windows PHP distribution and in order
for PHP to talk to MySQL this file needs to be available to the Windows
systems PATH.
3. the PHP directive extension_dir should be set to the directory where
the PHP extensions are located.

Have you done all this? Especially (2) seems to be overlooked by a lot of
people.
--
Rik Wasmus

Re: PHP/MySQL + IIS

On Aug 13, 3:57 pm, Rik wrote:
> On Mon, 13 Aug 2007 21:42:45 +0200, Miyagi
> wrote:
>
>
>
> > I am running a custom setup that the workgroup here needs to run.
> > IIS6 with Windows Server 2K3. PHP install was a little tricky but
> > only required the Environment Path to include C:\PHP\ and use the
> > php.ini in the PHP dir.
>
> > The htdocs directory is located on the D:\
>
> > I also installed MySQL on the D:\ and have the PATH variable for that
> > as well.
> > However, MySQL will not configure with PHP (as shown through the
> > phpinfo() );
> > C:\PHP\ext has all required files. php.ini has all of the comments.
> > Things just don't seem to work correctly.
>
> > I was just wondering if anybody had any luck with this setup and if
> > it's just me going crazy, or I'm doing something totally wrong. It's
> > been a breeze with Apache/MySQL/PHP on my local computer - however IIS
> > has been on heck of a pain. This has gone on for awhile now and I
> > definitely need to have this running soon.
>
>
> 1. php_mysql.dll must be enabled inside of php.ini.
> 2. libmysql.dll is included in the Windows PHP distribution and in order
> for PHP to talk to MySQL this file needs to be available to the Windows
> systems PATH.
> 3. the PHP directive extension_dir should be set to the directory where
> the PHP extensions are located.
>
> Have you done all this? Especially (2) seems to be overlooked by a lot of
> people.
> --
> Rik Wasmus

Yes, I definitely checked and rechecked all of these. I definitely
think it's something with the Path of PHP looking for the .dlls -
everything's activated. Would it throw an error if I had multiple
instances of those .dll files? (ie: in both windows/system32, and php/
ext with both in the PATH variable?)

Re: PHP/MySQL + IIS

This is also weird -
in the phpinfo.php:

Configuration File (php.ini) Path C:\WINDOWS
Loaded Configuration File C:\PHP\php.ini

Re: PHP/MySQL + IIS

On Mon, 13 Aug 2007 22:22:02 +0200, Miyagi
wrote:

> This is also weird -
> in the phpinfo.php:
>
> Configuration File (php.ini) Path C:\WINDOWS
> Loaded Configuration File C:\PHP\php.ini

Then by all means, edit the configuration file it does use :P
--
Rik Wasmus

Re: PHP/MySQL + IIS

"Miyagi" ha scritto nel messaggio
news:1187036522.998010.302660@d55g2000hsg.googlegroups.com.. .

> This is also weird -
> in the phpinfo.php:
>

Hi, I'm a newby on php and on php+IIS+MySql.
I taken some hours to make MySql work also following all the manuals found
on the web.
Dont' use the php_mysql.dll that you find in the php package but use the one
given by MySql
http://dev.mysql.com/downloads/connector/php/

Copy them to the php directory, NOT in the php/ext

I moved the php.ini to c:\windows, I didn't understand if I can leave it in
the php path...