Обсуждение: pg_hba.conf
I am trying to use this tool called Zeos Database explorer. Everytime I try to connect to my postgresql RedHat 6.2 box, it tells me that there is no entry in my pg_hba.conf file so that the program has permissions to talk with the database. There are some samples in that file, but they aren't working for me. Would someone that has this working email me a sample entry that would allow everyone from any IP address to connect to the database? Thanks!
I mean: #host all 0.0.0.0 0.0.0.0 trust It was an example in the pg_hba.conf file. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "ShaneMRyan" <ShaneMRyan@hotmail.com> To: <pgsql-general@hub.org> Sent: Wednesday, September 27, 2000 9:45 AM Subject: [GENERAL] pg_hba.conf I am trying to use this tool called Zeos Database explorer. Everytime I try to connect to my postgresql RedHat 6.2 box, it tells me that there is no entry in my pg_hba.conf file so that the program has permissions to talk with the database. There are some samples in that file, but they aren't working for me. Would someone that has this working email me a sample entry that would allow everyone from any IP address to connect to the database? Thanks! Shane M Ryan ShaneMRyan@hotmail.com www.JaguarFutureSolutions.Com
host all 0.0.0.0 0.0.0.0 trust host all 64.0.0.0 255.0.0.0 trust local all trust host all trust host all 127.0.0.1 255.255.255.255 trust This is what mine looks like. ----- Original Message ----- From: "Adam Lang" <aalang@rutgersinsurance.com> To: "ShaneMRyan" <ShaneMRyan@hotmail.com> Cc: "PGSQL General" <pgsql-general@postgresql.org> Sent: Wednesday, September 27, 2000 10:17 AM Subject: Re: [GENERAL] pg_hba.conf > I mean: > > #host all 0.0.0.0 0.0.0.0 trust > > It was an example in the pg_hba.conf file. > > Adam Lang > Systems Engineer > Rutgers Casualty Insurance Company > ----- Original Message ----- > From: "ShaneMRyan" <ShaneMRyan@hotmail.com> > To: <pgsql-general@hub.org> > Sent: Wednesday, September 27, 2000 9:45 AM > Subject: [GENERAL] pg_hba.conf > > > I am trying to use this tool called Zeos Database explorer. Everytime I try > to connect to my postgresql RedHat 6.2 box, it tells me that there is no > entry in my pg_hba.conf file so that the program has permissions to talk > with the database. There are some samples in that file, but they aren't > working for me. Would someone that has this working email me a sample entry > that would allow everyone from any IP address to connect to the database? > Thanks! > > > > > > Shane M Ryan > ShaneMRyan@hotmail.com > www.JaguarFutureSolutions.Com > > > >
On Wed, Sep 27, 2000 at 08:45:04AM -0500, ShaneMRyan wrote: > I am trying to use this tool called Zeos Database explorer. Everytime I > try to connect to my postgresql RedHat 6.2 box, it tells me that there is > no entry in my pg_hba.conf file so that the program has permissions to > talk with the database. There are some samples in that file, but they > aren't working for me. Would someone that has this working email me a > sample entry that would allow everyone from any IP address to connect to > the database? Thanks! You want something like: host all 0.0.0.0 0.0.0.0 trust although this of course insecure because it allows literally anyone from anywhere. If you know you'll be coming from somewhere on your own network you're safer with something like: host all 192.168.1.0 255.255.255.0 trust where 192.168.1/24 is your network. Be aware that the first matching line in pg_hba.conf will be used, so if you have a "reject" line above your "trust" line you may get rejected and not be able to see why. There's a useful section about all of this in Chapter 8 of the Administrator's Guide: http://www.postgresql.org/users-lounge/docs/7.0/admin/security.htm or if you're using 6.5.3: http://www.postgresql.org/users-lounge/docs/6.5/admin/security.htm and "man 5 pg_hba.conf". Richard
It should take two lines: local all trust host all 0.0.0.0 0.0.0.0 trust This will allow anyone anywhere on the network (including the internet, when you are connected to it) to connect to and add/tamper with data in your database. ---------------------------------------------------------------- Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer ---------------------------------------------------------------- On Wed, 27 Sep 2000, ShaneMRyan wrote: > I am trying to use this tool called Zeos Database explorer. Everytime I try to connect to my postgresql RedHat 6.2 box,it tells me that there is no entry in my pg_hba.conf file so that the program has permissions to talk with the database. There are some samples in that file, but they aren't working for me. Would someone that has this working emailme a sample entry that would allow everyone from any IP address to connect to the database? Thanks! > > > > > > Shane M Ryan > ShaneMRyan@hotmail.com > www.JaguarFutureSolutions.Com > >