Re: [Qgis-developer] login to postgres/postgis from QGIS

2015-03-03 Thread Otto Dassau
Hi, thanks for your help. the database was spatially enabled, but it was necessary to grant some rights (create/usage) to the public schema. I believe that a better message should point the user to the right direction. A added a ticket for that. http://hub.qgis.org/issues/12304 Regards Otto

Re: [Qgis-developer] login to postgres/postgis from QGIS

2015-03-02 Thread Alessandro Pasotti
2015-03-03 8:10 GMT+01:00 Olivier Dalang : > Is your database spatially enabled ? Try to run 'create extension postgis;" > in pgadmin. > > Bests, > Hi, I've got the same error once, and the reason was that the DB wasn't spatially enabled, that said I believe that a better message should point the

Re: [Qgis-developer] login to postgres/postgis from QGIS

2015-03-02 Thread Olivier Dalang
Is your database spatially enabled ? Try to run 'create extension postgis;" in pgadmin. Bests, Olivier On Feb 27, 2015 8:08 AM, "Otto Dassau" wrote: > Hi, > > I cannot login to a postgis database with QGIS as a normal user 'testuser'. > But I can login with psql and using pgadmin3. > > CREATE R

Re: [Qgis-developer] login to postgres/postgis from QGIS

2015-02-27 Thread Yves Jacolin
On Friday, February 27, 2015 8:08:13 Otto Dassau wrote: > Hi, > > I cannot login to a postgis database with QGIS as a normal user 'testuser'. > But I can login with psql and using pgadmin3. > > CREATE ROLE testuser LOGIN > NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; > > I get fo

[Qgis-developer] login to postgres/postgis from QGIS

2015-02-26 Thread Otto Dassau
Hi, I cannot login to a postgis database with QGIS as a normal user 'testuser'. But I can login with psql and using pgadmin3. CREATE ROLE testuser LOGIN NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION; I get following error in QGIS: CET ERROR: function postgis_version() does not e