Re: dbaccess authentication?

Thank you very much, That did the trick. On Thu, May 6, 2010 at 10:37 AM, Art Kagel <art.kagel@gmail.com> wrote: > 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 > >