<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Dear Alexandr,<br>
<br>
Appreciated!<br>
<br>
Thx,<br>
Misi<br>
<br>
On 2013-04-02 18:06, Alexandr Dubovikov wrote:
<blockquote
cite="mid:CAKbiHhxg57yUoZ2sfpw5xGwOT=ngTXBuXZrxZAijcteBYoceTA@mail.gmail.com"
type="cite">
<div dir="ltr">Hi Mihaly,
<div><br>
</div>
<div style="">yes, you should use new SQL schema (Version 2)
there we use "auth" field to be compatible with PostgresSQL.</div>
<div style=""><br>
</div>
<div style=""><a moz-do-not-send="true"
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"><<a moz-do-not-send="true"
href="mailto:misi@niif.hu" target="_blank">misi@niif.hu</a>></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 moz-do-not-send="true"
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 'auth' in 'field list'<br>
</li>
<li>on <a moz-do-not-send="true"
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 moz-do-not-send="true"
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't find any information about sipcapture
database on this page, not even the complete db doc:<br>
<a moz-do-not-send="true"
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>
</blockquote>
<br>
</body>
</html>