You could get creative with your SQL queries:<br><br>    'upd_msg' =><br>      'UPDATE msgs SET content=?, quar_type=?, quar_loc=?, dsn_sent=?,'.<br>      ' spam_level=?, message_id=?, from_addr=?, subject=LEFT(?, null), client_addr=?,'.<br>      ' originating=?'.<br>      ' WHERE partition_tag=? AND mail_id=?',<br><br>MySQL Manual:<br><blockquote><a class="link" href="http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_left"><code class="literal">LEFT(<em class="replaceable"><code>str</code></em>,<em class="replaceable"><code>len</code></em>)</code></a>
        <p>
          Returns the leftmost <em class="replaceable"><code>len</code></em> characters
          from the string <em class="replaceable"><code>str</code></em>, or
          <code class="literal">NULL</code> if any argument is
          <code class="literal">NULL</code>.
        </p></blockquote>The only time the subject is visible from the SQL server would be during the update when monitoring the server with SHOW PROCESSLIST;<br><br><br><div class="gmail_quote">On 24 October 2014 21:05, Mark Martinec <span dir="ltr"><<a href="mailto:Mark.Martinec+amavis@ijs.si" target="_blank">Mark.Martinec+amavis@ijs.si</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Carsten,<span class=""><br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
how can i turn off subject logging in SQL?<br>
Everything else should be logged, but not the subject, due to privacy reasons.<br>
</blockquote>
<br></span>
It is not configurable, you'd need to change the code, e.g.:<br>
<br>
<br>
--- amavisd~    2014-10-24 20:52:43.705420534 +0200<br>
+++ amavisd     2014-10-24 21:03:09.181378822 +0200<br>
@@ -26855,4 +26855,5 @@<br>
                         $m_id, $from, $subj);<br>
       # update message record with additional information<br>
+      $subj = '';  # privacy reasons<br>
       $conn_h->execute($upd_msg,<br>
                $content_type, $q_type, $q_to, $dsn_sent,<br>
<br>
<br>
Mark<br>
</blockquote></div><br>