24 Feb
2016
24 Feb
'16
5:55 a.m.
hi Daniel,
Thanks a lot for your reply,
in "homer_data" database has following tables,
logs_capture
report_capture
rtcp_capture
sip_capture
sip_capture_call_20150407
sip_capture_registration_20150407
sip_capture_rest_20150407
if i try to call as mentioned kamailio server try to put data to
'homer_data.sip_capture_call_20160223' table
but there-are no tables created dynamically or no excising table with date
then i change bellow table names as 'sip_capture_call_20160223' then i can
see data on homer ui.
i need to know if i change the table names on kamailio.cfg (removing date
part) is it working properly or not ??
-----
route[STORE] {
if($rm == "REGISTER") {
$var(table) = "sip_capture_registration";
}
else if($rm =~ "(INVITE|UPDATE|BYE|ACK|PRACK|REFER|CANCEL)$")
{
$var(table) = "sip_capture_call";
}
else if($rm =~ "(INFO)$")
{
$var(table) = "sip_capture_call";
}
else if($rm =~ "(OPTIONS)$" )
{
$var(table) = "sip_capture_rest";
}
else {
$var(table) = "sip_capture_rest";
}
#For old models. Not accurate insert time. System vs capture time.
$var(a) = $var(table) + "_" + $timef(%Y%m%d);
#for Kamailio >4.3 please uncomment this parameters:
# runscript removed -- $var(a) = $var(table) + "_%Y%m%d";
$var(a) = $var(table) + "_*%Y%m%d"*;
sip_capture("$var(a)");
}
-----
thanking you
Achintha
On 24 Feb 2016 13:24, "Daniel-Constantin Mierla" <miconda(a)gmail.com>
wrote:
Hello,
have you created the tables required by homer sipcapture?
I think you have to use the scripts from source tree, path:
- modules/sipcapture/sql/
Cheers,
Daniel
On 23/02/16 14:36, Achintha wrote:
hi ,
we configured homer with kamailio sip capture (server-A)
then i try configured another kamailio with siptrace (server-B)
mysql database configured with "homer_data" DB
i try to call to the second kamailio server using sip phone but didn't
get data on homer ui
then I find an error on kamailio server configured with homer (server-B)
as follows,
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)
5(18128) ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while
submitting query
kindly help me to solve this
--
Thanking you
Achintha
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
listsr-users@lists.sip-router.orghttp://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
--
Daniel-Constantin Mierlahttp://twitter.com/#!/miconda -
http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, March 7-9, 2016 - http://www.asipto.com