POST
|
After checking the right files for 64 libraries files and applying the update patch, the geodatabase was created and authorized. Thanks for all your help. The issue from the beginnning was the lack of not applying the latest patch. Mario
... View more
04-10-2012
02:17 PM
|
0
|
0
|
226
|
POST
|
I have reinstall the Postgres 8.4.1 database in Linux RedHat 5.7 and I get this errors when I run the following command (Passwords have been change) ./sdesetup -o install -d POSTGRESQL -u sde -p sdepassword -D stormdata -s localhost -l /home/sde/sdeexe100/Authorization_ArcSDE.ecp - N [Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist LINE 1: select count(*) from stormdata.sde.sde_layers ^ [Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist LINE 1: select count(1) from stormdata.sde.sde_server_config ^ [Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist LINE 1: select count(keyword) from stormdata.sde.sde_dbtune ^ [Thu Apr 5 17:58:03 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist LINE 1: select count(1) from stormdata.sde.sde_server_config ^ [Thu Apr 5 17:58:03 2012] ST_GEOMETRY support being installed... [Thu Apr 5 17:58:03 2012] ev.SQLstate = 58P01 SDE DBMS Error: -51 ERROR: could not load library "/usr/lib64/pgsql/st_geometry.so": /usr/lib64/pgsql/st_geometry.so: wrong ELF class: ELFCLASS32 [Thu Apr 5 17:58:03 2012] ST_GEOMETRY install not completed (-51). [Thu Apr 5 17:58:03 2012] ERROR installing/upgrading ArcSDE, Error = -51
... View more
04-05-2012
05:02 PM
|
0
|
2
|
2005
|
POST
|
Yes I did to be open to all connection and ipaddresses
... View more
04-02-2012
04:53 PM
|
0
|
0
|
486
|
POST
|
Thanks for all your help, unfortunatelly I dont have that help...
... View more
04-02-2012
04:19 PM
|
0
|
0
|
1002
|
POST
|
Thanks Vince for all the recomendations you had advise in this post. Yes, I believe that I should just use the install for ArcSDE 10, but I don't have it... Do you know where I can download it as PDF file? The resource online is very confusing in following step by step since it is not very explicit on what to do as Root, Postgres or SDE users and if it is linux postgres or sde user; or the database users. Mario
... View more
03-29-2012
04:40 PM
|
0
|
0
|
1002
|
POST
|
That is strange because I setup the postgres database from the RPM's that are for 64 BIT and the sde server from the same 64 bit folder, I also copy the library files from the 64 folder... The Postgres is intalled in /var/lib/pgsql I have run the installers with the postgres user and the sde user depending on which commands I was running to install, setup and authorize the geodatabase. Follow all the instructions as was to install the Postgres database, and the sde server. So I am very confuse about you are telling me in how to set up the SDE Server. First time, I download the postgresql 8.4.1 from source so I can setup by using the commands configure, make, install. However I could never make the SDE work properly to authorize. So I erase the database and all the processes I had made. Then, I use the media files and I am here. I use the "Installation Guide: ArcSDE for PostgreSQL" from ESRI that it is for ArcSDE 9 just to make sure I was doing all step by step. Still I been running with this issues that I can pass by...I just want to make sure I can install a version and be able to recognize the process to install and authorize... Then I will reinstall all of it by using PostgreSQL 8.4.1 with SDEServer 10 Thanks... Mario
... View more
03-27-2012
05:24 PM
|
0
|
0
|
1002
|
POST
|
There is one think that I may think it is an issue with the sdesetup command... The redhat version is 5.7 and NOT 5.5 or 5 with update 5.... It is this something that may give me all those errors in the preceding post? Mario
... View more
03-27-2012
05:01 PM
|
0
|
0
|
1002
|
POST
|
I have installed the sde server 10 in Linux 5.7 and postgres 8.3.1 that comes with the media installation disk. After running the setup command as follows password is dressed: ./sdesetup -o install -d POSTGRESQL -u sde -p sdepassword -D stormdatabase -s localhost -l /home/sde/sdeexe100/Authorization_ArcSDE.ecp - N I get the following on the terminal window: ESRI ArcSDE Server Setup Utility Tue Mar 27 15:26:29 2012 ---------------------------------------------------------------- Install or update ST_GEOMETRY, ArcSDE, GDB schema objects: Are you sure? (Y/N): y Checking INSTALL privileges for geodatabase ... Current user has privilege to install geodatabase instance. Checking geodatabase XML datatype support... Underlying RDBMS database instance supports XML data type. Creating ST_GEOMETRY and ArcSDE schema..... Error: Underlying DBMS error (-51). SDE release install not completed. Check SDEHOME\etc\sde_setup.log for more details. The setup log has this input for the command errors ran... [Tue Mar 27 15:26:31 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_layers" does not exist [Tue Mar 27 15:26:31 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist [Tue Mar 27 15:26:31 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_dbtune" does not exist [Tue Mar 27 15:26:31 2012] ev.SQLstate = 42P01 SDE DBMS Error: -37 ERROR: relation "sde.sde_server_config" does not exist [Tue Mar 27 15:26:31 2012] ST_GEOMETRY support being installed... [Tue Mar 27 15:26:31 2012] ev.SQLstate = 58P01 SDE DBMS Error: -51 ERROR: could not load library "/usr/lib/pgsql/st_geometry.so": /usr/lib/pgsql/st_geometry.so: wrong ELF class: ELFCLASS64 [Tue Mar 27 15:26:31 2012] ST_GEOMETRY install not completed (-51). [Tue Mar 27 15:26:31 2012] ERROR installing/upgrading ArcSDE, Error = -51 Then I check the library folder and the st_geometry.so does exist... It may be the wrong geometry? Or the issue has to do that belongs to root and not sde user? -rwxr-xr-x 1 root root 4920193 Mar 26 16:52 st_geometry.so Thanks, Mario
... View more
03-27-2012
03:01 PM
|
0
|
8
|
1272
|
POST
|
Well I finally figure out what the problem was to the error -9 of wrong user or password to the database, I changed the server name from storm which is the computer's name to localhost... Mario
... View more
03-27-2012
02:28 PM
|
0
|
0
|
486
|
POST
|
This are the export commands I have in my setup: SDEHOME=/home/sde/sdeexe100 export SDEHOME PATH=$PATH:$HOME/bin:$SDEHOME/bin export PATH LD_LIBRARY_PATH=$SDEHOME/lib:/usr/lib:/usr/lib/pgsql export LD_LIBRARY_PATH After I run the command: ~/sdeexe100/bin/sdesetup -o install -d POSTGRESQL -u sde -p sdepassword -D stormdatabase -s storm -l /wd1/home/sde/sdeexe100/Authrization_ArcSDE.ecp - N I get the following error: ESRI ArcSDE Server Setup Utility Mon Mar 26 17:21:17 2012 ---------------------------------------------------------------- Connection to database 'stormdatabase' failed. Connection to stormdatabase failed(0) Error creating ArcSDE direct connection (-9) I have check in the OS and in the Database that the user sde has the same password sdepassword. and Still gets me the same error over and over. Mario
... View more
03-26-2012
04:38 PM
|
0
|
0
|
486
|
POST
|
I have run all the commands to make sure that the schema is installed for the sde user at the geodatabase create on the postgres database. Never the less I still geting this issue when I run the ldd command.... [sde@storm bin]$ which sdesetup ~/bin/sdesetup [sde@storm bin]$ ldd 'which sdesetup' ldd: ./which sdesetup: No such file or directory [sde@storm bin]$ Also I get this when I try to run the ./sdesetup -o install -d POSTGRESQL -u sde -p sdepassword -D stormdatabase -l /usr/local/arcsde/Authorization_ArcSDE.ecp Where I get this message: ./sdesetup: error while loading shared libraries: libsdesetup.so: cannot open shared object file: No such file or directory I am sure I have setup all path in the sde user setup... Mario Dynamic link libraries are resolved by the use of the LD_LIBRARY_PATH variable. You must populate it with the colon-delimited list of directories where desired shared libraries reside; the ArcSDE libraries must be in this list. How you do this is a shell-specific issue, but using Bourne, Korn, and BASH shells, something like the following will work:
SDEHOME=/opt/esri/sdeexe100_pg32-sp4
PATH=$SDEHOME/bin:$PATH
LD_LIBRARY_PATH=/opt/postgres/pg-8.3.8/lib:$SDEHOME/lib:/usr/X11R6/LessTif/Motif2.0/lib:/usr/X11R6/lib:/usr/local/lib:/usr/lib
export SDEHOME PATH LD_LIBRARY_PATH
You can locate any missing shared libraries by using the `ldd` command:
$ which sdesetup
/opt/esri/sdeexe100_pg32-sp2/bin/sdesetup
$ ldd `which sdesetup`
linux-gate.so.1 => (0x00123000)
libsdesetup.so => /opt/esri/sdeexe100_pg32-sp2/lib/libsdesetup.so (0x00cd0000)
libsde.so => /opt/postgres/pg-8.3.8/lib/libsde.so (0x00212000)
libsg.so => /opt/postgres/pg-8.3.8/lib/libsg.so (0x00e04000)
libpe.so => /opt/postgres/pg-8.3.8/lib/libpe.so (0x0064f000)
libXm.so.3 => /usr/lib/libXm.so.3 (0x00e64000)
libXmu.so.6 => /usr/lib/libXmu.so.6 (0x00c45000)
libXp.so.6 => /usr/lib/libXp.so.6 (0x00a3d000)
libXt.so.6 => /usr/lib/libXt.so.6 (0x06621000)
libSM.so.6 => /usr/lib/libSM.so.6 (0x00110000)
libICE.so.6 => /usr/lib/libICE.so.6 (0x00124000)
libXext.so.6 => /usr/lib/libXext.so.6 (0x00dce000)
libX11.so.6 => /usr/lib/libX11.so.6 (0x00ace000)
libg2c.so.0 => /usr/lib/libg2c.so.0 (0x0013e000)
libpthread.so.0 => /lib/libpthread.so.0 (0x0015c000)
libdl.so.2 => /lib/libdl.so.2 (0x00c3f000)
libstdc++.so.6 => /usr/lib/libstdc++.so.6 (0x06188000)
libm.so.6 => /lib/libm.so.6 (0x00c16000)
libc.so.6 => /lib/libc.so.6 (0x01cc6000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0x00173000)
libXau.so.6 => /usr/lib/libXau.so.6 (0x00119000)
libXdmcp.so.6 => /usr/lib/libXdmcp.so.6 (0x0011c000)
/lib/ld-linux.so.2 (0x00ab2000)
- V
... View more
03-23-2012
03:18 PM
|
0
|
0
|
486
|
POST
|
After set all the environment path described above and making sure that library are share I get this error... ESRI ArcSDE Server Setup Utility Wed Mar 21 15:11:40 2012 ---------------------------------------------------------------- Connection to database 'stormdatabase' failed. Connection to stormdatabase failed(0) Error creating ArcSDE direct connection (-9) I know the postgresql server is working and I have database called stormdatabase with user and password. Mario
... View more
03-21-2012
02:16 PM
|
0
|
0
|
486
|
POST
|
Hello GISrs, I am installed SDE Server 10 in RED-HAT 5.7 with PostgreSQL 8.3 or files included in the DVD installation disk for Linux. I been following most of the installation process and creation of sde and postgres users with their proper attributes. When I am trying to run the authorization command I get the following errors... ./sdeexe100/bin/sdesetup -o install -d POSTGRESQL -u sde -p sdepassword -D stormdatabase -l /usr/local/arcsde/Authorization_ArcSDE.ecp I get this errors: ./sdeexe100/bin/sdesetup: error while loading shared libraries: libsdesetup.so: cannot open shared object file: No such file or directory Mario
... View more
03-20-2012
04:54 PM
|
0
|
9
|
1089
|
POST
|
I am installed SDE Server 10 in RED-HAT 5.7 with PostgreSQL 8.3 or files included in the DVD installation disk for Linux. I been following most of the installation process and creation of sde and postgres users with their proper attributes. When I am trying to run the authorization command I get the following errors... ./sdeexe100/bin/sdesetup -o install -d POSTGRESQL -u sde -p sdepassword -D stormdatabase -l /usr/local/arcsde/Authorization_ArcSDE.ecp I get this errors: ./sdeexe100/bin/sdesetup: error while loading shared libraries: libsdesetup.so: cannot open shared object file: No such file or directory
... View more
03-20-2012
04:52 PM
|
0
|
0
|
176
|
POST
|
Hi, I been working with a feature class that contains multiple polygons or areas, and I need to combine them into a single one. I am using the dissolve tool but it keeps failing to dissolve the the polygons in the feature class. Mario
... View more
08-23-2011
10:37 AM
|
0
|
2
|
2962
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|