Running the ssdesetup authorization command

MarioBurrola · ‎03-20-2012

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

MarioBurrola · ‎03-26-2012

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 solution in original post

VinceAngelo · ‎03-20-2012

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

MarioBurrola · ‎03-21-2012

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

VinceAngelo · ‎03-21-2012

The '-9' error code is SE_INVALID_USER (with meaning "CANNOT VALIDATE THE SPECIFIED USER AND PASSWORD").

I suggest you make sure the 'sde' server login corresponds to an 'sde' schema user in the target database.

- V

MarioBurrola · ‎03-23-2012

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

VinceAngelo · ‎03-23-2012

The direction of quotes is vitally important in Unix -- Backquotes execute the contents,
so "ldd `which sdesetup`" is equivalent to pasting the output of "which sdesetup" as
the parameter(s) to the ldd command.

The output of 'which' indicates that you have not followed my example -- "~/bin/sdesetup"
indicates that you have not provided a fully qualified path to the PATH and LD_LIBRARY_PATH
variables, rendering them useless.

You should not ever make the SDEHOME directory the home directory of the software owner.
The hosts I administer *average* 15 ArcSDE installs -- all owned by the same user, and the
$HOME of that user is unlikely to be on the same filesystem as the $SDEHOME installations.

- V

MarioBurrola · ‎03-26-2012

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

MarioBurrola · ‎03-27-2012

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

KimPeter · ‎04-02-2012

Hi Mario,

Had you altered the pg_hba.conf file to allow connections to the database cluster? The fact that the server name didn't work but localhost did made me think this might be the issue.

Just a thought.

-Kim

MarioBurrola · ‎04-02-2012

Yes I did to be open to all connection and ipaddresses