<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
<div>Hallo,</div><div>mein Postfix speichert soweit ich weiß alle eMails sowohl Spam als auch normale in einer mySQLDB.</div><div>Falls du Amavisd-new im Einsatz hast geht das ganze sehr einfach.</div><div><br></div><div>Man trägt einfach in der Amavis config (50-user) folgendes ein:</div><div><br class="webkit-block-placeholder"></div><div>Hier Debian(getrennte Configs, glaube auf anderen Systemen ist es eine große Config):</div><div><br class="webkit-block-placeholder"></div><div><div>#using the 'sql:' method to store quarantined message to a SQL database:</div><div>$virus_quarantine_method = $spam_quarantine_method =</div><div> $banned_files_quarantine_method = $bad_header_quarantine_method = 'sql:';</div><div><br class="webkit-block-placeholder"></div><div>$sql_select_policy = 'SELECT *,users.id FROM users,policy'.</div><div> ' WHERE (users.policy_id=policy.id) AND (users.email IN (%k))'.</div><div> ' ORDER BY users.priority DESC';</div><div><br class="webkit-block-placeholder"></div><div># Meine mySQL User heißen amavis_r und amavis_rw, danach kommt das jeweilige passwort</div><div># </div><div>@lookup_sql_dsn = ( ['DBI:mysql:dbname=amavis;host=localhost;port=5432', 'amavis_r', 'pw_r']);</div><div>@storage_sql_dsn = ( ['DBI:mysql:dbname=amavis;host=localhost;port=5432', 'amavis_rw', 'pw_rw']);</div></div><div><br class="webkit-block-placeholder"></div><div><br class="webkit-block-placeholder"></div><div>Die Datenbankstruktur zum importieren gibt es hier:</div><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://misc.matthias-balke.de/daten/amavis.sql">http://misc.matthias-balke.de/daten/amavis.sql</a></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br class="webkit-block-placeholder"></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Hoffe das ist das was du suchst...</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br class="webkit-block-placeholder"></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br class="webkit-block-placeholder"></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Mit freundlichen Grüßen</div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><br class="webkit-block-placeholder"></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; ">Matthias B.</div></div><br></body></html>