Pooler Error No Such User
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups
Pgbouncer No Such Database
Project lists Inactive lists IRC Local User Groups Featured pgbouncer userlist Users International Sites Propaganda Resources Weekly News Re: [Pgbouncer-general] PGBouncer help (how to get it
Psql: Error: Pgbouncer Cannot Connect To Server
working) From: raghu ram To: clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com Cc: Phoenix Kiula , PG-General Mailing List , pgbouncer-general(at)pgfoundry(dot)org Subject: Re: [Pgbouncer-general] PGBouncer help (how to pgbouncer tutorial get it working) Date: 2012-04-14 13:29:18 Message-ID: CALnrrJR83Q5kU2sjR2j3BoaHtH98iRw6F_4FOMV6be3ON3Q0EQ@mail.gmail.com (view raw or whole thread) Thread: 2012-04-12 17:12:12 from Phoenix Kiula 2012-04-12 17:41:51 from Scott Marlowe 2012-04-13 05:30:21 from Phoenix Kiula 2012-04-13 05:36:45 from Raghavendra 2012-04-13 05:59:36 from Raghavendra 2012-04-13 19:03:42 from Phoenix Kiula pgbouncer config 2012-04-14 11:01:01 from Clodoaldo Neto 2012-04-14 12:39:10 from raghu ram 2012-04-14 13:05:28 from Clodoaldo Neto 2012-04-14 13:29:18 from raghu ram Lists: pgsql-general On Sat, Apr 14, 2012 at 6:35 PM, Clodoaldo Neto < clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> wrote: > Em 14 de abril de 2012 09:39, raghu ram escreveu: > >> >> >> On Sat, Apr 14, 2012 at 4:31 PM, Clodoaldo Neto < >> clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> wrote: >> >>> Em 12 de abril de 2012 14:12, Phoenix Kiula escreveu: >>> >>>> I had pgbouncer working somehow, but we have switched servers recently >>>> and now I cannot for the life of me figure out again how to set it up. >>>> >>>> Online guides say things like "create a user ID". Well, where? Inside >>>> PG the database? Or in my CentOS system? >>>> >>>> Here's my "/etc/pgbouncer.ini": >>>> >>>> [database
pgsql-announce pgsql-bugs pgsql-docs pgsql-general pgsql-interfaces pgsql-jobs pgsql-novice pgsql-performance pgsql-php pgsql-sql pgsql-students Developer lists Regional lists Associations User groups Project lists Inactive lists IRC Local User Groups Featured Users International Sites Propaganda Resources Weekly News Re: [Pgbouncer-general] Again, problem with pgbouncer From: Wolf Schwurack https://www.postgresql.org/message-id/CALnrrJR83Q5kU2sjR2j3BoaHtH98iRw6F_4FOMV6be3ON3Q0EQ@mail.gmail.com To: Phoenix Kiula , raghu ram Cc: "pgbouncer-general(at)pgfoundry(dot)org" ,PG-General Mailing List Subject: Re: [Pgbouncer-general] Again, problem with pgbouncer Date: 2012-10-03 18:50:51 Message-ID: 485368C10B2A274EABE47136B8AFCA123426FE6C@X-MB11.xds.umail.utah.edu (view raw or whole thread) Thread: 2012-10-01 10:26:04 from Phoenix Kiula 2012-10-01 https://www.postgresql.org/message-id/485368C10B2A274EABE47136B8AFCA123426FE6C@X-MB11.xds.umail.utah.edu 10:44:33 from raghu ram 2012-10-01 16:59:40 from Phoenix Kiula 2012-10-02 03:29:09 from Phoenix Kiula 2012-10-02 09:27:50 from Phoenix Kiula 2012-10-03 18:01:39 from Phoenix Kiula 2012-10-03 18:13:17 from dinesh kumar 2012-10-03 18:50:51 from Wolf Schwurack 2012-10-05 15:37:26 from Phoenix Kiula 2012-10-05 16:01:36 from Wolf Schwurack 2012-10-06 02:00:49 from Phoenix Kiula 2012-10-06 02:07:48 from Adrian Klaver 2012-10-06 02:13:31 from Shashank Tripathi 2012-10-06 02:23:02 from Phoenix Kiula 2012-10-06 02:24:20 from Adrian Klaver 2012-10-06 02:30:52 from Phoenix Kiula 2012-10-06 02:36:05 from Adrian Klaver 2012-10-08 08:05:54 from Marko Kreen 2012-10-06 12:24:16 from Johnny Tan 2012-10-07 14:02
(how to get it working) Messages sorted by: [ date ] [ thread http://lists.pgfoundry.org/pipermail/pgbouncer-general/2012-April/000965.html ] [ subject ] [ author ] Em 10 https://arthurpemberton.com/2016/01/pgbouncer-giving-you-no-such-user-errors de abril de 2012 15:29, Clodoaldo Neto escreveu: > The last yum update in Centos 6 updated pgbouncer to 1.5. Since then I'm > having this error in the log: no such > > (nodb)/(nouser)@127.0.0.1:50737 Pooler Error: No such user: > > The /etc/pgbouncer_userlist.txt has the user in the format: > > "the_user" "the_password" > > Now I see from this page: > > http://pgbouncer.projects.postgresql.org/doc/config.html#_authentication_file_format > > that the file format changed but pooler error no I don't understand how to generate it. > That page says: > > "See ./etc/mkauth.py for sample script" > > But I don't have that file. Are there other instructions on how to > authenticate with pgbouncer 1.5? I have been using postgresql 9.0 on this > version since the first release. > > I found the problem. Now the config file must be owned by pgbouncer whereas before it was onwed by postgres. Clodoaldo -------------- next part -------------- An HTML attachment was scrubbed... URL: Previous message: [Pgbouncer-general] How to generate auth file? Next message: [Pgbouncer-general] PGBouncer help (how to get it working) Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] More information about the Pgbouncer-general mailing list
you've just setup PgBouncer, and you're getting errors such as `closing because: No such user: *****` , especially if you've installed on CentOS the problem may be simple. First. verify that you can actually log in into the PostgreSQL directly using the same username and password. Once confirmed, it's time to check your file permissions. If you're use PgBouncer, you're probably using a user list, specified by `auth_file` in the `pgbouncer.ini` file. You need to ensure that that file is readable by the same user that the PgBouncer process runs as. If you've installed via yum on CentOS, that would be the aptly named `pgbouncer` user. Solving the problem is then as simple as: chown pgbouncer:pgbouncer /etc/pgbouncer/userlist.txt Leave a Reply Click here to cancel reply. Name (required) Email (required) Website Comment (required) Search for: Categories ASP.NET Django Linux Miscellaneous Sysadmin Wordpress Archives October 2016 September 2016 June 2016 February 2016 January 2016 September 2015 July 2015 June 2015 April 2015 April 2014 February 2014 October 2013 © Arthur Pemberton 2010 - 2016 | Lost • Mobile Version