On 2/8/05 10:48 AM, "Frank D. Engel, Jr." <[EMAIL PROTECTED]> wrote:
> -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > No, it wouldn't. > > Let's say you want to enable 192.168.0.x, for example (x is anything in > 0..255): > > all all 192.168.0.0 255.255.255.0 trust > > Note: "trust" for a network is a *really* *really* *really* bad idea, > since it does not demand a password from any user, and anyone can just > claim to be "postgres" (the database superuser), and the server will > just "trust" that they are indeed who they claim to be. You should *at > least* use "password", or even better use "md5"... > > all all 192.168.0.0 255.255.255.0 md5 I wish I'd know how to use it, set it. Hershel > > > Note about Subnet Masks: when comparing two given IP addresses to > determine if an incoming connection is part of the specified subnet, so > to speak, both addresses are bitwise ANDed with the subnet mask, and > the result must match. > > So if you really trust the entire world of hackers and virus-writers > with complete and unrestricted access to your database server: > > all all 0.0.0.0 0.0.0.0 trust > > > will probably work. > > On Feb 7, 2005, at 11:58 PM, Hershel Fisch wrote: > >> On 2/7/05 2:45 PM, "Jan Schenkel" <[EMAIL PROTECTED]> wrote: >> Thanks, it works with the addition of 255.255.255.255 . My question >> now if I >> want to enable a range of ip's how do I do that instead of putting a >> whole >> lot of lines , like writing >> All all 0.0.0.0 255.255.255.255 trust >> or leaving it blank >> All all 255.255.255.255 trust >> would work? >> Hershel >> >>> --- Hershel Fisch <[EMAIL PROTECTED]> wrote: >>>> Hi all I'm trying to connect to my postgres 8.0 >>>> server on a osx 10.3 >>>> >>>> >>>> This is a copy from the pg_hpa.con file >>>> >>>> >>>> # TYPE DATABASE USER CIDR-ADDRESS >>>> METHOD >>>> >>>> # "local" is for Unix domain socket connections only >>>> local all all >>>> trust >>>> # IPv4 local connections: >>>> host all all 127.0.0.1/32 >>>> trust >>>> >>>> host all all 192.168.1.101 >>>> trust # this is the >>>> line I added . >>>> >>>> # IPv6 local connections: >>>> host all all ::1/128 >>>> trust >>>> >>>> The error " FATAL: missing or erroneous pg_hba.conf >>>> file." >>>> Thanks a mill. >>>> Ps I reinstalled postgres clean. >>>> Thanks , Hershel >>>> >>> >>> Hi Hershel, >>> >>> I think you forgot to add the subnet-mask at the end >>> of that IP-address 192.168.1.101 -- I think that ought >>> to be /24 but I'm not good with this sort of >>> calculations. However, there are calculators on the >>> internet. >>> >>> Hope this helped, >>> >>> Jan Schenkel. >>> >>> ===== >>> Quartam - Tools for Revolution >>> <http://www.quartam.com> >>> >>> ===== >>> "As we grow older, we grow both wiser and more foolish at the same >>> time." (La >>> Rochefoucauld) >>> >>> >>> >>> __________________________________ >>> Do you Yahoo!? >>> The all-new My Yahoo! - What will yours do? >>> http://my.yahoo.com >>> _______________________________________________ >>> use-revolution mailing list >>> [email protected] >>> http://lists.runrev.com/mailman/listinfo/use-revolution >> >> _______________________________________________ >> use-revolution mailing list >> [email protected] >> http://lists.runrev.com/mailman/listinfo/use-revolution >> >> > - ----------------------------------------------------------- > Frank D. Engel, Jr. <[EMAIL PROTECTED]> > > $ ln -s /usr/share/kjvbible /usr/manual > $ true | cat /usr/manual | grep "John 3:16" > John 3:16 For God so loved the world, that he gave his only begotten > Son, that whosoever believeth in him should not perish, but have > everlasting life. > $ > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.4 (Darwin) > > iD8DBQFCCN9p7aqtWrR9cZoRAsGFAKCEMVI7wSpF7gHgYmZ16unoE5BYNQCfcLGx > XQeR2reyjVYTmzc5ho7SAqI= > =LivA > -----END PGP SIGNATURE----- > > > > ___________________________________________________________ > $0 Web Hosting with up to 120MB web space, 1000 MB Transfer > 10 Personalized POP and Web E-mail Accounts, and much more. > Signup at www.doteasy.com > > _______________________________________________ > use-revolution mailing list > [email protected] > http://lists.runrev.com/mailman/listinfo/use-revolution _______________________________________________ use-revolution mailing list [email protected] http://lists.runrev.com/mailman/listinfo/use-revolution
