Re: [mapguide-users] Fdo Provider PostGreSql 12
Thank you Jackie I decided to adventure with MG 4.00 and Ubuntu 16.04 x64 Everything is working fine now. Cheers From: mapguide-users on behalf of Jackie Ng Sent: May 19, 2021 06:01 To: mapguide-users@lists.osgeo.org Subject: Re: [mapguide-users] Fdo Provider PostGreSql 12 The adsrc column was removed in PostgreSQL 12 and so queries that list tables and views broke. This issue (https://trac.osgeo.org/fdo/ticket/973) is actually fixed a long time ago in FDO 4.1 and a patched PostgreSQL provider dll is available for MGOS 3.1.2, but only for Windows. For Linux, you will have to compile the PostgreSQL provider from source yourself on the latest FDO 4.1 branch. - Jackie You wrote: Hello there I have MapGUIDE 3.1.2 on Centos 6 x64 Everything seems to work properly, except connecting a layer to Postgresql 12 How do I set up FDO 4.1 properly ? RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... -- Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
The adsrc column was removed in PostgreSQL 12 and so queries that list tables and views broke. This issue (https://trac.osgeo.org/fdo/ticket/973) is actually fixed a long time ago in FDO 4.1 and a patched PostgreSQL provider dll is available for MGOS 3.1.2, but only for Windows. For Linux, you will have to compile the PostgreSQL provider from source yourself on the latest FDO 4.1 branch. - Jackie You wrote: Hello there I have MapGUIDE 3.1.2 on *Centos 6 x64* Everything seems to work properly, except connecting a layer to Postgresql 12 How do I set up FDO 4.1 properly ? *RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist* *LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as...* -- *Please Note: I no longer create new posts or post replies to any OSGeo mailing list through nabble. As a result, you most likely won't see this message appear on nabble's view of any OSGeo mailing list and may only see this message through mailing list archives or depending on your mailing list subscription settings, through daily message digests or automated notifications from the mailing lists.* ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
Maybe the word "TYPE" is a reserved word. On Tue, May 18, 2021 at 12:18 AM Diego Ordonez wrote: > Hi Gordon > > No I'm trying to read a table, and permissions are OK because I use the > postgres user > > MapGuide Server is Centos 6 x64 > > System.Exception: The remote server returned an error: (559) > MgFdoException.: > An exception occurred in FDO component. > Error occurred in Feature Source > (Library://Ejemplo_Neiva/Data/postgres@200.116.160.53_10654 (12 > Test).FeatureSource): RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc > does not exist > LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... > ^ > (Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist > LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... > ^ > , Root Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not > exist > LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... > ^ > ) > > - MgFeatureServiceHandler.ProcessOperation() line 83 file > FeatureServiceHandler.cpp > - MgOpDescribeSchemaAsXml.Execute() line 110 file OpDescribeSchemaAsXml.cpp > - MgServerFeatureService.DescribeSchemaAsXml() line 381 file > ServerFeatureService.cpp > - MgServerDescribeSchema.DescribeSchemaAsXml() line 647 file > ServerDescribeSchema.cpp > - MgServerDescribeSchema.DescribeSchema() line 583 file > ServerDescribeSchema.cpp > - MgServerDescribeSchema.DescribeFdoSchema() line 217 file > ServerDescribeSchema.cpp > > ---> System.Net.WebException: The remote server returned an error: (559) > MgFdoException. >at System.Net.HttpWebRequest.GetResponse() >at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.OpenRead(String req) > in > C:\projects\mapguide-maestro\OSGeo.MapGuide.MaestroAPI\Http\HttpServerConnection.cs:line > 1405 > > > > -------------- > *From:* mapguide-users on behalf > of Gordon Luckett > *Sent:* May 17, 2021 16:36 > *To:* MapGuide Users Mail List > *Subject:* Re: [mapguide-users] Fdo Provider PostGreSql 12 > > Are you trying to look at a view? > It looks like one of the tables on the view is not accessable to the login > user.. > > On Mon, May 17, 2021, 9:14 PM Diego Ordonez > wrote: > > Hello there > > I have MapGUIDE 3.1.2 on *Centos 6 x64* > > Everything seems to work properly, except connecting a layer to Postgresql > 12 > > How do I set up FDO 4.1 properly ? > > > *RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist* > *LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc > as...* > > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users > > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users > -- *יזהר עזתי* טרומפלדור 5 קרית אונו 5529505 iz...@azati.co.il +972502066983 http://www.azati.co.il ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
Hi Gordon No I'm trying to read a table, and permissions are OK because I use the postgres user MapGuide Server is Centos 6 x64 System.Exception: The remote server returned an error: (559) MgFdoException.: An exception occurred in FDO component. Error occurred in Feature Source (Library://Ejemplo_Neiva/Data/postgres@200.116.160.53_10654 (12 Test).FeatureSource): RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... ^ (Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... ^ , Root Cause: RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... ^ ) - MgFeatureServiceHandler.ProcessOperation() line 83 file FeatureServiceHandler.cpp - MgOpDescribeSchemaAsXml.Execute() line 110 file OpDescribeSchemaAsXml.cpp - MgServerFeatureService.DescribeSchemaAsXml() line 381 file ServerFeatureService.cpp - MgServerDescribeSchema.DescribeSchemaAsXml() line 647 file ServerDescribeSchema.cpp - MgServerDescribeSchema.DescribeSchema() line 583 file ServerDescribeSchema.cpp - MgServerDescribeSchema.DescribeFdoSchema() line 217 file ServerDescribeSchema.cpp ---> System.Net.WebException: The remote server returned an error: (559) MgFdoException. at System.Net.HttpWebRequest.GetResponse() at OSGeo.MapGuide.MaestroAPI.HttpServerConnection.OpenRead(String req) in C:\projects\mapguide-maestro\OSGeo.MapGuide.MaestroAPI\Http\HttpServerConnection.cs:line 1405 From: mapguide-users on behalf of Gordon Luckett Sent: May 17, 2021 16:36 To: MapGuide Users Mail List Subject: Re: [mapguide-users] Fdo Provider PostGreSql 12 Are you trying to look at a view? It looks like one of the tables on the view is not accessable to the login user.. On Mon, May 17, 2021, 9:14 PM Diego Ordonez mailto:diordon...@hotmail.com>> wrote: Hello there I have MapGUIDE 3.1.2 on Centos 6 x64 Everything seems to work properly, except connecting a layer to Postgresql 12 How do I set up FDO 4.1 properly ? RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc as... ___ mapguide-users mailing list mapguide-users@lists.osgeo.org<mailto:mapguide-users@lists.osgeo.org> https://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
Are you trying to look at a view? It looks like one of the tables on the view is not accessable to the login user.. On Mon, May 17, 2021, 9:14 PM Diego Ordonez wrote: > Hello there > > I have MapGUIDE 3.1.2 on *Centos 6 x64* > > Everything seems to work properly, except connecting a layer to Postgresql > 12 > > How do I set up FDO 4.1 properly ? > > > *RDBMS: [PGRES_FATAL_ERROR] ERROR: column d.adsrc does not exist* > *LINE 1: ...name AS table_name, c.attname AS name, 1 AS type, d.adsrc > as...* > > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users > ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
Thanks a lot Jackie. It works smoothly with Postgresql 12 x64 in Windows 10. -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
Brilliant! Thank you Jackie. Have a nice day, Jérôme. Le lun. 10 févr. 2020 à 11:58, Jackie Ng a écrit : > I've uploaded a patched FDO provider for FDO 4.1/MGOS 3.1.2 64-bit: > > > http://download.osgeo.org/mapguide/patches/PostGIS_MGOS312_x64/PostgreSQLProvider_MGOS312_x64_r7963.zip > > - Jackie > > > > -- > Sent from: > http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > https://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
I've uploaded a patched FDO provider for FDO 4.1/MGOS 3.1.2 64-bit: http://download.osgeo.org/mapguide/patches/PostGIS_MGOS312_x64/PostgreSQLProvider_MGOS312_x64_r7963.zip - Jackie -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Fdo Provider PostGreSql 12
I recently verified the PostgreSQL provider can works under PostgreSQL 12.0: https://trac.osgeo.org/fdo/ticket/973 If I have spare time this weekend, I can try to build and upload a patched provider dll (for MGOS 3.1.2). Or if you're capable of building from source, just build from svn HEAD of the FDO 4.1 branch, which has the fix. If you need this for older FDO versions, you'll have to backport this changeset yourself: https://trac.osgeo.org/fdo/changeset/7962 - Jackie -- Sent from: http://osgeo-org.1560.x6.nabble.com/MapGuide-Users-f4182607.html ___ mapguide-users mailing list mapguide-users@lists.osgeo.org https://lists.osgeo.org/mailman/listinfo/mapguide-users
