POST
|
I always use multiple SDEHOMEs for multiple instances, partially because I don't have the patience to work out how the files need to be named in oreder to run multiple instances out of one. But I don't think your setup is correct: 1) ArcSDE doesn't use UDP, so there's no reason to have duplicate service name entries 2) If you do use one SDEHOME, your "-i" parameter should be the service name (dbN), not the port number (so it finds the dbinit file) I don't see how the 10.1 clients can be connecting to the right database, but if they do, there's no apparent reason why the 10.0 clients should not have the same behavior. First off, use the service name in your 'sdemon' directives. If it still fails, try using two different SDEHOME directories. If that fails, contact Tech Support. - V Heya, thx for the reply. Tried it with instance name, same problem. Will try the multiple SDEHOME approach during the weekend. Tried our regional Tech Support but they only gave me the afformentioned bug report or to use direct connections, but I'm not as ambitious as to change the connection properties and installations on 30+ computers 🙂 Regards...
... View more
03-29-2013
06:14 AM
|
0
|
0
|
267
|
POST
|
ArcSDE application services can only run in one database (can't connect to multiple databases through one service). What values are you placing in the various connection parameters at 10.0 SP5? Are you using Direct Connect or an application server port? What PostgreSQL client libraries are you using on the various hosts? - V Heya, to clarify things a little bit here is the complete setup: SDE server (Linux64): -- /etc/services: db1 6629/tcp db1 6629/udp db2 6630/tcp db2 6630/udp -- $SDEHOME/etc/services.sde db1 6629/tcp db2 6630/tcp -- $SDEHOME/etc/dbinit_db1.sde set PGHOST=/var/run/pgsql set SDE_DATABASE=db1 -- $SDEHOME/etc/dbinit_db2.sde set PGHOST=/var/run/pgsql set SDE_DATABASE=db2 PGHOST=/var/run/pgsql SDE_DATABASE=db1 sdemon -o start -i 6629 PGHOST=/var/run/pgsql SDE_DATABASE=db2 sdemon -o start -i 6630 Connection Properties db1 (ArcCatalog 10.0): Server: <address of db server> Service: 6629 Database: db1 Database Authentication: Username: sde Password: <sde password> Connection Properties db2 (ArcCatalog 10.0): Server: <address of db server> Service: 6630 Database: db2 Database Authentication: Username: sde Password: <sde password> Connection Properties db1 (ArcCatalog 10.1): Database Platfrom: Application Server Server: <address of db server> Service: 6629 Database Authentication: Username: sde Password: <sde password> Database: db1 Connection Properties db2 (ArcCatalog 10.1): Database Platfrom: Application Server Server: <address of db server> Service: 6630 Database Authentication: Username: sde Password: <sde password> Database: db2 With 10.1 clients everything works normal. With 10.0 I can't establish a connection. For instance if I try to connect to db1 I get the same error message as hfoster for db2. I don't use any client libraries because until 10.0 they weren't needed for SDE connections. And for 10.1 it works without client libraries. Regards...
... View more
03-29-2013
04:40 AM
|
0
|
0
|
267
|
POST
|
Heya, we have the same issues. Client 10.0 can't connect to a sde GDB if there is more than one database to connect to in PostgresSQL, through sde service. And in the compatibility matrix it says it can, 10.0 clients can conect to sde 10.1. We also tried this reference http://support.esri.com/en/knowledgebase/techarticles/detail/36445 But given that sde 10.1 doesn't have sdesetup -o install the last step was a little bit difficult. When connecting through sde 10.1 service with a client of 10.0 the connection somehow gets confused. For instance if I want to connect to Database1 it tries to connect to Database2 If you connect with a 10.1 client everything works as expected. We tried it with every client version that we got. The error is the same as HFOSTER stated it. And what he meant with <wrong database> is that the connection tries to connect to another database than stated in the database connection. The setup is as follows: SDE 10.1 SP1 on Linux64. PostgresSQL 9.1.3 on Linux64. ArcGis for Desktop Advanced (SP1, postgresql patch) x 1 ArcEditor x2 (10.0) (SP5) ArcGis for Desktop Basic x1 (SP1, postgresql patch) ArcView (10.0) x2 (SP5) Thanks....
... View more
03-28-2013
08:17 AM
|
0
|
0
|
781
|
POST
|
If you are using a Postgres version that we do not certify, than you run the risk of the Postgres client libraries being different enough from the ones found in the version that we do certify on, for our st_geometry dll/so to be inaccessible. In which case there is nothing that can be done. The only way to fix it would be for the st_geometry library to be recompiled with the newer Postgres client libraries and that ends up being a new release. Sincerely, Kasia Heya, is there a way for as normal mortal users to get to the source code of the st_geometry library so that we can recompile it for the used Postgres database? The question why I ask is to test it with Postgres 9, and to circumvent having to do pachtworking like I did with SDE 9.3.1 and Postgres 64bit. Back then I copied the library files from SDE 10 64bit to postgres. Fortunatly it worked back then. But if we have to move to Postgres 9 without moving to GIS 10.1 then we are going to have a problem again in which I again will have to do this patchworking. It would be much easier if we would have the sources of the librarires to compile against the used Postgres version. Regards, Daniel
... View more
02-24-2012
03:40 AM
|
0
|
0
|
487
|
POST
|
Just wanted to thank you 🙂 I have used the wrong methodology of creating geo-dbs. Though one thing is still bothering me. Now I have one sde service, the spatial data is not in the sde-schema anymore but by themselfs in their own schemas and as their own users, but still through arccatalog, connecting as a user you can see the feature datasets of the other users. You can't see whats inside or change them, but you can see them. i.e. if I have a schema test1 and user test1, where let's say I have a feature dataset "streets" and let's say I have schema test2 with user test2 with a feature dataset "rivers", if I connect, through arccatalog, as user test1 to the database test where the schemas test1 and test2 are, test1 can see the feature dataset of test2. I tried to revoke priviliges of the users respectively to their schemas but that didn't work. Any ideas about that? Thanks again.... D.
... View more
10-21-2011
08:15 AM
|
0
|
0
|
271
|
POST
|
Thanks Vince and Kasia. Just saw that ArcSDE 10 can use multiple users and schemas. http://help.arcgis.com/en/geodatabase/10.0/install_guides/arcsde_for_postgresql_installation_and_upgrade_guide/00q3/00q30000002p000000.htm Though a confirmation would be nice before I turn to 10. The reason why I need multiple users and not just one, the sde user, is that I have multiple users editing different geodatabases. Until now I had to start several sde services to not allow that user1 can edit data on user2 geodb, and that only if I don't tell them the ports that the other sde services are running. And installing a new service is a great hassle, with /etc/services, dbinit.sde and such. This is like 1 hour for one service instance. Yes I can have multiple databases through one sde service, but they are all owned by the role "sde". And that is something that I want to avoid. I need multiple databases with different roles for sec. reasons. I want to have one sde service through which users can connect with arccatalog but only to edit their db, and not the ones that they are not supposed to. And that can only be done if I have one service, through which I can connect to diff databases with different user names (roles). Thx again, D
... View more
10-13-2011
08:29 AM
|
0
|
0
|
583
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|