Skip site navigation (1) Skip section navigation (2)

md5 is invalid?

From: Robert C Paulsen Jr <robert(at)paulsenonline(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: md5 is invalid?
Date: 2004-03-29 00:25:43
Message-ID: 1080519943.21114.18.camel@avalon (view raw or flat)
Thread:
Lists: 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.





Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2004-03-29 00:44:01
Subject: Re: md5 is invalid?
Previous:From: Tom LaneDate: 2004-03-28 15:36:59
Subject: Re: License for PostgreSQL for commercial purpose

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group