[SR-Users] getting error on kamailio with homer configurations

[Achintha]

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 at 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 at 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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20160224/3d8bf64a/attachment.html>