Ivan,
I've never tried OS authentication.
Mike
--
Michael Smith
Remote Sensing/GIS Center
US Army Corps of Engineers
From: Ivan Lucena mailto:lucena_i...@hotmail.com>>
Date: Wednesday, October 14, 2015 at 9:44 AM
To: Michael Smith
mailto:michael.sm...@erdc.dren.mil>>, Jukka
Rahkonen
mailto:jukka.rahko...@maanmittauslaitos.fi>>,
"gdal-dev@lists.osgeo.org<mailto: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"
> mailto:gdal-dev-boun...@lists.osgeo.org> on
> behalf of
> jukka.rahko...@maanmittauslaitos.fi<mailto:jukka.rahko...@maanmittauslaitos.fi>>
> wrote:
>
> >Andrea Peri 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 "(DESCRIPTION = (ADDRESS_LIST =
> >>(ADDRESS
> >> = (PROTOCOL = TCP)(HOST = )(PORT = >> port>)))(CONNECT_DATA = (SID =))):."
> >>
> >> The server return
> >>
> >> ERROR 1: ORA-01005: null password given; logon denied
> >> in
> >>
> >
> >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
