hershrev at realtorsgroup.us
Tue Feb 8 21:12:32 CST 2005
On 2/8/05 10:48 AM, "Frank D. Engel, Jr." <fde101 at fjrhome.net> 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
> 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.
> 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" <janschenkel at yahoo.com> 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
>> 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 Fisch <hershrev at realtorsgroup.us> 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
>>>> # "local" is for Unix domain socket connections only
>>>> local all all
>>>> # IPv4 local connections:
>>>> host all all 127.0.0.1/32
>>>> host all all 192.168.1.101
>>>> trust # this is the
>>>> line I added .
>>>> # IPv6 local connections:
>>>> host all all ::1/128
>>>> The error " FATAL: missing or erroneous pg_hba.conf
>>>> 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
>>> Hope this helped,
>>> Jan Schenkel.
>>> Quartam - Tools for Revolution
>>> "As we grow older, we grow both wiser and more foolish at the same
>>> time." (La
>>> Do you Yahoo!?
>>> The all-new My Yahoo! - What will yours do?
>>> use-revolution mailing list
>>> use-revolution at lists.runrev.com
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
> - -----------------------------------------------------------
> Frank D. Engel, Jr. <fde101 at fjrhome.net>
> $ 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)
> -----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
> use-revolution at lists.runrev.com
More information about the use-livecode