[OBM Admin] QGIS connection

[Bán Miklós]

Hi Attila,


The OBM application in the browser uses local postgresql connection
while the QGIS uses remote connection.

The related settings are the following:

/etc/postgresql/9.4/main/postgresql.conf
listen_addresses = '*'

/etc/postgresql/9.4/main/pg_hba.conf
local	all	postgres		ident
host	all	all	0.0.0.0/0	md5

I don't know "hostssl" type - is this valid?
The ssl mode is enabled in the postgresql.conf....


Miki

On Tue, 20 Dec 2016 13:44:17 +0100
Ferenc Attila <ferenca at bnpi.hu> wrote:

> Hi Everyone,
> 
> I’ve just tried to establish a connection between the pgsql server
> and a qgis client on gekko in local network.
> 
> In the /etc/postgresql/9.4/main/postgresql.conf file I inserted the 
> listen_addresses = '*' value.
> 
> In the /etc/postgresql/9.4/main/pg_hba.conf I inserted this line:
> 
> # TYPE   DATABASE  USER  ADDRESS            METHOD
> hostssl  all       all   192.168.1.76/32    md5
> 
> I’ve restarted the pgsql server (/etc/init.d/postgresql restart).
> 
> In QGIS the Connection infos are:
> 
> Name: Teszt
> Service:
> Machine: 192.168.1.73
> Port: 5432
> Database: my_database_name
> SSL Mode: require
> User name: my_database_name_admin
> Password: ...
> 
> Now I can’t log in to my database neither from qgis, nor from browser.
> 
> When I set back the original pg_hba.conf file, I can log in from 
> browser, but can’t log in from QGIS.
> 
> Can somebody help me?
> 
> Thanks,
> 
> Attila
> 
> 



-- 
Miklós Bán, PhD
MTA-DE "Lendület" Behavioural Ecology Research Group
Department of Evolutionary Zoology, University of Debrecen
H-4010 Debrecen, Egyetem tér 1.
Phone:  +36 52 512-900 ext. 62356
http://zoology.unideb.hu/?m=Miklos_Ban
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~