Hi,
I have the following config:
[PG server] ------------------ [Webserver + pgBouncer + ledgersmb 1.3]
I would like to setup a working environment to use remote database via pgBouncer.
I succeed to setup basically, I can connect to the database on the webserver as postgres user (login to the localhost with psql - pgBouncer connects to the database, can work on the database).
My problem is, I run into problem when installing lsmb via the webui.
Explicitely:
I found the following error message in the webserver log:
2013/11/02 09:06:31 [error] 22258#0: *51 FastCGI sent in stderr: "setup.pl at app.psgi line 39.
DBI connect('dbname=teszt13352','',...) failed: could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
could not connect to server: Connection refused
Is the server running on host "localhost" (::1) and accepting
TCP/IP connections on port 5432?
ERROR: pgbouncer cannot connect to server at scripts/setup.pl line 793" while reading response header from upstream, client: 10.0.2.200, server: _, request: "POST /setup.pl HTTP/1.1", upstream: "fastcgi://unix:/run/nginx/fcgi/lsmb.sock:", host: "10.0.2.55", referrer: "http://10.0.2.55/setup.pl"
2013/11/02 09:06:31 [error] 22258#0: *51 FastCGI sent in stderr: "10.0.2.200 - - [02/Nov/2013:09:06:31 +0100] "POST /setup.pl HTTP/1.1" 500 137 "http://10.0.2.55/setup.pl" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/28.0.1500.71 Chrome/28.0.1500.71 Safari/537.36"" while reading response header from upstream, client: 10.0.2.200, server: _, request: "POST /setup.pl HTTP/1.1", upstream: "fastcgi://unix:/run/nginx/fcgi/lsmb.sock:", host: "10.0.2.55", referrer: "http://10.0.2.55/setup.pl"
pgBouncer log contains the following:
2013-11-02 09:06:31.073 13577 LOG C-0xce8170: teszt13352/postgres@127.0.0.1:60321 closing because: pgbouncer cannot connect to server (age=0)
2013-11-02 09:06:31.073 13577 WARNING C-0xce8170: teszt13352/postgres@127.0.0.1:60321 Pooler Error: pgbouncer cannot connect to server
2013-11-02 09:06:31.073 13577 LOG S-0xd05c88: teszt13352/postgres@10.0.2.31:5432 new connection to server
2013-11-02 09:06:31.073 13577 LOG C-0xce8170: teszt13352/postgres@127.0.0.1:60321 login failed: db=teszt13352 user=postgres
2013-11-02 09:06:31.076 13577 LOG C-0xce8170: teszt13352/postgres@127.0.0.1:60325 closing because: pgbouncer cannot connect to server (age=0)
2013-11-02 09:06:31.076 13577 WARNING C-0xce8170: teszt13352/postgres@127.0.0.1:60325 Pooler Error: pgbouncer cannot connect to server
2013-11-02 09:06:31.076 13577 LOG C-0xce8170: teszt13352/postgres@127.0.0.1:60325 login failed: db=teszt13352 user=postgres
The setup.pl dies here, at line 793:
$request->{dbh} = DBI->connect("dbi:Pg:dbname=$request->{database}");
I guess there is something between pgBouncer and ledgersmb, regarding the authentication or similar, but until now, I stuck at this point.
So, my question, does anybody succeed to use lsmb via pgbouncer? Where is the trick?
Bye,
István