<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.E-mailStijl17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=NL link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Jason, did not know of such list. I subscribed and off course
will share when something comes out. I ‘m pretty sure it is a Mapguide
FDO problem. After I’ve update Quantum Gis to v 1.3 (not included within
the ever so useful osgeo4w) I’m able to connect to postgis from Quantum
Gis as well besides Udig.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>If somebody here knows a solution please let me know. Do others
experience the same trouble?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'> <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Calibri","sans-serif";color:#5F5F5F'>Met
vriendelijke groet,<br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'><br>
</span><span style='font-family:"Calibri","sans-serif";color:#5F5F5F'> </span><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:black'><br>
</span><span style='font-family:"Calibri","sans-serif";color:#5F5F5F'>Remco
Houtkamp</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'><br>
</span><b><span style='color:#5F5F5F'> </span></b><span style='font-size:
10.0pt;color:black'><br>
</span><b><span style='font-family:"Calibri","sans-serif";color:#5F5F5F'>BURO
HOUTKAMP</span></b><span style='font-size:10.0pt;font-family:"Calibri","sans-serif";
color:black'><br>
</span><span style='font-family:"Calibri","sans-serif";color:#E26200'>|T: </span><span
style='font-family:"Calibri","sans-serif";color:#5F5F5F'>06 14 390 205</span><span
style='font-family:"Calibri","sans-serif";color:#E26200'> |E: </span><span
style='font-family:"Calibri","sans-serif";color:#5F5F5F'>r.houtkamp@burohoutkamp.nl</span><span
style='font-family:"Calibri","sans-serif";color:#E26200'> |P: </span><span
style='font-family:"Calibri","sans-serif";color:#5F5F5F'>Kweldergras 21, 1441
WP, Purmerend </span><span style='font-family:"Calibri","sans-serif";
color:#E26200'>|</span><span style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Van:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <b>Namens </b>Jason Birch<br>
<b>Verzonden:</b> maandag 21 september 2009 22:29<br>
<b>Aan:</b> MapGuide Users Mail List<br>
<b>Onderwerp:</b> Re: [mapguide-users] trouble connecting mapguide maestro
postgis<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I haven't played with the PostGIS provider for a long time,
but it would be key to ensure that you are using the same version of libpq (and
the other postgresql client libraries) as the provider was compiled with.
I'm not entirely sure what version that is, but someone on the fdo-users
mailing list should be able to help.<o:p></o:p></p>
<div>
<div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Jason<o:p></o:p></p>
<div>
<p class=MsoNormal>2009/9/21 Remco Houtkamp <<a
href="mailto:r.houtkamp@burohoutkamp.nl">r.houtkamp@burohoutkamp.nl</a>><o:p></o:p></p>
<p class=MsoNormal>Been away for the weekend, so I couldn't continue. This
morning I made a newe setup.<br>
Winxp<br>
Mapguide 2.1<br>
Mapguide Maestro<br>
Postgresql 8.4<br>
Postgis 1.4<br>
Same trouble as before with missing libpq.ddl, so I copied this file from the
postgresql tot the mapguide FDO folde. Depend.exe showed me that there were
some other files missing in the FDO folder so I copied them as wel. After this
maestro returen no errors after adding a new connection>postgis>test
connection. So I'm as far as I got before.<br>
<br>
When I add a layer and try to connect it, I get an error. The error log shows
me:<br>
<2009-09-21T05:20:54> 2200
127.0.0.1 Administrator<br>
Error: Cannot establish connection.<o:p></o:p></p>
<div>
<p class=MsoNormal> StackTrace:<br>
- MgFeatureServiceHandler.ProcessOperation line 83 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\FeatureServiceHandler.cpp<o:p></o:p></p>
</div>
<p class=MsoNormal> - MgOpDescribeSchemaAsXml.Execute line 110 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpDescribeSchemaAsXml.cpp<br>
- MgServerFeatureService.DescribeSchemaAsXml line 333 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerFeatureService.cpp<br>
- MgServerDescribeSchema.DescribeSchemaAsXml line 628 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerDescribeSchema.cpp<br>
- MgServerDescribeSchema.DescribeSchema line 564 file c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerDescribeSchema.cpp<br>
- MgServerDescribeSchema.DescribeFdoSchema line 196 file
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\ServerDescribeSchema.cpp<br>
<br>
Looking forward to reponds.<o:p></o:p></p>
<div>
<p class=MsoNormal><br>
-----Oorspronkelijk bericht-----<br>
Van: <a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>]
Namens Zac Spitzer<o:p></o:p></p>
</div>
<p class=MsoNormal>Verzonden: vrijdag 18 september 2009 11:11<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal>Aan: MapGuide Users Mail List<br>
Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro postgis<br>
<br>
maybe adding the bin dir for your postgres client to your path,<br>
rather than adding just the dll to fdo?<br>
<br>
z<br>
<br>
On Fri, Sep 18, 2009 at 7:01 PM, Remco Houtkamp<br>
<<a href="mailto:r.houtkamp@burohoutkamp.nl">r.houtkamp@burohoutkamp.nl</a>>
wrote:<br>
> Message is the same as yesterday when things did work. The lbpq.ddl is
still marked when running depend.exe. ieframe.ddl is also marked and has a
hourglass at the beginning of the line.<br>
> The meesage is as follows:<br>
> Error: At least one module has an unresolved import due to a missing
export function in an implicitly dependent module.<br>
> Warning: At least one module has an unresolved import due to a missing
export function in a delay-load dependent module.<br>
><br>
><br>
><br>
> Met vriendelijk groet,<br>
><br>
><br>
> Remco Houtkamp<br>
><br>
> BURO HOUTKAMP<br>
> |T: 06 14 390 205 |E: <a href="mailto:r.houtkamp@burohoutkamp.nl">r.houtkamp@burohoutkamp.nl</a> |P:
Kweldergras 21, 1441 WP, Purmerend |<br>
><br>
> -----Oorspronkelijk bericht-----<br>
> Van: <a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>
[mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>]
Namens Zac Spitzer<br>
> Verzonden: vrijdag 18 september 2009 10:56<br>
> Aan: MapGuide Users Mail List<br>
> Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro
postgis<br>
><br>
> try depends on libpq.dll<br>
><br>
> On Fri, Sep 18, 2009 at 6:46 PM, Remco Houtkamp<br>
> <<a href="mailto:r.houtkamp@burohoutkamp.nl">r.houtkamp@burohoutkamp.nl</a>>
wrote:<br>
>> You guys respond faster than I can check it! Great list!<br>
>><br>
>><br>
>><br>
>> But... for some reason Test connection does not work anymore only
difference<br>
>> is a restart of my laptop.<br>
>><br>
>><br>
>><br>
>> Logfile tells me:<br>
>><br>
>> <2009-09-18T10:40:23>
3508<br>
>>
127.0.0.1
Administrator<br>
>><br>
>> Error: An exception occurred in FDO component.<br>
>><br>
>> Unable to load the FDO
Provider: (null)<br>
>><br>
>> StackTrace:<br>
>><br>
>> - MgFeatureServiceHandler.ProcessOperation line 83 file<br>
>>
c:\osgeo\mapguide_21\mgdev\server\src\services\feature\FeatureServiceHandler.cpp<br>
>><br>
>> - MgOpTestFeatureSourceConnection.Execute line 100 file<br>
>> c:\osgeo\mapguide_21\mgdev\server\src\services\feature\OpTestFeatureSourceConnection.cpp<br>
>><br>
>> - MgFdoConnectionManager.Open line 262 file<br>
>>
c:\osgeo\mapguide_21\mgdev\server\src\common\manager\FdoConnectionManager.cpp<br>
>><br>
>><br>
>><br>
>> Maestro gives the following error:<br>
>><br>
>> De externe server heeft een fout geretourneerd: (559) MgFdoException.:<br>
>><br>
>> An exception occurred in FDO component.<br>
>><br>
>> Unable to load the FDO Provider: (null)<br>
>><br>
>><br>
>><br>
>> Since installing/registering libpq.dll worked yesterday, I've redone
that<br>
>> step... but no cigar... I'm trying to learn GIS for some months now,
but the<br>
>> assumingly last obstacles are very hard to pass....<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> Met vriendelijk groet,<br>
>><br>
>><br>
>> Remco Houtkamp<br>
>><br>
>> BURO HOUTKAMP<br>
>> |T: 06 14 390 205 |E: <a href="mailto:r.houtkamp@burohoutkamp.nl">r.houtkamp@burohoutkamp.nl</a> |P:
Kweldergras 21, 1441<br>
>> WP, Purmerend |<br>
>><br>
>><br>
>><br>
>> Van: <a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a><br>
>> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>]
Namens Kenneth Skovhede,<br>
>> GEOGRAF A/S<br>
>> Verzonden: donderdag 17 september 2009 14:22<br>
>> Aan: MapGuide Users Mail List<br>
>> Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro
postgis<br>
>><br>
>><br>
>><br>
>> ieshims.dll and ieframe.dll can be ignored.<br>
>> There should be no harm in copying the files, but it's not required.<br>
>><br>
>> Now that you get that error, it is likely that the error.log contains
extra<br>
>> information:<br>
>> 2.0.2: C:\Program Files\MapGuideOpenSource\Server\Logs\Error.log<br>
>> 2.1: C:\Program Files\OSGeo\MapGuide\Server\Logs\Error.log<br>
>><br>
>> The MgConnectionFailedException usually means that the MapGuide
service has<br>
>> stopped.<br>
>><br>
>> Regards,. Kenneth Skovhede, GEOGRAF A/S<br>
>><br>
>> Remco Houtkamp skrev:<br>
>><br>
>> Been strugling along. Depend.exe told libpq.dll could not be opened. I<br>
>> googled for it, followed instructions and installed it. Now when I
press<br>
>> test connections, it will not give me errors...seems like progress!<br>
>><br>
>><br>
>><br>
>> I saved the data connection and tried to connect a layer. Maestro
tells me:<br>
>><br>
>> Failed to read schema from data source.<br>
>><br>
>> The operation gave the error message: De externe server heeft een fout<br>
>> geretourneerd (Dutch for the external server returned an error): (559)<br>
>> MgConnectionFailedException.: Cannot establish connection.<br>
>><br>
>><br>
>><br>
>> Depend.exe also says it cannot open ieshims.dll so I just copied it
(is that<br>
>> ok) to the FDO folder.<br>
>><br>
>> Now it only says Warning: At least one module has an unresolved import
due<br>
>> to a missing export function in a delay-load dependent module.<br>
>><br>
>> It also shows a hourglass and some kind of red grid on an icon for the
file<br>
>> ieframe.dll<br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> -----Oorspronkelijk bericht-----<br>
>><br>
>> Van: <a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a><br>
>> [mailto:<a href="mailto:mapguide-users-bounces@lists.osgeo.org">mapguide-users-bounces@lists.osgeo.org</a>]
Namens Zac Spitzer<br>
>><br>
>> Verzonden: woensdag 16 september 2009 16:08<br>
>><br>
>> Aan: MapGuide Users Mail List<br>
>><br>
>> Onderwerp: Re: [mapguide-users] trouble connecting mapguide maestro
postgis<br>
>><br>
>><br>
>><br>
>> try running depends.exe (google it) on the postgis fdo provider
dll<br>
>><br>
>><br>
>><br>
>> sounds like the required postgres dll's are being found<br>
>><br>
>><br>
>><br>
>> z<br>
>><br>
>><br>
>><br>
>> On Thu, Sep 17, 2009 at 12:04 AM, Remco Houtkamp<br>
>><br>
>> <<a href="mailto:r.houtkamp@burohoutkamp.nl">r.houtkamp@burohoutkamp.nl</a>>
wrote:<br>
>><br>
>><br>
>><br>
>> Hi all, this is my first post, still a newbie.<br>
>><br>
>><br>
>><br>
>> I think I managed to import data from <a
href="http://openstreetmap.org" target="_blank">openstreetmap.org</a> to
postgis. But now<br>
>><br>
>> I cannot connect. I guess things are working since I can connect from
a<br>
>><br>
>> program called Udig.<br>
>><br>
>><br>
>><br>
>> In mapguide maestro I go through the following steps:<br>
>><br>
>><br>
>><br>
>> Create a new resource>data connection<br>
>><br>
>><br>
>><br>
>> OSGEO FDO Provider for Postgis<br>
>><br>
>><br>
>><br>
>> Database: osm (is visible in Udig)<br>
>><br>
>><br>
>><br>
>> server: I tried localhost <a href="http://localhost/" target="_blank">http://localhost/</a>
127.0.0.1 http:// <a href="http://127.0.0.1/" target="_blank">127.0.0.1/</a><br>
>><br>
>><br>
>><br>
>> Port: 5432<br>
>><br>
>><br>
>><br>
>> Tried all three credentials but think it must be Specified Credentials
with<br>
>><br>
>> user postgres and my secret password ;)<br>
>><br>
>><br>
>><br>
>> Press test connection and then the following error appears:<br>
>><br>
>><br>
>><br>
>> De externe server heeft een fout geretourneerd: (559) MgFdoException.:
An<br>
>><br>
>> exception occurred in FDO component. Unable to load the FDO Provider:
Kan<br>
>><br>
>> opgegeven module niet vinden. (some of this is Dutch...)<br>
>><br>
>><br>
>><br>
>> My setup contains postgresql 8.4 and postgis 1.4.<br>
>><br>
>><br>
>><br>
>> Can anybody tell me where I'm going wrong... struggling for days and
days...<br>
>> and<br>
>><br>
>> days...<br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>><br>
>> mapguide-users mailing list<br>
>><br>
>> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
>><br>
>> <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>><br>
>> _______________________________________________<br>
>> mapguide-users mailing list<br>
>> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
>> <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
>><br>
>><br>
><br>
><br>
><br>
> --<br>
> Zac Spitzer -<br>
> <a href="http://zacster.blogspot.com" target="_blank">http://zacster.blogspot.com</a><br>
> +61 405 847 168<br>
> _______________________________________________<br>
> mapguide-users mailing list<br>
> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
> _______________________________________________<br>
> mapguide-users mailing list<br>
> <a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
><br>
<br>
<br>
<br>
--<br>
Zac Spitzer -<br>
<a href="http://zacster.blogspot.com" target="_blank">http://zacster.blogspot.com</a><br>
+61 405 847 168<br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><o:p></o:p></p>
</div>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</div>
</div>
</body>
</html>