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 <gentoo-user+bounces-132502-garchives=archives.gentoo.org@lists.gentoo.org>)
	id 1RbOrN-0008Ku-4R
	for garchives@archives.gentoo.org; Fri, 16 Dec 2011 03:53:25 +0000
Received: from pigeon.gentoo.org (localhost [127.0.0.1])
	by pigeon.gentoo.org (Postfix) with SMTP id 2F90321C04C;
	Fri, 16 Dec 2011 03:53:07 +0000 (UTC)
Received: from svr-us4.tirtonadi.com (svr-us4.tirtonadi.com [69.65.43.212])
	by pigeon.gentoo.org (Postfix) with ESMTP id 1877621C169
	for <gentoo-user@lists.gentoo.org>; Fri, 16 Dec 2011 03:51:31 +0000 (UTC)
Received: from mail-we0-f181.google.com ([74.125.82.181])
	by svr-us4.tirtonadi.com with esmtpsa (TLSv1:RC4-SHA:128)
	(Exim 4.69)
	(envelope-from <pandu@poluan.info>)
	id 1RbOpX-000MUK-GM
	for gentoo-user@lists.gentoo.org; Fri, 16 Dec 2011 10:51:31 +0700
Received: by werm12 with SMTP id m12so321118wer.40
        for <gentoo-user@lists.gentoo.org>; Thu, 15 Dec 2011 19:51:26 -0800 (PST)
Precedence: bulk
List-Post: <mailto:gentoo-user@lists.gentoo.org>
List-Help: <mailto:gentoo-user+help@lists.gentoo.org>
List-Unsubscribe: <mailto:gentoo-user+unsubscribe@lists.gentoo.org>
List-Subscribe: <mailto:gentoo-user+subscribe@lists.gentoo.org>
List-Id: Gentoo Linux mail <gentoo-user.gentoo.org>
X-BeenThere: gentoo-user@lists.gentoo.org
Reply-to: gentoo-user@lists.gentoo.org
MIME-Version: 1.0
Received: by 10.216.138.143 with SMTP id a15mr4498wej.11.1324007486798; Thu,
 15 Dec 2011 19:51:26 -0800 (PST)
Received: by 10.223.103.70 with HTTP; Thu, 15 Dec 2011 19:51:26 -0800 (PST)
Received: by 10.223.103.70 with HTTP; Thu, 15 Dec 2011 19:51:26 -0800 (PST)
In-Reply-To: <20111216034210.GK9747@syscon4.inet>
References: <20111215035436.GE9747@syscon4.inet>
	<CAA2qdGVm45dg_U4sRcU4rZMUyh+_vsN3bs=XXdk=JPThiwcExw@mail.gmail.com>
	<20111215055134.GF9747@syscon4.inet>
	<CAA2qdGWfB4tsjGpGyacqS2+AoU7ipGvvxzPrWiKUr7sv_51kQw@mail.gmail.com>
	<20111215135243.GH9747@syscon4.inet>
	<CAA2qdGUQ5xKr6ZxnyCjOOYjpHjxq+aTbfeMLXYuqFnL8yf2aFg@mail.gmail.com>
	<CAA2qdGXQEK4KRc5HQ0NhhUJDqYmzctJR04HqgLYVEvJeUVf0eg@mail.gmail.com>
	<CAA2qdGWCCkpVR8kAPmS2fnVeRmraRxemfE9=u=umt4k36cb6XQ@mail.gmail.com>
	<20111216032838.GJ9747@syscon4.inet>
	<20111216034210.GK9747@syscon4.inet>
Date: Fri, 16 Dec 2011 10:51:26 +0700
Message-ID: <CAA2qdGXnFTusR1Tr+4rRPTM3uAAPXQBd6XyjR5P1mMiyZWd4bA@mail.gmail.com>
Subject: Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied
From: Pandu Poluan <pandu@poluan.info>
To: gentoo-user@lists.gentoo.org
Content-Type: multipart/alternative; boundary=0016e6d784efee3cc204b42d83a3
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: 9f54e1fa-ef25-4d05-8e4c-a1db32e03d00
X-Archives-Hash: 0cfd7088307684f68639fbb62e69159d

--0016e6d784efee3cc204b42d83a3
Content-Type: text/plain; charset=UTF-8

On Dec 16, 2011 10:42 AM, "Joseph" <syscon780@gmail.com> wrote:
>
> On 12/15/11 20:28, Joseph wrote:
>>
>> On 12/16/11 06:09, Pandu Poluan wrote:
>>>
>>>
>>>  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,
>>
>>
>> Thanks for the pointer, that is interesting!
>> How do I check if apache loaded multithreaded MPM module?
>>
>> This is a new machine and everthing is possible.
>>
>> --
>> Joseph
>
>
> It seems to me that my apache is loading both modules:
> ./httpd.conf:LoadModule cgi_module modules/mod_cgi.so
> ./httpd.conf:LoadModule cgid_module modules/mod_cgid.so
>
> but this is identical with my other working server that is functioning
correctly.
>

Honestly, I have no idea whether that's good or ungood. But if the other
servers have no problem...

> dbh = DBI->connect( 'DBI:Pg:dbname=DBNAME','USERNAME','PASSWORD');
>
> I was trying to test this line, but I don't think so I can as I did not
even created the database.
> I'm trying to create dataset using SQL-Ledger apacher web-interface.
>

Hmmm... try GRANTing the user sql-ledger ALL privileges to the database.

Rgds,

--0016e6d784efee3cc204b42d83a3
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<p><br>
On Dec 16, 2011 10:42 AM, &quot;Joseph&quot; &lt;<a href=3D"mailto:syscon78=
0@gmail.com">syscon780@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; On 12/15/11 20:28, Joseph wrote:<br>
&gt;&gt;<br>
&gt;&gt; On 12/16/11 06:09, Pandu Poluan wrote:<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; =C2=A0Some thoughts : if the line is correct, the problem migh=
t be in how you<br>
&gt;&gt;&gt; =C2=A0configured Apache. Here&#39;s a reference :<br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; =C2=A0<a href=3D"http://cpanforum.com/threads/1268">http://cpa=
nforum.com/threads/1268</a><br>
&gt;&gt;&gt;<br>
&gt;&gt;&gt; =C2=A0Rgds,<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; Thanks for the pointer, that is interesting!<br>
&gt;&gt; How do I check if apache loaded multithreaded MPM module?<br>
&gt;&gt;<br>
&gt;&gt; This is a new machine and everthing is possible.<br>
&gt;&gt;<br>
&gt;&gt; -- <br>
&gt;&gt; Joseph<br>
&gt;<br>
&gt;<br>
&gt; It seems to me that my apache is loading both modules:<br>
&gt; ./httpd.conf:LoadModule cgi_module modules/mod_cgi.so<br>
&gt; ./httpd.conf:LoadModule cgid_module modules/mod_cgid.so<br>
&gt;<br>
&gt; but this is identical with my other working server that is functioning=
 correctly.<br>
&gt;</p>
<p>Honestly, I have no idea whether that&#39;s good or ungood. But if the o=
ther servers have no problem... </p>
<p>&gt; dbh =3D DBI-&gt;connect( &#39;DBI:Pg:dbname=3DDBNAME&#39;,&#39;USER=
NAME&#39;,&#39;PASSWORD&#39;);<br>
&gt;<br>
&gt; I was trying to test this line, but I don&#39;t think so I can as I di=
d not even created the database.<br>
&gt; I&#39;m trying to create dataset using SQL-Ledger apacher web-interfac=
e.<br>
&gt;</p>
<p>Hmmm... try GRANTing the user sql-ledger ALL privileges to the database.=
 </p>
<p>Rgds, <br>
</p>

--0016e6d784efee3cc204b42d83a3--