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" <mico...@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-us...@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
>
>
_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
