[Mapserver-users] PostGIS blank error - bit of a newbie question....!

[Matt Hatcher]

Paul,

Thanks. You've indirectly solved my problem!

I did have a valid entry in both geometry_columns and spatial_ref_sys, but
I hadn't granted permissions on them to my webserver user. I'd granted to
the table itself but not the metadata tables.

It works like a dream now!

Matt.


> Is there a valid entry for your table in geometry_columns?
> Is there a valid entry for your srid in spatial_ref_sys?
> Can you put the SQL from the error message (minus the DECLARE statement)
> into psql and get something back?
>
> Matt Hatcher wrote:
>
>> Hi,
>>
>> I'm trying to get a postgres connection working with Mapserver 4.0.1 on
>> Mandrake 9.2. I'm using the Postgres and Postgis RPMs from the postgis
>> site, and the stable 4.0.1 source compiled with the postgis option. My
>> -v
>> gives:
>>
>> MapServer version 4.0.1 OUTPUT=PNG OUTPUT=JPEG OUTPUT=WBMP OUTPUT=PDF
>> SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER SUPPORTS=WMS_CLIENT
>> SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT INPUT=JPEG INPUT=POSTGIS
>> INPUT=OGR
>> INPUT=GDAL INPUT=SHAPEFILE
>>
>>
>> I've got a table that I loaded from a point shapefile using shp2pgsql
>> which I can query quite happily from the psql command line. The data in
>> there is in SRID 4326, e.g.:
>>
>>  gid | id |     x     |     y     | height_m |  height_ft  | type  |
>> name    |               the_geom
>> -----+----+-----------+-----------+----------+-------------+-------+-----------+--------------------------------------
>>     |  1 | -5.003492 | 56.796264 | 1343.798 | 4408.786096 | Munro | Ben
>> Nevis | SRID=4326;POINT(-5.003492 56.796264)
>>
>>
>> When I try and get the data through Mapserver I get the following
>> unhelpful "blank" error message:
>>
>> msDrawMap(): Image handling error. Failed to draw layer named 'peaks'.
>> prep_DB(): Query error. Error executing POSTGIS DECLARE (the actual
>> query)
>> statement: 'DECLARE mycursor BINARY CURSOR FOR SELECT
>> asbinary(force_collection(force_2d(the_geom)),'NDR'),OID::text from
>> mountains WHERE the_geom && setSRID('BOX3D(-10.5612147941099
>> 48.9367546675052,6.81724902590237 55.7611851275149)'::BOX3D,
>> find_srid('','mountains','the_geom') )'
>>
>> Postgresql reports the error ''
>>
>> More Help:
>>
>> Error with POSTGIS data variable. You specified '<check your .map
>> file>'.
>> Standard ways of specifiying are :
>> (1) 'geometry_column from geometry_table'
>> (2) 'geometry_column from (<sub query>) as foo using unique <column
>> name>
>> using SRID=<srid#>'
>>
>> Make sure you put in the 'using unique <column name>' and 'using SRID=#'
>> clauses in.
>>
>> For more help, please see
>> http://postgis.refractions.net/documentation.php
>>
>>
>> Mappostgis.c - version of June 12/2003.
>>
>>
>> My map file has:
>>
>> LAYER
>>   NAME "peaks"
>>   TYPE POINT
>>   STATUS OFF
>>   CONNECTIONTYPE POSTGIS
>>   CONNECTION "user=apache dbname=geo"
>>   DATA "the_geom from mountains"
>>
>>   PROJECTION
>>     "init=epsg:4326"
>>   END
>>
>>   CLASS
>>     SYMBOL 'circle'
>>     SIZE 4
>>     COLOR   0
>>   END
>> END
>>
>>
>> Any suggestions would be gratefully received!
>>
>> Cheers, Matt.
>>
>> _______________________________________________
>> Mapserver-users mailing list
>> Mapserver-users at lists.gis.umn.edu
>> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>