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" <tvilliers@xxxxxxxxx> wrote:
On 29/01/07, Oliver Howe <oliverj@xxxxxxxxxxxxxxxxxxx> 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.
.

Relevant Pages

  • oninit -i failure
    ... I'm trying to startup informix for the first time on a CentOS 4.5 ... server. ... # Disk Mirroring Configuration Parameters ... # BUFFSIZE - OnLine no longer supports this configuration parameter. ...
    (comp.databases.informix)
  • Re: DBIx::DBH - Perl extension for simplifying database connectio ns
    ... Only one of the Informix notations has a host name in it, ... that's technically not a host name but a server name - the distinction ... under the illusion that people who use Perl to access a database know ... The connection string is system-specific -- end of sob story. ...
    (perl.dbi.users)
  • Re: Select from 2 Servers
    ... where is specified the Server? ... > You don't refer to the server, you refer to the Informix instance. ... >> columns in a table except the primary key could/should be nullable. ... > and you don't have a parent row for it, just do an insert into the parent ...
    (comp.databases.informix)
  • Re: Info Store Help!!!
    ... I look after an SBS2003 client with 20 ... Hmmm - this is a message you saw on the server? ... I found the problem was the average disk queue length was at ... Offline Defrag against both the Public and Private stores. ...
    (microsoft.public.exchange.admin)
  • RE: isa server
    ... To: Abdullah Akoglu; informix ... Subject: RE: isa server ... Bu e-posta mesaji kisiye ozel olup, ...
    (comp.databases.informix)