SLUG Mailing List Archives
Re: [SLUG] SQL-ledger and IDENT fatal error...
- To: Taryn East <slug@xxxxxxxxxxxxx>
- Subject: Re: [SLUG] SQL-ledger and IDENT fatal error...
- From: Howard Lowndes <lannet@xxxxxxxxxxxxx>
- Date: Thu, 18 Aug 2005 08:10:15 +1000
- Cc: slug <slug@xxxxxxxxxxx>
- Organization: LANNet Computing Associates
- User-agent: Mozilla Thunderbird 1.0.6-1.1.fc4 (X11/20050720)
You did restart your Postgresql after you changed pg_hba.conf...?
Taryn East wrote:
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:
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:
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.
LANNet Computing Associates - Your Linux people <http://lannet.com.au>
When you just want a system that works, you choose Linux;
When you want a system that just works, you choose Microsoft.
Flatter government, not fatter government;
Get rid of the Australian states.