Well, I guess i just needed more fiddling.
And I needed to make _absolutely_ 100% sure that my mail client was set
to send mail out through my postfix setup instead of my normal smtp server.
It wasn't. It is now. It all works. tyvm for allowing me to waste
your time.
William Finn wrote:
First, I tried searching the archive, but it doesn
I've set up postfix + dbmail and it all appears to be working fine. I
can send and receive mail ok.
My problem is I want to save copies of all outgoing email in the
database. From what I've read, all I would need to do is setup
postfix's always_bcc or sender_bcc_maps config vars.
I've tried both: always_bcc works for incoming mail only, neither work
for outgoing. The bcc is not sent, there are no error messages &
nothing is in my queue. Right now, everything is set up like:
main.cf:
always_bcc = [EMAIL PROTECTED]
sender_bcc_maps = proxy:mysql:/etc/postfix/mysql/sender_bcc_map.cf
sender_bcc_map.cf:
user = postfixusername
password = postfixdbpassword
hosts = 127.0.0.1
dbname = postfix
query = SELECT recipient_address FROM sender_bcc_map WHERE
sender_address='%s' AND active=1
dbmail database->dbmail_users table:
+-----------+--------------------------------+------------------------------------+-------------+--------------+--------------+-----------------+---------------------+
| user_idnr | userid |
passwd | client_idnr | maxmail_size |
curmail_size | encryption_type | last_login |
+-----------+--------------------------------+------------------------------------+-------------+--------------+--------------+-----------------+---------------------+
| 12 | outgoing | my ultra secret
password | 0 | 0 | 634 |
md5 | 2005-07-25 14:33:04 |
| 13 | ufccopy | my super secret
password | 0 | 0 | 0 |
md5 | 2005-07-25 16:12:45 |
+-----------+--------------------------------+------------------------------------+-------------+--------------+--------------+-----------------+---------------------+
postfix database->sender_bcc_maps table:
+----------------+-------------------+--------+
| sender_address | recipient_address | active |
+----------------+-------------------+--------+
| [EMAIL PROTECTED] | [EMAIL PROTECTED] | 1 |
+----------------+-------------------+--------+
I even tried making the query something stupid like 'select blargg
from nowhere' just to see if send_bcc_map.cf was at least being used.
I never got any error messages.
