[Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

von_Minden_Peter_A_D · September 30, 2013, 2:31am

Hello All,

Can someone who has successfully connected to an ArcSDE data store via a direct connect please give me some assistance?

I have followed the instructions detailed in the User Manual Geoserver 2.4.x but I must be missing something or entering the details incorrectly.

I am attempting to connect on a local install of Geoserver 2.4.0 on a windows 7 machine. My TNS entry looks like the following for an Oracle 11g database:

TESTDB.COM.AU =

(DESCRIPTION =

(LOAD_BALANCE = off)

(ADDRESS = (PROTOCOL = TCP)(HOST = test01.com.au)(PORT = 1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = test02.com.au)(PORT = 1521))

(CONNECT_DATA =

(SERVICE_NAME = testdb.com.au)

)

My user details are as follows:

User Name: test_user

Password: testPassw0rd

So connecting via a non-direct method using the following details works:

Server name or IP address * = test01.com.au, Port * = 5151, User * = test_user, Password = testPassw0rd

But a direct connect using the following details does not work:

Server name or IP address * = none, Port * = sde:oracle11g:/:TESTDB.COM.AU, Instance name = none, User * = test_user, Password = testPassw0rd

The error message I get is:

Error creating data store, check the parameters. Error message: Can’t create connection to none for Session #22[SDE error -66][Error desc=SPECIFIED PARAMETER VALUE IS INVALID.][Extended desc= ]

I have tried putting TESTDB.COM.AU in the Server name or IP Address entry, i have tried putting sde in the instance name, I have tried a heap of variations of the password such as testPassw0rd@anonymised.com., test_user/testPassw0rd@anonymised.com , test_user:testPassw0rd@anonymised.com … but I still get the same result.

I know I could try connecting directly to oracle but at this stage, I am keen to work out how to do it via an ArcSDE Direct Connect. Any help on this one would be very much appreciated.

Cheers

Peter

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

Andrea_Aime4 · September 30, 2013, 6:13am

On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE) <
Peter.vonMinden@anonymised.com> wrote:

But a direct connect using the following details does not work:

*Server name or IP address ** = none, *Port ** =
sde:oracle11g:/:TESTDB.COM.AU, *Instance name* = none,* **User ** =
test_user, *Password* =* *testPassw0rd

Hi,
know nothing of direct connect and never tried it but there are a couple of
things that seem odd/out of place:
* Are the username/password are the same for sde and the database? In
direct connect the guide says to use the username/password of the
geodatabase
* The syntax reported by ESRI for direct connect provides a few options
http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm
,
you seem to be going with the schema name one, however, can schema name
contain dots?

Cheers
Andrea

--

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------

Hochmeister_Rudolf · September 30, 2013, 9:02am

Hi,

http://docs.oracle.com/cd/A57673_01/DOC/net/doc/NWUS233/apb.htm says that

Service Name Character Set
The listener name, service name, and Interchange names used in TNS
configuration files are limited to the following character set:

[a...z] [A...Z] [0...9] _

The first character in a service name must be an alphabetic character. The
number of characters allowed is platform specific; in general, however, up
to 64 characters is acceptable. A database service name must match the
global database name defined by the DBA. It consists of a database name
(originally limited to eight characters), and the database domains. Service
names and global database names are not case sensitive.

Note: Network Manager uses periods (.) when it appends domains to the names
you enter, but it does not accept periods in the name you provide.

So I guess "TESTDB.COM.AU" should be changed to "TESTDB_COM.AU" or something
else with ONLY 1 "."-char in order to work with ArcSDE direct connect String
which uses TNS name resolving...

You can verify with tnsping of sqlplus if your TNS is valid.

cheers Rudi

--
View this message in context: http://osgeo-org.1560.x6.nabble.com/I-need-help-with-an-ArcSDE-direct-Connect-in-Geoserver-2-4-0-tp5080836p5080890.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Jonathan_Moules2 · September 30, 2013, 10:23am

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

···

I’d be surprised if the passwords are different. SDE just transparently passes the credentials straight through to the database; the username/password are actually the database ones.

Peter - Can you direct connect from ArcGIS to Oracle?

Jonathan

On 30 September 2013 07:13, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

But a direct connect using the following details does not work:

Server name or IP address * = none, Port * = sde:oracle11g:/:TESTDB.COM.AU, Instance name = none, User * = test_user, Password = testPassw0rd

Hi,
know nothing of direct connect and never tried it but there are a couple of things that seem odd/out of place:

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase
The syntax reported by ESRI for direct connect provides a few options http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm,
you seem to be going with the schema name one, however, can schema name contain dots?

Cheers
Andrea

–

==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

Ing. Andrea Aime

@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054 Massarosa (LU)
Italy
phone: +39 0584 962313
fax: +39 0584 1660272
mob: +39 339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

von_Minden_Peter_A_D · September 30, 2013, 10:17pm

Hi All,

Jonathan is correct. The user name is the database name so I can use it to log in via sql developer or sqlplus.

I can connect directly via ArcGIS and via FME. The string I use in the instance section for ArcGIS and for FME is sde:oracle11g:TESTDB.COM.AU, which is a little different to the way the Geoserver manual suggests as there is the extra “:/”. I have tried to use the same instance in Geoserver that I use in ArcGIS and FME but still no luck.

Jonathan, have you managed to do a direct connect to ArcSDE in Geoserver? If you have could you send me an example of the credentials you used and maybe an example of what you used in ArcGIS so I can see what you do differently between the two applications? (Same goes for any of you that may have successfully connected via a direct connect)

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Monday, 30 September 2013 8:23 PM
To: Andrea Aime
Cc: von Minden, Peter A (DPIPWE); geoserver-users@anonymised.comnet
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

I’d be surprised if the passwords are different. SDE just transparently passes the credentials straight through to the database; the username/password are actually the database ones.

Peter - Can you direct connect from ArcGIS to Oracle?

Jonathan

On 30 September 2013 07:13, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

But a direct connect using the following details does not work:

Server name or IP address * = none, Port * = sde:oracle11g:/:TESTDB.COM.AU, Instance name = none, User * = test_user, Password = testPassw0rd

Hi,

know nothing of direct connect and never tried it but there are a couple of things that seem odd/out of place:

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase
The syntax reported by ESRI for direct connect provides a few options http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm,

you seem to be going with the schema name one, however, can schema name contain dots?

Cheers

Andrea

–

==

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

==

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@anonymised.comsts.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

Jonathan_Moules2 · October 1, 2013, 10:38am

Hi Pete,
Well I didn’t have the ArcSDE plugin installed, but it was on my todo list, so did it anyway.
ArcSDE 9.3.1
GeoServer 2.4.0

The machine in question already has and ArcGIS install that direct-connects installed on it.

I can get it to do a regular ArcSDE connection just fine, however the direct connect isn’t working. I enter my credentials, press “Save” and nothing happens. I get the little “working” icon for a fraction of a second.
The logs are almost empty - no error:

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - populating ArcSDE connection pool
2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Created ArcSDE connection pool for ArcSDEConnectionConfig[server=none, port=sde:oracle11g:co_gislive, database=none, user=OSMM, minConnections=2, maxConnections=6, timeout=500]
2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)

Again, no error at all.

But if I look in the log again later, it seems something did happen - I now have something like:

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)
2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.data] - FeatureTypeCache background process running…
2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.session] - Grabbing session from pool on pool-6-thread-1
2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the pool on pool-6-thread-1
2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the in use queue on pool-6-thread-1
2013-10-01 10:26:35,257 TRACE [org.geotools.arcsde.data] - Ignoring non registered table MAPINFO.MAPINFO_MAPCATALOG
2013-10-01 10:26:35,260 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPFEATURELAYER
2013-10-01 10:26:35,262 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPIMPORTSETTINGS

[hundreds of tables]

2013-10-01 10:26:35,681 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MAIN_SETTL_5KM_SEC_BUFF_WSHIRE
2013-10-01 10:26:35,684 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MOB_LIB_RTS_2012_WSHIRE_SOL
2013-10-01 10:26:35,708 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.TRAFFIC_REG_ORDS_DATE
2013-10-01 10:26:35,742 TRACE [org.geotools.arcsde.session] - passivating connection Session[4]
2013-10-01 10:26:35,747 DEBUG [org.geotools.arcsde.data] - Finished updated type name cache

So it seems to actually connect despite the GeoServer interface failing (a bug I’ll report in a minute).

My connection details:

Inline images 1

Despite what the documentation says. My password is only of the form “password”, not “password@anonymised.com”.

It also “works” without the extra “:/” in the “port” string.

Hope that helps,

Jonathan

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

···

On 30 September 2013 23:17, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

Hi All,

Jonathan is correct. The user name is the database name so I can use it to log in via sql developer or sqlplus.

I can connect directly via ArcGIS and via FME. The string I use in the instance section for ArcGIS and for FME is sde:oracle11g:TESTDB.COM.AU, which is a little different to the way the Geoserver manual suggests as there is the extra “:/”. I have tried to use the same instance in Geoserver that I use in ArcGIS and FME but still no luck.

Jonathan, have you managed to do a direct connect to ArcSDE in Geoserver? If you have could you send me an example of the credentials you used and maybe an example of what you used in ArcGIS so I can see what you do differently between the two applications? (Same goes for any of you that may have successfully connected via a direct connect)

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Monday, 30 September 2013 8:23 PM
To: Andrea Aime
Cc: von Minden, Peter A (DPIPWE); geoserver-users@anonymised.comnet
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

I’d be surprised if the passwords are different. SDE just transparently passes the credentials straight through to the database; the username/password are actually the database ones.

Peter - Can you direct connect from ArcGIS to Oracle?

Jonathan

On 30 September 2013 07:13, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com…2631…> wrote:

But a direct connect using the following details does not work:

Server name or IP address * = none, Port * = sde:oracle11g:/:TESTDB.COM.AU, Instance name = none, User * = test_user, Password = testPassw0rd

Hi,

know nothing of direct connect and never tried it but there are a couple of things that seem odd/out of place:

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

The syntax reported by ESRI for direct connect provides a few options http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm,

you seem to be going with the schema name one, however, can schema name contain dots?

Cheers

Andrea

–

==

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

==

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

Jonathan_Moules2 · October 1, 2013, 11:10am

So, after more extensive testing, the only thing I can say is, I’m confused. I don’t think that wall of connections was actually from the direct connect but was an issue from the regular ArcSDE connection I’d created.

···

Error creating data store, check the parameters. Error message: Can’t create connection to sde:oracle11g:co_gislive for Session #20[SDE error -66][Error desc=SPECIFIED PARAMETER VALUE IS INVALID.][Extended desc= ]

Jonathan

On 1 October 2013 11:38, Jonathan Moules <jonathanmoules@anonymised.com> wrote:

Hi Pete,
Well I didn’t have the ArcSDE plugin installed, but it was on my todo list, so did it anyway.
ArcSDE 9.3.1
GeoServer 2.4.0

The machine in question already has and ArcGIS install that direct-connects installed on it.

I can get it to do a regular ArcSDE connection just fine, however the direct connect isn’t working. I enter my credentials, press “Save” and nothing happens. I get the little “working” icon for a fraction of a second.
The logs are almost empty - no error:

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.
2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.
2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - populating ArcSDE connection pool
2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Created ArcSDE connection pool for ArcSDEConnectionConfig[server=none, port=sde:oracle11g:co_gislive, database=none, user=OSMM, minConnections=2, maxConnections=6, timeout=500]
2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)

Again, no error at all.

But if I look in the log again later, it seems something did happen - I now have something like:

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)
2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.data] - FeatureTypeCache background process running…
2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.session] - Grabbing session from pool on pool-6-thread-1
2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the pool on pool-6-thread-1
2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the in use queue on pool-6-thread-1
2013-10-01 10:26:35,257 TRACE [org.geotools.arcsde.data] - Ignoring non registered table MAPINFO.MAPINFO_MAPCATALOG
2013-10-01 10:26:35,260 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPFEATURELAYER
2013-10-01 10:26:35,262 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPIMPORTSETTINGS

[hundreds of tables]

2013-10-01 10:26:35,681 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MAIN_SETTL_5KM_SEC_BUFF_WSHIRE
2013-10-01 10:26:35,684 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MOB_LIB_RTS_2012_WSHIRE_SOL
2013-10-01 10:26:35,708 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.TRAFFIC_REG_ORDS_DATE
2013-10-01 10:26:35,742 TRACE [org.geotools.arcsde.session] - passivating connection Session[4]
2013-10-01 10:26:35,747 DEBUG [org.geotools.arcsde.data] - Finished updated type name cache

So it seems to actually connect despite the GeoServer interface failing (a bug I’ll report in a minute).

My connection details:

Despite what the documentation says. My password is only of the form “password”, not “password@anonymised.com”.

It also “works” without the extra “:/” in the “port” string.

Hope that helps,

Jonathan

Either way, it completely fails to actually connect as best I can tell. But the two different failure modes suggests that maybe your credentials are wrong.
Best I can manage I’m afraid. I’ve never gotten on with ArcSDE.
Regards,

On 30 September 2013 23:17, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

Hi All,

Jonathan is correct. The user name is the database name so I can use it to log in via sql developer or sqlplus.

I can connect directly via ArcGIS and via FME. The string I use in the instance section for ArcGIS and for FME is sde:oracle11g:TESTDB.COM.AU, which is a little different to the way the Geoserver manual suggests as there is the extra “:/”. I have tried to use the same instance in Geoserver that I use in ArcGIS and FME but still no luck.

Jonathan, have you managed to do a direct connect to ArcSDE in Geoserver? If you have could you send me an example of the credentials you used and maybe an example of what you used in ArcGIS so I can see what you do differently between the two applications? (Same goes for any of you that may have successfully connected via a direct connect)

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Monday, 30 September 2013 8:23 PM
To: Andrea Aime
Cc: von Minden, Peter A (DPIPWE); geoserver-users@anonymised.comnet
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

I’d be surprised if the passwords are different. SDE just transparently passes the credentials straight through to the database; the username/password are actually the database ones.

Peter - Can you direct connect from ArcGIS to Oracle?

Jonathan

On 30 September 2013 07:13, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com…2631…> wrote:

But a direct connect using the following details does not work:

Server name or IP address * = none, Port * = sde:oracle11g:/:TESTDB.COM.AU, Instance name = none, User * = test_user, Password = testPassw0rd

Hi,

know nothing of direct connect and never tried it but there are a couple of things that seem odd/out of place:

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

The syntax reported by ESRI for direct connect provides a few options http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm,

you seem to be going with the schema name one, however, can schema name contain dots?

Cheers

Andrea

–

==

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

==

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

von_Minden_Peter_A_D · October 4, 2013, 3:45am

Thanks for having a crack at this one for me Jonathan. I think I have run out of options in trying to get a direct connect to ArcSDE. DId you end up logging a bug for this?

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Tuesday, 1 October 2013 9:10 PM
To: von Minden, Peter A (DPIPWE)
Cc: geoserver-users@lists.sourceforge.net; Andrea Aime
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

So, after more extensive testing, the only thing I can say is, I’m confused. I don’t think that wall of connections was actually from the direct connect but was an issue from the regular ArcSDE connection I’d created.

So far I’ve had the following happen:

a) When I have what I think are the right credentials (as in original screenshot), I don’t get any error or feedback at all when I press save.

b) But if I make it “wrong” information (add a typo), then I get an error that appears to be the same as yours Peter:

Error creating data store, check the parameters. Error message: Can’t create connection to sde:oracle11g:co_gislive for Session #20[SDE error -66][Error desc=SPECIFIED PARAMETER VALUE IS INVALID.][Extended desc= ]

Either way, it completely fails to actually connect as best I can tell. But the two different failure modes suggests that maybe your credentials are wrong.

Best I can manage I’m afraid. I’ve never gotten on with ArcSDE.

Regards,

Jonathan

On 1 October 2013 11:38, Jonathan Moules <jonathanmoules@anonymised.com942…> wrote:

Hi Pete,

Well I didn’t have the ArcSDE plugin installed, but it was on my todo list, so did it anyway.

ArcSDE 9.3.1

GeoServer 2.4.0

The machine in question already has and ArcGIS install that direct-connects installed on it.

I can get it to do a regular ArcSDE connection just fine, however the direct connect isn’t working. I enter my credentials, press “Save” and nothing happens. I get the little “working” icon for a fraction of a second.

The logs are almost empty - no error:

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - populating ArcSDE connection pool

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Created ArcSDE connection pool for ArcSDEConnectionConfig[server=none, port=sde:oracle11g:co_gislive, database=none, user=OSMM, minConnections=2, maxConnections=6, timeout=500]

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)

Again, no error at all.

But if I look in the log again later, it seems something did happen - I now have something like:

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)

2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.data] - FeatureTypeCache background process running…

2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.session] - Grabbing session from pool on pool-6-thread-1

2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the pool on pool-6-thread-1

2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the in use queue on pool-6-thread-1

2013-10-01 10:26:35,257 TRACE [org.geotools.arcsde.data] - Ignoring non registered table MAPINFO.MAPINFO_MAPCATALOG

2013-10-01 10:26:35,260 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPFEATURELAYER

2013-10-01 10:26:35,262 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPIMPORTSETTINGS

[hundreds of tables]

2013-10-01 10:26:35,681 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MAIN_SETTL_5KM_SEC_BUFF_WSHIRE

2013-10-01 10:26:35,684 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MOB_LIB_RTS_2012_WSHIRE_SOL

2013-10-01 10:26:35,708 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.TRAFFIC_REG_ORDS_DATE

2013-10-01 10:26:35,742 TRACE [org.geotools.arcsde.session] - passivating connection Session[4]

2013-10-01 10:26:35,747 DEBUG [org.geotools.arcsde.data] - Finished updated type name cache

So it seems to actually connect despite the GeoServer interface failing (a bug I’ll report in a minute).

My connection details:

Inline images 1

Despite what the documentation says. My password is only of the form “password”, not “password@anonymised.com”.

It also “works” without the extra “:/” in the “port” string.

Hope that helps,

Jonathan

On 30 September 2013 23:17, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

Hi All,

Jonathan is correct. The user name is the database name so I can use it to log in via sql developer or sqlplus.

I can connect directly via ArcGIS and via FME. The string I use in the instance section for ArcGIS and for FME is sde:oracle11g:TESTDB.COM.AU, which is a little different to the way the Geoserver manual suggests as there is the extra “:/”. I have tried to use the same instance in Geoserver that I use in ArcGIS and FME but still no luck.

Jonathan, have you managed to do a direct connect to ArcSDE in Geoserver? If you have could you send me an example of the credentials you used and maybe an example of what you used in ArcGIS so I can see what you do differently between the two applications? (Same goes for any of you that may have successfully connected via a direct connect)

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Monday, 30 September 2013 8:23 PM
To: Andrea Aime
Cc: von Minden, Peter A (DPIPWE); geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

I’d be surprised if the passwords are different. SDE just transparently passes the credentials straight through to the database; the username/password are actually the database ones.

Peter - Can you direct connect from ArcGIS to Oracle?

Jonathan

On 30 September 2013 07:13, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com…2631…> wrote:

But a direct connect using the following details does not work:

Server name or IP address * = none, Port * = sde:oracle11g:/:TESTDB.COM.AU, Instance name = none, User * = test_user, Password = testPassw0rd

Hi,

know nothing of direct connect and never tried it but there are a couple of things that seem odd/out of place:

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase
The syntax reported by ESRI for direct connect provides a few options http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm,

you seem to be going with the schema name one, however, can schema name contain dots?

Cheers

Andrea

–

==

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

==

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

Jonathan_Moules2 · October 4, 2013, 10:19am

Hi Pete,
I logged two ArcSDE related bugs, but I don’t think either is necessarily the same as yours.
http://jira.codehaus.org/browse/GEOS-6066

http://jira.codehaus.org/browse/GEOS-6067

So it may be worth reporting yours as well.
Regards,
Jonathan

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

···

On 4 October 2013 04:45, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

Thanks for having a crack at this one for me Jonathan. I think I have run out of options in trying to get a direct connect to ArcSDE. DId you end up logging a bug for this?

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Tuesday, 1 October 2013 9:10 PM
To: von Minden, Peter A (DPIPWE)
Cc: geoserver-users@lists.sourceforge.net; Andrea Aime

Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

So, after more extensive testing, the only thing I can say is, I’m confused. I don’t think that wall of connections was actually from the direct connect but was an issue from the regular ArcSDE connection I’d created.

So far I’ve had the following happen:

a) When I have what I think are the right credentials (as in original screenshot), I don’t get any error or feedback at all when I press save.

b) But if I make it “wrong” information (add a typo), then I get an error that appears to be the same as yours Peter:

Error creating data store, check the parameters. Error message: Can’t create connection to sde:oracle11g:co_gislive for Session #20[SDE error -66][Error desc=SPECIFIED PARAMETER VALUE IS INVALID.][Extended desc= ]

Either way, it completely fails to actually connect as best I can tell. But the two different failure modes suggests that maybe your credentials are wrong.

Best I can manage I’m afraid. I’ve never gotten on with ArcSDE.

Regards,

Jonathan

On 1 October 2013 11:38, Jonathan Moules <jonathanmoules@anonymised.com942…> wrote:

Hi Pete,

Well I didn’t have the ArcSDE plugin installed, but it was on my todo list, so did it anyway.

ArcSDE 9.3.1

GeoServer 2.4.0

The machine in question already has and ArcGIS install that direct-connects installed on it.

I can get it to do a regular ArcSDE connection just fine, however the direct connect isn’t working. I enter my credentials, press “Save” and nothing happens. I get the little “working” icon for a fraction of a second.

The logs are almost empty - no error:

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.client.SeConnection is in place.

2013-10-01 10:26:06,354 TRACE [org.geotools.arcsde.ArcSDEDataStoreFactory] - com.esri.sde.sdk.pe.PeCoordinateSystem is in place.

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - populating ArcSDE connection pool

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Created ArcSDE connection pool for ArcSDEConnectionConfig[server=none, port=sde:oracle11g:co_gislive, database=none, user=OSMM, minConnections=2, maxConnections=6, timeout=500]

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)

Again, no error at all.

But if I look in the log again later, it seems something did happen - I now have something like:

2013-10-01 10:26:06,355 DEBUG [org.geotools.arcsde.session] - Creating connection for session #7(try 1 of 3)

2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.data] - FeatureTypeCache background process running…

2013-10-01 10:26:34,331 DEBUG [org.geotools.arcsde.session] - Grabbing session from pool on pool-6-thread-1

2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the pool on pool-6-thread-1

2013-10-01 10:26:34,332 DEBUG [org.geotools.arcsde.session] - Got session from the in use queue on pool-6-thread-1

2013-10-01 10:26:35,257 TRACE [org.geotools.arcsde.data] - Ignoring non registered table MAPINFO.MAPINFO_MAPCATALOG

2013-10-01 10:26:35,260 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPFEATURELAYER

2013-10-01 10:26:35,262 TRACE [org.geotools.arcsde.data] - Ignoring non registered table OSMM.ADMPIMPORTSETTINGS

[hundreds of tables]

2013-10-01 10:26:35,681 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MAIN_SETTL_5KM_SEC_BUFF_WSHIRE

2013-10-01 10:26:35,684 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.MOB_LIB_RTS_2012_WSHIRE_SOL

2013-10-01 10:26:35,708 TRACE [org.geotools.arcsde.data] - Ignoring non registered table WCCDATA.TRAFFIC_REG_ORDS_DATE

2013-10-01 10:26:35,742 TRACE [org.geotools.arcsde.session] - passivating connection Session[4]

2013-10-01 10:26:35,747 DEBUG [org.geotools.arcsde.data] - Finished updated type name cache

So it seems to actually connect despite the GeoServer interface failing (a bug I’ll report in a minute).

My connection details:

Despite what the documentation says. My password is only of the form “password”, not “password@anonymised.com”.

It also “works” without the extra “:/” in the “port” string.

Hope that helps,

Jonathan

On 30 September 2013 23:17, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

Hi All,

Jonathan is correct. The user name is the database name so I can use it to log in via sql developer or sqlplus.

I can connect directly via ArcGIS and via FME. The string I use in the instance section for ArcGIS and for FME is sde:oracle11g:TESTDB.COM.AU, which is a little different to the way the Geoserver manual suggests as there is the extra “:/”. I have tried to use the same instance in Geoserver that I use in ArcGIS and FME but still no luck.

Jonathan, have you managed to do a direct connect to ArcSDE in Geoserver? If you have could you send me an example of the credentials you used and maybe an example of what you used in ArcGIS so I can see what you do differently between the two applications? (Same goes for any of you that may have successfully connected via a direct connect)

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Monday, 30 September 2013 8:23 PM
To: Andrea Aime
Cc: von Minden, Peter A (DPIPWE); geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

I’d be surprised if the passwords are different. SDE just transparently passes the credentials straight through to the database; the username/password are actually the database ones.

Peter - Can you direct connect from ArcGIS to Oracle?

Jonathan

On 30 September 2013 07:13, Andrea Aime <andrea.aime@anonymised.com> wrote:

On Mon, Sep 30, 2013 at 4:31 AM, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com…2631…> wrote:

But a direct connect using the following details does not work:

Server name or IP address * = none, Port * = sde:oracle11g:/:TESTDB.COM.AU, Instance name = none, User * = test_user, Password = testPassw0rd

Hi,

know nothing of direct connect and never tried it but there are a couple of things that seem odd/out of place:

Are the username/password are the same for sde and the database? In direct connect the guide says to use the username/password of the geodatabase

The syntax reported by ESRI for direct connect provides a few options http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm,

you seem to be going with the schema name one, however, can schema name contain dots?

Cheers

Andrea

–

==

Our support, Your Success! Visit http://opensdi.geo-solutions.it for more information.

==

Ing. Andrea Aime

@geowolf

Technical Lead

GeoSolutions S.A.S.

Via Poggio alle Viti 1187

55054 Massarosa (LU)

Italy

phone: +39 0584 962313

fax: +39 0584 1660272

mob: +39 339 8844549

http://www.geo-solutions.it

http://twitter.com/geosolutions_it

October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk

Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

This transmission is intended for the named addressee(s) only and may contain sensitive or protectively marked material up to RESTRICTED and should be handled accordingly. Unless you are the named addressee (or authorised to receive it for the addressee) you may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please notify the sender immediately. All email traffic sent to or from us, including without limitation all GCSX traffic, may be subject to recording and/or monitoring in accordance with relevant legislation.

CONFIDENTIALITY NOTICE AND DISCLAIMER
The information in this transmission may be confidential and/or protected by legal professional privilege, and is intended only for the person or persons to whom it is addressed. If you are not such a person, you are warned that any disclosure, copying or dissemination of the information is unauthorised. If you have received the transmission in error, please immediately contact this office by telephone, fax or email, to inform us of the error and to enable arrangements to be made for the destruction of the transmission, or its return at our cost. No liability is accepted for any unauthorised use of the information contained in this transmission.

von_Minden_Peter_A_D · October 7, 2013, 12:37am

Hi Jonathon,

I have been able to replicate the same problem you are having with the schema name type connection under http://webhelp.esri.com/arcgisserver/9.3/java/index.htm#geodatabases/arcsde-2034353163.htm.

The schema name for me is sde as sde is the schema that owns the geodatabase. So my connection string to testbd.com.au, in the port section, would be sde:oracle11g:sde or sde:oracle11g:/:sde (as using sde:oracle11g: testbd.com.au or sde:oracle11g:/:testbd.com.au doesn’t work). I get the same issue as you where it seems do nothing at all and returns no error.

I guess I am confused as to how Geoserver knows which database to connect to if I use the schema name. I have a database called devbd.com.au in my TNS names file that has the exact same structure as testbd.com.au and has the same schema name of sde. The only difference is the passwords.

So for testbd.com.au I have:

schema name: sde

User Name: test_user

Password: testPassw0rd

connection string under port: :oracle11g:sde or sde:oracle11g:/:sde

and for devbd.com.au I have:

schema name: sde

User Name: test_user

Password: devPassw0rd

connection string under port: :oracle11g:sde or sde:oracle11g:/:sde

How does Geoserver know which database I am trying to connect too if I don’t use a connection string like sde:oracle11g: testbd.com.au or sde:oracle11g: devbd.com.au?

I guess I should log the original email as a separate bug but I have no idea if I am entering my details in correctly or not.

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Friday, 4 October 2013 8:20 PM
To: von Minden, Peter A (DPIPWE)
Cc: geoserver-users@lists.sourceforge.net; Andrea Aime
Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0

Hi Pete,

I logged two ArcSDE related bugs, but I don’t think either is necessarily the same as yours.

http://jira.codehaus.org/browse/GEOS-6066

http://jira.codehaus.org/browse/GEOS-6067

So it may be worth reporting yours as well.

Regards,

Jonathan

On 4 October 2013 04:45, von Minden, Peter A (DPIPWE) <Peter.vonMinden@anonymised.com> wrote:

Thanks for having a crack at this one for me Jonathan. I think I have run out of options in trying to get a direct connect to ArcSDE. DId you end up logging a bug for this?

Cheers

Pete

From: Jonathan Moules [mailto:jonathanmoules@anonymised.com]
Sent: Tuesday, 1 October 2013 9:10 PM
To: von Minden, Peter A (DPIPWE)
Cc: geoserver-users@lists.sourceforge.net; Andrea Aime

Subject: Re: [Geoserver-users] I need help with an ArcSDE direct Connect in Geoserver 2.4.0