PostGIS login

3 messages Options
Embed this post
Permalink
Armando Forlani

PostGIS login

Reply Threaded More More options
Print post
Permalink
Hi there,
I need some help with this. I've been aregular user and developer of various propetary desktop gis s/w for the past five years and only now starting using uDig. looking forward developing customised gis application but for the moment just getting to know it. I'm afraid I've it my first problem.
I've added a map and a layer using data from a database in PostGIS, directly, i.e. no wms, and from the public schema. It all works fine but only if I use the postgis superuser. It wont work at all for any other user role (with select rights only), udig cant see any tables/views, giving the same response as when entering a non existent user detail.
Your help would be much appreciated.
Thanks
Armando

_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Jody Garnett-2

Re: PostGIS login

Reply Threaded More More options
Print post
Permalink
Can I 1st check what version you are using? We have just switched to a  
new PostGIS "data source" implementation and are going through some  
pains :-) In particular the uDig 1.1.1 implementation will be better  
at picking up tables and views that have not correctly "added" their  
geometry column.

If you would like to evaluate uDig 1.2 please check out 1.2-M6 (as  
this is just prior to us trying out a new data source.

Jody
On 21/10/2009, at 9:00 PM, Armando Forlani wrote:

> Hi there,
> I need some help with this. I've been aregular user and developer of  
> various propetary desktop gis s/w for the past five years and only  
> now starting using uDig. looking forward developing customised gis  
> application but for the moment just getting to know it. I'm afraid  
> I've it my first problem.
> I've added a map and a layer using data from a database in PostGIS,  
> directly, i.e. no wms, and from the public schema. It all works fine  
> but only if I use the postgis superuser. It wont work at all for any  
> other user role (with select rights only), udig cant see any tables/
> views, giving the same response as when entering a non existent user  
> detail.
> Your help would be much appreciated.
> Thanks
> Armando
> _______________________________________________
> udig-users mailing list
> [hidden email]
> http://lists.refractions.net/mailman/listinfo/udig-users

_______________________________________________
udig-users mailing list
[hidden email]
http://lists.refractions.net/mailman/listinfo/udig-users
Armando Forlani

Re: PostGIS login

Reply Threaded More More options
Print post
Permalink
I'm using uDig 1.1.1 and the latest stable releases of PostgreSQL + PostGIS, everything on localhost.
The 'testuser' (which has only select rights) connects perfectly, I've tested it with a 'Select' within a PHP script. As an additional test... GeoServer run smoothly with this user. However, adding data in uDig I get the annoying 'unable to recognize service, choose...'. Everything works fine using the 'postgres' superuser. Sorry for repeating myself but I had to add a few more details. I'll be more than happy evaluating new releases but I've got some work to do first and I'm stuck.