[mapserver-users] How to check problem when load postgis data but no right map return? (Jeff McKenna)

[李杨]

I use the origin info and found some problem with relation
geography_columns,

jack at 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 <mapserver-users-request at lists.osgeo.org>

> Send mapserver-users mailing list submissions to
>         mapserver-users at lists.osgeo.org
>
> 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
>         mapserver-users-request at lists.osgeo.org
>
> You can reach the person managing the list at
>         mapserver-users-owner at lists.osgeo.org
>
> 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: ?? <gisyangli at gmail.com>
> To: mapserver-users at lists.osgeo.org
> Cc: mapserver-dev at lists.osgeo.org
> Subject: [mapserver-users] How to check problem when load postgis data
>         but     no right map return?
> Message-ID:
>         <
> CANtWbEBCPJP0ON0hxkH8CoC3GnAQMUSb6VWnWHEE2K6qxBqQ8A at 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 <jmckenna at gatewaygeomatics.com>
> To: mapserver-users at lists.osgeo.org
> Subject: Re: [mapserver-users] How to check problem when load postgis
>         data but no right map return?
> Message-ID: <5038BEA9.9010700 at gatewaygeomatics.com>
> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>
> End of mapserver-users Digest, Vol 55, Issue 51
> ***********************************************
>



-- 
Yang Li
GIS Developer
P.R.China
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120826/dd638135/attachment-0001.html>