[SLUG] SQL-ledger and IDENT fatal error...

[Taryn East <slug@xxxxxxxxxxxxx>]

Hi all, I'm having some issues getting SQL-ledger to work and I'd be
very grateful for any suggestions on where to look next.

Basically, I'm running Ubuntu Hoary. I apt-get installed sql-ledger
(btw, postgres didn't automatically get pulled in when I did that -
should it have?) and set up the database users etc and have logged into
the administration page. I am up to the step that tells me I should do a
"create dataset", but whatever I do (whether I put details in or not) it
gives me the following error:

Error!

FATAL: IDENT authentication failed for user "sql-ledger"


Now I've googled for answers and the FAQs all do mention this error -
they tell me to edit pg_hba.conf and add "local all all trust"

which I tried... to no avail. :(

I googled further to find a suggestion to someone else, mentioning that
they had had two copies around and it was seeing the wrong one...

using find I see that I have both:
/etc/postgresql/pg_hba.conf
/var/lib/postgres/data/pg_hba.conf
so that looks like a distinct possibility...

I was hoping somebody would be able to help me to find out which one is
the "right" one and what I do with it when I do... otherwise if anybody
has any other good suggestions they would also be welcome.

Thanks heaps,
Taryn



-- 
This .sig temporarily out-of-order.
We apologise for any inconvenience
                    - The Management