Try it with just the DataSource and ReadOnly properties. It will pick up the
user name and password from the DataSource string, so you should not specify
separate username and password connection properties. Also try running the
mapguide server from the command line using the /interactive flag. It may print
out useful information when opening OGR connections.
Traian
________________________________
From: [EMAIL PROTECTED] [EMAIL PROTECTED] On Behalf Of schwanzy [EMAIL
PROTECTED]
Sent: Friday, January 11, 2008 10:42 AM
To: MapGuide Users Mail List
Subject: [mapguide-users] MG1.2.0: OGRProvider connection to PostgreSQL
Hello,
how do I connect MapGuide OS 1.2.0 to PostgreSQL 8.1?
I downloaded http://download.osgeo.org/fdo/3.2.2/OGRProvider-3.2.2.win32.zip,
extracted to FDOs directory, then added:
<FeatureProvider>
<Name>OSGeo.OGR.0.1</Name>
<DisplayName>OSGeo FDO Provider for OGR </DisplayName>
<Description>Access to OGR data sources. </Description>
<IsManaged>False</IsManaged>
<Version>3.2.2.0</Version>
<FeatureDataObjectsVersion>3.2.2.0</FeatureDataObjectsVersion>
<LibraryPath>C:\Programmi\MapGuideOpenSource\Server\Bin\FDO\OGRProvider.dll</LibraryPath>
</FeatureProvider>
to providers.xml and restarted MGOS.
In MapGuide Studio 2008:
[connection properties]
DataSource PG: host=10.1.1.150 dbname=myDB user=myUser
password=myPassword
ReadOnly FALSE
username: myUser
password: myPassword
"Verify connection" is ok, but when I try to see a preview it complains:
Invalid argument(s): [1] = "0" The value is invalid because it is too
large.
and there is no log in /var/log/postgresql/postgresql-8.1-main.log.
If I set:
[connection properties]
DataSource PG: host=10.1.1.150 dbname=myDB
ReadOnly FALSE
username: myUser
password: myPassword
"Verify connection" complains:
An exception occurred in FDO component. Connect failed: PQconnectdb failed.
FATAL role "SYSTEM" does not exist
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.
Any idea?
Regards
_______________________________________________
mapguide-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/mapguide-users
