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 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