I have installed DBMail 2.0.7 STABLE on FreeBSD 5.3.
I have followed the directions in INSTALL. Everything works until I try
to add a user.
"Opening connection to database...
Failed. Could not connect to database (check log)
Command failed."
Here's the output in /var/log/maillog:
Sep 9 12:35:03 host dbmail/adduser[37229]: dbpgsql.ci,db_connect:
PQconnectdb failed: FATAL: missing or erroneous pg_hba.conf file HINT:
See server log for details.
I start/stop postgres from /usr/local/etc/rc.d/010.pgsql.sh. Here's the
relevant section:
prefix=/usr/local
. /etc/rc.subr
load_rc_config postgresql
postgresql_enable=${postgresql_enable:-"NO"}
postgresql_flags=${postgresql_flags:-"-w -s -m fast -l
/usr/local/pgsql/postgresql.log"}
postgresql_user=pgsql
eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data"}
postgresql_class=${postgresql_class:-"default"}
name=postgresql
rcvar=`set_rcvar`
command=${prefix}/bin/pg_ctl
command_args="-D ${postgresql_data} ${postgresql_flags} $1"
Here is pertinent part of my etc/dbmail.conf
host=localhost # host for database, set to localhost if
sqlport=
sqlsocket=
user=dbmail # user to connect as to database
pass=secret # password for user to database
db=dbmail # name of database
TRACE_LEVEL=5
/usr/local/pgsql/data/pg_hba.conf
local all all trust
I've gotten past this point before, I don't know what's different.
Postgres is not logging anything to /usr/local/pgsql/postgres.log. It is
empty. I don't know how to fix this.
Still, I cannot imagine what would be wrong with pg_hba.conf. I can
successfully use psql from the command line. I've tried multiple
pg_hba.conf configurations, they all reflect properly when using psql.
Any ideas? Thanks.
Ross Gohlke
http://www.grinz.com
