dbaccess authentication?
Posted in 2010
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@app1.domain.com is not known onhe 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/binexport 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,