Re: Problem with 7.4.5 and webmin 1.8 in grant function - Mailing list pgsql-performance

From amrit@health2.moph.go.th
Subject Re: Problem with 7.4.5 and webmin 1.8 in grant function
Date
Msg-id 1109048458.421abc8a280ed@webmail.moph.go.th
Whole thread Raw
In response to Re: Problem with 7.4.5 and webmin 1.8 in grant function  (Mark Kirkwood <markir@coretech.co.nz>)
Responses Re: Problem with 7.4.5 and webmin 1.8 in grant function
List pgsql-performance
> Ok - I must be looking at the *updated* FC3 distribution...
>
> I may have 'jumped the gun' a little - the situation I describe above
> will prevent *any* access at all to Pg from webmin. If this is the case
> then check you have (perl) DBI and (perl) DBD-Pg components installed.
>
> If on the other hand you can do *some* Pg admin from webmin, and you are
> only having problems with the grants then there is something it does not
> like about the *particular* statement. The way to debug this is to do a
> tiny perl DBI program that tries to execute the statement :
>
> select relname, relacl from pg_class where (relkind = 'r' OR relkind =
> 'S') and relname !~ '^pg_' order by relname
>
> So - sorry to confuse, but let us know which situation you have there :-)
>
> best wishes
>
> Mark
>

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:


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.

Would you give me an idea what's wrong?
Thanks .
Amrit,Thailand

pgsql-performance by date:

Previous
From: Ron Mayer
Date:
Subject: Re: seq scan cache vs. index cache smackdown
Next
From: Mark Kirkwood
Date:
Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function