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.
Regards,
irked postfix/dbmail newbie
