Apache/PHP4/SE7.22.UC2 problem
Chris Dunlop, new to Informix, got error -25591 from PHP4 ifx_pconnect on Linux to SE 7.22 on Sun with sqlhosts protocol seipcpip. David Stes said seipcpip is local only and a network protocol such as sesoctcp or setlitcp is needed. After the change Chris got error -931 (service not in /etc/services); David advised defining the service port and installing I-Connect. Likely on track.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, I'm not at all familiar with Informix, however, I have been asked to connect our webserver to a remote Informix database on a Sun box. My webserver is a Linux Mandrake 7 box, running apache and PHP. I've compiled PHP4 --with-informix and the compile went fine. I granted access to user nobody to /opt/informix. I've placed the relevant environment info in my httpd startup script (INFORMIXSERVER=overthere, INFORMIXDIR=/opt/informix and the path to $INFORMIXDIR/bin) In my PHP script, when I try to use $conn_id=pconnect("joe@overthere","uname","password"); i get the error: Warning: ifx_pconnect : E [SQLSTATE=IX 000 SQLCODE=-25591] -25591 is defined as Transport control received an invalid connection address. the host information is in my sqlhosts file. overthere seipcpip thatserver sqlexec thatserver is in my /etc/hosts file as well. Any ideas where to go from here? Best Regards, Chris Dunlop
On Fri, 26 May 2000, Chris Dunlop wrote: > I'm not at all familiar with Informix, however, I have been asked to connect > our webserver to a remote Informix database on a Sun box. > ... > sqlhosts: overthere seipcpip thatserver sqlexec I'm sorry if I misunderstood, but if you want to connect from a Linux machine to the Sun computer, you can't use seipcpip. seipcpip is local inter-process communication (not networked). You'll have to use a sesoctcp or setlitcp. If on the other hand, you DO want to use pipes (seipcpip) I would suspect the third field might not be the FQDN (complete hostname).
> I'm sorry if I misunderstood, but if you want to connect from a Linux > machine to the Sun computer, you can't use seipcpip. Like I said, I know nothing about Informix, or what exactly is supposed to by in sqlhosts. But step in the right direction! I changed seipcpip to sesoctcp and got error -931 instead (Cannot locate %s service/tcp service in /etc/services.) I should be able to fix it from here i hope. Thanks for the help! Chris Dunlop
On Fri, 26 May 2000, Chris Dunlop wrote: > Like I said, I know nothing about Informix, or what exactly is supposed to > by in sqlhosts. But step in the right direction! I changed seipcpip to > sesoctcp and got error -931 instead (Cannot locate %s service/tcp service in > /etc/services.) I should be able to fix it from here i hope. You'll have to define the sqlexec service in /etc/service and it should correspond to the port that the SUN is using, i.e. is listening on. You also may have to install I-Connect, if you don't already have it. I believe that you need I-Connect for making remote connections. Also, the Sun should be configured to accept connections from your Linux machine. I'm not sure, since I use seipcpip (database runs on the same machine as the clients). What's puzzling, is that you have to specify TCP port number and hostname for seipcpip as well. This may have caused you to think that you could use seipcpip for making remote connections, but that's not the case.
Related threads
- Example sqlhosts file
- Error 25591: Transport control received an invalid connection address when accessing database via seipcpip method