Re: IDENT failed
[email protected] (Jørgen Binningsbø) 01 Oct 2002 11:21:23 +0200
| Newsgroups | gmane.comp.web.sql-ledger.user |
|---|---|
| Message-ID | <[email protected]> |
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]/