Hi Jonathan:
On Tue, 9 Oct 2001, Jonathan Leffler wrote:
> "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.
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=''
> (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
>
> (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.
On the client machine, that doesn't have the Informix server, but just the clietn
software, NO I do not have dbaccess.
> (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]
