I shared the database installation directory on db1 (IDS 11.50) server
through Samba (first time with a password and now opened to everyone -
which I am going to change back as soon as I figure out the problem
but I did just to avoid an extra step.)

I tried to access dbaccess from app1 server through a shell script.
(both servers are Red Hat 5).

However, I am getting an error:


951: Incorrect password or user dbauser (AT) app1 (DOT) domain.com is not known on
he database server.


the dbauser is basically the DBA of the database but for some reason
the database is recognizing it as dbauser@app1 when the script only
sends dbauser

Here it is the script:


INFORMIXDIR=/scratch/informix
ONCONFIG=onconfig.wms
INFORMIXSERVER=wms_net
export INFORMIXDIR ONCONFIG INFORMIXSERVER

PATH=$PATH:$INFORMIXDIR/bin
export PATH
clear
while :
do
echo -e "Enter Container Number or Q to quit:"; read ShipNbr
clear
if test "$ShipNbr" = "q"
then
break
fi
if test "$ShipNbr" = "Q"
then
break
fi
.. conn.sh


dbaccess test_w1 - <<EOF

CONNECT USER 'dbauser' USING 'dbapassword';

set isolation dirty read;

select b.cont, sum(a.unit_price * b.qty)
from od_f a, iv_f b
where b.cont ="$ShipNbr" and
(a.ob_oid = b.ob_oid and
a.ob_type = b.ob_type and
a.ob_lno = b.ob_lno)
group by b.cont


EOF

done

Any suggestion on how can I authenticate through dbaccess remotely
would be helpful. I had the same setup for 9.40 but we upgraded and is
not working anymore.

Thank you very much,

In the dbauser's home directory on the server add 'dbausr@app1' to the
..rhosts file.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art (AT) iiug (DOT) org)

See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.



On Thu, May 6, 2010 at 9:54 AM, Gentian Hila <genti.tech (AT) gmail (DOT) com> wrote:

Thank you very much,

That did the trick.

On Thu, May 6, 2010 at 10:37 AM, Art Kagel <art.kagel (AT) gmail (DOT) com> wrote: