"Ing. Roberto Andrade Fonseca" wrote: > Hi: > > 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
(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. (b) When you set DBD_INFORMIX_USERNAME, you must also set DBD_INFORMIX_PASSWORD. (c) Can you ping everest from this machine? (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? (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. (f) Check /etc/services. Try a FQDN in place of everest (eg everest.abl.com.mx). > When I test the environment whith the program esqlbasic, I get this: > > [informix@ingrid DBD-Informix-1.00.PC1]$ esql -o esqlbasic esqlbasic.ec && ./es > qlbasic > /opt/informix/lib/esql/libifos.so: the use of `mktemp' is dangerous, better use > `mkstemp' That's an obnoxious warning, however justified it might be in some respects. > $DBI_DBNAME set to 'stores7@everest'. > $DBD_INFORMIX_DATABASE set to 'stores7@everest'. > Testing connection to stores7@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@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 > > -------------------------------------------------- > > How can I fix the environment? > > How can I give sufficient privileges to the informix user on the client machine? > > Saludos, > > Roberto Andrade Fonseca > [EMAIL PROTECTED] -- Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED]) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include <disclaimer.h>
