John Summerfield <[EMAIL PROTECTED]> writes:
> On Mon, 30 Sep 2002 20:54, Colin Tree wrote:
> > Hi,
> > I'm new to sql-ledger and am having a bit of a problem
> > setting up my database. When I do a create Dataset I get this
> >
> >
> > Error!
> > FATAL 1: IDENT authentication failed for user "sql-colin"
> >
> > My setup is Debian 3.0r0,
> > I've followed the faq to the letter ???
> > my eyes are nearly burnt out,
> > more coffee you say!
>
> postgresql?
>
> Check your configuration. I don't know what the defaults are on Debian, but it
> seems they don't suit you.
the defaults for postgresql on debian gave me problems yesterday also.
I have a fresh debian 3.0r0-box, and have installed postgresql via
apt-get.
I had to change the line in /etc/postgresql/pg_hba.conf saying
something like (taken from memory, my box is at home):
host 127.0.0.1 255.255.255.0 ident
I changed 'ident' to 'md5' and now it works. this assumes of course
that your database server and web server are on the same machine.
regards,
j�rgen
--
j�rgen binningsb� in steepness is safety
- w. c. slingsby
!!! NYTT MOBILNUMMER: 404 738 11 !!!
http://www.pvv.org/~jb
-------------------------------------------------------
This sf.net email is sponsored by: DEDICATED SERVERS only $89!
Linux or FreeBSD, FREE setup, FAST network. Get your own server
today at http://www.ServePath.com/indexfm.htm
-------------------------------------------------------
(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive: http://www.mail-archive.com/[email protected]/