<div dir="ltr"><div class="gmail_quote">hi Daniel,</div><div class="gmail_quote"><br></div><div class="gmail_quote">Thanks a lot for your reply,</div><div class="gmail_quote"><br></div><div class="gmail_quote">in "homer_data" database has following tables,</div><div class="gmail_quote"><br></div><div class="gmail_quote">logs_capture<br></div><div class="gmail_quote">report_capture<br></div><div class="gmail_quote">rtcp_capture<br></div><div class="gmail_quote">sip_capture<br></div><div class="gmail_quote"><br></div><div class="gmail_quote">sip_capture_call_20150407<br></div><div class="gmail_quote">sip_capture_registration_20150407<br></div><div class="gmail_quote">sip_capture_rest_20150407<br></div><div class="gmail_quote"><br></div><div class="gmail_quote">if i try to call as mentioned kamailio server try to put data to 'homer_data.sip_capture_call_20160223' table</div><div class="gmail_quote">but there-are no tables created dynamically or no excising table with date</div><div class="gmail_quote"><br></div><div class="gmail_quote">then i change bellow table names as 'sip_capture_call_20160223' then i can see data on homer ui.</div><div class="gmail_quote">i need to know if i change the table names on kamailio.cfg (removing date part) is it working properly or not ??</div><div class="gmail_quote"><br></div><div class="gmail_quote">-----</div><div class="gmail_quote"><div class="gmail_quote">route[STORE] {</div><div class="gmail_quote"><br></div><div class="gmail_quote"> if($rm == "REGISTER") {</div><div class="gmail_quote"> $var(table) = "sip_capture_registration";</div><div class="gmail_quote"> }</div><div class="gmail_quote"> else if($rm =~ "(INVITE|UPDATE|BYE|ACK|PRACK|REFER|CANCEL)$")</div><div class="gmail_quote"> {</div><div class="gmail_quote"> $var(table) = "sip_capture_call";</div><div class="gmail_quote"> }</div><div class="gmail_quote"> else if($rm =~ "(INFO)$")</div><div class="gmail_quote"> {</div><div class="gmail_quote"> $var(table) = "sip_capture_call";</div><div class="gmail_quote"> }</div><div class="gmail_quote"> else if($rm =~ "(OPTIONS)$" )</div><div class="gmail_quote"> {</div><div class="gmail_quote"> $var(table) = "sip_capture_rest";</div><div class="gmail_quote"> }</div><div class="gmail_quote"> else {</div><div class="gmail_quote"> $var(table) = "sip_capture_rest";</div><div class="gmail_quote"> }</div><div class="gmail_quote"><br></div><div class="gmail_quote"> #For old models. Not accurate insert time. System vs capture time.</div><div class="gmail_quote"> $var(a) = $var(table) + "_" + $timef(%Y%m%d);</div><div class="gmail_quote"> #for Kamailio >4.3 please uncomment this parameters:</div><div class="gmail_quote"> # runscript removed -- $var(a) = $var(table) + "_%Y%m%d";</div><div class="gmail_quote"> $var(a) = $var(table) + "_<b>%Y%m%d"</b>;</div><div class="gmail_quote"><br></div><div class="gmail_quote"> sip_capture("$var(a)");</div><div class="gmail_quote">}</div><div><br></div></div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote">-----</div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote">thanking you</div><div class="gmail_quote">Achintha</div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote"><br></div><div class="gmail_quote">On 24 Feb 2016 13:24, "Daniel-Constantin Mierla" <<a href="mailto:miconda@gmail.com" target="_blank">miconda@gmail.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
Hello,<br>
<br>
have you created the tables required by homer sipcapture?<br>
<br>
I think you have to use the scripts from source tree, path:<br>
<br>
- modules/sipcapture/sql/<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div>On 23/02/16 14:36, Achintha wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">hi ,
<div><br>
<div>we configured homer with kamailio sip capture (server-A)</div>
<div>then i try configured another kamailio with siptrace
(server-B)</div>
<div><br>
</div>
<div>mysql database configured with "homer_data" DB</div>
<div><br>
</div>
<div> i try to call to the second kamailio server using sip
phone but didn't get data on homer ui</div>
<div>then I find an error on kamailio server configured with
homer (server-B) as follows,</div>
<div><br>
</div>
<div>
<div> 5(18128) ERROR: db_mysql [km_dbase.c:128]:
db_mysql_submit_query(): driver error on query: Table
'homer_data.sip_capture_call_20160223' doesn't exist
(1146)</div>
<div> 5(18128) ERROR: <core> [db_query.c:235]:
db_do_insert_cmd(): error while submitting query</div>
</div>
<div><br>
</div>
<div><br>
</div>
<div>kindly help me to solve this</div>
<div><br clear="all">
<div><br>
</div>
-- <br>
<div>Thanking you<br>
Achintha<br>
</div>
</div>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a href="mailto:sr-users@lists.sip-router.org" target="_blank">sr-users@lists.sip-router.org</a>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre cols="72">--
Daniel-Constantin Mierla
<a href="http://twitter.com/#!/miconda" target="_blank">http://twitter.com/#!/miconda</a> - <a href="http://www.linkedin.com/in/miconda" target="_blank">http://www.linkedin.com/in/miconda</a>
Kamailio Advanced Training, Berlin, March 7-9, 2016 - <a href="http://www.asipto.com" target="_blank">http://www.asipto.com</a></pre>
</div>
</blockquote></div>
</div>