Apache 2, php 5, mysql 5 ~~> Error???

Csoft

This is some of the things I have done for integrate apache 2, php 5, mysql 5 alpha:

make sure that php could run fine without the mysql support on.
edit php.ini: extension_dir=C:\php\ext
In c:\windows\system32, I have php5ts.dll only, nothing else related to php5
in c:\windows, I have php.ini, nothing else related to php5
in apache2/bin directory, I have libmysql.dll
in php directory, I have libmysql.dll
in php/ext, I have libmysql.dll

As you can see, I have libmysql.dll in three different places.

But i still have problem. The error message when i restart apache by Apache monitor Service :

the procedure entry point mysql_drop_db could not be located in the dynamic link library LIBMYSQL.dll

and then:

PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll"-the specified module could not be found

Let me one sugesstion!

Weedpacket

Let me one sugesstion!

[man]mysql[/man]. The installation section. Hey, it's a suggestion.

It looks like MySQL's libmysql.dll API has changed in version 5. Either that or it's buggy.

Csoft

Originally posted by Weedpacket
[man]mysql[/man]. The installation section. Hey, it's a suggestion.

It looks like MySQL's libmysql.dll API has changed in version 5. Either that or it's buggy.

I had tried with this guide! but i still meet this problems.

Moonglobe

libmysql should be in your path, not your php directory (although i suppose that counts) but you shouldnt put extension=libmysql.dll in php.ini. you're running mysql 5, so you need extension=php_mysqli.dll (note the "i" after "mysql")

Csoft

libmysql should be in your path, not your php directory

~~> I don't understand. what is "your path"???

you shouldnt put extension=libmysql.dll in php.ini

~~> in php.ini i didn't put extension=libmysql.dll . it look like that

extension=php_mysql.dll
extension=php_mysqli.dll

Moonglobe

your path is where your operating system looks for files. on windows you should probably put libmysql.dll in %windir%\system32. in fact, i'd put all the .dlls that dont start with 'php' in system32 (this shouldnt make a difference but windows is messed). other than that i dont know.. you might try

print_r(get_extension_funcs('mysql'));

Csoft

Originally posted by Moonglobe
your path is where your operating system looks for files. on windows you should probably put libmysql.dll in %windir%\system32. in fact, i'd put all the .dlls that dont start with 'php' in system32

I do follow your suggestion! but hic hic still get error:

the procedure entry point mysql_drop_db could not be located in the dynamic link library LIBMYSQL.dll

and then:

PHP Startup: Unable to load dynamic library 'C:\php\ext\php_mysql.dll"-the specified module could not be found

I try to reinstall 3 times but still get these again.

Weedpacket

It looks like libmysql.dll is being found, it's just that the DLL doesn't have the mysql_drop_db() function. Either that or Windows is lying to PHP about the problem again.

Do you have any utilities handy to examine the DLL's contents with?

When you're on the bleeding edge, you have to be prepared to bleed a little.

(Not prepared to tackle the second error message in case solving the first makes it go away....)

Csoft

Originally posted by Weedpacket
It looks like libmysql.dll is being found, it's just that the DLL doesn't have the mysql_drop_db() function. Either that or Windows is lying to PHP about the problem again.

Do you have any utilities handy to examine the DLL's contents with?

(Not prepared to tackle the second error message in case solving the first makes it go away....)

I think maybe i problems in libmysql.dll so i come to mysql.com to find the last one but i couldn't found it.

Do you have any utilities handy to examine the DLL's contents with?

~~> could you give me a link for this utilities! (The best one because seaching with google~~ > So many!)

Tanus

I had a similar problem myself initially... The libmysql.dll that comes with php5 should be about 220kb in size (offhand, I'm not at a pc with php installed). Check that against the libmysql.dll in your C:\windows\system32 folder. The old one (that gives these errors) is about 190KB in size I think. Simply copy the libmysql.dll that comes with php5 to C:\windows\system32 and overwrite the old one (it still works with php4).

Csoft

Originally posted by Tanus
I had a similar problem myself initially... The libmysql.dll that comes with php5 should be about 220kb in size (offhand, I'm not at a pc with php installed). Check that against the libmysql.dll in your C:\windows\system32 folder. The old one (that gives these errors) is about 190KB in size I think. Simply copy the libmysql.dll that comes with php5 to C:\windows\system32 and overwrite the old one (it still works with php4).

But nothing happen!!!!