Click to See Complete Forum and Search --> : ifx_connect-problem with PHP4+InformixSD


Anon
03-28-2001, 10:43 AM
Situation:
Computer A (Linux, 2.4x-Kernel) runs Apache with PHP4 / MySQL and has the Informix Client SDK installed. Installation seems to be ok.

Computer B (Unix System VR4) runs an Informix Database Server V7.1.

Computer C (test: Win32 with Informix ODBC driver).

Configuration A:
Informix sqlhosts-File ok.
Environment variables all set (INFORMIXDIR etc...). PHP Installation ok. Apache ok.

Problem:
When I start an ifx_connect to the remote Server from A, the call is first accepted on B (i.e., the Informix sqlexecd-daemon passes the call to sqlexec, but rejects the call with an "cannot access database on nfs mount" error.
On B I can see that sqlexec was called with a "-X<database name>".
The same call from C (all Environmet variables equal to A) via ODBC generates the sqlexec call with "-d<database name>".

Is there a problem with the Informix client SDK in conjunction with PHP4 ?
By the way: Informix documentation is lousy !

Anyone else who has connected with PHP/Informix client SDK to an remote Informix server? Most entries specify the Informix server and PHP running on the same machine ...

bassoon
03-30-2001, 11:15 AM
I got it! So forget about the question...

The problem wasn´t the behaviour of the sqlexed daemon parsing to sqlexec - the error message was simple confusing. We duplicated the necessary parameters from machine C on A and that was silly wrong. The win32 informix driver pre-translates the transmitted string to the sqlexed daemon in a different manner the the informix SDK for Linux. So that was NOT an PHP problem!

Now all works fine, and the connection between PHP and Informix is VERY fast :-)