Re: Installed. Now what?

On Sun, Nov 20, 2011 at 4:14 AM, Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>wrote:

> On Sun, Nov 20, 2011 at 3:35 AM, Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
> wrote:<snip>
>
> [databases]
> MYDB = host=127.0.0.1 dbname=MYDB user=MYUSER client_encoding=utf8
> port=5432
>
> ;; Configuation section
> [pgbouncer]
> logfile = /var/log/pgbouncer.log
> pidfile = /var/run/pgbouncer/pgbouncer.pid
> ; ip address or * which means all ip-s
> listen_addr = 127.0.0.1
> listen_port = 6543
> auth_type = trust
> auth_file = /var/lib/pgsql/pgbouncer.txt
>
> admin_users = postgres
> stats_users = stats, root
> pool_mode = session
> server_reset_query = DISCARD ALL
>
> ;;; Connection limits
> ; total number of clients that can connect
> max_client_conn = 1500
> default_pool_size = 50
>
>
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.

Amitabh