pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedError In connection ??
6+ messages / 2 participants
[nested] [flat]
* Error In connection ??
@ 2004-11-10 16:32 Goutam Paruchuri <gparuchuri@oneil.com>
2004-11-10 17:19 ` Re: Error In connection ?? Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 6+ messages in thread
From: Goutam Paruchuri @ 2004-11-10 16:32 UTC (permalink / raw)
To: pgsql-sql
Hello,
I get an error in my log when connecting to postgres server on Windows.
Postgres version : 8.0.0-beta4
LOG TEXT
2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
"192.168.2.1/254"
2004-11-10 11:22:47 FATAL: missing or erroneous pg_hba.conf file
2004-11-10 11:22:47 HINT: See server log for details.
Configuration file pg_hba.conf
host all all 192.168.2.1/254 md5
host all all 127.0.0.1/32 md5
Any ideas how to fix it ??
Thanks !
Goutam
Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error In connection ??
2004-11-10 16:32 Error In connection ?? Goutam Paruchuri <gparuchuri@oneil.com>
@ 2004-11-10 17:19 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 6+ messages in thread
From: Richard Huxton @ 2004-11-10 17:19 UTC (permalink / raw)
To: Goutam Paruchuri <gparuchuri@oneil.com>; +Cc: pgsql-sql
Goutam Paruchuri wrote:
> Hello,
>
> I get an error in my log when connecting to postgres server on Windows.
> Postgres version : 8.0.0-beta4
>
> LOG TEXT
>
> 2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
> Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
> "192.168.2.1/254"
> 2004-11-10 11:22:47 FATAL: missing or erroneous pg_hba.conf file
> 2004-11-10 11:22:47 HINT: See server log for details.
>
> Configuration file pg_hba.conf
>
> host all all 192.168.2.1/254 md5
You don't have 254 bits in in IP address. Did you mean /32?
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error In connection ??
@ 2004-11-10 18:11 Goutam Paruchuri <gparuchuri@oneil.com>
2004-11-10 18:30 ` Re: Error In connection ?? Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 6+ messages in thread
From: Goutam Paruchuri @ 2004-11-10 18:11 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
My understanding was it means ip range of 1 to 254.
192.168.2.1 to 192.168.1.254
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com]
> Sent: Wednesday, November 10, 2004 12:19 PM
> To: Goutam Paruchuri
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Error In connection ??
>
>
> Goutam Paruchuri wrote:
> > Hello,
> >
> > I get an error in my log when connecting to postgres server
> on Windows.
> > Postgres version : 8.0.0-beta4
> >
> > LOG TEXT
> >
> > 2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
> > Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
> > "192.168.2.1/254"
> > 2004-11-10 11:22:47 FATAL: missing or erroneous pg_hba.conf file
> > 2004-11-10 11:22:47 HINT: See server log for details.
> >
> > Configuration file pg_hba.conf
> >
> > host all all 192.168.2.1/254 md5
> You don't have 254 bits in in IP address. Did you mean /32?
>
> --
> Richard Huxton
> Archonet Ltd
>
Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error In connection ??
2004-11-10 18:11 Re: Error In connection ?? Goutam Paruchuri <gparuchuri@oneil.com>
@ 2004-11-10 18:30 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 6+ messages in thread
From: Richard Huxton @ 2004-11-10 18:30 UTC (permalink / raw)
To: Goutam Paruchuri <gparuchuri@oneil.com>; +Cc: pgsql-sql
Goutam Paruchuri wrote:
> My understanding was it means ip range of 1 to 254.
>
> 192.168.2.1 to 192.168.1.254
No, it refers to the number of bits. You can use either of:
192.168.2.0 255.255.255.0
192.168.2.0/24
Both of these cover the range:
192.168.2.1 - 192.168.1.255
Might be worth searching for a network howto on CIDR subnet formats.
--
Richard Huxton
Archonet Ltd
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error In connection ??
@ 2004-11-10 18:15 Goutam Paruchuri <gparuchuri@oneil.com>
0 siblings, 0 replies; 6+ messages in thread
From: Goutam Paruchuri @ 2004-11-10 18:15 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
The IP of the client machine aim connecting from is 192.168.2.123
Which is greater than 32.
Thanks !
- Goutam
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com]
> Sent: Wednesday, November 10, 2004 12:19 PM
> To: Goutam Paruchuri
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Error In connection ??
>
>
> Goutam Paruchuri wrote:
> > Hello,
> >
> > I get an error in my log when connecting to postgres server
> on Windows.
> > Postgres version : 8.0.0-beta4
> >
> > LOG TEXT
> >
> > 2004-11-10 11:22:47 LOG: invalid entry in file "C:/Program
> > Files/PostgreSQL/8.0.0-beta4/data/pg_hba.conf" at line 64, token
> > "192.168.2.1/254"
> > 2004-11-10 11:22:47 FATAL: missing or erroneous pg_hba.conf file
> > 2004-11-10 11:22:47 HINT: See server log for details.
> >
> > Configuration file pg_hba.conf
> >
> > host all all 192.168.2.1/254 md5
> You don't have 254 bits in in IP address. Did you mean /32?
>
> --
> Richard Huxton
> Archonet Ltd
>
Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Error In connection ??
@ 2004-11-10 18:38 Goutam Paruchuri <gparuchuri@oneil.com>
0 siblings, 0 replies; 6+ messages in thread
From: Goutam Paruchuri @ 2004-11-10 18:38 UTC (permalink / raw)
To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-sql
Its works if I specify the ipaddress of each client which is being
connecting to the server.
Its hard to do it on a DHCP network . Any roundabouts ?
- Goutam
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com]
> Sent: Wednesday, November 10, 2004 1:30 PM
> To: Goutam Paruchuri
> Cc: pgsql-sql@postgresql.org
> Subject: Re: [SQL] Error In connection ??
>
>
> Goutam Paruchuri wrote:
> > My understanding was it means ip range of 1 to 254.
> >
> > 192.168.2.1 to 192.168.1.254
>
> No, it refers to the number of bits. You can use either of:
> 192.168.2.0 255.255.255.0
> 192.168.2.0/24
> Both of these cover the range:
> 192.168.2.1 - 192.168.1.255
>
> Might be worth searching for a network howto on CIDR subnet formats.
> --
> Richard Huxton
> Archonet Ltd
>
Confidentiality Notice
The information contained in this e-mail is confidential and intended for use only by the person(s) or organization listed in the address. If you have received this communication in error, please contact the sender at O'Neil & Associates, Inc., immediately. Any copying, dissemination, or distribution of this communication, other than by the intended recipient, is strictly prohibited.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-11-10 18:38 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-11-10 16:32 Error In connection ?? Goutam Paruchuri <gparuchuri@oneil.com>
2004-11-10 17:19 ` Richard Huxton <dev@archonet.com>
2004-11-10 18:11 Re: Error In connection ?? Goutam Paruchuri <gparuchuri@oneil.com>
2004-11-10 18:30 ` Richard Huxton <dev@archonet.com>
2004-11-10 18:15 Re: Error In connection ?? Goutam Paruchuri <gparuchuri@oneil.com>
2004-11-10 18:38 Re: Error In connection ?? Goutam Paruchuri <gparuchuri@oneil.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox