title: gammu-smsd SQL Query Customization
body: <p>I've a Problem with the gammu smsd-daemon. I wan't to customize some mysql querys to write something into my database.</p>
  
  <p>I found this
  <a href="http://wammu.eu/docs/manual/smsd/sql.html#gammu-smsd-sql" rel="nofollow">http://wammu.eu/docs/manual/smsd/sql.html#gammu-smsd-sql</a></p>
  
  <p>So I added this line to my config:</p>
  
  <p><code>[sql]</code></p>
  
  <p><code>refresh_phone_state = "UPDATE</code>state<code>set</code>signal<code>='%2',</code>battery<code>='%1' WHERE</code>id<code>='1'"</code></p>
  
  <p>Then I killed all smsd Instances and restarted the smsd-daemon but the refresh_phone_state is always the same, my table state is never touched:</p>
  
  <p><code>May 24 18:43:01 debian gammu-smsd[2567]: Execute SQL: UPDATE</code>phones<code>SET</code>TimeOut<code>= (NOW() + INTERVAL 10 SECOND)+0,</code>Battery<code>= 0,</code>Signal<code>= 57 WHERE</code>IMEI<code>= '354483029016862'</code></p>
  
  <p>My config file is this:
  <a href="http://pastie.org/pastes/3961819/text?key=kbkpmkalyybediaqxfb1a" rel="nofollow">http://pastie.org/pastes/3961819/text?key=kbkpmkalyybediaqxfb1a</a></p>
  
  <p>What did I wrong?</p>