[EMAIL PROTECTED] wrote:
I get the following error when I try to use dbmail-smtp:
dbmail/smtp[28737]: dbconnect(): PQconnectdb failed: FATAL: no PostgreSQL
username specified in startup packet
dbmail/smtp[28737]: main(): database connection failed
I try sending the email as user dbmail. Postgresql is working, as is the MTA
(qmail). On the command line, I tried:
echo "test" | dbmail-smtp -d "[EMAIL PROTECTED]"
but I get the same error. Any help would be appreciated.
Thanks,
Fei
_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
Hi, you must tell the dbmail with which user (and pass) you may connect
to the database and dbmail-tables (read & write - rights needed).
that is done in the /etc/dbmail.conf - file in the [DBMAIL] section ...
(here a short example)
******
[DBMAIL]
sqlport=PORT TO POSTGRES (i don't realy know if that is needed by
postgres, if not put it away by uncommenting it .. ;-)
host=DATABASE-HOST (IP of your maschine or just "localhost" or "127.0.0.1")
user=USER (User wich may connect to the db)
pass=PASS (password ...)
db=dbmail (your database-name with the tables of dbmail)
**************
You must set also the permissions for that file (dbmail.conf) that
dbmail-smtp and all other dbmail-programms may access it (read it )
simply type "chmod 644 /etc/dbmail.conf"
that should it be ....
