DBD::Informix Installation problems on Linux

[Professor Bruno]

Greetings,

Perhaps this problem has been answered before, but my search of the web and newsgroups
hasn't yielded any results. Apologies at the outset for not having able to find the
answer on my own.

I'm trying to compile DBI:DBD for Informix. I've successfully compiled, installed, and used
DBI:DBD for MySQL and PostgreSQL. This one, though has got me a bit stumped.

In doing perl Makefile.PL my compilation bombs at this point:

###############
...

lib/DBD/Informix/Defaults.pm written OK
esqlvrsn.h written OK
esqlinfo.h written OK

Testing whether your Informix test environment will work...
ESQLTEST Program Running:
@(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
$INFORMIXDIR is set to '/usr/local/informix'.
$INFORMIXSERVER is set to 'leeloo'.
$DBI_DBNAME unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
$DBD_INFORMIX_USERNAME is set to 'informix'.
$DBD_INFORMIX_USERNAME2 is set to 'informix'.
$DBD_INFORMIX_PASSWORD is set.
$DBD_INFORMIX_PASSWORD2 is set.
Testing connection to stores
CONNECT TO 'stores' with user info
SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.

Testing concurrent connection to stores
CONNECT TO 'stores' with user info
SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.


*** Your Informix environment is not usable
*** You must fix it before building or testing DBD::Informix
...
###############

Some details:
OS - Redhat Linux 6.2, kernel-2.2.24-6.2.3
Informix Online 5.10.UD1 installed and running
INFORMIX-ESQL Version 9.16.UC1



contents of /usr/local/informix/sqlhosts
# demo_on onipcshm on_hostname on_servername
# demo_se seipcpip se_hostname sqlexec
leelooshm onipcshm leeloo dummy
leeloosoc onsoctcp leeloo leeloo


Some Environments Info:
HOSTNAME=leeloo
HOSTTYPE=i386
INFORMIXDIR=/usr/local/informix
INFORMIXSERVER=leeloo
LD_LIBRARY_PATH=:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql
OSTYPE=Linux
PATH=/usr/local/informix/bin:/usr/sbin:/sbin:.:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/informix
SHELL=/bin/bash
SHLVL=1
SQLEXEC=/usr/local/informix/lib/sqlturbo
TERM=vt100

DBD_INFORMIX_PASSWORD2, DBD_INFORMIX_PASSWORD omitted from the environments listing here but set.



Any help or guidance would be appreciated.

Max

[Fernando Nunes]

Post by Professor Bruno
Greetings,
Perhaps this problem has been answered before, but my search of the web and newsgroups
hasn't yielded any results. Apologies at the outset for not having able to find the
answer on my own.
I'm trying to compile DBI:DBD for Informix. I've successfully compiled, installed, and used
DBI:DBD for MySQL and PostgreSQL. This one, though has got me a bit stumped.
###############
...
lib/DBD/Informix/Defaults.pm written OK
esqlvrsn.h written OK
esqlinfo.h written OK
Testing whether your Informix test environment will work...
@(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
$INFORMIXDIR is set to '/usr/local/informix'.
$INFORMIXSERVER is set to 'leeloo'.
$DBI_DBNAME unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
$DBD_INFORMIX_USERNAME is set to 'informix'.
$DBD_INFORMIX_USERNAME2 is set to 'informix'.
$DBD_INFORMIX_PASSWORD is set.
$DBD_INFORMIX_PASSWORD2 is set.
Testing connection to stores
CONNECT TO 'stores' with user info
SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
Testing concurrent connection to stores
CONNECT TO 'stores' with user info
SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
*** Your Informix environment is not usable
*** You must fix it before building or testing DBD::Informix
...
###############
OS - Redhat Linux 6.2, kernel-2.2.24-6.2.3
Informix Online 5.10.UD1 installed and running
INFORMIX-ESQL Version 9.16.UC1
contents of /usr/local/informix/sqlhosts
# demo_on onipcshm on_hostname on_servername
# demo_se seipcpip se_hostname sqlexec
leelooshm onipcshm leeloo dummy
leeloosoc onsoctcp leeloo leeloo
HOSTNAME=leeloo
HOSTTYPE=i386
INFORMIXDIR=/usr/local/informix
INFORMIXSERVER=leeloo
LD_LIBRARY_PATH=:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql
OSTYPE=Linux
PATH=/usr/local/informix/bin:/usr/sbin:/sbin:.:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/informix
SHELL=/bin/bash
SHLVL=1
SQLEXEC=/usr/local/informix/lib/sqlturbo
TERM=vt100
DBD_INFORMIX_PASSWORD2, DBD_INFORMIX_PASSWORD omitted from the environments listing here but set.
Any help or guidance would be appreciated.
Max

I've never used DBD but:

The sqlhosts file must be located in $INFORMIXDIR/etc/sqlhosts or
pointed to a location by $INFORMIXSQLHOSTS

You apparently don't have the $INFORMIXSQLHOSTS environment set and have
the file directly in $INFORMIXDIR instead of $INFORMIXDIR/etc


Regards

[Professor Bruno]

Fernando Nunes <***@domus.online.pt> wrote:
: Professor Bruno wrote:
:> Greetings,
:>
:> Perhaps this problem has been answered before, but my search of the web and newsgroups
:> hasn't yielded any results. Apologies at the outset for not having able to find the
:> answer on my own.
:>
:> I'm trying to compile DBI:DBD for Informix. I've successfully compiled, installed, and used
:> DBI:DBD for MySQL and PostgreSQL. This one, though has got me a bit stumped.
:>
:> In doing perl Makefile.PL my compilation bombs at this point:
:>
:> ###############
:> ...
:>
:> lib/DBD/Informix/Defaults.pm written OK
:> esqlvrsn.h written OK
:> esqlinfo.h written OK
:>
:> Testing whether your Informix test environment will work...
:> ESQLTEST Program Running:
:> @(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
:> $INFORMIXDIR is set to '/usr/local/informix'.
:> $INFORMIXSERVER is set to 'leeloo'.
:> $DBI_DBNAME unset - defaulting to 'stores'.
:> $DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
:> $DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
:> $DBD_INFORMIX_USERNAME is set to 'informix'.
:> $DBD_INFORMIX_USERNAME2 is set to 'informix'.
:> $DBD_INFORMIX_PASSWORD is set.
:> $DBD_INFORMIX_PASSWORD2 is set.
:> Testing connection to stores
:> CONNECT TO 'stores' with user info
:> SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
:>
:> Testing concurrent connection to stores
:> CONNECT TO 'stores' with user info
:> SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
:>
:>
:> *** Your Informix environment is not usable
:> *** You must fix it before building or testing DBD::Informix
:> ...
:> ###############
:>
:> Some details:
:> OS - Redhat Linux 6.2, kernel-2.2.24-6.2.3
:> Informix Online 5.10.UD1 installed and running
:> INFORMIX-ESQL Version 9.16.UC1
:>
:>
:>
:> contents of /usr/local/informix/sqlhosts
:> # demo_on onipcshm on_hostname on_servername
:> # demo_se seipcpip se_hostname sqlexec
:> leelooshm onipcshm leeloo dummy
:> leeloosoc onsoctcp leeloo leeloo
:>
:>
:> Some Environments Info:
:> HOSTNAME=leeloo
:> HOSTTYPE=i386
:> INFORMIXDIR=/usr/local/informix
:> INFORMIXSERVER=leeloo
:> LD_LIBRARY_PATH=:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql
:> OSTYPE=Linux
:> PATH=/usr/local/informix/bin:/usr/sbin:/sbin:.:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/informix
:> SHELL=/bin/bash
:> SHLVL=1
:> SQLEXEC=/usr/local/informix/lib/sqlturbo
:> TERM=vt100
:>
:> DBD_INFORMIX_PASSWORD2, DBD_INFORMIX_PASSWORD omitted from the environments listing here but set.
:>
:>
:>
:> Any help or guidance would be appreciated.
:>
:> Max
:>

: I've never used DBD but:

: The sqlhosts file must be located in $INFORMIXDIR/etc/sqlhosts or
: pointed to a location by $INFORMIXSQLHOSTS

Ooops, typo on my part. sqlhosts is located in /usr/local/informix/etc

: You apparently don't have the $INFORMIXSQLHOSTS environment set and have
: the file directly in $INFORMIXDIR instead of $INFORMIXDIR/etc

I set $INFORMIXSQLHOSTS but the installation still bombs in the same place.

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.

Thanks for your advice; would appreciate any further guidance to get through this.


: Regards


Max Pyziur

[Professor Bruno]

Pulling my own chain ...
Professor Bruno <***@panix.com> wrote:
: Fernando Nunes <***@domus.online.pt> wrote:
: : Professor Bruno wrote:
: :> Greetings,
: :>
: :> Perhaps this problem has been answered before, but my search of the web and newsgroups
: :> hasn't yielded any results. Apologies at the outset for not having able to find the
: :> answer on my own.
: :>
: :> I'm trying to compile DBI:DBD for Informix. I've successfully compiled, installed, and used
: :> DBI:DBD for MySQL and PostgreSQL. This one, though has got me a bit stumped.
: :>
: :> In doing perl Makefile.PL my compilation bombs at this point:
: :>
: :> ###############
: :> ...
: :>
: :> lib/DBD/Informix/Defaults.pm written OK
: :> esqlvrsn.h written OK
: :> esqlinfo.h written OK
: :>
: :> Testing whether your Informix test environment will work...
: :> ESQLTEST Program Running:
: :> @(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
: :> $INFORMIXDIR is set to '/usr/local/informix'.
: :> $INFORMIXSERVER is set to 'leeloo'.
: :> $DBI_DBNAME unset - defaulting to 'stores'.
: :> $DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
: :> $DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
: :> $DBD_INFORMIX_USERNAME is set to 'informix'.
: :> $DBD_INFORMIX_USERNAME2 is set to 'informix'.
: :> $DBD_INFORMIX_PASSWORD is set.
: :> $DBD_INFORMIX_PASSWORD2 is set.
: :> Testing connection to stores
: :> CONNECT TO 'stores' with user info
: :> SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
: :>
: :> Testing concurrent connection to stores
: :> CONNECT TO 'stores' with user info
: :> SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
: :>
: :>
: :> *** Your Informix environment is not usable
: :> *** You must fix it before building or testing DBD::Informix
: :> ...
: :> ###############
: :>
: :> Some details:
: :> OS - Redhat Linux 6.2, kernel-2.2.24-6.2.3
: :> Informix Online 5.10.UD1 installed and running
: :> INFORMIX-ESQL Version 9.16.UC1
: :>
: :>
: :>
: :> contents of /usr/local/informix/sqlhosts
: :> # demo_on onipcshm on_hostname on_servername
: :> # demo_se seipcpip se_hostname sqlexec
: :> leelooshm onipcshm leeloo dummy
: :> leeloosoc onsoctcp leeloo leeloo
: :>
: :>
: :> Some Environments Info:
: :> HOSTNAME=leeloo
: :> HOSTTYPE=i386
: :> INFORMIXDIR=/usr/local/informix
: :> INFORMIXSERVER=leeloo
: :> LD_LIBRARY_PATH=:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql
: :> OSTYPE=Linux
: :> PATH=/usr/local/informix/bin:/usr/sbin:/sbin:.:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/informix
: :> SHELL=/bin/bash
: :> SHLVL=1
: :> SQLEXEC=/usr/local/informix/lib/sqlturbo
: :> TERM=vt100
: :>
: :> DBD_INFORMIX_PASSWORD2, DBD_INFORMIX_PASSWORD omitted from the environments listing here but set.
: :>
: :>
: :>
: :> Any help or guidance would be appreciated.
: :>
: :> Max
: :>

: : I've never used DBD but:

: : The sqlhosts file must be located in $INFORMIXDIR/etc/sqlhosts or
: : pointed to a location by $INFORMIXSQLHOSTS

: Ooops, typo on my part. sqlhosts is located in /usr/local/informix/etc

: : You apparently don't have the $INFORMIXSQLHOSTS environment set and have
: : the file directly in $INFORMIXDIR instead of $INFORMIXDIR/etc

: I set $INFORMIXSQLHOSTS but the installation still bombs in the same place.

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

: Thanks for your advice; would appreciate any further guidance to get through this.



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

Much thanks.


: : Regards


: Max Pyziur
[recycle]

[Fernando Nunes]

Wow.... ;)

Let's look at your setup carefully:

SQLHOSTS:

# demo_on onipcshm on_hostname on_servername
# demo_se seipcpip se_hostname sqlexec
leelooshm onipcshm leeloo dummy
leeloosoc onsoctcp leeloo leeloo

the columns are as follow:

1st - INFORMIXSERVER name
2nd - Protocolo (usually onsoctcp or onipcshm
3rd - hostname (be sure your environment can ping it)
4th - service name ou port (if name must be specified in /etc/services)

So, if you have "leelosoc" on the 1st column you muste use it and not leeloo.
The other errors (no such file...) can be due to bad onconfig (tbconfig if online 5).

Take a good look at "SERVERNAME" and "DBSERVERALIAS". You must configure a name for each "name" you want it to answer.
So, if you want SOC and SHM you must user both entries. For instance, SERVERNAME=leeloosoc and DBSERVERALIAS=leelooshm

Regards.

[Jonathan Leffler]

Professor Bruno wrote:
[...snip...]

Post by Professor Bruno
: 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
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)
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
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).

[Paul Watson]

Your INFORMIXSERVER is set the host name and not leelooshm/soc

Post by Professor Bruno
Greetings,
Perhaps this problem has been answered before, but my search of the web and newsgroups
hasn't yielded any results. Apologies at the outset for not having able to find the
answer on my own.
I'm trying to compile DBI:DBD for Informix. I've successfully compiled, installed, and used
DBI:DBD for MySQL and PostgreSQL. This one, though has got me a bit stumped.
###############
...
lib/DBD/Informix/Defaults.pm written OK
esqlvrsn.h written OK
esqlinfo.h written OK
Testing whether your Informix test environment will work...
@(#)$Id: esqltest.ec,v 100.3 2002/02/08 22:49:23 jleffler Exp $
$INFORMIXDIR is set to '/usr/local/informix'.
$INFORMIXSERVER is set to 'leeloo'.
$DBI_DBNAME unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE unset - defaulting to 'stores'.
$DBD_INFORMIX_DATABASE2 unset - defaulting to 'stores'.
$DBD_INFORMIX_USERNAME is set to 'informix'.
$DBD_INFORMIX_USERNAME2 is set to 'informix'.
$DBD_INFORMIX_PASSWORD is set.
$DBD_INFORMIX_PASSWORD2 is set.
Testing connection to stores
CONNECT TO 'stores' with user info
SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
Testing concurrent connection to stores
CONNECT TO 'stores' with user info
SQL: -25596: The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry.
*** Your Informix environment is not usable
*** You must fix it before building or testing DBD::Informix
...
###############
OS - Redhat Linux 6.2, kernel-2.2.24-6.2.3
Informix Online 5.10.UD1 installed and running
INFORMIX-ESQL Version 9.16.UC1
contents of /usr/local/informix/sqlhosts
# demo_on onipcshm on_hostname on_servername
# demo_se seipcpip se_hostname sqlexec
leelooshm onipcshm leeloo dummy
leeloosoc onsoctcp leeloo leeloo
HOSTNAME=leeloo
HOSTTYPE=i386
INFORMIXDIR=/usr/local/informix
INFORMIXSERVER=leeloo
LD_LIBRARY_PATH=:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql:/usr/local/informix/lib:/usr/local/informix/lib/esql
OSTYPE=Linux
PATH=/usr/local/informix/bin:/usr/sbin:/sbin:.:/bin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/local/informix
SHELL=/bin/bash
SHLVL=1
SQLEXEC=/usr/local/informix/lib/sqlturbo
TERM=vt100
DBD_INFORMIX_PASSWORD2, DBD_INFORMIX_PASSWORD omitted from the environments listing here but set.
Any help or guidance would be appreciated.
Max