Re: DBD::Informix Installation problems on Linux

Professor Bruno wrote: [...snip...] > : Further, I've tried installing both DBD-Informix-2003.04 and DBD-Informix-1.04.PC1 > : and both bomb in the same place on running perl Makefile.PL > : I have upgraded to DBI-1.37, btw. > > As a self-followup, my expeience with Informix installations on Linux has been > periodic. I have installed the following Informix pieces on my RH 6.2 box. > ONLINE 5.10.UD1 > INFORMIX-SQL Version 7.20.UD1 > INFORMIX-ESQL Version 9.51.UC1 > INFORMIX-4GL Version 7.20.UD1 > > I've started and run ONLINE along with it's companion piece dbaccess. As yet, I > haven't tested ESQL or 4GL. > > I've tried running Informix-SQL, but it fails. > > Interestingly, I receive the same errors using Informix-SQL and trying to > run perl Makefile.PL. > > Trying different scenarios, when $INFORMIXSERVER is set to 'leeloo' (per > the above mentioned sqlhosts file) I get the following error: > SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry. > > When setting $INFORMIXSERVER to leeloosoc, adding the line 1536/tcp to /etc/services, > and turning ipchains off (the box connects to the Internet and has an ipchain firewall) > I get: > SQL: -908: Attempt to connect to database server (leeloosoc) failed. > ISAM: 107: ISAM error: record is locked. > > When setting $INFORMIXSERVER to leelooshm with ipchains on (I'm not making a tcp/ip connection > here) I get: > Testing connection to stores > CONNECT TO 'stores' with user info > SQL: -25588: The appl process cannot connect to the database server leelooshm. > ISAM: 2: No such file or directory > > > If anyone can shed any light on this ... You've gotten one of the key pieces of information from other people - you must set $INFORMIXSERVER to one of the entries in your sqlhosts files (based on the first column). What I've not yet seen is any discussion of the fact that you're using OnLine 5.10 (on Linux - that means it must be a SCO port running in a compatibility box, I think; did you consider OnLine 5.20 instead?), and therefore you need to have I-Star (or, possibly, I-Net) running - you need $INFORMIXDIR/lib/sqlexecd up and running and listening for the network connections, and hence $INFORMIXSERVER needs to be set to leelootcp and not leelooshm. You can check whether the system header /usr/include/sys/errno.h defines an error 107 -- that may be more relevant than the assumed ISAM error code. However, until programs such as ISQL and I4GL can connect to the database server, there is little point in attempting to build DBD::Informix. You must be able to connect smoothly to your database to be able to build DBD::Informix. Incidentally, if you were using OnLine 5.20 and the latest CSDK 2.81 (ESQL/C 9.53), then you would be able to configure an olipcpip connection direct to the server without having to run I-Star (and you would get the I-Star software as part of the base package, rather than as a separately purchasable item). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/