<div dir="ltr"><div><div><div>Hello,<br><br>It seems to be more PostGIS related. Run the legacy.sql or legacy_minimal.sql<br></div>See <a href="http://postgis.net/docs/postgis_installation.html">http://postgis.net/docs/postgis_installation.html</a> for more details<br>
</div><div>But maybe, I'm wrong...<br></div><div><br></div>Regards<br><br></div>Thomas Gratier<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/7/27 Michael McInnis <span dir="ltr"><<a href="mailto:mmcinnis59@msn.com" target="_blank">mmcinnis59@msn.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">
<p class="MsoNormal">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.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Ideas? Thanks in Advance !<br></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal"><a href="http://mapserver0/cgi-bin/mapserv?map=/media/D_Drive/www/gis/postgresMap.map&layer=airports&mode=map" target="_blank"><span>http://mapserver0/cgi-bin/mapserv?map=/media/D_Drive/www/gis/postgresMap.map&layer=airports&mode=map</span></a></p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">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'))</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">postgresMap.map file:</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas">MAP
NAME airports EXTENT -180 -90 180 90</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>SIZE 1000 500</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>#SHAPEPATH "./data"</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span></span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>SYMBOL</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>NAME "circle-filled"</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>TYPE ELLIPSE</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>FILLED TRUE</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>POINTS 1 1 END</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>END</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>LAYER</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>CONNECTIONTYPE POSTGIS</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>NAME airports</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>CONNECTION "host=localhost
dbname=Airports user=xxxx password=xxxx port=5432"</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>PROCESSING
"CLOSE_CONNECTION=DEFER"</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>DATA "geom From airports" </span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>#DATA "geom From (select icao,
geom From airports) as subquery using unique icao using srid=4326" </span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>STATUS ON</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>TYPE POINT</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>CLASS</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>NAME "airportsClass"</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>SYMBOL 'circle-filled'</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>SIZE 2</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>COLOR 255 22 22</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>END</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>END # Class</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas"><span> </span>END # Layer</span></p>
<p class="MsoNormal" style="line-height:normal;text-autospace:none"><span style="font-size:9.5pt;font-family:Consolas">END #
Map File</span></p>
<p class="MsoNormal"> </p>
<br><br>Michael McInnis
6033 44th Ave. N.E.
Seattle, WA 98115
<a href="tel:206%20517-4701" value="+12065174701" target="_blank">206 517-4701</a> </div></div>
<br>_______________________________________________<br>
mapserver-users mailing list<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
<br></blockquote></div><br></div>