[Mapserver-users] Mapserver + PostGIS for dummies.

[Zamil Murji]

Alternatively, you could edit your pg_hba.conf and add an entry for your database and database user with "trust" (don't remember if it has to be UPPERCASE) as your method. 

I don't suggest this for a production environment, but this is a quick and dirty way to check if this is the issue.

Hope this helps,
Zamil

-----Original Message-----
From: mapserver-users-admin at lists.gis.umn.edu
[mailto:mapserver-users-admin at lists.gis.umn.edu]On Behalf Of Pericles S.
Nacionales
Sent: Friday, January 16, 2004 12:46 PM
To: Jason M. Nielsen
Cc: Eric Bridger; Mapserver List
Subject: Re: [Mapserver-users] Mapserver + PostGIS for dummies.


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

_______________________________________________
Mapserver-users mailing list
Mapserver-users at lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users