RE: PHP access to Informix-SE

Wouldn't the entry on the CentOs box have to be: linux_sun sesoctcp sun_host_name linux_sun From: Hultgren, Walt [mailto:walt.hultgren@emory.edu] Sent: Thursday, January 21, 2010 1:25 PM To: Plugge, Joe R.; informix-list@iiug.org Subject: RE: PHP access to Informix-SE On the Sun db server, it's (edited for public consumption): sqlhosts: linux_sun setlitcp sun_host_name linux_sun /etc/services: linux_sun 48700/tcp # Informix from CentOS On the CentOS box, it's: sqlhosts: linux_sun onsoctcp sun_host_name linux_sun /etc/services: linux_sun 48700/tcp # Informix on Sun box For the protocol on the CentOS box, I have also tried sesoctcp, setlitcp and several others. Each time, I match the protocol in the PDO connectin string to what's in sqlhosts. Walt. PS: Sorry for the top-post -- it's just easier in Outlook. From: Plugge, Joe R. [mailto:JRPlugge@west.com] Sent: Thursday, January 21, 2010 2:09 PM To: Hultgren, Walt; informix-list@iiug.org Subject: RE: PHP access to Informix-SE Walt, what does your line in the sqlhosts file look like for the Web Server to make the connection to the Sun Box? From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of Hultgren, Walt Sent: Thursday, January 21, 2010 12:48 PM To: informix-list@iiug.org Subject: PHP access to Informix-SE I'm attempting to set up access to an Informix-SE database on a Sun server from a Web server running Apache/PHP on CentOS. So far, I'm having no success. Here's the environment -- the two versions each of Apache and PHP mean that I've tried them in various combinations: Web Server: - CentOS 5.4 - Apache 2.2.3 (w/CentOS), 2.0.63 (compiled locally) - PHP 5.1.6 (w/CentOS), 5.3.1 (compiled locally) - PDO Informix 1.2.6 - Informix Client SDK 3.50.FC6 Database Server: - Sun Solaris 10 - Informx-SE 7.25.UC7 One question I have is whether I need Informix Client SDK or Informix Connect on the db server for this type of access. I don't currently have it, but just run sqlexecd. I can successfully connect to the Sun db server from a different Sun box using Informix tools (dbaccess, isql,...). The two errors I see the most are when attempting PHP access from the CentOS box are "-11005: Invalid connection string attribute" from PHP, and (when I actually make it across to the Sun box) "-408: Invalid message type received from the sqlexec process" in the sqlexecd log. I can connect to the Sun db server from a different Sun box using Informix tools (dbaccess, isql,...) with no problem. All of the info I've been able to find on the Web and various forums is geared toward IDS, and most of it is a little dated at this point. If anyone has this type of set-up (or something close) working, I'd appreciate any suggestions you have, including which versions of the various packages to use. Thanks, Walt. -- Walt Hultgren Mailto:walt.hultgren@emory.edu<mailto:walt.hultgren@emory.edu> -- 404-727-0648 ________________________________ This e-mail message (including any attachments) is for the sole use of the intended recipient(s) and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this message (including any attachments) is strictly prohibited. If you have received this message in error, please contact the sender by reply e-mail message and destroy all copies of the original message (including attachments).