Re: Installed. Now what?

On Sun, Nov 20, 2011 at 10:37 AM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
> On Sun, Nov 20, 2011 at 10:33 AM, Amitabh Kant <amitabhkant(at)gmail(dot)com> wrote:
>>
>> I am assuming the difference in the port numbers between your config file
>> and php code is a typing error.
>> Does the auth file (/var/lib/pgsql/pgbouncer.txt) contain valid login
>> credentials to your database? If I remember correctly, it should have the
>> username and password to your database.
>
>
> Port numbers are correct.
>
> Auth_file has text in this format:
>
>
> "username" "password in plain text"
> "username2" "password2 in plain text"
> ..
>
> Is this incorrect?

I just did some testing.

If the password is wrong, then it shows me the "authentication failed"
message right in the terminal window, immediately.

If the password is correct (plain text or md5 of that plain text --
both have similar requests), it shows me the second error "no working
connection" below.

[host] > psql -h 127.0.0.1 MYDB -E "MYDB_MYDB" -p 6543psql: ERROR:
password authentication failed for user "MYDB_MYDB"[coco] ~ > [coco] ~
> pico /var/lib/pgsql/pgbouncer.txt

[host] ~ > psql -h 127.0.0.1 MYDB -E "MYDB_MYDB" -p 6543
psql: ERROR: no working server connection

But in the second case, the error in the pgbouncer log is the same --
authentication is failing.

Why this inconsistent and utterly inane behavior from pgbouncer? Why
can't we see transparently what the error is?

Nowhere in the docs does it clearly specify with an example how the
auth_file format should be.

Any pointers please? I'm fresh out of google keywords to search for,
two days later.

Thank you!