Обсуждение: [ADMIN]

Поиск
Список
Период
Сортировка

[ADMIN]

От
Santiago DIEZ
Дата:
Hi,

I'm trying to execute postgresql inside a chroot environment.
initdb runs OK
pg_ctl runs OK and server can be queried.

But, the logs show :
2017-03-21 22:34:03 CET LOG:  could not receive test message on socket for statistics collector: Connection refused
2017-03-21 22:34:03 CET LOG:  disabling statistics collector for lack of working socket
2017-03-21 22:34:03 CET WARNING:  autovacuum not started because of misconfiguration
2017-03-21 22:34:03 CET HINT:  Enable the "track_counts" option.
2017-03-21 22:34:03 CET LOG:  database system was shut down at 2017-03-21 22:34:03 CET
2017-03-21 22:34:04 CET LOG:  database system is ready to accept connections

Note that outside the chroot, the server is not showing any error :
2017-03-21 17:51:58 CET LOG:  database system was shut down at 2017-03-21 17:51:58 CET
2017-03-21 17:51:58 CET LOG:  database system is ready to accept connections
2017-03-21 17:51:58 CET LOG:  autovacuum launcher started


What is necessary to run statistic collector?
How should I configure my chroot?
How can I debug? (apart from setting log_min_messages to debug1 which does not help me much because I can't interpret the output).

Regards
-------------------------
Santiago DIEZ
 
-------------------------
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------

Re: [ADMIN]

От
Tom Lane
Дата:
Santiago DIEZ <santiago.diez@caoba.fr> writes:
> I'm trying to execute postgresql inside a chroot environment.
> initdb runs OK
> pg_ctl runs OK and server can be queried.

> But, the logs show :
> 2017-03-21 22:34:03 CET LOG:  could not receive test message on socket for
> statistics collector: Connection refused
> 2017-03-21 22:34:03 CET LOG:  disabling statistics collector for lack of
> working socket

Apparently there's some aspect of your chroot setup that breaks TCP
connections to "localhost".  You need to fix that ...

            regards, tom lane

Re: [ADMIN]

От
Santiago DIEZ
Дата:
Hi Tom,

Thanks for your advice. I'm indeed only able to connect to the cluster from outside the chroot using unix sockets like:
$ psql --host /jail/tmp --port 5421 mydb

If I try and force a TCP/IP connexion, it fails with:
$ psql --host localhost --port 5421 mydb
psql: could not connect to server: Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5421?
FATAL:  no pg_hba.conf entry for host "192.168.1.103", user "santiago", database "santiago"

I have mounted /dev, /proc and /sys inside the chroot. What else could be necessary to allow TCP/IP connections to postgresql?

Regards
-------------------------
Santiago DIEZ
+33 6 37 90 81 98
-------------------------
 
-------------------------
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------

On Wed, Mar 22, 2017 at 4:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Santiago DIEZ <santiago.diez@caoba.fr> writes:
> I'm trying to execute postgresql inside a chroot environment.
> initdb runs OK
> pg_ctl runs OK and server can be queried.

> But, the logs show :
> 2017-03-21 22:34:03 CET LOG:  could not receive test message on socket for
> statistics collector: Connection refused
> 2017-03-21 22:34:03 CET LOG:  disabling statistics collector for lack of
> working socket

Apparently there's some aspect of your chroot setup that breaks TCP
connections to "localhost".  You need to fix that ...

                        regards, tom lane

Re: [ADMIN]

От
Santiago DIEZ
Дата:
Hi,

Actually, port 5421 is open for localhost but not on eth0. What puzzles me is why psql is resolving localhost to 192.168.1.103 when nc is rightfully resolving it to 127.0.0.1:

$ nc -vz localhost 5421
localhost [127.0.0.1] 5421 (?) open

$ nc -vnz 192.168.1.103 5421
(UNKNOWN) [192.168.1.103] 5421 (?) : Connection refused

$ psql --host localhost --port 5421
psql: could not connect to server: Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5421?
FATAL:  no pg_hba.conf entry for host "192.168.1.103", user "santiago", database "santiago"

$ psql --host 127.0.0.1 --port 5421
psql: FATAL:  no pg_hba.conf entry for host "192.168.1.103", user "santiago", database "santiago"

-------------------------
Santiago DIEZ
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------

On Wed, Mar 22, 2017 at 9:28 AM, Santiago DIEZ <santiago.diez@caoba.fr> wrote:
Hi Tom,

Thanks for your advice. I'm indeed only able to connect to the cluster from outside the chroot using unix sockets like:
$ psql --host /jail/tmp --port 5421 mydb

If I try and force a TCP/IP connexion, it fails with:
$ psql --host localhost --port 5421 mydb
psql: could not connect to server: Connection refused
        Is the server running on host "localhost" and accepting
        TCP/IP connections on port 5421?
FATAL:  no pg_hba.conf entry for host "192.168.1.103", user "santiago", database "santiago"

I have mounted /dev, /proc and /sys inside the chroot. What else could be necessary to allow TCP/IP connections to postgresql?

Regards
-------------------------
Santiago DIEZ
+33 6 37 90 81 98
-------------------------
 
-------------------------
Quark Systems & CAOBA
23 rue du Buisson Saint-Louis, 75010 Paris
-------------------------

On Wed, Mar 22, 2017 at 4:23 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Santiago DIEZ <santiago.diez@caoba.fr> writes:
> I'm trying to execute postgresql inside a chroot environment.
> initdb runs OK
> pg_ctl runs OK and server can be queried.

> But, the logs show :
> 2017-03-21 22:34:03 CET LOG:  could not receive test message on socket for
> statistics collector: Connection refused
> 2017-03-21 22:34:03 CET LOG:  disabling statistics collector for lack of
> working socket

Apparently there's some aspect of your chroot setup that breaks TCP
connections to "localhost".  You need to fix that ...

                        regards, tom lane


Re: [ADMIN]

От
Tom Lane
Дата:
Santiago DIEZ <santiago.diez@caoba.fr> writes:
> Actually, port 5421 is open for localhost but not on eth0. What puzzles me
> is why psql is resolving localhost to 192.168.1.103 when nc is rightfully
> resolving it to 127.0.0.1:

Maybe the chroot's /etc/hosts file says so?

            regards, tom lane