X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 9B65ED1EDB9 for ; Mon, 29 Mar 2004 00:25:44 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15302-06 for ; Sun, 28 Mar 2004 20:25:45 -0400 (AST) Received: from hosting33.com (ns1.hosting33.com [203.194.209.173]) by svr1.postgresql.org (Postfix) with SMTP id 193EED1EDB3 for ; Sun, 28 Mar 2004 20:25:42 -0400 (AST) Received: (qmail 1015 invoked from network); 29 Mar 2004 00:25:57 -0000 Received: from unknown (HELO avalon.localdomain) (24.27.14.75) by hosting33.com with SMTP; 29 Mar 2004 00:25:57 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by avalon.localdomain (8.12.10/8.12.10) with ESMTP id i2T0PhwP021261 for ; Sun, 28 Mar 2004 18:25:43 -0600 Subject: md5 is invalid? From: Robert C Paulsen Jr To: pgsql-admin@postgresql.org Content-Type: text/plain Message-Id: <1080519943.21114.18.camel@avalon> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 (1.4.5-1) Date: Sun, 28 Mar 2004 18:25:43 -0600 Content-Transfer-Encoding: 7bit X-Relayed-For: robert%693;carl%693;rita%693; from 24.27.14.75 X-Abuse: Please report spam to abuse@suresupport.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/367 X-Sequence-Number: 12936 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.