#5656 [Csd]: ifx_pconnect : E [SQLSTATE=IX 001 SQLCODE=-1829]

ID: 5656 User updated by: marsu at europe dot com Reported By: marsu at europe dot com Status: Closed Bug Type: Informix related Operating System: Linux RedHat 6 PHP Version: 4.0 Release Candidate 2 Assigned To: danny New Comment: The troubles i Had were solverd by removing the PHP module for Informix Database Access from the inner module of Apache. Said in another way, the problem was solved by deactivating the php inculded in Apache. But I don't work in the entreprise I was in at that time since years, so I won't be able to help you much more :( Hope this helps! Previous Comments: ------------------------------------------------------------------------ [2004-08-20 01:04:49] SWISSWAP at BLUEWIN dot CH ifx_pconnect SQLCODE = -1829 ============================= I have developed a payment gateway that uses Informix Database. The gateway never reported database connection problem since it launched live in Aug. 2003. The gateway is running as a cgi (C and ESQL/C) on Apache httpsd. However, we have web-applications written in PHP which use the same database server and suffer from ifx_pconnect problem that mentioned in Bug 5656. We have employed Informix specialists to check informix CSDK and other configuration stuffs. They have not found anything wrong with configuration that may cause the connection problem. I guess the problem is either with PHP informix module or PHP and Apache... Apache or PHP open/close operations with file handle are not consistent. I will appreciate if ideas about fixes or suggestions to get rid of the connection problem with PHP. ------------------------------------------------------------------------ [2000-12-07 11:20:20] sniper@php.net Reopen, if this still happens when using latest snapshot from http://snaps.php.net/ --Jani ------------------------------------------------------------------------ [2000-10-03 03:58:00] danny@php.net I really need the versions of : - Informix Server (IDS 7.x, 2000, or SE 7.x ?) - Informix ESQL/C or CSDK used to build modphp Danny --- ------------------------------------------------------------------------ [2000-10-02 20:10:09] marsu at europe dot com Though this item was closed, I have to re-open it. I still have the problem, which happens or doesn't happen, without any apparent reason. We've opened a call with Informix support, which hasn't found anything yet. We've tested 3.0.14 AND 4.0RC1 ; the trouble is still there. We have tested Danny's proposed solution; the symptoms remain. Sometimes we can connect, sometimes not. Lastly I noticed that the "persistant" optin is set in httpd.ini file; so maybe the tests made with ifx_connect() instead of ifx_pconnect() may not mean anything. Anyway, in the ifx_close() doc, I read that it doesn't close the persistant opened connections. Is this true? (I also tested with no call to ifx_close().) I can't find a solution to this. Did something change in the code of ifx_connect in the 4.02 PHP release??? maybe it could help, but I can't do it without knowing this. TIA, marsu@europe.com ------------------------------------------------------------------------ [2000-08-27 18:08:40] sniper@php.net Danny: I assume you forgot to close this one? If not please reopen with feedback. --Jani ------------------------------------------------------------------------ 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/5656 -- Edit this bug report at http://bugs.php.net/?id=5656&edit=1