Re: Problem with 7.4.5 and webmin 1.8 in grant function

amrit@health2.moph.go.th wrote:
>
> I used you perl script and found the error =>
> [root@samba tmp]# perl relacl.pl
> DBI connect('dbname=template1;port=5432','postgres',...) failed: FATAL:  IDENT
> authentication failed for user "postgres" at relacl.pl line 21
> Error in connect to DBI:Pg:dbname=template1;port=5432:
>
>
Excellent - we know what is going on now!


> And my pg_hba.conf is
>
> # IPv4-style local connections:
> host    all         all         127.0.0.1         255.255.255.255   trust
> host    all             all     192.168.0.0     255.255.0.0         trust
>
> trusted for every user.

Ok, what I think has happened is that there is another Pg installation
(or another initdb'ed cluster) on this machine that you are accidentally
talking to. Try

$ rpm -qa|grep -i postgres

which will spot another software installation, you may just have to
search for files called pg_hba.conf to find another initdb'ed cluster....

This other installation should have a pg_hba.conf that looks something
like :

local   all     all                                ident
host    all     all   127.0.0.1  255.255.255.255   ident

So a bit of detective work is in order :-)

Mark