Subject: Re: Question on pgwatch
To: Bikram MAJUMDAR <Bikram.Majumdar@aqsacom.com>,
 pgsql-general <pgsql-general@postgresql.org>
References: 
 <AM6PR0502MB36240E7D8C081584D618A557EFD30@AM6PR0502MB3624.eurprd05.prod.outlook.com>
 <CAKoxK+7=tsOeNwG4_gAwdbiroV70U0vDjPLAyG-eQviOot5HgA@mail.gmail.com>
 <AM6PR0502MB3624547753A9749E454EA6BFEFD20@AM6PR0502MB3624.eurprd05.prod.outlook.com>
 <CAKoxK+6x_SPVJqpqeZQFVqvf1SGHE3_4oLoBTGoYS1kS+QcJ=Q@mail.gmail.com>
 <9CB8AC2E-27EA-431A-A00A-763E7DF124BA@elevated-dev.com>
 <AM6PR0502MB3624E424FBF9C49F1DF49E73EFD20@AM6PR0502MB3624.eurprd05.prod.outlook.com>
 <CAKoxK+4_-h7W2MENrw+-6eP6d1dmEg8CexzoA9qxy5tyObygCA@mail.gmail.com>
 <AM6PR0502MB3624021F836D421D56DB75FCEFAD0@AM6PR0502MB3624.eurprd05.prod.outlook.com>
 <CAKoxK+7ibJ=Ab9Wz06qUZbdO9XpEwPi6zS=mfAaM+XZYKc0NyQ@mail.gmail.com>
 <AM6PR0502MB3624751E4B2B236FA3575E2EEFAF0@AM6PR0502MB3624.eurprd05.prod.outlook.com>
 <AM6PR0502MB36249643361A7E23189FE185EFA50@AM6PR0502MB3624.eurprd05.prod.outlook.com>
From: "Georg H." <georg-h@silentrunner.de>
Message-ID: <2c6ba2e4-04dc-474b-09b7-c4ab5b6af285@silentrunner.de>
Date: Fri, 23 Aug 2019 09:00:36 +0200
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101
 Thunderbird/60.8.0
MIME-Version: 1.0
In-Reply-To: 
 <AM6PR0502MB36249643361A7E23189FE185EFA50@AM6PR0502MB3624.eurprd05.prod.outlook.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Content-Language: de-DE
Precedence: bulk

Hello Bikram,

Am 22.08.2019 um 23:50 schrieb Bikram MAJUMDAR:
> Hi,
> Need help from anyone in the team who has worked on pgwatch2.
>
> Yesterday we installed  pgwatch2 docker image and started the container.
> We are running the pgwatch2 container from the database server itself -
> Now we want to add our databases for monitoring using the admin interface:
> We are opening the pgwatch2 admin interface at <host IP>:8080/dbs.But, when we try to add the database (cemtore) in the admin interface we get the following error:
>
> Could not connect to specified host (ignore if gatherer daemon runs on another host): FATAL: no pg_hba.conf entry for host "172.17.0.2", user "cemtore", database "cemtore", SSL off
>
> Any idea what we are doing wrong?
>
> We would now like to add the database manually following notes below:
> Usage
> by default the pgwatch2 configuration database running inside Docker is being monitored so that you can immediately see some graphs, but you should add new databases by opening the admin interface at 127.0.0.1:8080/dbs or logging into the Postgres config DB and inserting into pgwatch2.monitored_db table (db - pgwatch2 , default user/pw - pgwatch2/pgwatch2admin)
>
> But, my question is, how do I run the psql on my  database server to login to this default pgwatch2 configuration DB?
>
> Bikram Majumdar
> Sr Software Developer/DBA, Aqsacom Inc.
> c. 1.972.365.3737

As the message states (FATAL: no pg_hba.conf entry for host 
"172.17.0.2", user "cemtore", database "cemtore", SSL off) you have to 
edit pg_hba.conf of the PostgreSQL Cluster hosting the cemtore database

to allow connections from pgwatch to it as your current config doesn't 
allow that. Also you may need the connecting user within your database 
with the required rights (if not added yet).


regards

Georg