On Dec 15, 2011 12:52 PM, "Joseph" <syscon...@gmail.com> wrote:
>
> On 12/15/11 12:23, Pandu Poluan wrote:
>>
>> On Dec 15, 2011 10:55 AM, "Joseph" <syscon...@gmail.com> wrote:
>> >
>> > I have postgresql up and running but when I try to connect via apache
to
>> postgresql I get an error:
>> >
>> > [error] [client 127.0.0.1] DBI
>> connect('dbname=template1','sql-ledger',...) failed: could not connect
to
>> server: Permission denied, referer: http://localhost/sql-ledger/admin.pl
>> >
>> > Anybody knows what to look for?
>> >
>> > --
>> > Joseph
>> >
>>
>> Check pg_hba.conf
>>
>> Rgds,
>
>
> I did, it is identical to my other working systems:
> local all all trust
>
> here are other details:
>
> # psql -p 5432 -U postgres
> psql (9.1.1)
> Type "help" for help.
>
> postgres=#
> Available PostgreSQL Slots
> 9.1 * server-9.1.1 base-9.1.1
>
Hmmm...
Have you GRANT the 'sql-ledger' user the CONNECT privilege to the database?
Rgds,
