| 1 |
On Dec 15, 2011 12:52 PM, "Joseph" <syscon780@×××××.com> wrote: |
| 2 |
> |
| 3 |
> On 12/15/11 12:23, Pandu Poluan wrote: |
| 4 |
>> |
| 5 |
>> On Dec 15, 2011 10:55 AM, "Joseph" <syscon780@×××××.com> wrote: |
| 6 |
>> > |
| 7 |
>> > I have postgresql up and running but when I try to connect via apache |
| 8 |
to |
| 9 |
>> postgresql I get an error: |
| 10 |
>> > |
| 11 |
>> > [error] [client 127.0.0.1] DBI |
| 12 |
>> connect('dbname=template1','sql-ledger',...) failed: could not connect |
| 13 |
to |
| 14 |
>> server: Permission denied, referer: http://localhost/sql-ledger/admin.pl |
| 15 |
>> > |
| 16 |
>> > Anybody knows what to look for? |
| 17 |
>> > |
| 18 |
>> > -- |
| 19 |
>> > Joseph |
| 20 |
>> > |
| 21 |
>> |
| 22 |
>> Check pg_hba.conf |
| 23 |
>> |
| 24 |
>> Rgds, |
| 25 |
> |
| 26 |
> |
| 27 |
> I did, it is identical to my other working systems: |
| 28 |
> local all all trust |
| 29 |
> |
| 30 |
> here are other details: |
| 31 |
> |
| 32 |
> # psql -p 5432 -U postgres |
| 33 |
> psql (9.1.1) |
| 34 |
> Type "help" for help. |
| 35 |
> |
| 36 |
> postgres=# |
| 37 |
> Available PostgreSQL Slots |
| 38 |
> 9.1 * server-9.1.1 base-9.1.1 |
| 39 |
> |
| 40 |
|
| 41 |
Hmmm... |
| 42 |
|
| 43 |
Have you GRANT the 'sql-ledger' user the CONNECT privilege to the database? |
| 44 |
|
| 45 |
Rgds, |
Archives