IBM Informix Client SDK
hi, i'm looking to download the IBM Informix Client SDK for linux (fedora), but i cant get it from http://www.ibm.com/software/data/informix/downloads.html (it is impossible to subscribe at the moment). can anyone point me in the right direction? thanks, oliver -- Oliver Howe Systems Administrator Bibliotech Ltd 20 Garrick Street London WC2E 9BT Tel: +44 (0) 20 7664 7811 Fax: +44 (0)20 7664 7878 www.bibliotech.co.uk www.homemaster.net www.officemaster.net www.postmaster.co.uk www.schoolmaster.net IMPORTANT: The contents of this email, and any attachments, are CONFIDENTIAL and intended only for the person(s) to whom they are addressed. If you have received the email in error please notify the sender immediately and delete it from your computer system. Do not copy or distribute it or diclose its contents to any person. Unless otherwise stated, the views and opinions expressed in this email are personal to the sender and do not represent the official view of the company.
installing DBD-Informix on fedora 6
hi, i am having some problems installing DBD-Informix-2005.02 on fedora6. i get stuck at perl rmautoinst.pl Makefile.PL | perl - when the esqltest program tries to contact my stores database and times out. but i'm pretty sure i am following the right steps as it works fine on other versions of fedora, and i can even telnet to the db server on port 1526 from the fedora6 server, and i have added it to the .rhosts file on the db server. can anyone provide some insight? this is what I do on fedora 4 perl -MCPAN -e 'install Bundle::DBI' groupadd -g 300 informix useradd -u 200 -g 300 informix source /etc/profile.d/informix.sh - see below for this files content vi /etc/services- i add sqlexec 1526/tcp informix at the bottom mkdir /opt/informix chown informix.informix /opt/informix/ cd /opt/informix/ tar xvf clientsdk.2.90.UC2.LINUX.tar cd clientsdk.2.90.UC2.LINUX.tar ./install_rpm cd tar xvzf DBD-Informix-2005.02.tar.gz cp /opt/informix/etc/sqlhosts.std /opt/informix/etc/sqlhosts vi /opt/informix/etc/sqlhosts - i add the db server here perl rmautoinst.pl Makefile.PL | perl - make make install any help would be appreciated, thanks oliver cat /etc/profile.d/informix.sh export INFORMIXDIR=/opt/informix export INFORMIXSERVER=pmuk2 export LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql/ PATH=/opt/informix/bin:${PATH} export ACCEPTLICENSE=yes export DBANSIWARN= export DBDATE=Y4MD- export CLIENT_LOCALE=en_us.utf8 export DB_LOCALE=en_us.utf8 -- Oliver Howe Senior Systems Administrator Tel: +44 (0) 79 7420 6484 Fax: +44 (0) 20 7664 7878 Spider Networks - the power behind interactive web communications - www.spider-networks.net -- Confidentiality Notice: This email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. General Statement: Any statements made, or intentions expressed in this communication, may not necessarily reflect the view of Spider Networks, that no content herein may be held binding upon Spider Networks or any associate or any associated company unless confirmed by the issuance of a formal contractual document or purchase order.
Re: installing DBD-Informix on fedora 6
pmuk2 onsoctcp dbpmuk2.uk1.bibliotech.net sqlexec k=1 Seems all right. Can you post the relevant entry from /etc/services? $ tail -4 /etc/services # Local services sqlexec 1526/tcpinformix sqlispy 1527/tcpinformix sqlispy11528/tcpinformix CONNECT TO 'stores' with user info SQL: -908: Attempt to connect to database server (pmuk2) failed. ISAM: 107: ISAM error: record is locked. Seems to suggest you are connecting to the database. Can you trace any TCP traffic on the server side? no i dont see anything from that server when running the esqltest. but on the client i can telnet to the server on port 1526 as the user informix. i have stopped iptables and ip6tables on the client Can you compile and run esqlbasic? yes, but i get the same output as before [EMAIL PROTECTED] DBD-Informix-2005.02]# esql -o ./esqlbasic esqlbasic.ec ./esqlb asic esqlc: esqlbasic.ec, line 93: Warning -33036: This line does not conform to AN SI X3.135-1989. esqlc: esqlbasic.ec, line 103: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlbasic.ec, line 158: Warning -33036: This line does not conform to ANSI X3.135-1989. 3 warning(s) $DBI_DBNAME set to 'stores'. $DBD_INFORMIX_DATABASE set to 'stores'. Testing connection to stores SQL: -908: Attempt to connect to database server (pmuk2) failed. ISAM: 107: ISAM error: record is locked. You cannot use stores as a test database. You do not have sufficient privileges. SQL: -908: Attempt to connect to database server (pmuk2) failed. ISAM: 107: ISAM error: record is locked. You cannot use stores as a test database. You do not have sufficient privileges. SQL: -908: Attempt to connect to database server (pmuk2) failed. ISAM: 107: ISAM error: record is locked. *** Your Informix environment is not usable *** You must fix it before building or testing DBD::Informix [EMAIL PROTECTED] DBD-Informix-2005.02]# these are the lines it is complaining about [EMAIL PROTECTED] DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 93 93 EXEC SQL CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL); [EMAIL PROTECTED] DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 103 103 EXEC SQL DROP TABLE dbd_ix_esqltest; [EMAIL PROTECTED] DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 158 158 EXEC SQL DATABASE :dbase1; --tielman -- Oliver Howe Senior Systems Administrator Tel: +44 (0) 79 7420 6484 Fax: +44 (0) 20 7664 7878 Spider Networks - the power behind interactive web communications - www.spider-networks.net -- Confidentiality Notice: This email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. General Statement: Any statements made, or intentions expressed in this communication, may not necessarily reflect the view of Spider Networks, that no content herein may be held binding upon Spider Networks or any associate or any associated company unless confirmed by the issuance of a formal contractual document or purchase order.
Re: installing DBD-Informix on fedora 6
is good). However, it did not run successfully (which is bad). If the esqltest program did not produce any output: This suggests that there is a problem with the ESQL/C runtime environment, or with the database permissions (in which case, you should have seen diagnostics from the esqltest program itself). Consider whether the shared library path environment variable (eg LD_LIBRARY_PATH or SHLIB_PATH) is set correctly. If the esqltest program did produce some output: This suggests that you do not have enough permissions in your Informix environment. You really need DBA (at least RESOURCE) level privileges on the database you are using. If you might be having problems with ESQL/C, try to compile and run the simple ESQL/C program esqlbasic.ec, which has no Perl related code in it at all -- it is a pure ESQL/C program: esql -o esqlbasic esqlbasic.ec esqlbasic If you cannot get that to work, then the problem is with ESQL/C and not with DBD::Informix per se, and you need to get your ESQL/C installation fixed so that you can compile and run the esqlbasic program successfully. Make sure you read the whole README file before asking the DBI/DBD community for help! [EMAIL PROTECTED] DBD-Informix-2005.02]# On Mon, 29 Jan 2007 12:27:09 + , Tielman de Villiers [EMAIL PROTECTED] wrote: On 29/01/07, Oliver Howe [EMAIL PROTECTED] wrote: i am having some problems installing DBD-Informix-2005.02 on fedora6. i get stuck at perl rmautoinst.pl Makefile.PL | perl - when the esqltest program tries to contact my stores database and times out. this is what I do on fedora 4 perl -MCPAN -e 'install Bundle::DBI' groupadd -g 300 informix useradd -u 200 -g 300 informix source /etc/profile.d/informix.sh - see below for this files content vi /etc/services- i add sqlexec 1526/tcp informix at the bottom mkdir /opt/informix chown informix.informix /opt/informix/ cd /opt/informix/ tar xvf clientsdk.2.90.UC2.LINUX.tar cd clientsdk.2.90.UC2.LINUX.tar ./install_rpm cd tar xvzf DBD-Informix-2005.02.tar.gz cp /opt/informix/etc/sqlhosts.std /opt/informix/etc/sqlhosts vi /opt/informix/etc/sqlhosts - i add the db server here perl rmautoinst.pl Makefile.PL | perl - make make install cat /etc/profile.d/informix.sh export INFORMIXDIR=/opt/informix export INFORMIXSERVER=pmuk2 export LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql/ PATH=/opt/informix/bin:${PATH} export ACCEPTLICENSE=yes export DBANSIWARN= export DBDATE=Y4MD- export CLIENT_LOCALE=en_us.utf8 export DB_LOCALE=en_us.utf8 Have you exported DBD_INFORMIX_DATABASE DBD_INFORMIX_USERNAME DBD_INFORMIX_PASSWORD Can you post your sqlhosts please? --tielman -- Oliver Howe Senior Systems Administrator Tel: +44 (0) 79 7420 6484 Fax: +44 (0) 20 7664 7878 Spider Networks - the power behind interactive web communications - www.spider-networks.net -- Confidentiality Notice: This email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. General Statement: Any statements made, or intentions expressed in this communication, may not necessarily reflect the view of Spider Networks, that no content herein may be held binding upon Spider Networks or any associate or any associated company unless confirmed by the issuance of a formal contractual document or purchase order.
Re: installing DBD-Informix on fedora 6
no i dont see anything from that server when running the esqltest. but on the client i can telnet to the server on port 1526 as the user informix. i have stopped iptables and ip6tables on the client can you snoop on the server to see if any packets reach the interface at all when running esqltest? there is some stuff that reaches it :- hmmail2.uk1.bibliotech.net - dbpmuk2 TCP D=9088 S=44560 Syn Seq=2402215035 Len=0 Win=5840 Options=mss 1460,sackOK,tstamp 63258436 0,nop,wscale 7 dbpmuk2 - hmmail2.uk1.bibliotech.net TCP D=44560 S=9088 Rst Ack=2402215036 Win=0 hmmail2.uk1.bibliotech.net - *ARP C Who is 10.10.0.163, dbpmuk2 ? dbpmuk2 - hmmail2.uk1.bibliotech.net ARP R 10.10.0.163, dbpmuk2 is 8:0:20:b3:7b:33 hmmail2.uk1.bibliotech.net - dbpmuk2 TCP D=9088 S=48066 Syn Seq=2472453262 Len=0 Win=5840 Options=mss 1460,sackOK,tstamp 63278438 0,nop,wscale 7 dbpmuk2 - hmmail2.uk1.bibliotech.net TCP D=48066 S=9088 Rst Ack=2472453263 Win=0 hmmail2.uk1.bibliotech.net - dbpmuk2 TCP D=9088 S=56943 Syn Seq=2480394266 Len=0 Win=5840 Options=mss 1460,sackOK,tstamp 63278440 0,nop,wscale 7 dbpmuk2 - hmmail2.uk1.bibliotech.net TCP D=56943 S=9088 Rst Ack=2480394267 Win=0 hmmail2.uk1.bibliotech.net - *ARP C Who is 10.10.0.163, dbpmuk2 ? dbpmuk2 - hmmail2.uk1.bibliotech.net ARP R 10.10.0.163, dbpmuk2 is 8:0:20:b3:7b:33 hmmail2.uk1.bibliotech.net - dbpmuk2 TCP D=9088 S=46455 Syn Seq=2553605914 Len=0 Win=5840 Options=mss 1460,sackOK,tstamp 63298443 0,nop,wscale 7 dbpmuk2 - hmmail2.uk1.bibliotech.net TCP D=46455 S=9088 Rst Ack=2553605915 Win=0 hmmail2.uk1.bibliotech.net - *ARP C Who is 10.10.0.163, dbpmuk2 ? dbpmuk2 - hmmail2.uk1.bibliotech.net ARP R 10.10.0.163, dbpmuk2 is 8:0:20:b3:7b:33 which seems to be referring to checking the hostnames? hmmail2.uk1.bibliotech.net is the client (running fedora 6) and dbpmuk2.uk1.bibliotech.net is the db server Can you do CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL); from dbaccess on the server in the stores database as the appropriate user? yes Thanks, --tielman -- Oliver Howe Senior Systems Administrator Tel: +44 (0) 79 7420 6484 Fax: +44 (0) 20 7664 7878 Spider Networks - the power behind interactive web communications - www.spider-networks.net -- Confidentiality Notice: This email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. General Statement: Any statements made, or intentions expressed in this communication, may not necessarily reflect the view of Spider Networks, that no content herein may be held binding upon Spider Networks or any associate or any associated company unless confirmed by the issuance of a formal contractual document or purchase order.
Re: installing DBD-Informix on fedora 6
can i ask does anyone have it working properly on fedora6 ? if so, can you let me know if you did it the same way as i am trying? thanks, oliver this is what I do on fedora 4 perl -MCPAN -e 'install Bundle::DBI' groupadd -g 300 informix useradd -u 200 -g 300 informix source /etc/profile.d/informix.sh - see below for this files content vi /etc/services - i add sqlexec 1526/tcp informix at the bottom mkdir /opt/informix chown informix.informix /opt/informix/ cd /opt/informix/ tar xvf clientsdk.2.90.UC2.LINUX.tar cd clientsdk.2.90.UC2.LINUX.tar ./install_rpm cd tar xvzf DBD-Informix-2005.02.tar.gz cp /opt/informix/etc/sqlhosts.std /opt/informix/etc/sqlhosts vi /opt/informix/etc/sqlhosts - i add the db server here perl rmautoinst.pl Makefile.PL | perl - make make install cat /etc/profile.d/informix.sh export INFORMIXDIR=/opt/informix export INFORMIXSERVER=pmuk2 export LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql/ PATH=/opt/informix/bin:${PATH} export ACCEPTLICENSE=yes export DBANSIWARN= export DBDATE=Y4MD- export CLIENT_LOCALE=en_us.utf8 export DB_LOCALE=en_us.utf8 On Mon, 29 Jan 2007 21:20:26 -0800 , Jonathan Leffler [EMAIL PROTECTED] wrote: On 1/29/07, Oliver Howe [EMAIL PROTECTED] wrote: no i dont see anything from that server when running the esqltest. but on the client i can telnet to the server on port 1526 as the user informix. i have stopped iptables and ip6tables on the client can you snoop on the server to see if any packets reach the interface at all when running esqltest? there is some stuff that reaches it :- [...snip...] which seems to be referring to checking the hostnames? hmmail2.uk1.bibliotech.net is the client (running fedora 6) and dbpmuk2.uk1.bibliotech.net is the db server Can you do CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL); from dbaccess on the server in the stores database as the appropriate user? yes This is a key issue (connecting with DB-Access on the server machine). The error 107 (discussed in previous emails in this thread) has me a bit puzzled. Does Fedora Core 6 have an error value (from errno.h) for 107? If so, does the associated message drop any hints? Taken at face value, it appears that someone has the database locked in exclusive mode (though I'd like to think the error would say that more clearly). Did the process (session) that created the database complete yet? Classically, you get exclusive access when you create a database, up until you terminate the session that created the DB. When you connect using DB-Access, you are using the same server name and sqlhosts values; you aren't suddenly switching to shared memory connections or anything like that? You're using CSDK 2.90.UC2; that's good. Close enough to the most recent version that it is unlikely to be the cause of the trouble. You seem to be connecting to IDS as either root or informix - frankly, you should do neither. Treat them both with extreme caution - they are just about equally powerful with respect to IDS. I never do things like building DBD::Informix as either informix or root; I'd find (or create) another user to do the work as. If I actually needed to install DBD::Informix as root, I'd use the privileges then, but only then. [Aside: I'm not sure why you feel having DBANSIWARN set is a good idea.] -- Jonathan Leffler [EMAIL PROTECTED] #include disclaimer.h Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org I don't suffer from insanity - I enjoy every minute of it. -- Oliver Howe Senior Systems Administrator Tel: +44 (0) 79 7420 6484 Fax: +44 (0) 20 7664 7878 Spider Networks - the power behind interactive web communications - www.spider-networks.net -- Confidentiality Notice: This email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. General Statement: Any statements made, or intentions expressed in this communication, may not necessarily reflect the view of Spider Networks, that no content herein may be held binding upon Spider Networks or any associate or any associated company unless confirmed by the issuance of a formal contractual document or purchase order.
Re: installing DBD-Informix on fedora 6
Thanks for doing that, very good of you. I have probably done (or not done) something obvious which I will end up kicking myself for. As soon as I find out what it is, I'll let you know. Regards, Oliver On Tue, 30 Jan 2007 15:09:59 + , Tielman de Villiers [EMAIL PROTECTED] wrote: On 30/01/07, Oliver Howe [EMAIL PROTECTED] wrote: can i ask does anyone have it working properly on fedora6 ? if so, can you let me know if you did it the same way as i am trying? I did a fresh install of FC6 and followed your installation procedure. Though I got the same warnings from esqlc, I did get a Makefile, it compiled, and works in a test script. I therefore suspect the problem is on your database side, ie, user permissions, etc. [EMAIL PROTECTED] DBD-Informix-2005.02]# perl rmautoinst.pl Makefile.PL | perl - Configuring IBM Informix Database Driver for Perl DBI Version 2005.02 (2005-07-29) (aka DBD::Informix) You are using DBI version 1.53 and Perl version 5.008008 Remember to actually read the README file! Perl: perl v5.008008 i386-linux-thread-multi dl_dlopen.xs System: linux hs20-bc2-2.build.redhat.com 2.6.9-34.elsmp #1 smp fri feb 24 16:56:28 est 2006 i686 i686 i386 gnulinux Using INFORMIXDIR=/opt/informix and ESQL/C compiler esql Using IBM Informix CSDK Version 2.90, IBM Informix-ESQL Version 2.90.UC2 from /opt/informix Beware: DBD::Informix is not yet aware of all the new IUS data types. Assert macro will be disabled! lib/DBD/Informix/Defaults.pm written OK esqlvrsn.h written OK esqlinfo.h written OK Testing whether your Informix test environment will work... esqlc: esqltest.ec, line 109: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqltest.ec, line 119: Warning -33036: This line does not conform to ANSI X3.135-1989. 2 warning(s) esqlc: esqlc_v6.ec, line 62: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 113: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 121: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 138: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 143: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 189: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 193: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 210: Warning -33036: This line does not conform to ANSI X3.135-1989. esqlc: esqlc_v6.ec, line 215: Warning -33036: This line does not conform to ANSI X3.135-1989. 9 warning(s) ESQLTEST Program Running: @(#)$Id: esqltest.ec,v 2004.1 2004/11/16 22:29:43 jleffler Exp $ $INFORMIXDIR is set to '/opt/informix'. $INFORMIXSERVER is set to 'xxx'. $DBI_DBNAME unset - defaulting to 'stores'. $DBD_INFORMIX_DATABASE set to 'xxx'. $DBD_INFORMIX_DATABASE2 unset - defaulting to 'xxx'. $DBD_INFORMIX_USERNAME is set to 'xxx'. $DBD_INFORMIX_USERNAME2 is unset - defaulting to 'xxx'. $DBD_INFORMIX_PASSWORD is set. $DBD_INFORMIX_PASSWORD2 is unset - defaulting to $DBD_INFORMIX_PASSWORD. Testing connection to xxx CONNECT TO 'xxx' with user info Testing concurrent connection to xxx CONNECT TO 'xxx with user info Your Informix environment is (probably) OK Using DBI 1.53 (for perl 5.008008 on i386-linux-thread-multi) installed in /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::Informix [EMAIL PROTECTED] DBD-Informix-2005.02]# -- Oliver Howe Senior Systems Administrator Tel: +44 (0) 79 7420 6484 Fax: +44 (0) 20 7664 7878 Spider Networks - the power behind interactive web communications - www.spider-networks.net -- Confidentiality Notice: This email is confidential and may also be privileged. If you are not the intended recipient, please notify the sender IMMEDIATELY; you should not copy the email or use it for any purpose or disclose its contents to any other person. General Statement: Any statements made, or intentions expressed in this communication, may not necessarily reflect the view of Spider Networks, that no content herein may be held binding upon Spider Networks or any associate or any associated company unless confirmed by the issuance of a formal contractual document or purchase order.
Re: installing DBD-Informix on fedora 6
I did have ipv6 switched on, so I tried turning it off but got the same error. I am going to reinstall the fedora server, without ipv6 this time and try it again. On Tue, 30 Jan 2007 17:58:27 -0800 , Jonathan Leffler [EMAIL PROTECTED] wrote: On 1/30/07, Oliver Howe [EMAIL PROTECTED] wrote: can i ask does anyone have it working properly on fedora6 ? if so, can you let me know if you did it the same way as i am trying? I asked on another mailing list ([EMAIL PROTECTED] - the International Informix User Group) and got at least a couple of positive responses. One of the answers I got was that maybe GCC 4.1.1 has issues with ESQL/C. I've got GCC 4.1.0 on my (old, slow) Sun Ultra 10 (1 CPU @ 333 MHz, 256 MB RAM) and haven't noticed problems there; I'm compiling GCC 4.1.1 as I type (into Stage2 comparison). I'll know whether that's a platform independent part of the problem - are you actually using GCC 4.1.1 in the first place? There was also mention that error 107 was something like 'end point not available' - maybe indicating a networking error -- I'm drafting this in a different gmail account from the one that gets the IIUG mailing lists so I can't see the exact message. I am inclined to agree with Tielman's assessment that the problem is as likely to be on the database server as on the client, or maybe in the networking in between the two. Presumably, you are satisfied that the DB server is operational and can be reached from other machines without problems. Are you using IPv6 by any chance? this is what I do on fedora 4 perl -MCPAN -e 'install Bundle::DBI' groupadd -g 300 informix useradd -u 200 -g 300 informix source /etc/profile.d/informix.sh - see below for this files content vi /etc/services - i add sqlexec 1526/tcp informix at the bottom mkdir /opt/informix chown informix.informix /opt/informix/ cd /opt/informix/ tar xvf clientsdk.2.90.UC2.LINUX.tar cd clientsdk.2.90.UC2.LINUX.tar ./install_rpm cd tar xvzf DBD-Informix-2005.02.tar.gz cp /opt/informix/etc/sqlhosts.std /opt/informix/etc/sqlhosts vi /opt/informix/etc/sqlhosts - i add the db server here perl rmautoinst.pl Makefile.PL | perl - make make install cat /etc/profile.d/informix.sh export INFORMIXDIR=/opt/informix export INFORMIXSERVER=pmuk2 export LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql/ PATH=/opt/informix/bin:${PATH} export ACCEPTLICENSE=yes export DBANSIWARN= export DBDATE=Y4MD- export CLIENT_LOCALE=en_us.utf8 export DB_LOCALE=en_us.utf8 On Mon, 29 Jan 2007 21:20:26 -0800 , Jonathan Leffler [EMAIL PROTECTED] wrote: On 1/29/07, Oliver Howe [EMAIL PROTECTED] wrote: no i dont see anything from that server when running the esqltest. but on the client i can telnet to the server on port 1526 as the user informix. i have stopped iptables and ip6tables on the client can you snoop on the server to see if any packets reach the interface at all when running esqltest? there is some stuff that reaches it :- [...snip...] which seems to be referring to checking the hostnames? hmmail2.uk1.bibliotech.net is the client (running fedora 6) and dbpmuk2.uk1.bibliotech.net is the db server Can you do CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL); from dbaccess on the server in the stores database as the appropriate user? yes This is a key issue (connecting with DB-Access on the server machine). The error 107 (discussed in previous emails in this thread) has me a bit puzzled. Does Fedora Core 6 have an error value (from errno.h) for 107? If so, does the associated message drop any hints? Taken at face value, it appears that someone has the database locked in exclusive mode (though I'd like to think the error would say that more clearly). Did the process (session) that created the database complete yet? Classically, you get exclusive access when you create a database, up until you terminate the session that created the DB. When you connect using DB-Access, you are using the same server name and sqlhosts values; you aren't suddenly switching to shared memory connections or anything like that? You're using CSDK 2.90.UC2; that's good. Close enough to the most recent version that it is unlikely to be the cause of the trouble. You seem to be connecting to IDS as either root or informix - frankly, you should do neither. Treat them both with extreme caution - they are just about equally powerful with respect to IDS. I never do things like building DBD::Informix as either informix or root; I'd find (or create) another user to do the work as. If I actually needed to install DBD::Informix as root, I'd use the privileges then, but only then. -- Jonathan Leffler [EMAIL PROTECTED] #include disclaimer.h Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org I don't suffer from insanity - I enjoy every minute of it. -- Oliver Howe Senior Systems Administrator