<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000066">
Hello,<br>
how do I connect MapGuide OS 1.2.0 to PostgreSQL 8.1?<br>
<br>
I downloaded
<a class="moz-txt-link-freetext" href="http://download.osgeo.org/fdo/3.2.2/OGRProvider-3.2.2.win32.zip">http://download.osgeo.org/fdo/3.2.2/OGRProvider-3.2.2.win32.zip</a>,
extracted to FDOs directory, then added:<br>
<br>
<FeatureProvider><br>
<Name>OSGeo.OGR.0.1</Name><br>
<DisplayName>OSGeo FDO Provider for OGR </DisplayName><br>
<Description>Access to OGR data sources. </Description><br>
<IsManaged>False</IsManaged><br>
<Version>3.2.2.0</Version><br>
<FeatureDataObjectsVersion>3.2.2.0</FeatureDataObjectsVersion><br>
<LibraryPath>C:\Programmi\MapGuideOpenSource\Server\Bin\FDO\OGRProvider.dll</LibraryPath><br>
</FeatureProvider><br>
<br>
to providers.xml and restarted MGOS.<br>
<br>
In MapGuide Studio 2008:<br>
<br>
[connection properties]<br>
DataSource PG: host=10.1.1.150 dbname=myDB
user=myUser password=myPassword<br>
ReadOnly FALSE<br>
username: myUser<br>
password: myPassword<br>
<br>
"Verify connection" is ok, but when I try to see a preview it complains:<br>
<br>
Invalid argument(s): [1] = "0" The value is invalid because it
is too large.<br>
<br>
and there is no log in /var/log/postgresql/postgresql-8.1-main.log.<br>
<br>
If I set:<br>
<br>
[connection properties]<br>
DataSource PG: host=10.1.1.150 dbname=myDB<br>
ReadOnly FALSE<br>
username: myUser<br>
password: myPassword<br>
<br>
"Verify connection" complains:<br>
<br>
An exception occurred in FDO component. Connect failed: PQconnectdb
failed. FATAL role "SYSTEM" does not exist<br>
<br>
and in /var/log/postgresql/postgresql-8.1-main.log I see that MG tried
tto connect as SYSTEM and not as the specified user.<br>
<br>
Any idea?<br>
<br>
Regards<br>
</body>
</html>