#7678 [Com]: Unable to establish connection: Can't initialize character set 7

ID: 7678 Comment by: mike at datahost dot gr Reported By: maxkir at email dot com Status: Closed Bug Type: MySQL related Operating System: Solaris x86 PHP Version: 4.0 Latest CVS (07/11/2000) New Comment: I had the same problem and also solved it with --with-mysql=/usr/local/mysql (didnt work with plain /usr/local path instead). It works prety fine with mysql's pre-compiled binaries... My server configuration was(for linux users): - apache 1.3.31 - php 4.3.8 - MySQL 4.0.17-standard (pre-comp binary) Thanks rasm ;) Previous Comments: ------------------------------------------------------------------------ [2000-11-07 18:53:19] rasmus@php.net Resolved ------------------------------------------------------------------------ [2000-11-07 18:38:59] maxkir at email dot com After upgrade to Mysql 3.23.25-beta and full recompile works fine. Thank you! ------------------------------------------------------------------------ [2000-11-07 18:26:26] rasmus@php.net Try a 'make clean' and recompile with your new --with-mysql=/usr/local switch. ------------------------------------------------------------------------ [2000-11-07 16:14:01] maxkir at email dot com I tried to use original mysql library and rebuild. IMHO, something wrong with configure process. I get: make[1]: Entering directory `/h/home/kir/SRC/php4' /bin/sh /h/home/kir/SRC/php4/libtool --silent --mode=link gcc -I. -I/h/home/kir /SRC/php4/ -I/h/home/kir/SRC/php4 -I/h/home/kir/SRC/php4/main -I/h/home/kir/SRC/ php4/Zend -I/h/home/kir/SRC/php4 -I/usr/local/include -I/usr/local/include/freet ype -I/usr/local/include/mysql -I/u/oracle7/rdbms/public -I/u/oracle7/rdbms/demo -I/u/oracle7/network/public -I/h/home/kir/SRC/php4/ext/xml/expat/xmltok -I/h/ho me/kir/SRC/php4/ext/xml/expat/xmlparse -I/h/home/kir/SRC/php4/TSRM -D_POSIX_PTH READ_SEMANTICS -DXML_BYTE_ORDER=12 -g -O2 -o php -export-dynamic stub.lo libphp4.la Undefined first referenced symbol in file mysql_num_fields .libs/libphp4.a(php_mysql.o) mysql_num_rows .libs/libphp4.a(php_mysql.o) mysql_insert_id .libs/libphp4.a(php_mysql.o) mysql_field_count .libs/libphp4.a(php_mysql.o) mysql_errno .libs/libphp4.a(php_mysql.o) mysql_error .libs/libphp4.a(php_mysql.o) mysql_affected_rows .libs/libphp4.a(php_mysql.o) ld: fatal: Symbol referencing errors. No output written to php collect2: ld returned 1 exit status make[1]: *** [php] Error 1 ------------------------------------------------------------------------ [2000-11-07 15:24:06] stas@php.net For the record: I had this problem too, it was cured with using installed MySQL library and not that supplied with PHP (i. e., --with-mysql=/path/to/mysql/dir). Please try it, it might help. ------------------------------------------------------------------------ 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/7678 -- Edit this bug report at http://bugs.php.net/?id=7678&edit=1