Topic: Using ..\MySQL\bin\libmysql.dll crashes Apache

[adonat]

Apache 2.2.9a (not IPV6)
php 5.2.6
MySQL 5.1.25rc
phpMyAdmin 2.11.7
Windows XP SP3

[httpd-php.conf] ---> [httpd.conf]
# LoadFile "C:/Server/PHP/libmysql.dll"
LoadFile "C:/Server/MySQL/bin/libmysql.dll"
LoadModule php5_module "C:/Server/PHP/php5apache2_2.dll"
PHPIniDir "C:/Server/PHP"
AddHandler application/x-httpd-php .php
AddHandler application/x-httpd-php-source .phps

When I use libmysql.dll from the MySQL directory and try to access a PHP script that uses a MySQLi function, Apache crashes with the faulting module php5ts.dll.

From what I have tried, and according to Process Monitor, it crashes when accessing mysqld.exe (mysqld-nt.exe named pipes in mysqld.exe now) When I use the one that comes with PHP, all MySQLi functions seem to work although phpMyAdmin complains about different client / server versions and it causing unpredictable behavior.

I just can't figure out how to fix this. I was going to try the native PHP / MySQL driver to bypass this problem (hopefully) but I can't find that. I was going to try a different newer php_mysqli.dll but can't find one of those either.

I used Dependency Walker and all dependencies seem to be there. Is there anyway to debug this further so I can find out what is actually going on. I get a Windows crash dump every time but I don't know what to do with it or read what it means. BTW, it says that Apache crashes but it is still running and still works, although I do a restart every time I try something else in the configs. I have done A LOT of searching and just can't crack this one.

[Steffen]

A cause could be that PHP is not build against your MySQL 5.1 .

And better not to mix MySQL 5.0 and MySQL 5.1.

Any reason you want to use 5.1.25 RC ?

Steffen

[adonat]

I changed the MySQL version to 5.051b and everything is working 100% now. I didn't realize php had to be built against a particular MySQL version. Oops.