Re: [gentoo-user] DBI connect dbname=template1 failed Permission denied

[Pandu Poluan]

On Dec 16, 2011 5:49 AM, "Pandu Poluan" <pandu@××××××.info> wrote:
>
>
> On Dec 16, 2011 5:46 AM, "Pandu Poluan" <pandu@××××××.info> wrote:
> >
> >
> > On Dec 15, 2011 8:52 PM, "Joseph" <syscon780@×××××.com> 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,