OGR and PostGIS providers not working under MapGuide on Ubuntu 7.10

[jbirch]

From Jo Cook on the mapguide-users mailing list:

I have managed to build MGOS2 on Ubuntu 7.04 with help from Jason's
great instructions on the wiki. However, when I try and make a new
data connection with either postgis or ogr I get errors. 

In mapguide studio when I try to make a postgis connection I get
the default feature editor screen and errors in my error log
saying CLNT_8_UNABLE_TO_LOAD_LIBRARY.

When I make an ogr connection I get the proper editor (with data
source and readonly connection options) but I get a connection
failed error when I try and test the connection. The error log
says CLNT_4_PROVIDERNOTREGISTERED.

I have tested my connection string with ogrinfo and it works,
and I have checked that both providers are in my providers.xml
file. 

I have also tested both connection strings with testconnection in
the web tier test suite and both give me the
CLNT_4_PROVIDERNOTREGISTERED error.

Has anyone successfully managed to use either of these connectors
with Ubuntu, and how do I begin debugging the problem?

[jbirch]

Jo's follow-up:

2: Running ldd -r on libPostGISProvider.so gives me the following line that I don't get when I run any of the others (including ogr): undefined symbol: crypt (./libPostGISProvider.so)

[jbirch]

Jack Lee responded:

The crypt library seems to be missing from PostGIS/Src/Makefile.am

You can try changing

   -lpq

to

  -lpq \
  -lcrypt


in Makefile.am and rebuild.

[jbirch]

OK, that's odd. I see the missing dependancy, but...

I am able to successfully test the conenction to PostGIS source via Studio anyways. Perhaps I have a system component (libcrypt, postgresql-dev) installed that Jo doesn't.

However, when I save the connection, the MapGuide server crashes and I get the following error:

<2007-12-04T14:45:10>                   Administrator
 Error: An exception occurred in FDO component.
        The execution of GetSpatialContextsCommand command failed.
 StackTrace:
  - MgFeatureServiceHandler.ProcessOperation line 83 file FeatureServiceHandler.cpp
  - MgOpGetSpatialContexts.Execute line 108 file OpGetSpatialContexts.cpp
  - MgServerGetSpatialContexts.GetSpatialContexts line 106 file ServerGetSpatialContexts.cpp    An exception occurred in FDO component.
The execution of GetSpatialContextsCommand command failed.

This may be because I'm not connected to a PostGIS server, but just a straight PostgreSQL server. I'll have to install the spatial extensions and see what happens.