Re: Installed. Now what?

On Sun, Nov 20, 2011 at 10:51 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)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(at)127(dot)0(dot)0(dot)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?