Search Postgresql Archives

Re: Installed. Now what?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sun, Nov 20, 2011 at 10:37 AM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote:
> On Sun, Nov 20, 2011 at 10:33 AM, Amitabh Kant <amitabhkant@xxxxxxxxx> 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!

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux