php-windows Digest 31 Oct 2004 03:44:11 -0000 Issue 2447
Topics (messages 24850 through 24854):
Re: Yet another MySQL+PHP5 issue
24850 by: Steven James Samuel Stapleton
24851 by: Adam Clauss
24852 by: colin_e
24854 by: Steven James Samuel Stapleton
Trouble with the ISAPI in PHP4
24853 by: George Hester
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Still no fix. (Actually, NT variants of windows will accept the "."
directory and "/" as a directory separator, I found this out a while ago,
and I've never had to change it before except in the Apache config which
states that directory is invalid if it has a "/".
The error states that it cannot find "C:\WBP\PHP\php_mysql.dll" this time.
(Note: it's a clean install on this machine)
-Jim Stapleton
----- Original Message -----
From: "Michael Purdy" <[EMAIL PROTECTED]>
To: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 3:49 AM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
Jim
I replied directly to you rather than the list so you would send the file
directly to me, because your 100% right, the list does not like
attachments.
Your php.ini is fine, but in CLI mode php.exe will look for a DOS/Windows
style path to the extension directory such as
; Directory in which the loadable extensions (modules) reside.
extension_dir = C:\WBP\PHP\EXTENSION
The current directory path of ./ for your extension is not valid.
Mike
----- Original Message -----
From: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
To: "Michael Purdy" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 5:22 PM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
here (oh, and it's XP-Pro SP2)
-eep, sorry, I keep forgetting to reply to the group and not the user on
email newsgroups... I'm sending this in a reply, as I remember,
newsgroups
don't like attachments (or there was a request not to use them or large
in-line junk)
Thanks,
-Jim Stapleton
----- Original Message -----
From: "Michael Purdy" <[EMAIL PROTECTED]>
To: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 2:48 AM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
> Jim
>
> Can you send me a copy of your php.ini file?
>
> Mike
>
--- End Message ---
--- Begin Message ---
You have to actually have the php_mysql.dll file somewhere (this is different from libmysql.dll). I got mine out of the zip file
for windows (not the installer). Place that in whatever directory you have specified as your extension directroy in php.ini.
Good luck
--
Adam Clauss
[EMAIL PROTECTED]
"Steven James Samuel Stapleton" <[EMAIL PROTECTED]> wrote in message news:[EMAIL
PROTECTED]
Still no fix. (Actually, NT variants of windows will accept the "." directory and "/" as a directory separator, I found this out a
while ago, and I've never had to change it before except in the Apache config which states that directory is invalid if it has a
"/".
The error states that it cannot find "C:\WBP\PHP\php_mysql.dll" this time.
(Note: it's a clean install on this machine)
-Jim Stapleton
----- Original Message -----
From: "Michael Purdy" <[EMAIL PROTECTED]>
To: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 3:49 AM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
Jim
I replied directly to you rather than the list so you would send the file
directly to me, because your 100% right, the list does not like attachments.
Your php.ini is fine, but in CLI mode php.exe will look for a DOS/Windows
style path to the extension directory such as
; Directory in which the loadable extensions (modules) reside.
extension_dir = C:\WBP\PHP\EXTENSION
The current directory path of ./ for your extension is not valid.
Mike
----- Original Message -----
From: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
To: "Michael Purdy" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 5:22 PM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
here (oh, and it's XP-Pro SP2)
-eep, sorry, I keep forgetting to reply to the group and not the user on
email newsgroups... I'm sending this in a reply, as I remember, newsgroups
don't like attachments (or there was a request not to use them or large
in-line junk)
Thanks,
-Jim Stapleton
----- Original Message -----
From: "Michael Purdy" <[EMAIL PROTECTED]>
To: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 2:48 AM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
> Jim
>
> Can you send me a copy of your php.ini file?
>
> Mike
>
--- End Message ---
--- Begin Message ---
I hit the same problem with my recent (first) install of PHP(5) with
Apache(2) and MySQL 4.0.18.
Looking at the PHP list archives it is clearly giving quite a few people
problems. I spent some time
experimenting with this to get it working, and came to some interesting
conclusions, which don't
always agree with what the docs say. Here's what I found-
* The libmySQL.dll (note capitalisation) that comes with the mysql
install will NOT work with
Apache/PHP, at least with the versions I have. Only the libmysql.dll
shipped with the PHP
install works.
I don't know what the reason is, it could be a version mismatch or
maybe mysql and PHP are
built using different compilers, but it's a problem.
* I think if the lib shipped with mysql is first in your search path
(but see below), it prevents the
PHP-shipped one being seen, and prevents the module loading.
* The PHP install docs say the dlls are searched for using the PATH from
the environment, but
I found this did not work reliably. For example I have both
"C:\WINDOWS" and
"C:\WINDOWS\system32" in my PATH, but putting the PHP-sourced
libmysql.dll in the
WINDOWS directory did not work, it had to be in the system32
subdirectory.
* Bizarrely, even putting the libmysql.dll in the same directory as
php_mysql.dll fails. Even
Though Apache finds php_mysql ok, this in turn fails to find libmysql.
Nett of all this, is (for me), to get a working system I have:
1) In Apache httpd.conf:
#
# PHP 5 Support.
#
LoadModule php5_module "C:/Program Files/PHP/php5apache2.dll"
AddType application/x-httpd-php .php
2) System PATH:
C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\MySQL\bin;C:\Program
Files\PHP
3) In C:\WINDOWS\php.ini:
extension_dir = "C:\Program Files\PHP\ext"
extension=php_mysql.dll
4) In C:\WINDOWS\system32:
A copy of the libmysql.dll taken from the PHP install directory.
Overall this is more than a bit obscure and error-prone, and it's not a
very elegant solution. My initial
impression is that Apache 2 is still fairly "green", for instance on my
machine after a couple of basic
edits of the httpd.conf file I now find the server will crash if I use
the Stop or Restart functions of the
Apache Service Monitor.
Lets hope this gets cleaned up as the software matures.
Good luck.
Regards: Colin
Steven James Samuel Stapleton <[EMAIL PROTECTED]> wrote:
Date:
Fri, 29 Oct 2004 22:46:11 -0400
To:
[EMAIL PROTECTED]
I am running PHP 5.0.2 and MySQL 4.0.21-nt
the install directory (C:\WBP\PHP\) is in the path. The MySQL dir is
not in the path.
I am attempting to use the PHP shell/command line feature (rather
than web server), however I get this result:
-----------------------------------------------------------------
C:\> php -v
PHP Warning: PHP Startup: Unable to load dyanamic library
'./php_mysql.dll' - The specified module could not be found.
-----------------------------------------------------------------
This occures with libmysql.dll in either the php dir, %WINDIR% and
%WINDIR%\system32.
If I place it in any of these spots and rename it php_mysql.dll, I
get this error:
-----------------------------------------------------------------
PHP Warning: PHP Startup: Invalid library (maybe not a PHP library)
'php_mysql.dll' in Unknown on line 0
-----------------------------------------------------------------
Someone said that this file does not work for MySQL 4.0.21, is that
the cause of this problem (or set of problems) or should I look
further? I'm really stumped here.
Thank you,
-Jim Stapleton
--- End Message ---
--- Begin Message ---
Thanks that got it working
-Jim Stapleton
----- Original Message -----
From: "Adam Clauss" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 12:02 PM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
You have to actually have the php_mysql.dll file somewhere (this is
different from libmysql.dll). I got mine out of the zip file for windows
(not the installer). Place that in whatever directory you have specified
as your extension directroy in php.ini.
Good luck
--
Adam Clauss
[EMAIL PROTECTED]
"Steven James Samuel Stapleton" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
Still no fix. (Actually, NT variants of windows will accept the "."
directory and "/" as a directory separator, I found this out a while ago,
and I've never had to change it before except in the Apache config which
states that directory is invalid if it has a "/".
The error states that it cannot find "C:\WBP\PHP\php_mysql.dll" this
time.
(Note: it's a clean install on this machine)
-Jim Stapleton
----- Original Message -----
From: "Michael Purdy" <[EMAIL PROTECTED]>
To: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 3:49 AM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
Jim
I replied directly to you rather than the list so you would send the
file
directly to me, because your 100% right, the list does not like
attachments.
Your php.ini is fine, but in CLI mode php.exe will look for a
DOS/Windows
style path to the extension directory such as
; Directory in which the loadable extensions (modules) reside.
extension_dir = C:\WBP\PHP\EXTENSION
The current directory path of ./ for your extension is not valid.
Mike
----- Original Message -----
From: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
To: "Michael Purdy" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 5:22 PM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
here (oh, and it's XP-Pro SP2)
-eep, sorry, I keep forgetting to reply to the group and not the user
on
email newsgroups... I'm sending this in a reply, as I remember,
newsgroups
don't like attachments (or there was a request not to use them or large
in-line junk)
Thanks,
-Jim Stapleton
----- Original Message -----
From: "Michael Purdy" <[EMAIL PROTECTED]>
To: "Steven James Samuel Stapleton" <[EMAIL PROTECTED]>
Sent: Saturday, October 30, 2004 2:48 AM
Subject: Re: [PHP-WIN] Yet another MySQL+PHP5 issue
> Jim
>
> Can you send me a copy of your php.ini file?
>
> Mike
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
If I am loading extensions in my php.ini file then this is what happens when I try try
load the php4isapi.dll.
I go ahead and add it as an ISAPI filter the way it supposed to be done in IIS 5.
Then I stop the IISAdmin
Service and restart it. Then I start the Web Puublishing Service. This is where the
issue arises. If I am loading
extensions in my php.ini then I will get errors, "./extensions\php_gd2.dll not found "
for example of course loading
the php_gd2.dll extension in my php.ini. The specific dll is not the issue. It
happens with any extension I have
loaded in my php.ini upon starting the Web Publishing Service. Any ideas how to fix
this?
Thanks.
--
George Hester
__________________________________
--- End Message ---
