From mboxrd@z Thu Jan 1 00:00:00 1970 Received: from pigeon.gentoo.org ([208.92.234.80] helo=lists.gentoo.org) by finch.gentoo.org with esmtp (Exim 4.60) (envelope-from ) id 1RbKSy-0006Hy-2z for garchives@archives.gentoo.org; Thu, 15 Dec 2011 23:11:56 +0000 Received: from pigeon.gentoo.org (localhost [127.0.0.1]) by pigeon.gentoo.org (Postfix) with SMTP id DBE9421C229; Thu, 15 Dec 2011 23:11:45 +0000 (UTC) Received: from svr-us4.tirtonadi.com (svr-us4.tirtonadi.com [69.65.43.212]) by pigeon.gentoo.org (Postfix) with ESMTP id C894F21C19D for ; Thu, 15 Dec 2011 23:10:45 +0000 (UTC) Received: from mail-wi0-f181.google.com ([209.85.212.181]) by svr-us4.tirtonadi.com with esmtpsa (TLSv1:RC4-SHA:128) (Exim 4.69) (envelope-from ) id 1RbKRp-002u6X-7B for gentoo-user@lists.gentoo.org; Fri, 16 Dec 2011 06:10:45 +0700 Received: by wibhq2 with SMTP id hq2so132547wib.40 for ; Thu, 15 Dec 2011 15:10:41 -0800 (PST) Precedence: bulk List-Post: List-Help: List-Unsubscribe: List-Subscribe: List-Id: Gentoo Linux mail X-BeenThere: gentoo-user@lists.gentoo.org Reply-to: gentoo-user@lists.gentoo.org MIME-Version: 1.0 Received: by 10.180.104.2 with SMTP id ga2mr10663276wib.33.1323990594109; Thu, 15 Dec 2011 15:09:54 -0800 (PST) Received: by 10.223.103.70 with HTTP; Thu, 15 Dec 2011 15:09:53 -0800 (PST) Received: by 10.223.103.70 with HTTP; Thu, 15 Dec 2011 15:09:53 -0800 (PST) In-Reply-To: References: <20111215035436.GE9747@syscon4.inet> <20111215055134.GF9747@syscon4.inet> <20111215135243.GH9747@syscon4.inet> Date: Fri, 16 Dec 2011 06:09:53 +0700 Message-ID: Subject: Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied From: Pandu Poluan To: gentoo-user@lists.gentoo.org Content-Type: multipart/alternative; boundary=f46d041827300c411904b42995e0 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - svr-us4.tirtonadi.com X-AntiAbuse: Original Domain - lists.gentoo.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - poluan.info X-Archives-Salt: 4027b799-a93a-4808-91a6-d83eefafe153 X-Archives-Hash: 27528a1f2ccbc0ac0b1e436274d7a829 --f46d041827300c411904b42995e0 Content-Type: text/plain; charset=UTF-8 On Dec 16, 2011 5:49 AM, "Pandu Poluan" wrote: > > > On Dec 16, 2011 5:46 AM, "Pandu Poluan" wrote: > > > > > > On Dec 15, 2011 8:52 PM, "Joseph" wrote: > > > > > > On 12/15/11 16:11, Pandu Poluan wrote: > > >> > > >> > > >> Hmmm... > > >> > > >> Have you GRANT the 'sql-ledger' user the CONNECT privilege to the > > >> database? > > >> > > >> Rgds, > > > > > > > > > After installing postgresql I run: > > > emerge --config =dev-db/postgresql-server-9.1.1 > > > > > > started postgresql-9.1 > > > # su - postgres > > > postgres@syscon5 ~ $ createuser -d sql-ledger > > > y > > > y > > > exit > > > > > > that was it. > > > > > > # psql -U postgres -l > > > List of databases > > > Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- > > > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + > > > | | | | | postgres=CTc/postgres > > > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + > > > | | | | | postgres=CTc/postgres > > > -- > > > Joseph > > > > > > > Okay, according to the documentation on GRANT, "=c/postgres" means the public is granted "CONNECT" privilege, granted by the user postgres. So no problem there. > > > > Hmm... wonder what's wrong... > > > > Okay, I'm grasping at straws currently... how does the offending line in admin.pl look like? > > Rgds, Some thoughts : if the line is correct, the problem might be in how you configured Apache. Here's a reference : http://cpanforum.com/threads/1268 Rgds, --f46d041827300c411904b42995e0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable


On Dec 16, 2011 5:49 AM, "Pandu Poluan" <pandu@poluan.info> wrote:
>
>
> On Dec 16, 2011 5:46 AM, "Pandu Poluan" <pandu@poluan.info> wrote:
> >
> >
> > On Dec 15, 2011 8:52 PM, "Joseph" <syscon780@gmail.com> wrote:
> > >
> > > On 12/15/11 16:11, Pandu Poluan wrote:
> > >>
> > >>
> > >> =C2=A0Hmmm...
> > >>
> > >> =C2=A0Have you GRANT the 'sql-ledger' user the C= ONNECT privilege to the
> > >> =C2=A0database?
> > >>
> > >> =C2=A0Rgds,
> > >
> > >
> > > After installing postgresql I run:
> > > emerge --config =3Ddev-db/postgresql-server-9.1.1
> > >
> > > started postgresql-9.1
> > > # su - postgres
> > > postgres@syscon5 ~ $ createuser -d sql-ledger
> > > =C2=A0 y
> > > =C2=A0 y
> > > exit
> > >
> > > that was it.
> > >
> > > # psql -U postgres -l
> > > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0List of database= s
> > > =C2=A0 Name =C2=A0 =C2=A0| =C2=A0Owner =C2=A0 | Encoding | = =C2=A0 Collate =C2=A0 | =C2=A0 =C2=A0Ctype =C2=A0 =C2=A0| =C2=A0 Access pri= vileges =C2=A0 -----------+----------+----------+-------------+------------= -+-----------------------
> > > =C2=A0postgres =C2=A0| postgres | UTF8 =C2=A0 =C2=A0 | en_US= .UTF-8 | en_US.UTF-8 | =C2=A0template0 | postgres | UTF8 =C2=A0 =C2=A0 | en= _US.UTF-8 | en_US.UTF-8 | =3Dc/postgres =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0+=
> > > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | postgres=3D= CTc/postgres
> > > =C2=A0template1 | postgres | UTF8 =C2=A0 =C2=A0 | en_US.UTF-= 8 | en_US.UTF-8 | =3Dc/postgres =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0+
> > > =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0| =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 | =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | postgres=3D= CTc/postgres
> > > --
> > > Joseph
> > >
> >
> > Okay, according to the documentation on GRANT, "=3Dc/postgre= s" means the public is granted "CONNECT" privilege, granted = by the user postgres. So no problem there.
> >
> > Hmm... wonder what's wrong...
> >
>
> Okay, I'm grasping at straws currently... how does the offending l= ine in admin.pl look like?
>
> Rgds,

Some thoughts : if the line is correct, the problem might be in how you = configured Apache. Here's a reference :

http://cpanforum.com/thre= ads/1268

Rgds,

--f46d041827300c411904b42995e0--