On Tue, 9 Oct 2001, Ing. Roberto Andrade Fonseca wrote: >Hi Jonathan: I've seen a newer message - I'll answer it shortly.
>On Tue, 9 Oct 2001, Jonathan Leffler wrote: >> "Ing. Roberto Andrade Fonseca" wrote: >> > I have Informix installed on server everest. A few hours ago I >> > compiled succesfuly DBD::Informix using the client software that >> > came with Informix. This machine is RH Linux 6.2 >> > >> > I am compiling DBD::Informix on a different machine (RH Linux 7.1) >> > with a newer Informix client. >> > In the client mechine I have this environment: >> > >> > PWD=/usr/local/DBD-Informix-1.00.PC1 >> > DBD_INFORMIX_USERNAME=informix >> > HOSTNAME=ingrid >> > LD_LIBRARY_PATH=/opt/informix/lib:/opt/informix/lib/esql >> > INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts >> > INFORMIXSERVER=ol_everest >> > LESSOPEN=|/usr/bin/lesspipe.sh %s >> > KDEDIR=/usr >> > DBD_INFORMIX_DATABASE=stores7@everest >> > USER=informix >> > OLDPWD=/home/informix >> > BASH_ENV=/home/informix/.bashrc >> > LANG=es_ES@euro >> > DBI_DBNAME=stores7@everest >> > INFORMIXDIR=/opt/informix >> > DISPLAY=:0.0 >> > LOGNAME=informix >> > SHELL=/bin/bash >> > HOSTTYPE=i386 >> > OSTYPE=linux-gnu >> > HISTSIZE=1000 >> > TERM=xterm >> > HOME=/home/informix >> > >> > And in sqlhosts: >> > ol_everest onipcshm everest on_everest No networking connection... >> (a) In general, you should not be connecting as user informix. Using >> user informix for general database access is rather like using user >> root for everyday work on a machine -- possible but dangerous, and >> not done by those wise in the ways of limiting damage before it gets >> out of hand. > >I've changed to: DBD_INFORMIX_USERNAME=randrade > >> (b) When you set DBD_INFORMIX_USERNAME, you must also set DBD_INFORMIX_PASSWORD. >And added: DBD_INFORMIX_USERNAME='' Did you mean DBD_INFORMIX_PASSWORD=''? If so, I recommend setting yourself a password. If you already have one, you need to reflect it in the environment variable. >> (c) Can you ping everest from this machine? > >Yes. > >> (d) Is the database server running on everest? Is it configured to >> monitor the network on the service with the name on_everest and the >> same service number as on_everest on the local machine? >Yes, on both files (/etc/services) I have the lines: >on_everest 1500/tcp # Informix >on_everest 1500/udp # Informix Informix does not need or use the udp service. >> (e) Can you run 'dbaccess stores7@everest'? If the answer is "No, I >> can't find DB-Access", then that's fair enough -- a nuisance, but a >> common state of affairs. If the answer is "No, it doesn't work", >> then RTFM would tell you that you must be able to do this before you >> bother to try building DBD::Informix. >On the server machine (everest), yes I can run 'stores7@ol_everest. OK; that's using the ONIPCSHM connection. Is there a network connection too? It will need a new DBSERVERALIAS and an entry under NETTYPE. >On the client machine, that doesn't have the Informix server, but just >the client software, NO I do not have dbaccess. Yes; it is a bad piece of packaging. >> (f) Check /etc/services. Try a FQDN in place of everest (eg everest.abl.com.mx). > >I tried with no luck. > > >I keep getting: > >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@ol_everest'. > $DBD_INFORMIX_DATABASE set to 'stores7@ol_everest'. >Testing connection to stores7@ol_everest >SQL: -25588: The appl process cannot connect to the database server ol_everest. >ISAM: 2: No such file or directory > >You cannot use stores7@ol_everest as a test database. >You do not have sufficient privileges. >SQL: -25588: The appl process cannot connect to the database server ol_everest. >ISAM: 2: No such file or directory > > >*** Your Informix environment is not usable >*** You must fix it before building or testing DBD::Informix > >[informix@ingrid DBD-Informix-1.00.PC1]$ > >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!"
