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 524418B9E08 for ; Tue, 22 Feb 2005 15:34:42 +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 03688-04 for ; Tue, 22 Feb 2005 15:34:32 +0000 (GMT) Received: from webmail.moph.go.th (health.moph.go.th [203.157.0.1]) by svr1.postgresql.org (Postfix) with SMTP id 2EED78B9E01 for ; Tue, 22 Feb 2005 15:34:33 +0000 (GMT) Received: (qmail 21804 invoked from network); 22 Feb 2005 15:37:20 -0000 Received: from unknown (HELO localhost) (127.0.0.1) by localhost with SMTP; 22 Feb 2005 15:37:20 -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 21152-18 for ; Tue, 22 Feb 2005 22:37:20 +0700 (ICT) Received: (qmail 21794 invoked from network); 22 Feb 2005 15:37:19 -0000 Received: from unknown (HELO localhost) (203.157.0.1) by health.moph.go.th with SMTP; 22 Feb 2005 15:37:19 -0000 Received: from 203.157.100.42 ([203.157.100.42]) by webmail.moph.go.th (IMP) with HTTP for ; Tue, 22 Feb 2005 22:37:19 +0700 Message-ID: <1109086639.421b51af6edd4@webmail.moph.go.th> Date: Tue, 22 Feb 2005 22:37:19 +0700 From: amrit@health2.moph.go.th To: PGsql-performance Cc: Mark Kirkwood 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> <1109048458.421abc8a280ed@webmail.moph.go.th> <421AC6F3.5010102@coretech.co.nz> In-Reply-To: <421AC6F3.5010102@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/295 X-Sequence-Number: 10624 > > 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: > > > > > 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 After being a detector I found that [root@samba ~]# rpm -qa|grep -i postgres postgresql-7.4.5-3.1.tlc postgresql-python-7.4.5-3.1.tlc postgresql-jdbc-7.4.5-3.1.tlc postgresql-tcl-7.4.5-3.1.tlc postgresql-server-7.4.5-3.1.tlc postgresql-libs-7.4.5-3.1.tlc postgresql-docs-7.4.5-3.1.tlc postgresql-odbc-7.3-8.1.tlc postgresql-pl-7.4.5-3.1.tlc postgresql-test-7.4.5-3.1.tlc postgresql-contrib-7.4.5-3.1.tlc [root@samba ~]# no other pg installation except the pgsql for windows in samba folder which I think it isn't matter ,is it? No other pg being run. [root@samba ~]# ps ax|grep postmaster 2228 ? S 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data 3308 pts/0 S+ 0:00 grep postmaster [root@samba ~]# Is it possible that it is related to pg_ident.conf ? Any comment please. Amrit,Thailand