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