Ted;
I have it set up like this:
host all server.ip.number.here 255.255.255.255
password
I'm not sure what (negative) effects the ident and crypt options can
have. Since the database server and the web server are on the same
machine I don't see a problem by not encrypting. If I'm wrong someone
can correct me. This means that the PostgreSQL server is started with
the -i option, meaning that it listens on tcp. You can also set it up
like this to test if the problem is the authentication:
local all
trust
An idea is to check if you have more than 1
pg_hba.conf
file and perhaps are changing the wrong one. As far as I know, Sql
Ledger does not read any of this.
I assume that the users, etc. exist in the database ;-)
Miguel
Ted Pibil wrote:
>Newbie question. I just installed SQL-Ledger onto a clean machine, but
>when I try to go into Database Administration I get the following error:
>
>FATAL 1: IDENT authentication failed for user "postgres".
>
>I am using the postgres userid and template1 for "connect to:".
>
>I read elsewhere that I should change the IDENT in pg_hba.conf to
>encrypt, but it did not make a difference because I do not think the
>file is where SQL-Ledger is looking.
>
>Can someone point me in the right direction? Thank you in advance.
>
>
>
>
>
>
>-------------------------------------------------------
>This sf.net email is sponsored by: Dice - The leading online job board
>for high-tech professionals. Search and apply for tech jobs today!
>http://seeker.dice.com/seeker.epl?rel_code=31
>-------------------------------------------------------
>(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
>Archive: http://www.mail-archive.com/[email protected]/
>
-------------------------------------------------------
This sf.net email is sponsored by: Dice - The leading online job board
for high-tech professionals. Search and apply for tech jobs today!
http://seeker.dice.com/seeker.epl?rel_code=31
-------------------------------------------------------
(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive: http://www.mail-archive.com/[email protected]/
