mod-mw: MySQL Works, a module to implement custom SQL queries on requests received

mod-MySQL Works introduction

Have you ever wanted to run some SQL queries personalized with request data received by postfix? Then mod-mw is for you. This module allows you to run customized SQL queries with actual request data on the valvula datbase, postfix database or some other mysql database defined by you.

mod-MySQL Works by example

<mysql-works>
   <with-db-def port="3579" use="valvula" >
      <run-on-request sql="INSERT INTO example_table (sasl_user, mail_from, rcpt_count) VALUES ('#sasl_user#', '#mail-from#', '#rcpt-count#')" />
      <run-every-hour sql="DELETE FROM example_table" />
   </with-db-def>
</mysql-works>