I use the origin info and found some problem with relation geography_columns,<br><br>jack@jack-Dell-DM061:~$ ogrinfo PG:'dbname=osm host=localhost user=osm password=osm port=5432' osm_new_places -summary<br>ERROR 1: ERROR: permission denied for relation geography_columns<br>
<br>ERROR 1: ERROR: permission denied for relation geography_columns<br><br>but I test it with QGIS-> addpostgis layer. it's no problem.<br><br>How to solve this problem?<br><br>thanks<br><br><br><div class="gmail_quote">
2012/8/26 <span dir="ltr"><<a href="mailto:mapserver-users-request@lists.osgeo.org" target="_blank">mapserver-users-request@lists.osgeo.org</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Send mapserver-users mailing list submissions to<br>
<a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:mapserver-users-request@lists.osgeo.org">mapserver-users-request@lists.osgeo.org</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:mapserver-users-owner@lists.osgeo.org">mapserver-users-owner@lists.osgeo.org</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of mapserver-users digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. How to check problem when load postgis data but no right map<br>
return? (??)<br>
2. Re: How to check problem when load postgis data but no right<br>
map return? (Jeff McKenna)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Sat, 25 Aug 2012 11:04:35 +0800<br>
From: ?? <<a href="mailto:gisyangli@gmail.com">gisyangli@gmail.com</a>><br>
To: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
Cc: <a href="mailto:mapserver-dev@lists.osgeo.org">mapserver-dev@lists.osgeo.org</a><br>
Subject: [mapserver-users] How to check problem when load postgis data<br>
but no right map return?<br>
Message-ID:<br>
<<a href="mailto:CANtWbEBCPJP0ON0hxkH8CoC3GnAQMUSb6VWnWHEE2K6qxBqQ8A@mail.gmail.com">CANtWbEBCPJP0ON0hxkH8CoC3GnAQMUSb6VWnWHEE2K6qxBqQ8A@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="iso-8859-1"<br>
<br>
I use mapserver to load postgis data, but get a blank map, so I don't know<br>
how to check where is the problem.<br>
<br>
<br>
I enter in the browser "<br>
<a href="http://127.0.0.1/cgi-bin/mapserv?&map=/home/jack/Downloads/mapfile.map&mode=map" target="_blank">http://127.0.0.1/cgi-bin/mapserv?&map=/home/jack/Downloads/mapfile.map&mode=map</a>",<br>
just get a blank image.<br>
<br>
my mapfile.map is like this:<br>
<br>
<br>
MAP<br>
NAME places0<br>
STATUS ON<br>
SIZE 420 300<br>
EXTENT -20000000 -20000000 20000000 20000000<br>
UNITS METERS<br>
IMAGECOLOR 255 255 255<br>
<br>
WEB<br>
TEMPLATE "template.html"<br>
IMAGEPATH "/var/www/output/"<br>
IMAGEURL "/output/"<br>
END<br>
<br>
<br>
LAYER<br>
STATUS default<br>
GROUP "default"<br>
TYPE POINT<br>
CONNECTIONTYPE postgis<br>
CONNECTION "dbname=osm host=localhost user=osm password=osm port=5432"<br>
NAME "places0"<br>
DATA "geometry from (select * from osm_new_places where name is not NULL<br>
order by population asc nulls first) as foo using unique osm_id using<br>
srid=3857"<br>
CLASS<br>
NAME "places0"<br>
COLOR 255 215 0<br>
END<br>
END<br>
<br>
END<br>
<br>
# end of map file<br>
END<br>
<br>
<br>
---------------------------------------------------------------------------------------<br>
<br>
<br>
I test in postgres the sentence "select * from osm_new_places where name is<br>
not NULL order by population asc nulls first" will return many results.<br>
Also the CONNECTION define I think is right.<br>
<br>
And I can not check wher the problem occured.<br>
<br>
Anyone give some advice and method for this?<br>
<br>
<br>
<br>
--<br>
Yang Li<br>
GIS Developer<br>
P.R.China<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120825/2d69b494/attachment-0001.html" target="_blank">http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120825/2d69b494/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Sat, 25 Aug 2012 09:01:45 -0300<br>
From: Jeff McKenna <<a href="mailto:jmckenna@gatewaygeomatics.com">jmckenna@gatewaygeomatics.com</a>><br>
To: <a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a><br>
Subject: Re: [mapserver-users] How to check problem when load postgis<br>
data but no right map return?<br>
Message-ID: <<a href="mailto:5038BEA9.9010700@gatewaygeomatics.com">5038BEA9.9010700@gatewaygeomatics.com</a>><br>
Content-Type: text/plain; charset=UTF-8<br>
<br>
On 12-08-25 12:04 AM, ?? wrote:<br>
> I use mapserver to load postgis data, but get a blank map, so I don't<br>
> know how to check where is the problem.<br>
><br>
<br>
<br>
Hmm. I might use the ogrinfo commandline utility to check the extents<br>
of the data, and then use those extents in the EXTENT parameter of the<br>
mapfile.<br>
<br>
ogrinfo PG:'dbname=osm host=localhost user=osm password=osm port=5432'<br>
osm_new_places -summary<br>
<br>
<br>
-jeff<br>
<br>
<br>
<br>
<br>
--<br>
Jeff McKenna<br>
MapServer Consulting and Training Services<br>
<a href="http://www.gatewaygeomatics.com/" target="_blank">http://www.gatewaygeomatics.com/</a><br>
<br>
<br>
<br>
<br>
------------------------------<br>
<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>
<br>
End of mapserver-users Digest, Vol 55, Issue 51<br>
***********************************************<br>
</blockquote></div><br><br clear="all"><br>-- <br><div style="text-align:left"><span style="text-align:-webkit-auto">Yang Li</span><div>GIS Developer</div><div>P.R.China</div><div><br></div></div><br>