Ivan, I've never tried OS authentication.
Mike -- Michael Smith Remote Sensing/GIS Center US Army Corps of Engineers From: Ivan Lucena <lucena_i...@hotmail.com<mailto:lucena_i...@hotmail.com>> Date: Wednesday, October 14, 2015 at 9:44 AM To: Michael Smith <michael.sm...@erdc.dren.mil<mailto:michael.sm...@erdc.dren.mil>>, Jukka Rahkonen <jukka.rahko...@maanmittauslaitos.fi<mailto:jukka.rahko...@maanmittauslaitos.fi>>, "gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org>" <gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org>> Subject: RE: [gdal-dev] [EXTERNAL] Re: How connect to a remote oracle with spatial Mike, I think I also implemented OS authentication for both driver, OCI and GeoRaster. Have you used that? Regards, Ivan > From: michael.sm...@erdc.dren.mil<mailto:michael.sm...@erdc.dren.mil> > To: > jukka.rahko...@maanmittauslaitos.fi<mailto:jukka.rahko...@maanmittauslaitos.fi>; > gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> > Date: Wed, 14 Oct 2015 13:01:56 +0000 > Subject: Re: [gdal-dev] [EXTERNAL] Re: How connect to a remote oracle with > spatial > > Note that you can also use what Oracle calls the ezconnect syntax which is > user/pass@host:port/service_name. Then no TNS is needed. Also note that > port only needs to be specified if its not 1521. > > Mike > > -- > Michael Smith > > Remote Sensing/GIS Center > US Army Corps of Engineers > > > > On 10/14/15, 3:56 AM, "gdal-dev on behalf of Jukka Rahkonen" > <gdal-dev-boun...@lists.osgeo.org<mailto:gdal-dev-boun...@lists.osgeo.org> on > behalf of > jukka.rahko...@maanmittauslaitos.fi<mailto:jukka.rahko...@maanmittauslaitos.fi>> > wrote: > > >Andrea Peri <aperi2007 <at> gmail.com> writes: > > > >> > >> Hi, > >> I'm trying to test using gdal the access to an oracle dbms. > >> > >> To do this I use the ogrinfo and try this sintax but without success. > >> > >> ogrinfo OCI:username:password <at> "(DESCRIPTION = (ADDRESS_LIST = > >>(ADDRESS > >> = (PROTOCOL = TCP)(HOST = <IP server dbms>)(PORT = <listener > >> port>)))(CONNECT_DATA = (SID =<the sid of dbms>))):<schema>.<table>" > >> > >> The server return > >> > >> ERROR 1: ORA-01005: null password given; logon denied > >> in <unnamed> > >> > > > >Don'n you have a record for your connection in the tnsnames.ora > >BlockedBlockedBlockedhttp://orafaq.com/wiki/Tnsnames.oraBlockedBlocked? If > >you have, > >use @SERVICE_NAME with ogrinfo > > > >Read also carefully the manual page > >BlockedBlockedBlockedhttp://www.gdal.org/drv_oci.htmlBlockedBlocked > >You wrote OCI:username:password but it should be > >OCI:username/password@database_instance:table,table > > > >As documented "ogrinfo OCI:username/password@database_instance" is enough > >but at least in our environment it can take several minutes to read the > >metadata from Oracle if table list is not given for limiting the search. > > > >-Jukka Rahkonen- > > > > > >_______________________________________________ > >gdal-dev mailing list > >gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> > >BlockedBlockedBlockedhttp://lists.osgeo.org/mailman/listinfo/gdal-devBlockedBlocked > > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org<mailto:gdal-dev@lists.osgeo.org> > Blockedhttp://lists.osgeo.org/mailman/listinfo/gdal-devBlocked
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
