[fdo-internals] RE: PostgreSQL libpq.a library for Linux

Jason Birch jason at jasonbirch.com
Fri Sep 17 21:15:06 EDT 2010 

I believe that it only works when compiled against an earlier version of the
PostgreSQL libs, but could be wrong.

If it's non-functional (GetCapabilities fails) why bother releasing it at
all?  I would have preferred to see it maintained for one release, but if
nobody's available to do so then just drop it.

Jason

On 17 September 2010 15:33, Trevor Wekel <trevor_wekel at otxsystems.com>wrote:

> Excellent... most excellent...
>
> Thanks Greg,
> Trevor
>
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Greg Boone
> Sent: September 17, 2010 4:32 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> We are not even supporting the PostGIS Provider anymore. It has been
> replaced with the PostgreSQL provider. IMHO, the PostGIS provider can be
> released as-is (non-functional against 8.4/1.5.1) for 3.5 and completely
> hauled out of the 3.6 release.
>
> Greg
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
> Sent: Friday, September 17, 2010 4:34 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> Hi Greg (and list),
>
> Good news and bad news.  First the good news.  I managed to set up a
> PostgreSQL 8.4 / PostGIS 1.5.1 database and import some data into it.  Then
> I tried to connect through MapGuide with the rebuilt PostgreSQL.3.5 and
> PostGIS.3.5 providers.  Once I figured out how to configure PostgreSQL to
> actually accept external connections on port 5432, I was able to author and
> see a map of the world using the PostgreSQL.3.5 FDO Provider.  Hooray!  One
> down!
>
> However, I don't even get out of the gate with the PostGIS.3.5 provider.
>  Calling get capabilities on the provider returns the following error
> message
>
> "An exception occurred in FDO component. FDO_45_ITEMINCOLLECTION"
>
>
> The same call does return successfully for PostgreSQL.3.5.  Any ideas?
>
>
> Regards,
> Trevor
>
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Greg Boone
> Sent: September 16, 2010 1:11 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> If the changes work in 3.5, I am ok with just submitting them there for now
> and worrying about trunk (3.6) as a secondary effort once 3.5 in out the
> door.
>
> Greg
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
> Sent: Thursday, September 16, 2010 2:58 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> Hi Greg,
>
> I was trying to get the fixes compiled with trunk on Linux before
> submitting to 3.5 and trunk.  Haven't had a lot of luck yet.
>
> Regards,
> Trevor
>
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Greg Boone
> Sent: September 16, 2010 12:57 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> Any word on getting these changes submitted?
>
> Are you close to publishing a 3.5 build? Can we publish piecemeal? Win64
> first then Win32 then Linux?
>
> Greg
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
> Sent: Monday, September 13, 2010 12:03 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> Ok.  I should be able to get the changes in today.
>
> Thanks Greg!
> Trevor
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Greg Boone
> Sent: September 13, 2010 9:56 AM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> Updating the makefile is OK too.
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
> Sent: Saturday, September 11, 2010 1:42 AM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> Ok.  I can now create a build of the PostGIS Provider on Linux which
> contains no "ldd -r" undefined symbol errors.  The second fix was easy.  The
> dependency on the Expression Engine was not present in
> Providers/PostGIS/Src/Makefile.am.  And Linux is so lenient that it doesn't
> even complain about the missing symbols until you try to *use* the library.
>  Geez.
>
> I would like to submit the build fixes to the FDO 3.5.0 branch and trunk.
>  Please see http://trac.osgeo.org/fdo/ticket/694 for full details on the
> fixes required.
>
>
> Regards,
> Trevor
>
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
> Sent: September 10, 2010 6:34 PM
> To: FDO Internals Mail List
> Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux
>
> Thought I would post a follow up on this one.  I downloaded source for
> PostgreSQL 8.4.2 and built it with the default configure settings.  Libpq.a
> comes out at around 164k and libecpg.a comes out at 91k.  I tried building
> with the new static libraries and the undefined symbol errors have gone
> away.  Look as though we have "odd" static libraries in Subversion.
>
> However, when I build the final shared library for
> libPostGISProvider-3.5.0.so I get the following undefined symbols:
>
> undefined symbol: _ZN12FdoFunctionZ6CreateEv    (./
> libPostGISProvider-3.5.0.so)
> undefined symbol: _ZN12FdoFunctionX6CreateEv    (./
> libPostGISProvider-3.5.0.so)
> undefined symbol: _ZN12FdoFunctionY6CreateEv    (./
> libPostGISProvider-3.5.0.so)
> undefined symbol: _ZN12FdoFunctionM6CreateEv    (./
> libPostGISProvider-3.5.0.so)
>
> Using c++filt (a name demangler on linux), the following functions are
> flagged.  Any ideas?
>
> FdoFunctionZ::Create()
> FdoFunctionX::Create()
> FdoFunctionY::Create()
> FdoFunctionM::Create()
> FdoExpressionEngine::GetStandardFunctions()
>
>
> Other than that, the following providers are showing no undefined symbols
> in Linux (whew!)
>
> libFdoMySQL-3.5.0.so
> libFdoODBC-3.5.0.so
> libFdoOws-3.5.0.so
> libFdoPostgreSQL-3.5.0.so
> libGRFPProvider-3.5.0.so
> libKingOracleProvider-3.5.0.so
> libOGRProvider-3.5.0.so
> libPostGISProvider-3.5.0.so
> libSDFProvider-3.5.0.so
> libSHPProvider-3.5.0.so
> libSQLiteProvider-3.5.0.so
> libWFSProvider-3.5.0.so
> libWMSProvider-3.5.0.so
>
> Regards,
> Trevor
>
>
> -----Original Message-----
> From: fdo-internals-bounces at lists.osgeo.org [mailto:
> fdo-internals-bounces at lists.osgeo.org] On Behalf Of Trevor Wekel
> Sent: September 10, 2010 11:08 AM
> To: FDO Internals Mail List
> Subject: [fdo-internals] PostgreSQL libpq.a library for Linux
>
> Hello,
>
> Does anyone recall how Thirdparty/pgsql/lib/libpq.a was generated?  I am
> seeing a number of undefined symbol messages when running "ldd -r
> libPostGISProvider.so" with the FDO 3.5.0 RC1 build.
>
> undefined symbol: PQclear       (./libPostGISProvider.so)
> undefined symbol: PQresultStatus        (./libPostGISProvider.so)
> undefined symbol: PQgetvalue    (./libPostGISProvider.so)
> undefined symbol: PQclear       (./libPostGISProvider.so)
> undefined symbol: PQresultErrorMessage  (./libPostGISProvider.so)
> undefined symbol: PQexec        (./libPostGISProvider.so)
>
> So I suspect there is something funky going on with libpq.a.  As a side
> note, the current version of libpq.a is smaller than its predecessor and
> much smaller than the "standard" libpq.a installed on CentOS 5.4 through
> "yum install postgresql-devel"
>
>
> http://trac.osgeo.org/fdo/browser/branches/3.5/Thirdparty/pgsql/lib/libpq.a?rev=5309 (96 kbytes)
>
> http://trac.osgeo.org/fdo/browser/trunk/Thirdparty/pgsql/lib/libpq.a?rev=3499(137 kbytes) /usr/lib/libpq.a from "yum install postgresql-devel" (755
> kbytes)
>
> Regards,
> Trevor
>
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>
>
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20100917/2b6c98ca/attachment.html

More information about the fdo-internals mailing list