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

[Pandu Poluan]

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,