Re: dbaccess authentication?
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@iiug.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@gmail.com> wrote:
> 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 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,
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>