On Sun, Nov 20, 2011 at 2:32 PM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote: > On Sun, Nov 20, 2011 at 2:16 PM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote: >> On Sun, Nov 20, 2011 at 1:57 PM, Amitabh Kant <amitabhkant@xxxxxxxxx> wrote: >>> >>> On Sun, Nov 20, 2011 at 12:12 PM, Tomas Vondra <tv@xxxxxxxx> 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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
