ID: 26478 Comment by: michaelw at webcentral dot com dot au Reported By: fillmore at nrcan dot gc dot ca Status: No Feedback Bug Type: MySQL related Operating System: Solaris 8 (SPARC) PHP Version: 4.3.4 New Comment:
I can duplicate this using PHP 4.3.10 with MySQL 3.23.58 under SunONE 6.1 under Solaris 9. (incidently, the fix for the 'unable to connect' issue mentioned is to set CFLAGS to include -D_REENTRANT ) I can give you any additional information you require, if you can tell me how :) Previous Comments: ------------------------------------------------------------------------ [2004-01-01 01:00:00] php-bugs at lists dot php dot net No feedback was provided for this bug for over 2 weeks, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2003-12-16 14:57:27] [EMAIL PROTECTED] Please check your mysql settings.. (my.cnf for starters) ------------------------------------------------------------------------ [2003-12-16 14:47:20] fillmore at nrcan dot gc dot ca I installed MySQL client libraries 4.0.15 and rebuilt PHP with --with-mysql=/usr/local/mysql, and now the PHP script is failing with: "Warning: mysql_connect(): Can't connect to MySQL server on 'aaa.bbb.xx.yy' (2) in /home1/fast1/WWW-data/cfs-scf/national/what-quoi/Solutions/index_e.php on line 7" (IP address is obscured as aaa.bbb.xx.yy) It works OK with the builtin MySQL support (with light load). ------------------------------------------------------------------------ [2003-12-09 06:14:16] [EMAIL PROTECTED] Please try compiling PHP with the external mysql client library, using --with-mysql=/mysql/install/prefix ------------------------------------------------------------------------ [2003-12-07 16:08:23] fillmore at nrcan dot gc dot ca I finally captured a core file, and with the gdb command "info threads" got this output for thread 25: 49 Thread 25 (LWP 17) _db_return_ (_line_=949, _sfunc_=0xfd3ee01c, _sfile_=0xfd3ee018, _slevel_=0xfd3ee014) at /home8/src/php/php-4.3.4/ext/mysql/libmysql/dbug.c:826 I can't get a full backtrace using "bt", maybe because the SunONE modules don't have debug symbols? I'm not very familiar with gdb - how do you run bt for a specified thread? I tried "thread 25" followed by "bt", but it traced libthread.so: (gdb) thread 25 [Switching to thread 25 (Thread 1 )] #0 0xfeb2826c in cond_wait () from /usr/lib/libthread.so.1 (gdb) bt #0 0xfeb2826c in cond_wait () from /usr/lib/libthread.so.1 #1 0xfeb28118 in pthread_cond_wait () from /usr/lib/libthread.so.1 #2 0xfed61a94 in PR_WaitCondVar () from /export/home/local/sunone/bin/https/lib/libnspr4.so #3 0xff298084 in __0fJWebServerDRunvT () from /export/home/local/sunone/bin/https/lib/libns-httpd40.so #4 0x10c44 in main () ------------------------------------------------------------------------ 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/26478 -- Edit this bug report at http://bugs.php.net/?id=26478&edit=1