RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
Dear Carlos, Never thought that it will be such easy. Thanks a ton! It worked :) Regards, Ritesh Ambastha Carlos Ruiz-5 wrote: Ritesh, There's a way to stablish the default schema to a postgres user when it connects, maybe this can help you to pull the data from postgres. To check what's the current default user's schema, you need to execute this: SHOW search_path It must throw $user, public So, to set the default user's schema, you execute this: ALTER USER user_name SET search_path TO schema_name I suggest you to create a new role to connect to the database via map file, and then change its default schema. Another thing (maybe this was the first step) is to check if the user postgres is the owner of the schema, and if it's not, then check if it haves the USAGE privilege on it. Hope this information helps IC Carlos Ruiz --- On Wed, 7/16/08, Ritesh Ambastha [EMAIL PROTECTED] wrote: From: Ritesh Ambastha [EMAIL PROTECTED] Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema To: mapserver-users@lists.osgeo.org Date: Wednesday, July 16, 2008, 4:37 AM Hey Venkat, Thanks for the details. I understand the standard way to write a connection parameter. I am sure that this table rgp_gis_gmm_100_metros is stored in public schema of your database. My question is, what will you write if you keep this table in some other schema? Regards, Venkatrao wrote: Hi, Here is my Example .I think it helps you. Layer # Layer starts here Name GMM 100 #name of the layer ConnectionType POSTGIS #connection type Connection host=192.168.1.158 dbname=GIS password=administrator user=postgres port=5432 #connection type. Data the_geom from rgp_gis_gmm_100_metros #table name Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 2:44 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hello Readers, I am facing a problem in defining the DATA path in mapserver while using PostGIS. I have two schemas, lets say 'a' and 'b' in a database 'd' Now, I want to access tables of schema 'a' in the mapserver layer. I define DATA path like this: DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 Please pour in your thoughts for defining schema in the connection/data parameters. Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483547.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483876.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18505303.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
Hello Readers, I am facing a problem in defining the DATA path in mapserver while using PostGIS. I have two schemas, lets say 'a' and 'b' in a database 'd' Now, I want to access tables of schema 'a' in the mapserver layer. I define DATA path like this: DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 Please pour in your thoughts for defining schema in the connection/data parameters. Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483547.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
Hi, Here is my Example .I think it helps you. Layer # Layer starts here Name GMM 100 #name of the layer ConnectionType POSTGIS #connection type Connection host=192.168.1.158 dbname=GIS password=administrator user=postgres port=5432 #connection type. Data the_geom from rgp_gis_gmm_100_metros #table name Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 2:44 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hello Readers, I am facing a problem in defining the DATA path in mapserver while using PostGIS. I have two schemas, lets say 'a' and 'b' in a database 'd' Now, I want to access tables of schema 'a' in the mapserver layer. I define DATA path like this: DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 Please pour in your thoughts for defining schema in the connection/data parameters. Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483547.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
Hey Venkat, Thanks for the details. I understand the standard way to write a connection parameter. I am sure that this table rgp_gis_gmm_100_metros is stored in public schema of your database. My question is, what will you write if you keep this table in some other schema? Regards, Venkatrao wrote: Hi, Here is my Example .I think it helps you. Layer # Layer starts here Name GMM 100 #name of the layer ConnectionType POSTGIS #connection type Connection host=192.168.1.158 dbname=GIS password=administrator user=postgres port=5432 #connection type. Data the_geom from rgp_gis_gmm_100_metros #table name Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 2:44 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hello Readers, I am facing a problem in defining the DATA path in mapserver while using PostGIS. I have two schemas, lets say 'a' and 'b' in a database 'd' Now, I want to access tables of schema 'a' in the mapserver layer. I define DATA path like this: DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 Please pour in your thoughts for defining schema in the connection/data parameters. Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483547.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483876.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
Hi, Have you checked other schema? See you can use either public or pg_temp_1 right ? if you want to use pg_temp_1 schema u need to have some setting while configuring at add new server connection. This is only as per knowledge. I did not tested. And my suggestion is Use Pulic.Because ,if there any joining among the table ,that would be again problem. If I am not right ,let me know. Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 3:07 PM To: mapserver-users@lists.osgeo.org Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hey Venkat, Thanks for the details. I understand the standard way to write a connection parameter. I am sure that this table rgp_gis_gmm_100_metros is stored in public schema of your database. My question is, what will you write if you keep this table in some other schema? Regards, Venkatrao wrote: Hi, Here is my Example .I think it helps you. Layer # Layer starts here Name GMM 100 #name of the layer ConnectionType POSTGIS #connection type Connection host=192.168.1.158 dbname=GIS password=administrator user=postgres port=5432 #connection type. Data the_geom from rgp_gis_gmm_100_metros #table name Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 2:44 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hello Readers, I am facing a problem in defining the DATA path in mapserver while using PostGIS. I have two schemas, lets say 'a' and 'b' in a database 'd' Now, I want to access tables of schema 'a' in the mapserver layer. I define DATA path like this: DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 Please pour in your thoughts for defining schema in the connection/data parameters. Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483547.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483876.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
Venkat, I am looking for that some setting :) Cheers, Ritesh On Wed, Jul 16, 2008 at 3:23 PM, Venkat Rao Tammineni [EMAIL PROTECTED] wrote: Hi, Have you checked other schema? See you can use either public or pg_temp_1 right ? if you want to use pg_temp_1 schema u need to have some setting while configuring at add new server connection. This is only as per knowledge. I did not tested. And my suggestion is Use Pulic.Because ,if there any joining among the table ,that would be again problem. If I am not right ,let me know. Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 3:07 PM To: mapserver-users@lists.osgeo.org Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hey Venkat, Thanks for the details. I understand the standard way to write a connection parameter. I am sure that this table rgp_gis_gmm_100_metros is stored in public schema of your database. My question is, what will you write if you keep this table in some other schema? Regards, Venkatrao wrote: Hi, Here is my Example .I think it helps you. Layer # Layer starts here Name GMM 100 #name of the layer ConnectionType POSTGIS #connection type Connection host=192.168.1.158 dbname=GIS password=administrator user=postgres port=5432 #connection type. Data the_geom from rgp_gis_gmm_100_metros #table name Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 2:44 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hello Readers, I am facing a problem in defining the DATA path in mapserver while using PostGIS. I have two schemas, lets say 'a' and 'b' in a database 'd' Now, I want to access tables of schema 'a' in the mapserver layer. I define DATA path like this: DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 Please pour in your thoughts for defining schema in the connection/data parameters. Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483547.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483876.htmlhttp://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483876.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema
Ritesh, There's a way to stablish the default schema to a postgres user when it connects, maybe this can help you to pull the data from postgres. To check what's the current default user's schema, you need to execute this: SHOW search_path It must throw $user, public So, to set the default user's schema, you execute this: ALTER USER user_name SET search_path TO schema_name I suggest you to create a new role to connect to the database via map file, and then change its default schema. Another thing (maybe this was the first step) is to check if the user postgres is the owner of the schema, and if it's not, then check if it haves the USAGE privilege on it. Hope this information helps IC Carlos Ruiz --- On Wed, 7/16/08, Ritesh Ambastha [EMAIL PROTECTED] wrote: From: Ritesh Ambastha [EMAIL PROTECTED] Subject: RE: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema To: mapserver-users@lists.osgeo.org Date: Wednesday, July 16, 2008, 4:37 AM Hey Venkat, Thanks for the details. I understand the standard way to write a connection parameter. I am sure that this table rgp_gis_gmm_100_metros is stored in public schema of your database. My question is, what will you write if you keep this table in some other schema? Regards, Venkatrao wrote: Hi, Here is my Example .I think it helps you. Layer # Layer starts here Name GMM 100 #name of the layer ConnectionType POSTGIS #connection type Connection host=192.168.1.158 dbname=GIS password=administrator user=postgres port=5432 #connection type. Data the_geom from rgp_gis_gmm_100_metros #table name Thanks and Regards Venkat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ritesh Ambastha Sent: Wednesday, July 16, 2008 2:44 PM To: mapserver-users@lists.osgeo.org Subject: [MAPSERVER-USERS] Connection parameter errors while using Postgres DB Schema Hello Readers, I am facing a problem in defining the DATA path in mapserver while using PostGIS. I have two schemas, lets say 'a' and 'b' in a database 'd' Now, I want to access tables of schema 'a' in the mapserver layer. I define DATA path like this: DATA the_geom FROM a.table_name USING UNIQUE id SRID -1 Please pour in your thoughts for defining schema in the connection/data parameters. Thanks, Ritesh Ambastha -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Sc hema-tp18483547p18483547.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users -- View this message in context: http://www.nabble.com/Connection-parameter-errors-while-using-Postgres-DB-Schema-tp18483547p18483876.html Sent from the Mapserver - User mailing list archive at Nabble.com. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
