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@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 list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio Advanced Training, Berlin, March 7-9, 2016 - http://www.asipto.com