----- Original Message ----- From: "William Finn" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Monday, July 25, 2005 8:24 PM
Subject: [Dbmail] sender_bcc_map


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
_______________________________________________
Dbmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail


Reply via email to