On Mon, 2004-07-12 at 18:15, Ross Gohlke wrote: > Hi, > > I'm new to DBMail. I have successfully installed DBMail 2.0rc7 on Mac OS > 10.2 (not without adventure). I am trying to run dbmail-adduser, and I > get this output: > > *** dbmail-adduser *** > Opening connection to database... > FATAL: no pg_hba.conf entry for host "::1", user "dbmail", database > "dbmail" > Failed. Could not connect to database (check log) > > I copies dbmail.conf to /etc/, here's the relevant part: > > [DBMAIL] > # Database settings > host=localhost > sqlport=5432 > sqlsocket=/tmp > user=dbmail # user to connect as to database > pass=secret # password for user to database > db=dbmail # name of database > # trace level for dbmail-maintenance > TRACE_LEVEL=5 > > sqlsocket I guessed at. I'm not sure if I'm trying to use tcp/ip or unix > sockets, or both, or which I should want to use! > > In data/pg_hba.conf I have: > host sameuser all 127.0.0.1 255.255.255.255 md5 > local sameuser all md5 >
how about change to host dbmail dbmail 127.0.0.1 255.255.255.255 md5 or add this is for ipv6 host dbmail dbmail ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff md5 > I know my postgresql works. > > I gave up trying to figure out where "host '::1'" is coming from. this is for ipv6 i think And it's trying to connect to localhost using ipv6 > > Any help would be greatly appreciated. I'm excited to try DBMail. > > ross > And DBMail ROCKS ! -- ,''`. Leonel Nunez : :' : http://enelserver.com `. `' DEBIAN GNU/LINUX `- A REAL FREE OS
