Re: Problem with 7.4.5 and webmin 1.8 in grant function

amrit(at)health2(dot)moph(dot)go(dot)th wrote:
>
> I used you perl script and found the error =>
> [root(at)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