Login Failures After Upgrade

From: "Greg Kelley" <gkelley(at)britannicaviation(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Login Failures After Upgrade
Date: 2002-12-16 14:32:48
Message-ID: 005201c2a510$01dd5f20$3501a8c0@greg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Folks,

Just upgraded from 7.1.3 to 7.3 (using RPMs) and now none of the assigned
users can login as before. Tried resetting passwords with 'ALTER USER XXX
WITH PASSWORD='pwd' and it didn't help. pg_hba.conf listing follows:

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local all all
password
host all all 127.0.0.1 255.255.255.255 password
host all all 192.168.1.0 255.255.255.0 password
host all all 24.128.216.179 255.255.255.255 password
host all all 217.33.127.174 255.255.255.248 password

Had to set the first two lines to 'trust' to get apache/php to access data.
Would like to have password protection working again, but can't figure out
what's gone wrong. Any ideas appreciated, thanks.

Rgds,

________________________
Greg Kelley, IT Director
Britannic Aviation, US and UK
US Office:
Pease Int'l Tradeport
68 New Hampshire Ave.
Portsmouth, NH 03801
603.766.3005
http://www.britannicaviation.com
AOPA, EAA, SSA
CFII SEL, MEL; Comm Glider

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Bucanac 2002-12-16 14:56:19 Postgres log statistics
Previous Message Tino Wildenhain 2002-12-16 14:28:46 Re: Total crash of my db-server