RE: PHP access to Informix-SE

Well, you'd think so, but the doc's make such a point about it having to be onsoctcp on CentOS. Maybe it really just has to be "*soctcp". From: Plugge, Joe R. [mailto:JRPlugge@west.com] Sent: Thursday, January 21, 2010 2:32 PM To: Hultgren, Walt; informix-list@iiug.org Subject: 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).

On Jan 22, 12:36 am, "Hultgren, Walt" <walt.hultg...@emory.edu> wrote: > Well, you'd think so, but the doc's make such a point about it having to be onsoctcp on CentOS.  Maybe it really just has to be "*soctcp". > > From: Plugge, Joe R. [mailto:JRPlu...@west.com] > Sent: Thursday, January 21, 2010 2:32 PM > To: Hultgren, Walt; informix-l...@iiug.org > Subject: 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.hultg...@emory.edu] > Sent: Thursday, January 21, 2010 1:25 PM > To: Plugge, Joe R.; informix-l...@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:JRPlu...@west.com] > Sent: Thursday, January 21, 2010 2:09 PM > To: Hultgren, Walt; informix-l...@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-boun...@iiug.org [mailto:informix-list-boun...@iiug.org] On Behalf Of Hultgren, Walt > Sent: Thursday, January 21, 2010 12:48 PM > To: informix-l...@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.hultg...@emory.edu<mailto:walt.hultg...@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). Article below is an example for configuring IDS 10 with PHP. This may help for configuring PHP and SE. http://www.ibm.com/developerworks/data/library/techarticle/dm-0606bombardier/ Thanks prasad

on your linux box: With clientsdk you get esql/c as well you could try and use demo1.ec to get a better error message/more meaning full error message compile it up using esql $INFORMIXDIR/demo/esqlc/demo1.ec -o /tmp/demo1 set env: export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql run it (make sure you are trusted on the sun or modify demo1.ec so it prompts for a user/passwd) /tmp/demo1 Or try and set sqlidebug with PHP eq export SQLIDEBUG=2:/tmp/sqliout do your test with php and use sqliprint to dump the info in /tmp/ sqliout* Superboer. On 21 jan, 20:36, "Hultgren, Walt" <walt.hultg...@emory.edu> wrote: > Well, you'd think so, but the doc's make such a point about it having to be onsoctcp on CentOS.  Maybe it really just has to be "*soctcp". > > From: Plugge, Joe R. [mailto:JRPlu...@west.com] > Sent: Thursday, January 21, 2010 2:32 PM > To: Hultgren, Walt; informix-l...@iiug.org > Subject: 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.hultg...@emory.edu] > Sent: Thursday, January 21, 2010 1:25 PM > To: Plugge, Joe R.; informix-l...@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:JRPlu...@west.com] > Sent: Thursday, January 21, 2010 2:09 PM > To: Hultgren, Walt; informix-l...@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-boun...@iiug.org [mailto:informix-list-boun...@iiug.org] On Behalf Of Hultgren, Walt > Sent: Thursday, January 21, 2010 12:48 PM > To: informix-l...@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.hultg...@emory.edu<mailto:walt.hultg...@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).