Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
pgbouncer crash on auth
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
zBrain
Tux's lil' helper
Tux's lil' helper


Joined: 14 Apr 2006
Posts: 144

PostPosted: Tue Feb 27, 2018 11:24 pm    Post subject: pgbouncer crash on auth Reply with quote

I have tried reconfiguring this with many different auth types, with the same result.

Here's the simplest:

Code:

[databases]

testdb = host=localhost port=5432 dbname=testdb

[pgbouncer]

logfile = /var/log/pgbouncer/pgbouncer.log

listen_addr = *
listen_port = 6432

unix_socket_dir = /run/postgresql
unix_socket_mode = 0777
unix_socket_group = postgres

auth_type = trust
auth_file = /etc/pgbouncer/userlist.txt

admin_users = postgres
stats_users = postgres

pool_mode = session



Then I have an entry in /etc/pgbouncer/userlist.txt
"testuser" "test"

but if I start it, and do:
psql -p 6432 testdb testuser I gett:

Code:

psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.


I don't ever get a password prompt
Logs show....

Code:


2018-02-27 16:04:30.322 8765 DEBUG S-0x7f96bc05c900: testuser/testdb@127.0.0.1:5432 server login ok, start accepting queries
2018-02-27 16:04:30.322 8765 NOISE S-0x7f96bc05c900: testuser/testdb@127.0.0.1:5432 release_server: new state=10
2018-02-27 16:04:30.322 8765 DEBUG C-0x7f96bc0579d0: testuser/testdb@unix(8778):6432 activate_client
2018-02-27 16:04:30.322 8765 NOISE resync: done=0, parse=0, recv=93
2018-02-27 16:04:30.322 8765 NOISE safe_recv(10, 4003) = Resource temporarily unavailable
2018-02-27 16:04:30.322 8765 NOISE C-0x7f96bc0579d0: testuser/testdb@unix(8778):6432 pkt='!' len=93
2018-02-27 16:04:30.322 8765 NOISE C-0x7f96bc0579d0: testuser/testdb@unix(8778):6432 P: welcome_client
2018-02-27 16:04:30.322 8765 NOISE safe_close(7) = 0
2018-02-27 16:04:30.322 8765 NOISE safe_close(8) = 0
2018-02-27 16:04:30.322 8765 NOISE safe_close(9) = 0


At this point pgbouncer is dead. Re running the psql command gives:
Code:
psql: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/run/postgresql/.s.PGSQL.6432"?


/etc/init.d/pgbouncer restart:
Code:

 # /etc/init.d/pgbouncer restart
 * Stopping PgBouncer (this can take up to 62 seconds) ...
 * start-stop-daemon: no matching processes found                                                                                                                                                                [ ok ]
 * /run/postgresql: correcting mode
 * Starting PgBouncer ...         


I've re-emerged pgbouncer, tried setups for query logn, md5, plain...I'm out of ideas

[Moderator edit: changed [quote] tags to [code] tags to preserve output layout. -Hu]
Back to top
View user's profile Send private message
zBrain
Tux's lil' helper
Tux's lil' helper


Joined: 14 Apr 2006
Posts: 144

PostPosted: Thu Jan 10, 2019 8:10 pm    Post subject: Reply with quote

I'm re-visiting this nearly a year later and still seeing the same behaviour. I'm hoping some expert out there can help.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum