Search Postgresql Archives

Re: [Pgbouncer-general] Again, problem with pgbouncer

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Sorry but you are showing two different paths

Your first email showed this path
/var/log/pgbouncer.log 

And now you are stating this, which would be correct
/var/log/pgbouncer/pgbouncer.log

Wolf


-----Original Message-----
From: Phoenix Kiula [mailto:phoenix.kiula@xxxxxxxxx] 
Sent: Friday, October 05, 2012 8:01 PM
To: Wolf Schwurack
Cc: raghu ram; pgbouncer-general@xxxxxxxxxxxxx; PG-General Mailing List
Subject: Re: [Pgbouncer-general]  Again, problem with pgbouncer

On Sat, Oct 6, 2012 at 12:01 AM, Wolf Schwurack <wolf@xxxxxxx> wrote:
....
> You need to have a pgbouner directory in /var/log and have the owner 
> pgbouncer. This is easy to test try creating a file in /var/log as the 
> user pgbouncer. It should fail because pgbouncer does not have writer 
> permissions to /var/log. As root create a directory 
> /var/log/pgbouncer, change owner to pgbouncer. Set your parameter for 
> pgbouncer.log to /var/log/pgbouncer. Then test by creating a file in 
> /var/log/pgbouncer as user pgbouncer



Wolf, I think you missed the earlier posts in this thread. The "/var/log/pgbouncer.log" already has those permissions.

Note this important fact: the same permissions have been working for nearly 2 years.

Anyway, I created a directory:  /var/log/pgbouncer/, put the pgbouncer.log file in it.

   chown -R pgbouncer:postgres /var/log/pgbouncer
   chown pgbouncer:postgres /var/log/pgbouncer/pgbouncer.log
   chmod 777 /var/log/pgbouncer/pgbouncer.log

As was already happening, pgbouncer starts. No problem.

It's now that I cannot connect to PSQL via pgbouncer (of course I can connect to psql directly) because it fails with this error:

  psql: ERROR:  No such user: MYSITE_MYSITE


Which is weird, because that user does exist. Both inside the postgres database when I do "\du" as you suggested, and of course in the pgbouncer authfile too --


   >   chown pgbouncer:postgres /var/lib/pgsql/pgbouncer.txt

   > cat /var/lib/pgsql/pgbouncer.txt

   "MYSITE_MYSITE" "md5 pass"
   "MYSITE_MYSITE" "raw pass"
   "postgres" "md5fd6313191fec7887f88c31a85c43df21"


So now. What? Why is this otherwise very useful tool coded so poorly that there's reams of such permissions and all of these threads online? Would love to have some help or guidance.

Thanks.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux