[Mapserver-users] Mapserver + PostGIS for dummies.

[Jason M. Nielsen]

Quoting "Pericles S. Nacionales" <nacional at cbs.umn.edu>:

> Jason,
> 
> I believe your problem has something to do with postgresql permissions.
> I bet you didn't have a local account named "gis_user".  You can try two
> things: 
> 
> 1. create a local account with the same name as your postgresql/postgis
> account.  You can give it a "/bin/false" for shell.
> 
> or, 
> 2. edit your pg_hba.conf and add an entry for your database and database
> user with "ident" as your method.  You'll then have to edit
> "pg_ident.conf" and map your database user with a local user.
> 
> #2 would be the option I'd recommend.  Don't mess with your system
> accounts if you don't have to.
> 
> Good luck!
> -Perry N.
> 
> On Thu, 2004-01-15 at 14:47, Jason M. Nielsen wrote:
> > Quoting Eric Bridger <eric at gomoos.org>:
> > 
> > > Just started using postgis recently and the error messages are a bit
> > > cryptic.  Just yesterday I spent an hour staring at a simliar error
> (you
> > > can try running the query i.e. everything after BINARY CURSOR FOR from
> > > psql to see if it works).  Until I checked the postgres log and
> realized
> > > that the table created by shp2pgsql had not granted permissions for my
> > > web user.  GRANT SELECT ON .... TO PUBLIC fixed the problem.
> > > 
> > > The using clauses are for advance queries with a sub-select. You are
> > > probably using the (1) the_geom from [table_name] form of query.
> > > 
> > > Note: there is a postgis list at:
> > > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> > Didnt think about that. Good information. I checked and there were no
> users
> > granted privledges to the table so I first added the intended user and
> > ultimately public but still no luck. Same error came back.
> > 
> > Thanks, Jason.
> > 
> > -------------------------------------------------
> > This mail sent through IMP: http://horde.org/imp/
> > _______________________________________________
> > Mapserver-users mailing list
> > Mapserver-users at lists.gis.umn.edu
> > http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
> -- 
> Pericles S. Nacionales <nacional at cbs.umn.edu>
> University of Minnesota
> 
> 

Yep no local user and that was indeed the cause of this error. Error gone!

Now just to find out why the vectors show up from the shp file but not when read
from the database. I look into it further.

Thanks!!!

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/