[mapguide-trac] #666: PostGIS FDO: connection problem with PostgreSQL+PostGIS

[MapGuide Open Source]

#666: PostGIS FDO: connection problem with PostgreSQL+PostGIS
---------------------+------------------------------------------------------
 Reporter:  ssimoss  |         Owner:       
     Type:  defect   |        Status:  new  
 Priority:  medium   |     Milestone:  2.1  
Component:  Server   |       Version:  2.0.1
 Severity:  major    |    Resolution:       
 Keywords:           |   External_id:       
---------------------+------------------------------------------------------
Comment (by ssimoss):

 == FDO::PostGIS ==

 This is the dataconnection xml (using ''maestro'') with ''OSGeo.PostGIS''
 provider:

 {{{
 <?xml version="1.0" encoding="utf-8"?>
 <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns:xsd="http://www.w3.org/2001/XMLSchema"
 xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd">
   <Provider>OSGeo.PostGIS</Provider>
   <Parameter>
     <Name>Username</Name>
     <Value>demo</Value>
   </Parameter>
   <Parameter>
     <Name>Password</Name>
     <Value>demo</Value>
   </Parameter>
   <Parameter>
     <Name>Service</Name>
     <Value>demo at 10.1.1.150:5432</Value>
   </Parameter>
   <Parameter>
     <Name>DataStore</Name>
     <Value>public</Value>
   </Parameter>
 </FeatureSource>
 }}}

 test connection reports no error, but when I try to use this
 dataconnection with a new layer I get:

 {{{
 MgInvalidStreamHeaderException.: Invalid stream header exception.
 Exception occurred in method MgCommand.GetResponse at line 152 in file
 Service/Command.cpp
 }}}

 and mgos 2 crashes with:

 {{{
 $ sudo /usr/local/mapguideopensource/server/bin/mgserver.sh
 /usr/local/mapguideopensource/server/bin ~
 Running the server interactively as an application instead of as a
 service.

 (3018266304) Server starting...
 (3018266304) PROJ4 Coordinate System Library
 (3018266304) Server started.
 terminate called after throwing an instance of 'FdoCommandException*'
 /usr/local/mapguideopensource/server/bin/mgserver.sh: line 7:  4941
 Aborted                 (core dumped) ./mgserver run
 ~
 }}}


 == FDO::OGR ==

 If I try to use OSGeo.OGR provider, which works (slow) with mgos 1.2, it
 don't pass test connection:

 {{{
 Errore del server remoto: (559) MgFdoException.:
 An exception occurred in FDO component.
 Connect failed:
 Exception occurred in method
 }}}

 and server console complains:

 {{{
 $ sudo /usr/local/mapguideopensource/server/bin/mgserver.sh
 /usr/local/mapguideopensource/server/bin ~
 Running the server interactively as an application instead of as a
 service.

 (3018061504) Server starting...
 (3018061504) PROJ4 Coordinate System Library
 (3018061504) Server started.
 (2691959696) An exception occurred in FDO component.
 Connect failed:
 Exception occurred in method MgFdoConnectionManager.Open at line 858 in
 file FdoConnectionManager.cpp
 }}}

 Now if I retry ''OSGeo.PostGIS'' test connection I get the #666 error
 message.

-- 
Ticket URL: <https://trac.osgeo.org/mapguide/ticket/666#comment:2>
MapGuide Open Source <http://mapguide.osgeo.org/>
MapGuide Open Source Internals