QGIS » QGIS Application

please check if connection is set-up correctly with the target DB name

When I click on Add postgis layers and define my service configuration I can access the database tables. It is only when I try to access the database using DB manager that it fails to connect

again... try to setup dbname in the connection con figuration. dbname is not set in the screenshot you sent.

If I define a dbname it works. But I thought the point of using service files is to have the whole database configuration defined in the service file and then just connect. So this way does it mean the port,user name,password are the only parameters that are read from the service file when using DB Manager. When using service files with the Add postgis layers you can just specify service file and no other parameters and it still works.

I don't think this is a but... but a feature request

when you add a db layer you connect to a specified db+table (otherwise default is tablename=username)... also just testing connection need a db... if not set it test on postgres db that is the administrative db always present.

if need db metadata... eg list of tables in a db, you have to connect to postgresdb and query relative tables.
if you need installed db on a remote db.

I feel that this have to be changed to feature request or removed as bug.

Hi Luigi. For me it is a regression - the behaviour changed from how it worked before in < 2.14 and if you are using a service file then you should not need to set the db name or other connection information since these are specified in the service file.

Sorry

I didn't know was a regression due to my lack of user experience

@Admire, just a question. your DB connection is set-up using basic authentication with user and pwd? or do you use any of the "new" authentication features storing credentials in auth-db? (settings->options->authentication).

The answer is useful to me to replicate the problem

sorry for my late... we are really busy on testing plugins stuffs. I'll be back on this issue in some days

tnx elpaso

Could you please backport it? Thanks.

I've done it already with 0bde357

Great, thanks.