[mapserver-users] No Postgresql mapserver images

[Thomas Gratier]

Hello,

It seems to be more PostGIS related. Run the legacy.sql or
legacy_minimal.sql
See http://postgis.net/docs/postgis_installation.html for more details
But maybe, I'm wrong...

Regards

Thomas Gratier


2013/7/27 Michael McInnis <mmcinnis59 at msn.com>

>  Problem: Although I can use my mapserver install to draw shapefile maps
> I can’t draw maps from my postgres source. I can also display the postgres
> points in QGIS so I’m not sure what the problem is in mapserver.
>
>
>
> Ideas? Thanks in Advance !
>
>
>
>
> http://mapserver0/cgi-bin/mapserv?map=/media/D_Drive/www/gis/postgresMap.map&layer=airports&mode=map
>
>
>
> msDrawMap(): Image handling error. Failed to draw layer named 'airports'.
> msPostGISLayerWhichShapes(): Query error. Error (ERROR: function
> geomfromtext(unknown, integer) does not exist LINE 1: ...,'hex') as
> geom,"oid" from airports where geom && GeomFromTe... ^ HINT: No function
> matches the given name and argument types. You might need to add explicit
> type casts. ) executing query: select
> encode(ST_AsBinary(ST_Force_2D("geom"),'NDR'),'hex') as geom,"oid" from
> airports where geom && GeomFromText('POLYGON((-180.180360721443
> -90,-180.180360721443 90,180.180360721443 90,180.180360721443
> -90,-180.180360721443 -90))',find_srid('','airports','geom'))
>
>
>
> postgresMap.map file:
>
>
>
> MAP NAME airports EXTENT -180 -90 180 90
>
>     SIZE 1000 500
>
>     #SHAPEPATH "./data"
>
>
>
>     SYMBOL
>
>         NAME "circle-filled"
>
>         TYPE ELLIPSE
>
>         FILLED TRUE
>
>         POINTS 1 1 END
>
>     END
>
>     LAYER
>
>         CONNECTIONTYPE POSTGIS
>
>         NAME airports
>
>         CONNECTION "host=localhost dbname=Airports user=xxxx
> password=xxxx port=5432"
>
>         PROCESSING "CLOSE_CONNECTION=DEFER"
>
>         DATA "geom From airports"
>
>         #DATA "geom From (select icao, geom From airports) as subquery
> using unique icao using srid=4326"
>
>         STATUS ON
>
>         TYPE POINT
>
>         CLASS
>
>             NAME "airportsClass"
>
>             SYMBOL 'circle-filled'
>
>                 SIZE 2
>
>                 COLOR 255 22 22
>
>             END
>
>         END # Class
>
>     END # Layer
>
> END # Map File
>
>
>
>
> Michael McInnis 6033 44th Ave. N.E. Seattle, WA 98115 206 517-4701
>
> _______________________________________________
> 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/20130727/6a311567/attachment.html>