Re: Installed. Now what? - Mailing list pgsql-general

On Sun, Nov 20, 2011 at 2:32 PM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
> On Sun, Nov 20, 2011 at 2:16 PM, Phoenix Kiula <phoenix.kiula@gmail.com> wrote:
>> On Sun, Nov 20, 2011 at 1:57 PM, Amitabh Kant <amitabhkant@gmail.com> wrote:
>>>
>>> On Sun, Nov 20, 2011 at 12:12 PM, Tomas Vondra <tv@fuzzy.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@127.0.0.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.
>





Another idea.

I use CSF/LFD firewall.

For TCP_IN, I have enabled "6432" port number.

Do I also need to enable it elsewhere, such as TCP_OUT or UDP_IN etc?