Re: Problem with 7.4.5 and webmin 1.8 in grant function

From: amrit(at)health2(dot)moph(dot)go(dot)th
To: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
Cc: PGsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function
Date: 2005-02-22 05:00:58
Message-ID: 1109048458.421abc8a280ed@webmail.moph.go.th
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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:

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Kirkwood 2005-02-22 05:45:23 Re: Problem with 7.4.5 and webmin 1.8 in grant function
Previous Message Ron Mayer 2005-02-22 01:14:19 Re: seq scan cache vs. index cache smackdown