pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
md5 is invalid?
2+ messages / 2 participants
[nested] [flat]

* md5 is invalid?
@ 2004-03-29 00:25  Robert C Paulsen Jr <robert@paulsenonline.net>
  0 siblings, 1 reply; 2+ messages in thread

From: Robert C Paulsen Jr @ 2004-03-29 00:25 UTC (permalink / raw)
  To: pgsql-admin


I am trying to setup postgresql 7.4.2 on Red Hat Enterprise ver 3.0.

I installed every rpm from the download directory:

        $ rpm -qa | grep postgres
        postgresql-docs-7.4.2-1PGDG
        postgresql-contrib-7.4.2-1PGDG
        postgresql-test-7.4.2-1PGDG
        postgresql-libs-7.4.2-1PGDG
        postgresql-debuginfo-7.4.2-1PGDG
        postgresql-pl-7.4.2-1PGDG
        postgresql-7.4.2-1PGDG
        postgresql-devel-7.4.2-1PGDG
        postgresql-python-7.4.2-1PGDG
        postgresql-server-7.4.2-1PGDG
        postgresql-tcl-7.4.2-1PGDG
        postgresql-jdbc-7.4.2-1PGDG

I did "initdb -W -D /var/lib/pgsql/data" and it apparently worked.

I added a line to pg_hba.conf:

        host    all     192.168.0.0     255.255.255.0   md5

I started the server via "service postgresql start" and it appears to be
running OK.

I tried to log into the server (from userid postgres) but it failed:

        $ psql template1
        psql: FATAL:  missing or erroneous pg_hba.conf file
        HINT:  See server log for details.
        
The log file shows:

        LOG:  invalid entry in pg_hba.conf file at line 67, token "md5"
        FATAL:  missing or erroneous pg_hba.conf file
        HINT:  See server log for details.







^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: md5 is invalid?
@ 2004-03-29 00:44  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Robert C Paulsen Jr <robert@paulsenonline.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2004-03-29 00:44 UTC (permalink / raw)
  To: Robert C Paulsen Jr <robert@paulsenonline.net>; +Cc: pgsql-admin

Robert C Paulsen Jr <robert@paulsenonline.net> writes:
> I added a line to pg_hba.conf:
>         host    all     192.168.0.0     255.255.255.0   md5

You're a field short ... apparently you are reading pre-7.4
documentation about the format of pg_hba.conf.  It's unhappy because
"md5" doesn't look like a valid IP mask.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-03-29 00:44 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-29 00:25 md5 is invalid? Robert C Paulsen Jr <robert@paulsenonline.net>
2004-03-29 00:44 ` Tom Lane <tgl@sss.pgh.pa.us>

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