Menu
▾
▴
Re: [Postgres-xc-general] PGXC PG User connect pooler error.
|
From: Donald K. <don...@gm...> - 2013-05-23 20:14:06
|
Right i did that ... by putting it for the coordinator servers. # IPv4 local connections: host all all 100.100.10.170/24 trust host all all 100.100.10.171/24 trust host all all 100.100.10.178/24 trust #GTM host all all 127.0.0.1/32 md5 host all all 100.100.10.0/24 md5 however, that means there's no password auth occuring at all then? B/c i then tried to connect from another server (a 9.2 db instance which has the client) and another server which had 9.0, I did: psql -h 10.10.0.170 -d testdb -U testuser No password prompt. and no, the pgpass file does not have an entry for these coordinator servers. So in this case that means i'm essentially making the PG-XC instance open to users w/o password auth. When I changed to md5, failed. On Thu, May 23, 2013 at 4:05 PM, Andrei Martsinchyk < and...@gm...> wrote: > Ah, sorry, I forgot to mention that coordinators should also be configured > to accept connections from other coordinators without a password. > Coordinator is sending DDLs to datanodes and coordinators, while DMLs and > SELECTs go only to datanodes. > That's why you are getting the error when trying to execute a DDL. > > > 2013/5/23 Donald Keyass <don...@gm...> > >> Alright i should apologize. I can do DMLs, but I can not do ddls. it >> seems only the postgres sys user can do that. I created a new postgres >> user w/ superuser privs: >> >> CREATE ROLE anotheruser WITH LOGIN PASSWORD 'password123' SUPERUSER >> INHERIT CREATEDB CREATEROLE; >> >> Granting privs, etc... >> Still can't do ddl's. i get the >> "ERROR: Failed to get pooled connections". >> >> when i create the user ... i do it through the coordinator. should I be >> creating user through the datanode on each datanode? >> >> >> On Thu, May 23, 2013 at 11:21 AM, Donald Keyass < >> don...@gm...> wrote: >> >>> actually selecting for the tables works. So I can run queries. But i >>> can't do any dmls or ddls in the database (ie create tables, >>> insert/update/delete). >>> >>> >>> On Thu, May 23, 2013 at 10:59 AM, Donald Keyass < >>> don...@gm...> wrote: >>> >>>> Andrei, >>>> Thanks! That was it. I set the hba for the datanodes as the same as >>>> coordinators. There was no documentation that I saw about the datanodes >>>> hba has to be passwordless (or in trust mode from all coordinators for all >>>> users). >>>> Again, thanks for the help! >>>> >>>> >>>> On Thu, May 23, 2013 at 3:36 AM, Andrei Martsinchyk < >>>> and...@gm...> wrote: >>>> >>>>> Hi Donald, >>>>> >>>>> Please checke your pg_hba.conf on the datanodes, they should allow >>>>> passwordless access from coordinators. >>>>> When coordinator builds up connection string it does not include the >>>>> password. >>>>> >>>>> >>>>> 2013/5/23 Koichi Suzuki <koi...@gm...> >>>>> >>>>>> The following is a typical additional postgresql.conf file lines for >>>>>> coordinators. They're generated by pgxc_ctl utility and works well. >>>>>> Could you compare this with your ones? Especially, I'm interested how you >>>>>> configured pooler_port. >>>>>> >>>>>> Regards; >>>>>> >>>>>> ----8<----8<---- >>>>>> #=========================================== >>>>>> # Added at initialization. 20130523_11:33:33 >>>>>> port = 20004 >>>>>> pooler_port = 20010 >>>>>> gtm_host = 'node13' >>>>>> gtm_port = 20001 >>>>>> # End of Additon >>>>>> ---->8------->8------ >>>>>> >>>>>> >>>>>> ---------- >>>>>> Koichi Suzuki >>>>>> >>>>>> >>>>>> 2013/5/22 Nikhil Sontakke <ni...@st...> >>>>>> >>>>>>> Hi Donald, >>>>>>> >>>>>>> This looks like a user permissions related internal bug in PGXC. >>>>>>> >>>>>>> Regards, >>>>>>> Nikhils >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Thu, May 23, 2013 at 3:13 AM, Donald Keyass < >>>>>>> don...@gm...> wrote: >>>>>>> >>>>>>>> The testdb and user were the very last thing I created after I >>>>>>>> created the node. >>>>>>>> >>>>>>>> >>>>>>>> On Wed, May 22, 2013 at 4:54 PM, Koichi Suzuki < >>>>>>>> koi...@gm...> wrote: >>>>>>>> >>>>>>>>> Did you issue CREATE NODE before you create databases/roles? If >>>>>>>>> you CREATE NODE after you create databases/users, they are not visible to >>>>>>>>> other node and may fall into errors. When you create each node by initdb, >>>>>>>>> you also create gtm's using initgtm, connect all the datanodes/coordinators >>>>>>>>> to the gtm and then issue CREATE NODE before you create anothing else. >>>>>>>>> >>>>>>>>> >>>>>>>>> You can visit >>>>>>>>> https://github.com/koichi-szk/PGXC-Tools/blob/master/pgxc_ctl/pgxc_ctlto look into pgxc_ctl shell script, which takes care of configuration, >>>>>>>>> failover, start and stop the cluster. init_all function will be helpful >>>>>>>>> for you. This shows what you should do to initialize your cluster. The >>>>>>>>> C-version of pgxc_ctl will be included in coming 1.1 release with new >>>>>>>>> Postgres-XC feature. >>>>>>>>> >>>>>>>>> Regards; >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> ------------------------------------------------------------------------------ >>>>>>>> Try New Relic Now & We'll Send You this Cool Shirt >>>>>>>> New Relic is the only SaaS-based application performance monitoring >>>>>>>> service >>>>>>>> that delivers powerful full stack analytics. Optimize and monitor >>>>>>>> your >>>>>>>> browser, app, & servers with just a few lines of code. Try New Relic >>>>>>>> and get this awesome Nerd Life shirt! >>>>>>>> http://p.sf.net/sfu/newrelic_d2d_may >>>>>>>> _______________________________________________ >>>>>>>> Postgres-xc-general mailing list >>>>>>>> Pos...@li... >>>>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> StormDB - http://www.stormdb.com >>>>>>> The Database Cloud >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> Try New Relic Now & We'll Send You this Cool Shirt >>>>>> New Relic is the only SaaS-based application performance monitoring >>>>>> service >>>>>> that delivers powerful full stack analytics. Optimize and monitor your >>>>>> browser, app, & servers with just a few lines of code. Try New Relic >>>>>> and get this awesome Nerd Life shirt! >>>>>> http://p.sf.net/sfu/newrelic_d2d_may >>>>>> _______________________________________________ >>>>>> Postgres-xc-general mailing list >>>>>> Pos...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Andrei Martsinchyk >>>>> >>>>> >>>>> StormDB - http://www.stormdb.com >>>>> The Database Cloud >>>>> >>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Try New Relic Now & We'll Send You this Cool Shirt >>>>> New Relic is the only SaaS-based application performance monitoring >>>>> service >>>>> that delivers powerful full stack analytics. Optimize and monitor your >>>>> browser, app, & servers with just a few lines of code. Try New Relic >>>>> and get this awesome Nerd Life shirt! >>>>> http://p.sf.net/sfu/newrelic_d2d_may >>>>> _______________________________________________ >>>>> Postgres-xc-general mailing list >>>>> Pos...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>>> >>>>> >>>> >>> >> > > > -- > Andrei Martsinchyk > > StormDB - http://www.stormdb.com > The Database Cloud > > |