[mapserver-users] Trouble connecting to PostGIS

[Brent Fraser]

Bob,
   Typical problems are
         - the connecting user (postgisuser) does not have privilege to 
access the table
         - coordinate system is not specified in data (SRID=-1) and not 
in the mapfile either
         -  and others

Turn on the layer debug logging by adding

DEBUG 5

to your mapfile and looking a the log.  You can also execute the SQL 
statements shown in the log file using pgAdmin's SQL tool to see 
additional information.

Best Regards,
Brent Fraser


On 2/13/2012 2:11 PM, Bistrais, Bob wrote:
>
> First of all, let me state that I am brand new to PostGIS and don't 
> know much about what I'm doing with it.  That being said, I am having 
> trouble displaying a PostGIS layer through MapServer.
>
> Right now I'm just experimenting with PostGIS and simply trying to get 
> a layer to display.  I installed the Postgre and PostGIS 1.5.  I used 
> the shapefile loader to convert a couple shapefiles to PostGIS data.  
> Looking in pgAdmin, I see the tables do indeed exist for these layers.
>
> So I built a MapServer map file.  Here is my connection strings:
>
> DATA "the_geom from MylayerPoly"
>
> CONNECTION "user=postgisuser password=MyPassword! dbname=postgistest 
> host=localhost port=5432"
>
> CONNECTIONTYPE postgis
>
> But the layer does not display.  Incidentally, I'm using GeoMoose as a 
> front end for testing, but that shouldn't matter here.
>
> I did a mapserv --v at commandline, and I see the parameter INPUT=POSTGIS.
>
> So as far as I know it should work. Can anyone offer suggestions as to 
> what I'm doing wrong?
>
> Thanks,
>
> Bob
>
>
>
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120213/9c071b91/attachment.htm>