[mapserver-users] Problem with queryByAttributes (C#-MapScript)
Hi to all of you.
I'm building a WebService based on MapServer using MapScript for C#.
While implementing a search function I ran into problems using the
queryByAttributes-function on the layerObj. The problem might be the
wrong syntax for the regular expressions. But it might be something
else.
I assume that both calls should return the same set of
features/shapes/object from the layer:
layer.queryByAttributes(Map, null, ('[StrName]' = 'Kropsburgweg'),
MS_QUERY_MULTIPLE);
and
layer.queryByAttributes(Map, null, ('[StrName]' =~ /Kropsburgweg/),
MS_QUERY_MULTIPLE);
But while the first call returns about 37 features the second call
doesn't return any features. Any idea what I#m doing wrong?!
Thanks in advance,
Daniel
___
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Remote PostGIS server connection problem
Hi, I am running 6.0.1 on a FreeBSD host. Everything works perfect when I connect to the local PostGIS server (located on the same machine as the Mapserver is running on). When I try to connect to the PostGIS server that is not in the same network, I get the following error: msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_NAME'. msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host IP and accepting TCP/IP connections on port 5432? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? 1. I can connect to the server IP on port 5432 via paql from console from the machine where Mapserver is running. 2. When doing tcpdump dst 5432 on the PostGIS server that is outside, I see no traffic comming in so basically when the error is displayed it is not due to remote server settings. I was browsing on the web and found out that people that were using SELinux had to enable the option httpd_can_network_connect. It seems like the Apache is not allowed to initiate a remote connection to a non-local IP address. Is it the Apache limitation? Is it the OS limitation or is it the Mapserver limitation (I am pretty sure that it isn't, but I don't know where to look anymore ...) After pulling my hair for several hours any help or idea would be very welcome :-) TIA, Matej ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Remote PostGIS server connection problem
On 12-08-23 10:02 AM, Matej Mailing wrote: Hi, I am running 6.0.1 on a FreeBSD host. Everything works perfect when I connect to the local PostGIS server (located on the same machine as the Mapserver is running on). When I try to connect to the PostGIS server that is not in the same network, I get the following error: msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_NAME'. msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host IP and accepting TCP/IP connections on port 5432? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? 1. I can connect to the server IP on port 5432 via paql from console from the machine where Mapserver is running. 2. When doing tcpdump dst 5432 on the PostGIS server that is outside, I see no traffic comming in so basically when the error is displayed it is not due to remote server settings. I was browsing on the web and found out that people that were using SELinux had to enable the option httpd_can_network_connect. It seems like the Apache is not allowed to initiate a remote connection to a non-local IP address. Is it the Apache limitation? Is it the OS limitation or is it the Mapserver limitation (I am pretty sure that it isn't, but I don't know where to look anymore ...) After pulling my hair for several hours any help or idea would be very welcome :-) You can test without Apache by using the MapServer commandline utility shp2img (http://mapserver.org/utilities/shp2img.html). Use the -all_debug 5 switch to see more info. (that's my favorite debugging tool) Next I would check the settings in the remote Postgres data folder's pg_hba.conf file. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Remote PostGIS server connection problem
Hi Matej, Are specifying a user name in your connection? If not then psql uses you user as the use name, but the apache uses whatever name is associated with the apache user. Do you get an error if you run shp2img or if you run: /path/to/mapserv QUERY_STRING='your mapserver request arguments' -Steve On 8/23/2012 9:02 AM, Matej Mailing wrote: Hi, I am running 6.0.1 on a FreeBSD host. Everything works perfect when I connect to the local PostGIS server (located on the same machine as the Mapserver is running on). When I try to connect to the PostGIS server that is not in the same network, I get the following error: msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_NAME'. msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host IP and accepting TCP/IP connections on port 5432? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? 1. I can connect to the server IP on port 5432 via paql from console from the machine where Mapserver is running. 2. When doing tcpdump dst 5432 on the PostGIS server that is outside, I see no traffic comming in so basically when the error is displayed it is not due to remote server settings. I was browsing on the web and found out that people that were using SELinux had to enable the option httpd_can_network_connect. It seems like the Apache is not allowed to initiate a remote connection to a non-local IP address. Is it the Apache limitation? Is it the OS limitation or is it the Mapserver limitation (I am pretty sure that it isn't, but I don't know where to look anymore ...) After pulling my hair for several hours any help or idea would be very welcome :-) TIA, Matej ___ 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
[mapserver-users] label offset bug
Hello, I have a layer with label (and offset on this lable). Some labels don't displayed correctly, ie offset value seems not used: see http://imageshack.us/f/163/mapserverstyleoffsetbug.png/ My label config looks like this: LABEL TYPE TRUETYPE FONT arial SIZE 7 COLOR 0 150 150 OUTLINECOLOR 255 255 255 OUTLINEWIDTH 2 ANTIALIAS TRUE ANGLE follow POSITION cc OFFSET 0 7 END Does follow ANGLE value change someting with the OFFSET value? Thanks, Y. -- Responsable Formation et Support Camptocamp France SAS Savoie Technolac, BP 352 73377 Le Bourget du Lac, Cedex Tel (France) : +33 4 79 26 57 98 Mob. : +33 6 18 75 42 21 Fax : 04 79 70 15 81 Mail : yves.jaco...@camptocamp.com http://www.camptocamp.com ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] error when installing MapServer 6.0.3
I have compiled the MapServer 6.0.3 successfully. But when I run it, I got the following error: ./mapserv: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by /var/scratch/pzhao1/gdal-1.9.1/lib/libgdal.so.1) ./mapserv: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by /var/scratch/pzhao1/libdap-3.11.1/lib/libdapserver.so.7) ./mapserv: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by /var/scratch/pzhao1/libdap-3.11.1/lib/libdapclient.so.3) ./mapserv: /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.9' not found (required by /var/scratch/pzhao1/libdap-3.11.1/lib/libdap.so.11) Any suggestion and solution? Thanks. ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] Different image for each point
Hello folks, We need to be able to display a different small image from each point in a data set, say along the lines of a thumbnail. From what I can see this could be done my defining each image as a symbol and then referencing that. However what we would like to be able to do is get the image file name as part of the query and display the image based on that. Is this possible? Thanks Ian ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Different image for each point
On 8/23/2012 1:31 PM, Ian Walberg wrote: Hello folks, We need to be able to display a different small image from each point in a data set, say along the lines of a thumbnail. From what I can see this could be done my defining each image as a symbol and then referencing that. However what we would like to be able to do is get the image file name as part of the query and display the image based on that. Is this possible? I have done this by creating a column with the filename in it. You can then use the column as a symbol name or symbol path or as attribute column in wfs to OpenLayers that can then be used to point to a thumbnail directory of fullsize directory of images. LAYER NAME images TYPE POINT DATA myImagePoints CLASS STYLE SYMBOL (/path/to/thumbs/+'[FILENAME]') END END END Where column FILENAME has something like 'myimage.png' and to do this you are probably limited to gif, jpg, and png images only. svg will NOT work. -Steve W ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Different image for each point
I was just replying along the same lines... :) On Thu, Aug 23, 2012 at 8:21 PM, Stephen Woodbridge wood...@swoodbridge.com wrote: On 8/23/2012 1:31 PM, Ian Walberg wrote: Hello folks, We need to be able to display a different small image from each point in a data set, say along the lines of a thumbnail. From what I can see this could be done my defining each image as a symbol and then referencing that. However what we would like to be able to do is get the image file name as part of the query and display the image based on that. Is this possible? I have done this by creating a column with the filename in it. You can then use the column as a symbol name or symbol path or as attribute column in wfs to OpenLayers that can then be used to point to a thumbnail directory of fullsize directory of images. LAYER NAME images TYPE POINT DATA myImagePoints CLASS STYLE SYMBOL (/path/to/thumbs/+'[FILENAME]') END END END Where column FILENAME has something like 'myimage.png' and to do this you are probably limited to gif, jpg, and png images only. svg will NOT work. gif and png are the only options. jpeg is not. -- thomas -Steve W ___ 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] Different image for each point
Stephen, This looks perfect, I need to look closer but I had thought the symbols needed to be defined separately. Regards Ian -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Stephen Woodbridge Sent: Thursday, August 23, 2012 11:21 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Different image for each point On 8/23/2012 1:31 PM, Ian Walberg wrote: Hello folks, We need to be able to display a different small image from each point in a data set, say along the lines of a thumbnail. From what I can see this could be done my defining each image as a symbol and then referencing that. However what we would like to be able to do is get the image file name as part of the query and display the image based on that. Is this possible? I have done this by creating a column with the filename in it. You can then use the column as a symbol name or symbol path or as attribute column in wfs to OpenLayers that can then be used to point to a thumbnail directory of fullsize directory of images. LAYER NAME images TYPE POINT DATA myImagePoints CLASS STYLE SYMBOL (/path/to/thumbs/+'[FILENAME]') END END END Where column FILENAME has something like 'myimage.png' and to do this you are probably limited to gif, jpg, and png images only. svg will NOT work. -Steve W ___ 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
[mapserver-users] compiler failture with mapserver 6.2.0beta2 on debian wheezy
Hello Dev's I am trying to compile mapserver 6.2.0beta2 in my Debian wheezy (amd64) system. the configure statement looks like this: ./configure --with-wfsclient --with-wfs --with-wmsclient --without-tiff --with-jpeg=/usr --with-ogr=/usr/local/bin/gdal-config --with-freetype=/usr --with-png=/usr --with-proj=/usr --enable-debug --with-gd=/usr/local --with-gdal=/usr/local/bin/gdal-config --with-postgis=/usr/local/pgsql/bin/pg_config --with-curl-config=/usr/bin/curl-config --with-threads --with-httpd=/usr/local/apache2_ssl/bin/httpd --with-php=/usr/local/php5/bin/php-config --with-agg=/usr/local --with-geos=/usr/local/bin/geos-config --without-opengl --without-ftgl Unfortunately the make statement fails with libtool: link: cannot find the library `/usr/lib/libfreetype.la' or unhandled argument `/usr/lib/libfreetype.la' The corresponding make file entry looks fine to me. #Freetype support FT_ENABLE= -DUSE_FREETYPE FT_LIB= -L/usr/lib/x86_64-linux-gnu -lfreetype -lz FT_INC= -I/usr/include/freetype2 Not sure it still looks for the file in '/usr/lib'. If I am symlinking the file the error disappears ln -s /usr/lib/x86_64-linux-gnu/libfreetype.la /usr/lib/libfreetype.la followed by the next failure: libtool: link: cannot find the library `/usr/lib/libsqlite3.la' or unhandled argument `/usr/lib/libsqlite3.la' Seems to be a more generic problem. Do you have any hints how to solve this? Thank you very much Best regards Nicol ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Different image for each point
A lot of this code has been changed in 6.2, but I think the basics still work. I'm not sure if images are cached or not when using this method or if it matters in your case. I guess ideally if it were a fixed set of images then you want caching, but it they are all different then you probably want to turn caching off, but I do not think there are any controls for that. If you have the whole path to the image in the attribute then you do not need to use an expression to concatenate the path and name so it simplies to: SYMBOL '[FILENAME]' Also be aware that you should probably use a POINT layer and not ANNOTATION layers as the latter is deprecated in 6.2 so upgrading it will be easier. -Steve W On 8/23/2012 2:27 PM, Ian Walberg wrote: Stephen, This looks perfect, I need to look closer but I had thought the symbols needed to be defined separately. Regards Ian -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Stephen Woodbridge Sent: Thursday, August 23, 2012 11:21 AM To: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] Different image for each point On 8/23/2012 1:31 PM, Ian Walberg wrote: Hello folks, We need to be able to display a different small image from each point in a data set, say along the lines of a thumbnail. From what I can see this could be done my defining each image as a symbol and then referencing that. However what we would like to be able to do is get the image file name as part of the query and display the image based on that. Is this possible? I have done this by creating a column with the filename in it. You can then use the column as a symbol name or symbol path or as attribute column in wfs to OpenLayers that can then be used to point to a thumbnail directory of fullsize directory of images. LAYER NAME images TYPE POINT DATA myImagePoints CLASS STYLE SYMBOL (/path/to/thumbs/+'[FILENAME]') END END END Where column FILENAME has something like 'myimage.png' and to do this you are probably limited to gif, jpg, and png images only. svg will NOT work. -Steve W ___ 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] Remote PostGIS server connection problem
Hi, when I use shp2img -m mapfile.map -all_debug 5 from the server with the same map file that causes mentioned error in Mapserver, I can see in the log that the server connects successfully so it works as it should with shp2img - thanks for this tip, I will use it in the future to debug connection string issues with map files. However, it still doesn't work from Apache and Mapserver. With Mapserver the connection doesn't even come to the remote Postgres since I see nothing in tcpdump, but everything is OK in pg_hba.conf because I can connect from the server where Mapserver is running to the remote server with pgsql from console. Best regards, Matej 2012/8/23 Jeff McKenna jmcke...@gatewaygeomatics.com: On 12-08-23 10:02 AM, Matej Mailing wrote: Hi, I am running 6.0.1 on a FreeBSD host. Everything works perfect when I connect to the local PostGIS server (located on the same machine as the Mapserver is running on). When I try to connect to the PostGIS server that is not in the same network, I get the following error: msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_NAME'. msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host IP and accepting TCP/IP connections on port 5432? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? 1. I can connect to the server IP on port 5432 via paql from console from the machine where Mapserver is running. 2. When doing tcpdump dst 5432 on the PostGIS server that is outside, I see no traffic comming in so basically when the error is displayed it is not due to remote server settings. I was browsing on the web and found out that people that were using SELinux had to enable the option httpd_can_network_connect. It seems like the Apache is not allowed to initiate a remote connection to a non-local IP address. Is it the Apache limitation? Is it the OS limitation or is it the Mapserver limitation (I am pretty sure that it isn't, but I don't know where to look anymore ...) After pulling my hair for several hours any help or idea would be very welcome :-) You can test without Apache by using the MapServer commandline utility shp2img (http://mapserver.org/utilities/shp2img.html). Use the -all_debug 5 switch to see more info. (that's my favorite debugging tool) Next I would check the settings in the remote Postgres data folder's pg_hba.conf file. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.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] Remote PostGIS server connection problem
Hi, as with the shp2img, I get a successful result also with mapserv QUERY_STRING='..' so the connection can be established (and it also works from one server to another via pgsql from console as mentioned in the previous mail). What could prevent Apache to allow the connection? I am little bit lost here also because of the fact that people on SELinux had an option to enable, but what can we do on FreeBSD? Still I don't know if it's OS or Apache's fault ... Thanks. Matej 2012/8/23 Stephen Woodbridge wood...@swoodbridge.com: Hi Matej, Are specifying a user name in your connection? If not then psql uses you user as the use name, but the apache uses whatever name is associated with the apache user. Do you get an error if you run shp2img or if you run: /path/to/mapserv QUERY_STRING='your mapserver request arguments' -Steve On 8/23/2012 9:02 AM, Matej Mailing wrote: Hi, I am running 6.0.1 on a FreeBSD host. Everything works perfect when I connect to the local PostGIS server (located on the same machine as the Mapserver is running on). When I try to connect to the PostGIS server that is not in the same network, I get the following error: msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_NAME'. msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host IP and accepting TCP/IP connections on port 5432? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? 1. I can connect to the server IP on port 5432 via paql from console from the machine where Mapserver is running. 2. When doing tcpdump dst 5432 on the PostGIS server that is outside, I see no traffic comming in so basically when the error is displayed it is not due to remote server settings. I was browsing on the web and found out that people that were using SELinux had to enable the option httpd_can_network_connect. It seems like the Apache is not allowed to initiate a remote connection to a non-local IP address. Is it the Apache limitation? Is it the OS limitation or is it the Mapserver limitation (I am pretty sure that it isn't, but I don't know where to look anymore ...) After pulling my hair for several hours any help or idea would be very welcome :-) TIA, Matej ___ 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] [tinyOWS] libxml2 2.8.0 not released on debian
Hi, I'm trying to build tinyOWS on Debian, but the requirement for libxml2-2.8.0 is not released on stable (squeeze) and not in the backports either. It is in testing (wheezy) but mixing versions is a recipe for problems. It would be nice if you limited library versions to what is generally release on stable OSs. -Steve W ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Remote PostGIS server connection problem
The only difference between running from the commandline and running from apache is the user and possible the LD_LIBRARY_PATH that apache uses. su -l apache_user /path/to/cgi-bin/mapserv QUERY_STRING='...' exit And see if you get any useful messages. You might also look in the apache error log. I forget where FreeBSD puts things but something like: more /var/log/apache/error.log I don't think many people here run FreeBSD. I did 5+ years ago, but its been a while. -Steve On 8/23/2012 3:35 PM, Matej Mailing wrote: Hi, as with the shp2img, I get a successful result also with mapserv QUERY_STRING='..' so the connection can be established (and it also works from one server to another via pgsql from console as mentioned in the previous mail). What could prevent Apache to allow the connection? I am little bit lost here also because of the fact that people on SELinux had an option to enable, but what can we do on FreeBSD? Still I don't know if it's OS or Apache's fault ... Thanks. Matej 2012/8/23 Stephen Woodbridge wood...@swoodbridge.com: Hi Matej, Are specifying a user name in your connection? If not then psql uses you user as the use name, but the apache uses whatever name is associated with the apache user. Do you get an error if you run shp2img or if you run: /path/to/mapserv QUERY_STRING='your mapserver request arguments' -Steve On 8/23/2012 9:02 AM, Matej Mailing wrote: Hi, I am running 6.0.1 on a FreeBSD host. Everything works perfect when I connect to the local PostGIS server (located on the same machine as the Mapserver is running on). When I try to connect to the PostGIS server that is not in the same network, I get the following error: msDrawMap(): Image handling error. Failed to draw layer named 'LAYER_NAME'. msPostGISLayerOpen(): Query error. Database connection failed (could not connect to server: Permission denied Is the server running on host IP and accepting TCP/IP connections on port 5432? Is it allowing connections? Does the specified user exist? Is the password valid? Is the database on the standard port? 1. I can connect to the server IP on port 5432 via paql from console from the machine where Mapserver is running. 2. When doing tcpdump dst 5432 on the PostGIS server that is outside, I see no traffic comming in so basically when the error is displayed it is not due to remote server settings. I was browsing on the web and found out that people that were using SELinux had to enable the option httpd_can_network_connect. It seems like the Apache is not allowed to initiate a remote connection to a non-local IP address. Is it the Apache limitation? Is it the OS limitation or is it the Mapserver limitation (I am pretty sure that it isn't, but I don't know where to look anymore ...) After pulling my hair for several hours any help or idea would be very welcome :-) TIA, Matej ___ 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 ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] Remote PostGIS server connection problem
On 12-08-23 5:06 PM, Matej Mailing wrote: Found it out - it was a firewall rule allowing to initiate all the connections for the root user (as I was running both testing procedures sugggested by Jeff and Stephen and of course it worked) and not allowing outside 5432 connection to the particular remote server :-) Thanks for all the tips and ideas. Best regards, Matej That one will make you earn your pay indeed :) Cheers. -jeff -- Jeff McKenna MapServer Consulting and Training Services http://www.gatewaygeomatics.com/ ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
[mapserver-users] postgis-topology-how to use topogeom field
As I know the topogeom type is automatically casting to geometry type. So I have a table (telek) with a field of topogeom (topo_geom) in the postgresql db (tdc) I made a map file for the mapserver and the layer looks like this: LAYER NAME telek CONNECTIONTYPE postgis CONNECTION host=localhost password=postgres user=postgres dbname=tdc DATA topo_geom from public.telek STATUS DEFAULT TYPE LINE TOLERANCE 10 PROJECTION init=epsg:2370 END CLASS STYLE COLOR 0 0 255 WIDTH 10 END END END But I got the following error message when I try to display the map: msDrawMap(): Image handling error. Failed to draw layer named 'telek'. msPostGISLayerWhichShapes(): Query error. Error executing query: ERROR: find_srid() - couldnt find the corresponding SRID - is the geometry registered in the GEOMETRY_COLUMNS table? Is there an uppercase/lowercase missmatch? What could be the problem? ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
