ID: 35292 User updated by: dgrimes at scvl dot com Reported By: dgrimes at scvl dot com -Status: Feedback +Status: Open Bug Type: MySQL related Operating System: SCO OpenServer PHP Version: 4.4.1 New Comment:
I agreed to test it. Maybe nobody else has reported this but I still need to figure out what the problem is and get it fixed. I'm not trying to be obstinate. I appreciate all of the help I have received from the folks at PHP. I was just merely pointing out that even if PHP5 works, I won't be able to use it. Version 4.2.x doesn't exhibit the problem. Is there a way to review the socket related changes in 4.3.0? Something that changed on that transition is causing this problem on both 5.0.4 and 5.0.6 OpenServer OS's. I'm willing to try anything you guy's suggest. I tried building with --disable-all and received the following error on make: .lo Zend/zend_reflection_api.lo Zend/zend_execute.lo sapi/cgi/cgi_main.lo sapi/c gi/getopt.lo main/internal_functions.lo -lm -lsocket -o sapi/cgi/php Undefined first referenced symbol in file spl_ce_Countable ext/standard/array.o php_pcre_replace main/SAPI.o php_ob_gzhandler_check main/output.o uncompress ext/standard/image.o sapi/cgi/php: fatal error: Symbol referencing errors. No output written to sapi/ cgi/php collect2: ld returned 1 exit status make: *** [sapi/cgi/php] Error 1 Thanks, Dean Previous Comments: ------------------------------------------------------------------------ [2005-11-21 00:05:39] [EMAIL PROTECTED] I did not ask you to start using PHP 5, I asked to TEST it. And use --disable-all to get as clean build as possible. Anyway, this all seems some problem in your system alone. Nobody else has reported any problem like this before. ------------------------------------------------------------------------ [2005-11-20 23:41:45] dgrimes at scvl dot com I tried PHP5 but could not get a clean compile out of it yet. First I was missing two libraries, libxml2 and libxslt and then SQLLite has problems then PATH_MAX is not defined. I finally worked past those and now I get errors installing to apache. There are some undefined symbols. Even if I did have a clean compile today, I've already completed testing PHP4 with my current project and with our existing systems. I just don't have time to implement PHP5 without going through all of the documentation and testing again, which is a lot of work. I am planning to deploy to the chain the 2nd week in January. With the holiday season just around the corner, my work load will not permit me to alter my design to include PHP5. If you think that it will help troubleshoot the problem, I'll persue PHP5 only to the extent that it will help us resolve this issue. Here is the error when I execute make install for PHP5: page: php-config.1 Installing PEAR environment: /usr/local/lib/php/ dynamic linker: /d/cdev/php5-200511201930/sapi/cli/php: relocation error: symbol not found: xmlStructuredError make[1]: *** [install-pear-installer] Killed make: *** [install-pear] Error 2 Thanks, Dean ------------------------------------------------------------------------ [2005-11-20 18:55:02] [EMAIL PROTECTED] Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip ------------------------------------------------------------------------ [2005-11-20 13:34:36] dgrimes at scvl dot com Yes. The path to the socket is correct. The only thing I do to make it work is refresh the page two or three times and it will eventually connect. Another thing, if I use PHP 4.2.3 or less, I don't have the problem at all. I noticed that beginning in PHP 4.3.0 many changes were made in the area of sockets. What is the large negative number that is returned in the message (-2146870980)? What I've seen in the past when the path is incorrect is this: 2002 - Can't connect to local MySQL server through socket '/d/mysql/var/mysqlx.sock' (2) Notice that (2) is a positive integer and not negative. All I did was change mysql.sock to mysqlx.sock in the php.ini file. What's also interesting is that I received the other error (-2146870980) two times before getting the correct error (2). MySQL isn't logging anything so as far as it's concerned, nothing has made an attempt to connect. I thought it might be a timeout so I tried setting some of the timeout values but it didn't help. Is it possible that PHP isn't waiting long enough for MySQL to respond? Is the error saying that it can't find the socket file or that it simply can't connect to the socket file? If you'd like, I can place some debug code in the connect function to see what is happening or I can compile with debug to watch it execute but I'll need instructions on where to place break points and what symbols to look at. Dean ------------------------------------------------------------------------ [2005-11-20 08:52:09] [EMAIL PROTECTED] Are you sure that path to the socket is correct? ------------------------------------------------------------------------ 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/35292 -- Edit this bug report at http://bugs.php.net/?id=35292&edit=1
