Re: Installed. Now what?

On Sun, Nov 20, 2011 at 2:16 PM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
> On Sun, Nov 20, 2011 at 1:57 PM, Amitabh Kant <amitabhkant(at)gmail(dot)com> wrote:
>>
>> On Sun, Nov 20, 2011 at 12:12 PM, Tomas Vondra <tv(at)fuzzy(dot)cz> wrote:
>>>
>>> Dne 20.11.2011 04:21, Phoenix Kiula napsal(a):
>>> <snip>
>>> My guess is that you actually require a password when connecting to the
>>> database, but you haven't specified a password in the pgbouncer.ini
>>> file. You have to specify it in the MYDB line, i.e. something like
>>>
>>> [databases]
>>> MYDB  = host=127.0.0.1 dbname=MYDB user=MYUSER client_encoding=utf8
>>> port=5432 password='mypassword'
>>>
>>>
>>> The auth_file is used only for connecting to the pgbouncer, it's not
>>> forwarded to the database server - the pgbouncer opens the connection on
>>> behalf of the users, and you may actually have a completely different
>>> users on the connection pooler.
>
>
> OK. So I specified the password enclosed in double quotes.
>
> [databases]
> MYDB  = host=127.0.0.1 dbname=MYDB user=MYUSER client_encoding=utf8
> port=5432 password="mypassword"
>
>
> Then restarted pgbouncer:
>
>   service pgbouncer restart
>
> And this shows up as this:
>
>   > lsof -i | grep pgbouncer
>   pgbouncer  8558 postgres    7u  IPv4 26187618       TCP
> localhost:lds-distrib (LISTEN)
>
> Is this normal? Shouldn't the port number be somewhere? What's "lds-distrib"?

I changed the port to the usual 6432 in the pgbouncer.ini. Restarted.
Now I see this:

> lsof -i | grep pgbounc
pgbouncer 10854 postgres 7u IPv4 26257796 TCP localhost:6432 (LISTEN)

So this is live and working. Pgbouncer is working. And yet, this is a problem:

> psql MYDB -E "MYDB_MYDB" -p 6432 -W
Password for user MYDB_MYDB:
psql: ERROR: no working server connection

From the log file:

2011-11-20 01:28:57.775 10854 WARNING server login failed: FATAL
password authentication failed for user "MYDB_MYDB"
2011-11-20 01:28:57.775 10854 LOG S-0x1ae2efc0:
MYDB/MYDB_MYDB(at)127(dot)0(dot)0(dot)1:5432 closing because: login failed (age=0)
2011-11-20 01:29:46.413 10854 LOG Stats: 0 req/s, in 0 b/s, out 0 b/s,query 0 us

The password I am entering in the terminal is right for sure. I've
tried it a few times, checked the caps lock, etc. Also, if the log
carries this "FATAL password authentication failed", why does the
terminal give the vague error "no working server connection"?

Thanks.