I added this to pg_hba.conf:
host sameuser all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff md5
reloaded postgresql:
sudo SystemStarter restart PostgreSQL
pg_ctl reload
Also, I changed /etc/dbmail.conf
FROM
sqlsocket=/tmp
TO
sqlsocket=
./dbmail-adduser .........
And it seems to be working like a charm.
Thanks, Leonel!
I wonder if others are in the same boat of not being ipv6-savvy and may
wonder at this same thing?
Leonel Nunez wrote:
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 !
DBMail + PostgreSQL ROLLS!
