On Sun, Nov 20, 2011 at 10:51 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
>
> I don't see a user specified. You sure you are connecting as correct user?
> Remember absent a -U the user will be either your system user name or what is
> specified in a ENV variable.
Adrian, all this is not helping.
To be sure, I tried this. Hope this command is MUCH simpler and puts
this to rest:
> psql --host=127.0.0.1 --dbname=MYDB --username="MYDB_MYDB" --port=6543
psql: ERROR: no working server connection
> tail -4 /var/log/pgbouncer.log
2011-11-19 22:16:49.139 26439 WARNING server login failed: FATAL
password authentication failed for user "MYDB_MYDB"
2011-11-19 22:16:49.139 26439 LOG S-0x15b61fe0:
MYDB/MYDB_MYDB@127.0.0.1:5432 closing because: login failed (age=0)
2011-11-19 22:17:13.490 26439 LOG Stats: 0 req/s, in 0 b/s, out 0 b/s,query 0 us
Please note that the word "MYDB" is a replacement of my private actual
word. As you can see, the password is failing.
I have read the segment of the manual you copy pasted, of course. I have
auth_type = any
auth_file = /var/lib/pgsql/pgbouncer.txt
I have tried "trust" and "md5" too. Same results as previously posted.
Just for convenience, here's how the file looks:
> cat /var/lib/pgsql/pgbouncer.txt
"MYDB_MYDB" "mypassword here"
Anything else?
