Hi Jonathan:
I've written to you two times on the last week. Now I'm working on the real
instalation: an Informix server on a UnixWare machine, in production, and a Linux
Intel client working with DBD/DBI.
The UnixWare server has an IDS 7.3., with the next configuration:
sqlhosts:
UXemision onipcshm UXemision on_uxemis
emisnet ontlitcp UXemision emisionol
sucunet ontlitcp UXsucu sucuol
UXemisdes onipcshm UXemisdes on_uxemisdes
emisdes ontlitcp UXemision emisdesol
emision ontlitcp UXemision emisdesol
sucudes ontlitcp UXsucu sucudesol
reemnet ontlitcp UXreemb reembol
reemdes ontlitcp UXreemb reemdesol
The /etc/services file says:
emisionol 1543/tcp
sucuol 1544/tcp
emisdesol 1545/tcp
sucudesol 1546/tcp
reembol 1547/tcp
reemdesol 1548/tcp
I've created, as the informix user, the stores7 database.
Now on the client side, I have:
Linux RH 6.2, DBI 1.20, perl 5.005_03 built for i386-linux, and CONNECT and CLIENT SDK
2.70.UC1-1 for INTEL LINUX 2.2.14 GLIBC2.1.3.
The Linux box sqlhosts has:
emisdes onsoctcp Uxemision emisdesol
The client enviroment is:
DBD_INFORMIX_DATABASE=stores7@emisdes
LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql
DBI_DBNAME=stores7@emisdes
TERM=xterm
HOSTTYPE=i386
PATH=/sbin:/usr/sbin:/bin:/usr/bin:/usr/bin/X11:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/root/bin:/usr/X11R6/bin:/root/bin:/usr/X11R6/bin:/root/bin:/root/bin:/opt/informix/bin
DBD_INFORMIX_USERNAME=informix
INFORMIXDIR=/opt/informix
DISPLAY=:0
INFORMIXSERVER=emisdes
DBD_INFORMIX_PASSWORD=********
OSTYPE=Linux
_=/usr/bin/env
The informix password refers to the system password of the informix user on the
UnixWare machine.
I do can execute dbaccess stores7@emisdes on the UnixWare server, and I can make a
rlogin Uxemision -l informix.
But when I test my enviroment with the esqlbasic program, that's what I get:
# esql -o esqlbasic esqlbasic.ec && ./esqlbasic
$DBI_DBNAME set to 'stores7@emisdes'.
$DBD_INFORMIX_DATABASE set to 'stores7@emisdes'.
Testing connection to stores7@emisdes
SQL: -908: Attempt to connect to database server (emisdes) failed.
ISAM: 107: ISAM error: record is locked.
You cannot use stores7@emisdes as a test database.
You do not have sufficient privileges.
SQL: -908: Attempt to connect to database server (emisdes) failed.
ISAM: 107: ISAM error: record is locked.
*** Your Informix environment is not usable
*** You must fix it before building or testing DBD::Informix
Please tell me what I'm missing.
TIA
Saludos,
Roberto Andrade Fonseca
[EMAIL PROTECTED]
