Running the sdesetup authorization command and getting errors -37 and -51

[MarioBurrola]

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

[VinceAngelo]

You need to pay close attention to the application word size in both binaries and libraries.
32-bit applications will only work with 32-bit libraries; 64-bit applications will only work
with 64-bit libraries. The error messages indicate you're trying to run a 32-bit application
with 64-bit libraries. The 'file' utility can be used to determine the wordsize of both DLLs
and applications (everything in the .../bin and .../lib of that directory tree should be the
same wordsize).

You really shouldn't ever run *any* installer as root (it's just about the only way you can
significantly damage a Linux box). I generally install ArcSDE as the 'postgres' user, so there
won't be any permission conflicts when it comes time to copy files to $PGHOME/lib.  I'm not
a fan of installing PostgreSQL anywhere in /usr partition, but I'm not a fan of using RPMs
either (I compile my apps from source, setting the --prefix to where I want it installed).

- V

[MarioBurrola]

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

[VinceAngelo]

The banner is reporting the environment in which it was compiled.  This is not a problem.

Nor are a majority of the "errors" in the log, which are warnings only encountered on
initial install.

- V

[MarioBurrola]

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

[VinceAngelo]

Your error messages are inconsistent with where you state you have installed software.
If your PATH doesn't point to these binaries first, they won't be used. Most Linux hosts
have a nominal PostgreSQL installed by default -- I always remove this to prevent
complications (if I didn't disable it during OS install).

ArcSDE 10 is not compatible with PG 8.3.1, only PG 8.3.8 or 8.4.1 (8.3.8 is on the release
media).

I've been a professional DBA for 20+ years with six different RDBMSes on five different
operating systems (if you lump all the Unix flavors and Windows flavors into one [each]).
I can't recommend you follow all my tricks on your first install, but by the time you get
to your tenth, you'll probably be intuiting many of them.  In the meantime, you should
make sure you're working from the install guide for the correct software (ArcSDE 9 and 10
documentation might be different enough to trip you up).

- V

[MarioBurrola]

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

[VinceAngelo]

I don't believe the install docs are distributed as PDF.  But the HTML is on the install media,
and if you enter "arcsde install linux" in the upper-right search window, PostgreSQL is the
first link.

Part of the reason what to do as each user is unclear is probably because, with the exception
of editing /etc/services, it doesn't matter what user you do it as, so long as you do it with
the appropriate user for any one of a few dozen possible configuration permutations.  SQL
commands can only be issued as a database user; if it isn't clear which is an OS command
and which is SQL, then you probably should be getting assistance from an experienced Unix
admin and/or DBA.

- V

[MarioBurrola]

Thanks for all your help, unfortunatelly I dont have  that help...