On Wed, 10 Oct 2001, Ing. Roberto Andrade Fonseca wrote: >Hi Jonathan: >I wrote yesterday to the DBI list. > >Thats the new situation: > >SERVER: >I have a RH Linux 6.2 server with IDS FOR LINUX 7.30.UC5, CLIENT SDK >FOR LINUX 2.10.UC2 and CONNECT FOR LINUX 2.10.UC2. > >Its name is everest. > >I have running the database server, and I have compiled DBD::Informix with success. > >I can access the database with dbaccess. > >sqlhosts says: > >ol_everest onipcshm everest on_everest >net_everest oltlitcp everest everest_net
OK. The onipcshm name does not have to be in /etc/services, and you can reuse a single name in both an onipcshm and an oltlitcp connection. If you're on Linux, you should probably be using olsoctcp - read the release notes. >/etc/services has: >on_everest 1500/tcp # Informix >on_everest 1500/udp # Informix >everest_net 1501/tcp # Informix >everest_net 1501/udp # Informix As before, the udp services are irrelevant to Informix. >CLIENT: >The client is a Linux RH 7.1, I have installed CLIENT SDK 2.70.UC1-1 for INTEL LINUX >2.2.14 GLIBC2.1.3 and CONNECT 2.70.UC1-1 for INTEL LINUX 2.2.14 GLIBC2.1.3, but no >Informix server. > >The sqlhosts has: >net_everest olsoctcp everest everest_net > >and the /etc/services has: > >everest_net 1500/tcp # Informix >everest_net 1500/udp # Informix Use the same number on both machines -- 1501. >I can make ping to everest from the client. OK. On everest, can you connect to 'stores7@net_everest'? If not, fix up you installation until you can. >DBD on the CLIENT: >Well, I'm trying to install DBD::Informix on the client machine. I've installed DBI. > >My env is: >PWD=/usr/local/DBD-Informix-1.00.PC1 >DBD_INFORMIX_USERNAME=randrade >DBD_INFORMIX_PASSWORD= You don't have a password? You probably don't need to specify the username either. Assuming you are building DBD::Informix as randrade, of course. If you do have a password, it must be set in DBD_INFORMIX_PASSWORD, of course. And the scripts provided with DBD::Informix for reporting bugs always translate the passwords to 'XXXXXXXX' since I have no use or interest in the details of the password. >HOSTNAME=ingrid >LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql >INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts >INFORMIXSERVER=net_everest >LESSOPEN=|/usr/bin/lesspipe.sh %s >DBD_INFORMIX_DATABASE=stores7@net_everest >USER=informix >MACHTYPE=i386-redhat-linux-gnu >LANG=es_ES@euro >DBI_DBNAME=stores7@net_everest >INFORMIXDIR=/opt/informix >ONCONFIG=onconfig_learn >SHELL=/bin/bash >HOSTTYPE=i386 >OSTYPE=linux-gnu >HOME=/home/informix >PATH=/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/home/informix/bin:/opt/informix/bin:/home/informix/bin:/opt/informix/bin >_=/usr/bin/env > > >I'm testing my DBD env with the esqlbasic program: > >[informix@ingrid DBD-Informix-1.00.PC1]$ esql -o esqlbasic esqlbasic.ec && >./esqlbasic >/opt/informix/lib/esql/libifos.so: the use of `mktemp' is dangerous, better use >`mkstemp' > $DBI_DBNAME set to 'stores7@net_everest'. > $DBD_INFORMIX_DATABASE set to 'stores7@net_everest'. >Testing connection to stores7@net_everest >SQL: -908: Attempt to connect to database server (net_everest) failed. >ISAM: 107: ISAM error: record is locked. > >You cannot use stores7@net_everest as a test database. >You do not have sufficient privileges. >SQL: -908: Attempt to connect to database server (net_everest) failed. >ISAM: 107: ISAM error: record is locked. > > >*** Your Informix environment is not usable >*** You must fix it before building or testing DBD::Informix > >Any idea? > >Saludos, > >Roberto Andrade Fonseca >[EMAIL PROTECTED] > > -- Yours, Jonathan Leffler ([EMAIL PROTECTED]) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"
