To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here
PHPBuilder.com  
 

 

Go Back   PHPBuilder.com > PHP Help > Upgrading PHP

Upgrading PHP Issues concerning PHP version upgrades and future releases

Reply
 
Thread Tools Rate Thread Display Modes
Old 05-23-2004, 08:35 AM   #1
Csoft
Junior Member
 
Join Date: May 2004
Location: Viet Nam
Posts: 6
Apache 2, php 5, mysql 5 ~~> Error???

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

1. make sure that php could run fine without the mysql support on.
2. edit php.ini: extension_dir=C:\php\ext
3. In c:\windows\system32, I have php5ts.dll only, nothing else related to php5
4. in c:\windows, I have php.ini, nothing else related to php5
5. in apache2/bin directory, I have libmysql.dll
6. in php directory, I have libmysql.dll
7. 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!
Csoft is offline   Reply With Quote
Old 05-23-2004, 08:55 AM   #2
Weedpacket
Custom User Title™
 
Weedpacket's Avatar
 
Join Date: Aug 2002
Location: Rapid Offensive Unit "Foreign Object Damage"
Posts: 19,128
Re: Apache 2, php 5, mysql 5 ~~> Error???

Quote:
Let me one sugesstion!
mysql. 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.
__________________
On two occasions I have been asked [by Members of Parliament], "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.

Last edited by Weedpacket; 05-23-2004 at 09:21 AM.
Weedpacket is offline   Reply With Quote
Old 05-23-2004, 09:22 AM   #3
Csoft
Junior Member
 
Join Date: May 2004
Location: Viet Nam
Posts: 6
Re: Re: Apache 2, php 5, mysql 5 ~~> Error???

Quote:
Originally posted by Weedpacket
mysql. 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.
Csoft is offline   Reply With Quote
Old 05-23-2004, 01:52 PM   #4
Moonglobe
Better fan than rebelo!
 
Moonglobe's Avatar
 
Join Date: Apr 2003
Location: brain://localhost:left-side
Posts: 2,381
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")
__________________
there's no place i can be, since i found serenity.
Moonglobe is offline   Reply With Quote
Old 05-23-2004, 02:34 PM   #5
Csoft
Junior Member
 
Join Date: May 2004
Location: Viet Nam
Posts: 6
[quote]
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
Csoft is offline   Reply With Quote
Old 05-23-2004, 03:27 PM   #6
Moonglobe
Better fan than rebelo!
 
Moonglobe's Avatar
 
Join Date: Apr 2003
Location: brain://localhost:left-side
Posts: 2,381
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
PHP Code:
print_r(get_extension_funcs('mysql'));
__________________
there's no place i can be, since i found serenity.
Moonglobe is offline   Reply With Quote
Old 05-23-2004, 09:11 PM   #7
Csoft
Junior Member
 
Join Date: May 2004
Location: Viet Nam
Posts: 6
Quote:
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.
Csoft is offline   Reply With Quote
Old 05-24-2004, 04:30 AM   #8
Weedpacket
Custom User Title™
 
Weedpacket's Avatar
 
Join Date: Aug 2002
Location: Rapid Offensive Unit "Foreign Object Damage"
Posts: 19,128
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?

Quote:
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....)
__________________
On two occasions I have been asked [by Members of Parliament], "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.

Last edited by Weedpacket; 05-24-2004 at 04:33 AM.
Weedpacket is offline   Reply With Quote
Old 05-24-2004, 05:56 AM   #9
Csoft
Junior Member
 
Join Date: May 2004
Location: Viet Nam
Posts: 6
Quote:
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!)
Csoft is offline   Reply With Quote
Old 05-27-2004, 02:09 AM   #10
Tanus
Junior Member
 
Join Date: Sep 2002
Posts: 14
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).
__________________
WebPanels for PHP
Tanus is offline   Reply With Quote
Old 05-27-2004, 05:16 AM   #11
Csoft
Junior Member
 
Join Date: May 2004
Location: Viet Nam
Posts: 6
Quote:
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!!!!
Csoft is offline   Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 05:16 AM.






Acceptable Use Policy

internet.comMediabistrojusttechjobs.comGraphics.com

WebMediaBrands Corporate Info


Advertise | Newsletters | Feedback | Submit News

Legal Notices | Licensing | Permissions | Privacy Policy


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.