The following bug has been logged online:
Bug reference: 1227
Logged by: Tobias
Email address: tobias.kaboth@arcor.de
PostgreSQL version: 7.4.2
Operating system: Fedora Core 2
Description: authentiation failed via web
Details:
Hello,
i tried an DB-update from an old version (?) to 7.4.2 (FC2 package).
I have only a ascii-dump (pg_dumpall) and tried it with psql < file. After
that i can't connect via browser. The webserver and the database is
installed on the same server.
First i add a DB and a user.
My pg_hba.conf:
try 1:
------
local all all ident sameuser
try 2:
------
local all all ident trust
try 3:
------
local all all ident trust
host all all 127.0.0.1 255.255.255.255 trust
try 4:
------
local all all ident trust
host all all 127.0.0.1 255.255.255.255 trust
host all all 192.23.21.137 255.255.255.255 trust
nothing happens in a real way, so i tried to
- created new DBs
- edited ph_hba.conf agn and agn
- granted the tables, views...
- try to give passwords to the DB-users with with psql- and bash-commands.
- edited my DB-dump
- use the -i command
- looked to /var/log/messages for other errors as described on the top
- searching for other logs
- giva a homedir, a password and a shell to user apache
I think it's a bug in the application.
I don't find the right sentences in the docu in the last weeks and i hope
that the bug can found.
I hope it is not my fault.
Greetings,
Tobias