Postgres

[Hershel Fisch]

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
> 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" <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
>> 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 <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
>>>>  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
>>> use-revolution at lists.runrev.com
>>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>> 
>> 
> - -----------------------------------------------------------
> 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)
> 
> 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
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution