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:
Can start the setup.pl, I give username/password and a new database.
Confirm operation -> Yes -> in the background I checked, the database and
plpgsql created.
Choose country -> hu -> Next
Choose COA -> Extended.sql -> Next
500 Internal server error
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/[email protected]
:60321 closing because: pgbouncer cannot connect to server (age=0)
2013-11-02 09:06:31.073 13577 WARNING C-0xce8170: teszt13352/[email protected]
:60321 Pooler Error: pgbouncer cannot connect to server
2013-11-02 09:06:31.073 13577 LOG S-0xd05c88: teszt13352/[email protected]
:5432 new connection to server
2013-11-02 09:06:31.073 13577 LOG C-0xce8170: teszt13352/[email protected]
:60321 login failed: db=teszt13352 user=postgres
2013-11-02 09:06:31.076 13577 LOG C-0xce8170: teszt13352/[email protected]
:60325 closing because: pgbouncer cannot connect to server (age=0)
2013-11-02 09:06:31.076 13577 WARNING C-0xce8170: teszt13352/[email protected]
:60325 Pooler Error: pgbouncer cannot connect to server
2013-11-02 09:06:31.076 13577 LOG C-0xce8170: teszt13352/[email protected]
: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
------------------------------------------------------------------------------
Android is increasing in popularity, but the open development platform that
developers love is also attractive to malware creators. Download this white
paper to learn more about secure code signing practices that can help keep
Android apps secure.
http://pubads.g.doubleclick.net/gampad/clk?id=65839951&iu=/4140/ostg.clktrk
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
