X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D64E28B9C84 for ; Tue, 22 Feb 2005 04:58:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07782-05 for ; Tue, 22 Feb 2005 04:58:15 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id B761B8B9E3C for ; Tue, 22 Feb 2005 04:58:13 +0000 (GMT) Received: (qmail 17377 invoked from network); 22 Feb 2005 05:00:59 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 22 Feb 2005 05:00:59 -0000 Received: from webmail.moph.go.th ([127.0.0.1]) by localhost (webmail.moph.go.th [127.0.0.1]) (amavisd-new, port 10024) with SMTP id 15528-40 for ; Tue, 22 Feb 2005 12:00:58 +0700 (ICT) Received: (qmail 17369 invoked from network); 22 Feb 2005 05:00:58 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 22 Feb 2005 05:00:58 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Tue, 22 Feb 2005 12:00:58 +0700 Message-ID: <1109048458.421abc8a280ed@webmail.moph.go.th> Date: Tue, 22 Feb 2005 12:00:58 +0700 From: amrit@health2.moph.go.th To: Mark Kirkwood Cc: PGsql-performance Subject: Re: Problem with 7.4.5 and webmin 1.8 in grant function References: <1108914570.4218b18a2cf0d@webmail.moph.go.th> <42191623.7060401@coretech.co.nz> <1108949685.42193ab53e07c@webmail.moph.go.th> <421A4F96.60803@coretech.co.nz> In-Reply-To: <421A4F96.60803@coretech.co.nz> MIME-Version: 1.0 Content-Type: text/plain; charset=TIS-620 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.3 X-Originating-IP: 203.157.100.42 X-Virus-Scanned: by amavisd-new at moph.go.th X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200502/292 X-Sequence-Number: 10621 > 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