ID: 35848 Comment by: milnivlek at gmail dot com Reported By: shawn dot richards at ink dot ltd dot uk Status: No Feedback Bug Type: MySQL related Operating System: Mac OS X Tiger. PHP Version: 5CVS-2005-12-30 (snap) Assigned To: andrey New Comment:
I think I've figured out the definitive solution for this problem (at least for most people): If you're building PHP for an x86 server, this problem apparently always occur when you use the 'Linux (x86, glibc-2.2, "standard" is static)' binary distribution from the MySQL download page. Simply use the 'Linux (x86)' distribution instead, and the problem should go away. (The 'Intel C/C++ compiled' version doesn't seem to work either, so stick with the regular one.) Hope this helps. Previous Comments: ------------------------------------------------------------------------ [2007-01-29 18:00:55] colin dot anderson at red-man dot com You're getting this problem because the MySQL >>binaries<< do not come with certain libraries that are created when you build from source on INTEL systems. To resolve this problem, you need to download the appropriate libraries. Visit >> http://dev.mysql.com/downloads/os-linux.html And grab the appropriate library for your server. All of the latest MySQL releases are compiled with the ICC9 libraries; so grab those for your appropriate architecture. This should solve your problems; as stated repeatedly above, --WITH-MYSQL-DIR[=DIR] WILL NOT WORK. :P ------------------------------------------------------------------------ [2007-01-09 20:14:56] dweller at devonweller dot com I experienced this same problem on Mac OS X 10.4 with the 64 bit package of MySQL 5.0.27. I installed the 32-bit version of MySQL 5.0.27. After that, the php compilation worked successfully. ------------------------------------------------------------------------ [2006-11-21 16:43:33] nicolasboulet at maisonlaprise dot com Thanks alot! The with-mysql-dir= command also fixed my problem on Suse Linux 10.1. Many thanks! Nicolas ------------------------------------------------------------------------ [2006-11-17 14:25:21] furyx001 at umn dot edu Has there been any update on the status of this? I was able to reproduce this as well on OS 10.4.8 Server using the 64 bit edition of MySQL (which I installed from a package). ------------------------------------------------------------------------ [2006-10-29 23:30:25] davxoc at hotmail dot com Hi everybody!!!, I had the same problem, but looking for and answer I found two things that can help me to solve it... The first one is located on http://lists.mysql.com/internals/34023 On this link explain which is the problem of integration of mysql, and give an answer ... http://dev.mysql.com/downloads/os-linux.html I had to download the libraries, after tried a lot, and reading the man's help from php config file (configure --help), found the solution. Finally those are the lines to compile my LAMP AND LAPP "framework's".... ./configure --prefix=/usr/local/php5 --with-apxs2=/usr/local/web/bin/apxs --enable-sockets --with-config-file-path=/usr/local/php5 --with-mysql-dir=/usr/local/mysql --with-pgsql=/usr/local/pgsql --with-zlib-dir=/usr/local/zlib-1.2.3 --with-libdir=/usr/local/intel-icc8-libs-8.1-i386 and tha's all!!! I hope that can 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/35848 -- Edit this bug report at http://bugs.php.net/?id=35848&edit=1