Re: [SL] Error! Permission denied

[Chris T. <ch...@me...>]

Ross Gohlke wrote:

>When I visit h ttps://mydomain.com/sql-ledger/admin.pl
>
>I first get a login screen with a password field. I enter the password I 
>set in postgres for user 'sql-ledger' and get the Accounting
>Administration screen. I click Pg Database Administration. I leave the 
>defaults alone and click Create Dataset and get:
>
>  
>
Is anything different when  you try to connect to 127.0.0.1?

How far do you get?  Do you get a list of existing datasets?

>Error!
>
>Permission denied
>
>I am a bit unclear on the difference between "local" and "remote"  access.
>Postgres is on the same box as Apache, so when I connect in a  browser, is
>it local or remote?
>
> From data/pg_hba.conf:
>local   template1     sql-ledger             trust
>host    template1         sql-ledger         127.0.0.1/32          trust
>
>  
>
You do realize that this means that unless you add more entries, you 
will be unable to connect to the new database you create, right?

For the record, local means local UNIX domain sockets (basically a pair 
of FIFO's bound to the same filesystem entry) and host means TCP/IP.

>There is nothing in httpd-error.log.
>  
>
What about the serverlog in the Postgresql data directory?

Best Wishes,
Chris Travers
Metatron Technology Conssultign