Re: Installed. Now what?

Dne 20.11.2011 04:21, Phoenix Kiula napsal(a):
>> tail -4 /var/log/pgbouncer.log
> 2011-11-19 22:16:49.139 26439 WARNING server login failed: FATAL
> password authentication failed for user "MYDB_MYDB"
> 2011-11-19 22:16:49.139 26439 LOG S-0x15b61fe0:
> MYDB/MYDB_MYDB(at)127(dot)0(dot)0(dot)1:5432 closing because: login failed (age=0)
> 2011-11-19 22:17:13.490 26439 LOG Stats: 0 req/s, in 0 b/s, out 0 b/s,query 0 us
>
>
> Please note that the word "MYDB" is a replacement of my private actual
> word. As you can see, the password is failing.
>
> I have read the segment of the manual you copy pasted, of course. I have
>
> auth_type = any
> auth_file = /var/lib/pgsql/pgbouncer.txt
>
> I have tried "trust" and "md5" too. Same results as previously posted.
> Just for convenience, here's how the file looks:
>
> > cat /var/lib/pgsql/pgbouncer.txt
> "MYDB_MYDB" "mypassword here"

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.

Tomas