<div dir="ltr">Hi Mihaly,<div><br></div><div style>yes, you should use new SQL schema (Version 2) there we use &quot;auth&quot; field to be compatible with PostgresSQL.</div><div style><br></div><div style><a href="https://code.google.com/p/homer/source/browse/sql/create_sipcapture_version_2.sql">https://code.google.com/p/homer/source/browse/sql/create_sipcapture_version_2.sql</a><br>
</div><div style><br></div><div style>we will fix FAQ ASAP.</div><div style><br></div><div style>Wbr,</div><div style>Alexandr</div><div style><br></div><div style><br></div><div style><br></div></div><div class="gmail_extra">
<br><br><div class="gmail_quote">2013/4/2 MÉSZÁROS Mihály <span dir="ltr">&lt;<a href="mailto:misi@niif.hu" target="_blank">misi@niif.hu</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

  

    
  
  <div text="#000000" bgcolor="#FFFFFF">
    Hi Alexandr,<br>
    <br>
    I find few anomalies regarding sipcapture modul.<br>
    May you could correct it?<br>
    <br>
    Issues i found:<br>
    <ol>
      <li>kamailio-4.0.0/modules/sipcapture/sql/create_sipcapture.sql in
        table sip_trace.<br>
        <pre>        `auth` varchar(256) NOT NULL,
</pre>
        but on page <br>
        <br>
<a href="http://code.google.com/p/homer/source/browse/sql/create_sipcapture.sql" target="_blank">http://code.google.com/p/homer/source/browse/sql/create_sipcapture.sql</a><br>
        <pre>        <span></span><span>`</span><span>authorization</span><span>`</span><span> varchar</span><span>(</span><span>256</span><span>)</span><span> </span><span>NOT</span><span> </span><span>NULL</span><span>,</span><span></span>
<span></span></pre>
        So what is the correct? <br>
        I am experiencing problem if i use git version of homer.<br>
         db_mysql [km_dbase.c:122]: driver error on query: Unknown
        column &#39;auth&#39; in &#39;field list&#39;<br>
      </li>
      <li>on 
        <a href="http://kamailio.org/docs/modules/4.0.x/modules/sipcapture.html" target="_blank">http://kamailio.org/docs/modules/4.0.x/modules/sipcapture.html</a><br>
        <br>
        <tt>6. Database setup<br>
          Before running Kamailio with the sipcapture module, you have
          to setup the database tables where the module will store the
          data. For that, if the table were not created by the
          installation script or you choose to install everything by
          yourself you can use the sipcapture_create.sql, SQL script in
          the sql folder of sipcapture module as template. You can also
          find the complete database documentation on the project
          webpage,
          <a href="http://www.kamailio.org/docs/db-tables/kamailio-db-devel.html" target="_blank">http://www.kamailio.org/docs/db-tables/kamailio-db-devel.html</a>.
          <br>
          <br>
        </tt>I couldn&#39;t find any information about sipcapture database
        on this page, not even the complete db doc:<br>
        <a href="http://www.kamailio.org/docs/db-tables/kamailio-db-devel.html" target="_blank">http://www.kamailio.org/docs/db-tables/kamailio-db-devel.html</a></li>
    </ol>
    <p>Many Thanks,<br>
      Misi<br>
    </p>
  </div>

</blockquote></div><br></div>