<div>I believe that it only works when compiled against an earlier version of the PostgreSQL libs, but could be wrong.</div><div><br></div>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.<div>
<br></div><div>Jason<br><br><div class="gmail_quote">On 17 September 2010 15:33, Trevor Wekel <span dir="ltr"><<a href="mailto:trevor_wekel@otxsystems.com">trevor_wekel@otxsystems.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Excellent... most excellent...<br>
<div class="im"><br>
Thanks Greg,<br>
Trevor<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Greg Boone<br>
</div><div><div></div><div class="h5">Sent: September 17, 2010 4:32 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
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.<br>
<br>
Greg<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Trevor Wekel<br>
Sent: Friday, September 17, 2010 4:34 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
Hi Greg (and list),<br>
<br>
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!<br>
<br>
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<br>
<br>
"An exception occurred in FDO component. FDO_45_ITEMINCOLLECTION"<br>
<br>
<br>
The same call does return successfully for PostgreSQL.3.5. Any ideas?<br>
<br>
<br>
Regards,<br>
Trevor<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Greg Boone<br>
Sent: September 16, 2010 1:11 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
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.<br>
<br>
Greg<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Trevor Wekel<br>
Sent: Thursday, September 16, 2010 2:58 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
Hi Greg,<br>
<br>
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.<br>
<br>
Regards,<br>
Trevor<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Greg Boone<br>
Sent: September 16, 2010 12:57 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
Any word on getting these changes submitted?<br>
<br>
Are you close to publishing a 3.5 build? Can we publish piecemeal? Win64 first then Win32 then Linux?<br>
<br>
Greg<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Trevor Wekel<br>
Sent: Monday, September 13, 2010 12:03 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
Ok. I should be able to get the changes in today.<br>
<br>
Thanks Greg!<br>
Trevor<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Greg Boone<br>
Sent: September 13, 2010 9:56 AM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
Updating the makefile is OK too.<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Trevor Wekel<br>
Sent: Saturday, September 11, 2010 1:42 AM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
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.<br>
<br>
I would like to submit the build fixes to the FDO 3.5.0 branch and trunk. Please see <a href="http://trac.osgeo.org/fdo/ticket/694" target="_blank">http://trac.osgeo.org/fdo/ticket/694</a> for full details on the fixes required.<br>
<br>
<br>
Regards,<br>
Trevor<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Trevor Wekel<br>
Sent: September 10, 2010 6:34 PM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] RE: PostgreSQL libpq.a library for Linux<br>
<br>
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.<br>
<br>
However, when I build the final shared library for <a href="http://libPostGISProvider-3.5.0.so" target="_blank">libPostGISProvider-3.5.0.so</a> I get the following undefined symbols:<br>
<br>
undefined symbol: _ZN12FdoFunctionZ6CreateEv (./<a href="http://libPostGISProvider-3.5.0.so" target="_blank">libPostGISProvider-3.5.0.so</a>)<br>
undefined symbol: _ZN12FdoFunctionX6CreateEv (./<a href="http://libPostGISProvider-3.5.0.so" target="_blank">libPostGISProvider-3.5.0.so</a>)<br>
undefined symbol: _ZN12FdoFunctionY6CreateEv (./<a href="http://libPostGISProvider-3.5.0.so" target="_blank">libPostGISProvider-3.5.0.so</a>)<br>
undefined symbol: _ZN12FdoFunctionM6CreateEv (./<a href="http://libPostGISProvider-3.5.0.so" target="_blank">libPostGISProvider-3.5.0.so</a>)<br>
<br>
Using c++filt (a name demangler on linux), the following functions are flagged. Any ideas?<br>
<br>
FdoFunctionZ::Create()<br>
FdoFunctionX::Create()<br>
FdoFunctionY::Create()<br>
FdoFunctionM::Create()<br>
FdoExpressionEngine::GetStandardFunctions()<br>
<br>
<br>
Other than that, the following providers are showing no undefined symbols in Linux (whew!)<br>
<br>
<a href="http://libFdoMySQL-3.5.0.so" target="_blank">libFdoMySQL-3.5.0.so</a><br>
<a href="http://libFdoODBC-3.5.0.so" target="_blank">libFdoODBC-3.5.0.so</a><br>
<a href="http://libFdoOws-3.5.0.so" target="_blank">libFdoOws-3.5.0.so</a><br>
<a href="http://libFdoPostgreSQL-3.5.0.so" target="_blank">libFdoPostgreSQL-3.5.0.so</a><br>
<a href="http://libGRFPProvider-3.5.0.so" target="_blank">libGRFPProvider-3.5.0.so</a><br>
<a href="http://libKingOracleProvider-3.5.0.so" target="_blank">libKingOracleProvider-3.5.0.so</a><br>
<a href="http://libOGRProvider-3.5.0.so" target="_blank">libOGRProvider-3.5.0.so</a><br>
<a href="http://libPostGISProvider-3.5.0.so" target="_blank">libPostGISProvider-3.5.0.so</a><br>
<a href="http://libSDFProvider-3.5.0.so" target="_blank">libSDFProvider-3.5.0.so</a><br>
<a href="http://libSHPProvider-3.5.0.so" target="_blank">libSHPProvider-3.5.0.so</a><br>
<a href="http://libSQLiteProvider-3.5.0.so" target="_blank">libSQLiteProvider-3.5.0.so</a><br>
<a href="http://libWFSProvider-3.5.0.so" target="_blank">libWFSProvider-3.5.0.so</a><br>
<a href="http://libWMSProvider-3.5.0.so" target="_blank">libWMSProvider-3.5.0.so</a><br>
<br>
Regards,<br>
Trevor<br>
<br>
<br>
-----Original Message-----<br>
From: <a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a> [mailto:<a href="mailto:fdo-internals-bounces@lists.osgeo.org">fdo-internals-bounces@lists.osgeo.org</a>] On Behalf Of Trevor Wekel<br>
Sent: September 10, 2010 11:08 AM<br>
To: FDO Internals Mail List<br>
Subject: [fdo-internals] PostgreSQL libpq.a library for Linux<br>
<br>
Hello,<br>
<br>
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.<br>
<br>
undefined symbol: PQclear (./libPostGISProvider.so)<br>
undefined symbol: PQresultStatus (./libPostGISProvider.so)<br>
undefined symbol: PQgetvalue (./libPostGISProvider.so)<br>
undefined symbol: PQclear (./libPostGISProvider.so)<br>
undefined symbol: PQresultErrorMessage (./libPostGISProvider.so)<br>
undefined symbol: PQexec (./libPostGISProvider.so)<br>
<br>
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"<br>
<br>
<a href="http://trac.osgeo.org/fdo/browser/branches/3.5/Thirdparty/pgsql/lib/libpq.a?rev=5309" target="_blank">http://trac.osgeo.org/fdo/browser/branches/3.5/Thirdparty/pgsql/lib/libpq.a?rev=5309</a> (96 kbytes)<br>
<a href="http://trac.osgeo.org/fdo/browser/trunk/Thirdparty/pgsql/lib/libpq.a?rev=3499" target="_blank">http://trac.osgeo.org/fdo/browser/trunk/Thirdparty/pgsql/lib/libpq.a?rev=3499</a> (137 kbytes) /usr/lib/libpq.a from "yum install postgresql-devel" (755 kbytes)<br>
<br>
Regards,<br>
Trevor<br>
<br>
_______________________________________________<br>
fdo-internals mailing list<br>
<a href="mailto:fdo-internals@lists.osgeo.org">fdo-internals@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-internals" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-internals</a><br>
<br>
_______________________________________________<br>
fdo-internals mailing list<br>
<a href="mailto:fdo-internals@lists.osgeo.org">fdo-internals@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-internals" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-internals</a><br>
<br>
_______________________________________________<br>
fdo-internals mailing list<br>
<a href="mailto:fdo-internals@lists.osgeo.org">fdo-internals@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-internals" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-internals</a><br>
<br>
_______________________________________________<br>
fdo-internals mailing list<br>
<a href="mailto:fdo-internals@lists.osgeo.org">fdo-internals@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-internals" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-internals</a><br>
<br>
</div></div><br>_______________________________________________<br>
fdo-internals mailing list<br>
<a href="mailto:fdo-internals@lists.osgeo.org">fdo-internals@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/fdo-internals" target="_blank">http://lists.osgeo.org/mailman/listinfo/fdo-internals</a><br>
<br></blockquote></div><br></div>