Error loading php_mysql.dll on Apache Startup

[Harry]

Since yesterday, when I try and start apache, I get the following
message:

Warning:
PHP Startup: Unable to load dynamic library 'C:\Program
Files\PHP\ext\php_mysql.dll' - the specified procedure could not be
found.

I am running PHP 5.0 on Apache 2 and have been for some time. I got
this error when I first installed PHP5/Apache2 on this machine (a
totally fresh install - HDD reformat!!) However, it went away, and I
can't remember what I did to get rid of it.

I originally thought it was because I had a space in the location of
the dll. but I have been running it this way for a long time. I have
not changed my php.ini recently, other than trying to solve this
problem (not got any further than just commenting/uncommenting the
line that loads that module.

The module is definitely located where it is looking. I have no clue
what is going on. Can anyone help me?

Many Thanks,
Harry

[Tim Van Wassenhove]

In article <c5*************************@posting.google.com> , Harry wrote:

Since yesterday, when I try and start apache, I get the following
message:

Warning:
PHP Startup: Unable to load dynamic library 'C:\Program
Files\PHP\ext\php_mysql.dll' - the specified procedure could not be
found.

Had a look at the FAQ? I don't think that mysql module is still in the
php package since version5
--
Tim Van Wassenhove <http://home.mysth.be/~timvw/contact.php>

[Andy Hassall]

On 24 May 2004 19:42:13 GMT, Tim Van Wassenhove <eu**@pi.be> wrote:

In article <c5*************************@posting.google.com> , Harry wrote:

Since yesterday, when I try and start apache, I get the following
message:

Warning:
PHP Startup: Unable to load dynamic library 'C:\Program
Files\PHP\ext\php_mysql.dll' - the specified procedure could not be
found.

Had a look at the FAQ? I don't think that mysql module is still in the
php package since version5

Depends what you mean by that - the php_mysql.dll is the PHP MySQL extension,
and is still included. The change in PHP5 is that it no longer has a bundled
MySQL client library, which the extension DLL needs - it's linked against
libmysql.dll which isn't included.

The fact that it's saying 'procedure could not be found' means it's loaded the
extension DLL, and _probably_ loaded the MySQL client library, but then there's
been some mismatch in the interface it's expecting. Does the OP have MySQL
installed, but some incompatible version? 4.1 or something?

--
Andy Hassall <an**@andyh.co.uk> / Space: disk usage analysis tool
http://www.andyh.co.uk / http://www.andyhsoftware.co.uk/space

[Harry]

Andy Hassall <an**@andyh.co.uk> wrote in message news:<cg********************************@4ax.com>. ..

On 24 May 2004 19:42:13 GMT, Tim Van Wassenhove <eu**@pi.be> wrote:

Had a look at the FAQ? I don't think that mysql module is still in the
php package since version5

Depends what you mean by that - the php_mysql.dll is the PHP MySQL extension,
and is still included. The change in PHP5 is that it no longer has a bundled
MySQL client library, which the extension DLL needs - it's linked against
libmysql.dll which isn't included.

The fact that it's saying 'procedure could not be found' means it's loaded the
extension DLL, and _probably_ loaded the MySQL client library, but then there's
been some mismatch in the interface it's expecting. Does the OP have MySQL
installed, but some incompatible version? 4.1 or something?

Hmm, interesting idea, However, having had the same version of
mysql,php,apache in this installation for a while, and had it working
for a long time, I am not inclined to think that this is the problem.

This libmysql.dll sounds like it could be a problem, I seem to
recognise it from when I had the issue before, what is it, and where
does it need to be located in order for it to work?

Many Thanks for your help.

Harry

[Justin Wyer]

Harry wrote:

Andy Hassall <an**@andyh.co.uk> wrote in message news:<cg********************************@4ax.com>. ..

On 24 May 2004 19:42:13 GMT, Tim Van Wassenhove <eu**@pi.be> wrote:

Had a look at the FAQ? I don't think that mysql module is still in the
php package since version5

Depends what you mean by that - the php_mysql.dll is the PHP MySQL extension,
and is still included. The change in PHP5 is that it no longer has a bundled
MySQL client library, which the extension DLL needs - it's linked against
libmysql.dll which isn't included.

The fact that it's saying 'procedure could not be found' means it's loaded the
extension DLL, and _probably_ loaded the MySQL client library, but then there's
been some mismatch in the interface it's expecting. Does the OP have MySQL
installed, but some incompatible version? 4.1 or something?

Hmm, interesting idea, However, having had the same version of
mysql,php,apache in this installation for a while, and had it working
for a long time, I am not inclined to think that this is the problem.

This libmysql.dll sounds like it could be a problem, I seem to
recognise it from when I had the issue before, what is it, and where
does it need to be located in order for it to work?

Many Thanks for your help.

Harry

Also, some versions of php5 are bugged when it comes to loading the
extensions, around about version RC1, download the latest win32 snapshot
or RC2.

[Harry]

Justin Wyer <ju****@isogo.co.za> wrote in message news:<c8**********@ctb-nnrp2.saix.net>...

Also, some versions of php5 are bugged when it comes to loading the
extensions, around about version RC1, download the latest win32 snapshot
or RC2.

OK, I downloaded RC2 and installed, and that didn't see to make a
difference, then I found a website which said something about
libmysql.dll in the System32 folder, mine was in the Windows folder,
and the version in system32 was an older version. so I updated the
version in system32 with the version in windows folder and it works
fine now...

Thanks for your help guys.

Harry