topic Re: Running the ssdesetup authorization command in Data Management Questions

Running the ssdesetup authorization command

MarioBurrola — Tue, 20 Mar 2012 23:54:10 GMT

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

Re: Running the ssdesetup authorization command

VinceAngelo — Sat, 11 Dec 2021 09:17:28 GMT

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

Re: Running the ssdesetup authorization command

MarioBurrola — Wed, 21 Mar 2012 21:16:08 GMT

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

Re: Running the ssdesetup authorization command

VinceAngelo — Thu, 22 Mar 2012 00:10:04 GMT

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

Re: Running the ssdesetup authorization command

MarioBurrola — Sat, 11 Dec 2021 09:17:31 GMT

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

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

Re: Running the ssdesetup authorization command

VinceAngelo — Fri, 23 Mar 2012 23:39:11 GMT

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

Re: Running the ssdesetup authorization command

MarioBurrola — Mon, 26 Mar 2012 23:38:57 GMT

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

Re: Running the ssdesetup authorization command

MarioBurrola — Tue, 27 Mar 2012 21:28:07 GMT

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

Re: Running the ssdesetup authorization command

KimPeter — Mon, 02 Apr 2012 18:51:16 GMT

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

Re: Running the ssdesetup authorization command

MarioBurrola — Mon, 02 Apr 2012 23:53:46 GMT

Yes I did to be open to all connection and ipaddresses