ID: 38841 User updated by: albertbrian at gmail dot com Reported By: albertbrian at gmail dot com Status: Assigned Bug Type: MySQLi related Operating System: OpenSuSE 10.0 PHP Version: 5.1.6 Assigned To: georg New Comment:
Okay I think I've figured out a clue to solve this problem. a) For MySQL 5.0.x: libmysqlclient.so.15 is required b) For PHP 5.1.x rpm package (OSS 10.0) was compiled to "decide" by itself: libmysqlclient.so.14 "has to" be used >From MySQL.Com, you can download "Shared compatibility libraries (4.x, 5.x libs in same package)" which contains many version of libmysqlclient.so. Think of it, if MySQL 5.0.x use libmysqlclient.so.15 but PHP 5.1.x was compiled to request libmysqlclient.so.14 only, it would make many troubles. My English is not very well, I hope everyone could understand what I mean. To solve this, just re-compile PHP 5.1.x rpm package (which is for OSS 10.0) to use libmysqlclient.so.15, or use the version as same as MySQL (in case users can choose diff MySQL version) Previous Comments: ------------------------------------------------------------------------ [2006-09-27 13:37:46] [EMAIL PROTECTED] mysql_set_character_set is a symbol defined in all MySQL 4.1 and 5.0 client libraries on my system (and i have quite a few). It is nothing that is only conditionally compiled in either (afaict.) My educated guess on this would be: some other apache module uses an older (<= 4.0) mysql client library? What happens if you try to run the PHP CLI binary and try to load ext/mysqli into that? ------------------------------------------------------------------------ [2006-09-17 07:56:59] [EMAIL PROTECTED] Please leave the status as it is, I'd like MySQL people to take a look at it. The question is why mysql_set_character_set() is not exported in libmysqlclient.so, while it's expected to be. ------------------------------------------------------------------------ [2006-09-16 00:44:35] albertbrian at gmail dot com Temporarily close this to do more investigation. ------------------------------------------------------------------------ [2006-09-16 00:37:32] albertbrian at gmail dot com Thank Judas. My bad, I do not really understand meaning of "what you are supposed to be using if you choose the server_apache_SuSE_Linux_10.0 repository". Can you please make it more clear ? Thanks. Currently, I temporarily uninstall mysqli extension. ------------------------------------------------------------------------ [2006-09-16 00:29:48] judas dot iscariote at gmail dot com to be more precise, they are linked against mysql 4.1.13 libraries, because that is the mysql version the distribution contains, and what you are supposed to be using if you choose the server_apache_SuSE_Linux_10.0 repository. and no, there is currenlty no php version for 10.0 linked against mysql 5, only for 10.1. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/38841 -- Edit this bug report at http://bugs.php.net/?id=38841&edit=1