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

On 29/01/07, Oliver Howe 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

Re: installing DBD-Informix on fedora 6

hi,

here is my sqlhosts file

demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
pmuk2 onsoctcp dbpmuk2.uk1.bibliotech.net sqlexec k=1


>Have you exported
>DBD_INFORMIX_DATABASE
>DBD_INFORMIX_USERNAME
>DBD_INFORMIX_PASSWORD

no, usually i authenticate on the db server by adding a line to the .rhosts file belonging to root.
my "stores" database is empty, i use it only for testing connections.

i just tried seting these variables

export DBD_INFORMIX_DATABASE=stores
export DBD_INFORMIX_USERNAME=informix
export DBD_INFORMIX_PASSWORD=123456

and then set the password for the user informix on the db server to 123456 (dbpmuk2.uk1.bibliotech.net is on a private network so nobody can get there). but i still get the same error as before :-

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 'pmuk2'.
$DBI_DBNAME unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE set to 'stores'.
$DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
$DBD_INFORMIX_USERNAME is set to 'informix'.
$DBD_INFORMIX_USERNAME2 is unset - defaulting to 'informix'.
$DBD_INFORMIX_PASSWORD is set.
$DBD_INFORMIX_PASSWORD2 is unset - defaulting to $DBD_INFORMIX_PASSWORD.
Testing connection to stores
CONNECT TO 'stores' with user info
SQL: -908: Attempt to connect to database server (pmuk2) failed.
ISAM: 107: ISAM error: record is locked.

Testing concurrent connection to stores
CONNECT TO 'stores' with user info
SQL: -908: Attempt to connect to database server (pmuk2) failed.
ISAM: 107: ISAM error: record is locked.


so then I tried setting DBD_INFORMIX_USERNAME to root and the password to the root password on the db server but still got the same error. here is the full output :-

[root@hmmail2 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 'pmuk2'.
$DBI_DBNAME unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE set to 'stores'.
$DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
$DBD_INFORMIX_USERNAME is set to 'root'.
$DBD_INFORMIX_USERNAME2 is unset - defaulting to 'root'.
$DBD_INFORMIX_PASSWORD is set.
$DBD_INFORMIX_PASSWORD2 is unset - defaulting to $DBD_INFORMIX_PASSWORD.
Testing connection to stores
CONNECT TO 'stores' with user info

SQL: -908: Attempt to connect to database server (pmuk2) failed.
ISAM: 107: ISAM error: record is locked.

Testing concurrent connection to stores
CONNECT TO 'stores' with user info
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


The test program esqltest compiled successfully (which 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!
[root@hmmail2 DBD-Informix-2005.02]#












On Mon, 29 Jan 2007 12:27:09 +0000 , "Tielman de Villiers" wrote:
>On 29/01/07, Oliver Howe 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

>> 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/tcp informix
sqlispy 1527/tcp informix
sqlispy1 1528/tcp informix



>
>> 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

[root@hmmail2 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 A NSI X3.135-1989.
esqlc: "esqlbasic.ec", line 158: Warning -33036: This line does not conform to A NSI 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

[root@hmmail2 DBD-Informix-2005.02]#



these are the lines it is complaining about

[root@hmmail2 DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 93
93 EXEC SQL CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL);
[root@hmmail2 DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 103
103 EXEC SQL DROP TABLE dbd_ix_esqltest;
[root@hmmail2 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

On 29/01/07, Oliver Howe wrote:

> >> 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 snoop on the server to see if any packets reach the interface
at all when running esqltest?


> >Can you compile and run esqlbasic?
>
> yes, but i get the same output as before
>
>
> these are the lines it is complaining about
>
> [root@hmmail2 DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 93
> 93 EXEC SQL CREATE TABLE dbd_ix_esqltest (Col01 INTEGER NOT NULL);
> [root@hmmail2 DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 103
> 103 EXEC SQL DROP TABLE dbd_ix_esqltest;
> [root@hmmail2 DBD-Informix-2005.02]# cat -n esqlbasic.ec | grep 158
> 158 EXEC SQL DATABASE :dbase1;
>

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?

Thanks,

--tielman

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=
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=
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=
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=
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

------=_Part_69048_13397765.1170134426680
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 1/29/07, Oliver Howe 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 #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

------=_Part_69048_13397765.1170134426680--

Re: installing DBD-Informix on fedora 6

--P+33d92oIH25kiaB
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On 2007-01-29 21:20:26 -0800, Jonathan Leffler wrote:
> This is a key issue (connecting with DB-Access on the server machine). T=
he
> 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?

Don't know about Core 6 specifically, but on Linux boxes of various ages
I have here errno 107 is ENOTCONN "Transport endpoint is not connected"
so it's probably the same on Core 6.

hp

--=20
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | hjp@wsr.ac.at | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users

--P+33d92oIH25kiaB
Content-Type: application/pgp-signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iQDQAwUBRb8J8FLjemazOuKpAQK3UQXUCgR8rWgkXRBA9oGB+Swud59Atn/e jYii
wwggnZN1qgdJLQt3PWD5ojRMHHTUp8imwp5ckswS7SACXWIUo1acPkb2sjEF E1ZY
Q5UhEGv7mt8XsCHIPRLZ7uqqPpeus2DMcjGGhLtyXrR5Rp3frsnYR1Fci5G7 awgO
j+m/OVwKJRi2kXjgiFuAdxPEn+sxWt6z5MKbSathOK5+Y4vPrEnwl10qToyV J+SQ
i8zkrJv8m7lWRN9UzSg6SDDxbA==
=7ATV
-----END PGP SIGNATURE-----

--P+33d92oIH25kiaB--

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" wrote:
>On 1/29/07, Oliver Howe 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 #include
>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

On 30/01/07, Oliver Howe 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.


[root@localhost 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
[root@localhost DBD-Informix-2005.02]#

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 +0000 , "Tielman de Villiers" wrote:
>On 30/01/07, Oliver Howe 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.
>
>
>[root@localhost 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
>[root@localhost 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

------=_Part_83575_27140246.1170208707777
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On 1/30/07, Oliver Howe 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 (linux@iiug.org - 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" <
> jonathan.leffler@gmail.com> wrote:
> >On 1/29/07, Oliver Howe 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 #include
Guardian of DBD::Informix - v2005.02 - http://dbi.perl.org
"I don't suffer from insanity - I enjoy every minute of it."

------=_Part_83575_27140246.1170208707777--

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" wrote:
>On 1/30/07, Oliver Howe 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 (linux@iiug.org - 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" <
>> jonathan.leffler@gmail.com> wrote:
>> >On 1/29/07, Oliver Howe 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 #include
>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.