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
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 |