[OpenSIPS-Users] Regarding opensips-cp 5.0

Mike Tesliuk mike.tesliuk at ultra.net.br
Sun Aug 4 10:05:14 CEST 2013


The acc table:

CREATE TABLE `acc` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `method` char(16) NOT NULL DEFAULT '',
  `from_tag` char(64) NOT NULL DEFAULT '',
  `to_tag` char(64) NOT NULL DEFAULT '',
  `callid` char(64) NOT NULL DEFAULT '',
  `sip_code` char(3) NOT NULL DEFAULT '',
  `sip_reason` char(32) NOT NULL DEFAULT '',
  `time` datetime NOT NULL,
  `cdr_id` bigint(11) NOT NULL DEFAULT '0',
  `duration` int(11) unsigned NOT NULL DEFAULT '0',
  `setuptime` int(11) unsigned NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `src_uri` varchar(250) DEFAULT NULL,
  `caller_domain` varchar(250) DEFAULT NULL,
  `dst_uri` varchar(250) DEFAULT NULL,
  `callee_domain` varchar(250) DEFAULT NULL,
  `legtype` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `callid_idx` (`callid`)
) ENGINE=MyISAM AUTO_INCREMENT=61660 DEFAULT CHARSET=latin1


Modparam extra information:

modparam("acc", "db_extra",
"src_uri=$fU;caller_domain=$fd;dst_uri=$rU;callee_domain=$rd;legtype=$avp(s:LEG)")


On your route you need to call the DB_FLAG where you call the ACC_DO

With this you should get in your acc table the INVITE and BYE method, with
this information, the stored procedure from opensips-cp should work fine.


2013/8/2 Nandini madhu <sermj2012 at gmail.com>

> Hi Mike Tesliuk,
>
> Thank for your prompt response. I am giving you the acc module parameters
> in from my table and also the script.
> Please have a glance on these and help me
>
> Acc table:
> +------------+------------------+------+-----+---------+----------------+
> | Field      | Type             | Null | Key | Default | Extra          |
> +------------+------------------+------+-----+---------+----------------+
> | id         | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
> | method     | char(16)         | NO   |     |         |                |
> | from_tag   | char(64)         | NO   |     |         |                |
> | to_tag     | char(64)         | NO   |     |         |                |
> | callid     | char(64)         | NO   | MUL |         |                |
> | sip_code   | char(3)          | NO   |     |         |                |
> | sip_reason | char(32)         | NO   |     |         |                |
> | time       | datetime         | NO   |     | NULL    |                |
> | cdr_id     | bigint(11)       | NO   |     | 0       |                |
> | duration   | int(11) unsigned | NO   |     | 0       |                |
> | setuptime  | int(11) unsigned | NO   |     | 0       |                |
> | created    | datetime         | YES  |     | NULL    |                |
> +------------+------------------+------+-----+---------+----------------+
> 12 rows in set (0.00 sec)
>
> And this is my script:
>
>
> loadmodule "acc.so"
> modparam("acc", "failed_transaction_flag", 1)
> modparam("acc", "report_cancels",     0)
> ##modparam("acc", "report_ack",         0)
> modparam("acc", "early_media",        0)
> modparam("acc", "log_level",          1)
> modparam("acc", "log_flag",           1)
> modparam("acc", "log_missed_flag",    1)
> modparam("acc", "cdr_flag", "CDR_FLAG")
> modparam("acc", "db_flag", "DB_FLAG")
> modparam("acc", "db_missed_flag", "DB_MISSED_FLAG")
>
> modparam("acc", "db_url", "mysql://opensips:opensipsrw@opensips/opensips")
> modparam("acc", "db_table_acc", "acc")
> modparam("acc", "acc_method_column", "method")
> modparam("acc", "acc_from_tag_column", "from_tag")
> modparam("acc", "acc_to_tag_column", "to_tag")
> modparam("acc", "acc_callid_column", "callid")
> modparam("acc", "acc_sip_code_column", "sip_code")
> modparam("acc", "acc_sip_reason_column", "sip_reason")
> modparam("acc", "acc_time_column", "time")
>
> route{
>     if (!mf_process_maxfwd_header("10")) {
>         sl_send_reply("483","Too Many Hops");
>         exit;
>     }
>
>     if (has_totag()) {
>         # sequential requests within a dialog should
>         # take the path determined by record-routing
>         if (loose_route()) {
>             if (is_method("BYE")) {
>                 setflag(ACC_DO); # do accounting ...
>                 setflag(ACC_FAILED); # ... even if the transaction fails
>             } else if (is_method("INVITE")) {
>                 # even if in most of the cases is useless, do RR for
>                 # re-INVITEs alos, as some buggy clients do change route
> set
>                 # during the dialog.
>                 record_route();
>             }
>
>             # route it out to whatever destination was set by loose_route()
>             # in $du (destination URI).
>             route(relay);
>         } else {
>             if ( is_method("ACK") ) {
>                 if ( t_check_trans() ) {
>                     # non loose-route, but stateful ACK; must be an ACK
> after
>                     # a 487 or e.g. 404 from upstream server
>                     t_relay();
>                     exit;
>                 } else {
>                     # ACK without matching transaction ->
>                     # ignore and discard
>                     exit;
>                 }
>             }
>             sl_send_reply("404","Not here");
>         }
>         exit;
>     }
>
>     # CANCEL processing
>     if (is_method("CANCEL"))
>     {
>         if (t_check_trans())
>             t_relay();
>         exit;
>     }
>
>     t_check_trans();
>
>     if ( !(is_method("REGISTER")  ) ) {
>         if (from_uri==myself)
>         {
>         } else {
>             # if caller is not local, then called number must be local
>             if (!uri==myself) {
>                 send_reply("403","Rely forbidden");
>                 exit;
>             }
>         }
>     }
>
>     # preloaded route checking
>     if (loose_route()) {
>         xlog("L_ERR",
>         "Attempt to route with preloaded Route's [$fu/$tu/$ru/$ci]");
>         if (!is_method("ACK"))
>             sl_send_reply("403","Preload Route denied");
>         exit;
>     }
>
>     # record routing
>     if (!is_method("REGISTER|MESSAGE"))
>         record_route();
>
>     # account only INVITEs
>     if (is_method("INVITE")) {
>         setflag(ACC_DO); # do accounting
>     }
>
>
>     if (!uri==myself) {
>         append_hf("P-hint: outbound\r\n");
>         route(relay);
>     }
>
>     # requests for my domain
>     if (is_method("PUBLISH|SUBSCRIBE"))
>     {
>         sl_send_reply("503", "Service Unavailable");
>         exit;
>     }
>
>     if (is_method("REGISTER"))
>     {
>         if (   0 ) setflag(TCP_PERSISTENT);
>
>         if (!save("location"))
>             sl_reply_error();
>
>         exit;
>     }
>
>     if ($rU==NULL) {
>         # request with no Username in RURI
>         sl_send_reply("484","Address Incomplete");
>         exit;
>     }
>
>     # do lookup with method filtering
>     if (!lookup("location","m")) {
>         t_newtran();
>         t_reply("404", "Not Found");
>         exit;
>     }
>
>     # when routing via usrloc, log the missed calls also
>     setflag(ACC_MISSED);
>     route(relay);
> }
>
>
> route[relay] {
>     # for INVITEs enable some additional helper routes
>     if (is_method("INVITE")) {
>         t_on_branch("per_branch_ops");
>         t_on_reply("handle_nat");
>         t_on_failure("missed_call");
>     }
>
>     if (!t_relay()) {
>         send_reply("500","Internal Error");
>     };
>     exit;
> }
>
>
> branch_route[per_branch_ops] {
>     xlog("new branch at $ru\n");
> }
>
>
> onreply_route[handle_nat] {
>
>     xlog("incoming reply\n");
> }
>
>
> failure_route[missed_call] {
>     if (t_was_cancelled()) {
>         exit;
>     }
>
>     # uncomment the following lines if you want to block client
>     # redirect based on 3xx replies.
>     ##if (t_check_status("3[0-9][0-9]")) {
>     ##t_reply("404","Not found");
>     ##    exit;
>     ##}
>
> }
>
> Thanks in advance.
>
> Regards
> sermj
>
>
> On Fri, Aug 2, 2013 at 2:16 AM, Mike Tesliuk <mike at ultra.net.br> wrote:
>
>> The CDR module from opensips-cp use the table cdrs, the acc module use
>> the table acc , the opensips-cp use a procedure on mysql to get the
>> information from acc and generate the data on cdrs, this happen through a
>> cron script .
>>
>> you need to generate the accounting to your INVITE too, becuase the
>> procedore check the INVITE and BYE status on the acc table.
>>
>>
>>
>>
>>
>>
>> 2013/8/1 Nandini madhu <sermj2012 at gmail.com>
>>
>>> Dear Shahzad,
>>> Greetings.
>>>
>>> Thanks for the input i will try as per your suggestions and get back to
>>> you.
>>>
>>> Regards,
>>> sermj
>>>
>>>
>>> On Wed, Jul 31, 2013 at 8:55 PM, Muhammad Shahzad <shaheryarkh at gmail.com
>>> > wrote:
>>>
>>>> The acc module params are missing flags for db, you only have flags for
>>>> logging, which actually logs acc data to syslog, also note that flags MUST
>>>> be quoted strings as integer flags have been deprecated in opensips 1.9.x.
>>>> See below link for details,
>>>>
>>>> http://www.opensips.org/html/docs/modules/1.9.x/acc.html#id293425
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> On Wed, Jul 31, 2013 at 12:07 PM, Nandini madhu <sermj2012 at gmail.com>wrote:
>>>>
>>>>> Dear Shahzad,
>>>>>
>>>>> I have tried the above options to know the status. But still i am
>>>>> facing the same problem.
>>>>>
>>>>> I am giving my acc module configuration list please have a glance and
>>>>> advice me please.
>>>>>
>>>>> loadmodule "acc.so"
>>>>> modparam("acc", "failed_transaction_flag", 1)
>>>>> modparam("acc", "report_cancels",     0)
>>>>> ##modparam("acc", "report_ack",         0)
>>>>> modparam("acc", "early_media",        0)
>>>>> modparam("acc", "log_level",          1)
>>>>> modparam("acc", "log_flag",           1)
>>>>> modparam("acc", "log_missed_flag",    1)
>>>>> modparam("acc", "cdr_flag", 1)
>>>>> modparam("acc", "db_url", "mysql://opensips:opensipsrw@opensips
>>>>> /opensips")
>>>>> modparam("acc", "db_table_acc", "acc")
>>>>> modparam("acc", "acc_method_column", "method")
>>>>> modparam("acc", "acc_from_tag_column", "from_tag")
>>>>> modparam("acc", "acc_to_tag_column", "to_tag")
>>>>> modparam("acc", "acc_callid_column", "callid")
>>>>> modparam("acc", "acc_sip_code_column", "sip_code")
>>>>> modparam("acc", "acc_sip_reason_column", "sip_reason")
>>>>> modparam("acc", "acc_time_column", "time")
>>>>>
>>>>> i have given super privileges to opensips user in mysql database
>>>>>
>>>>> Please advice
>>>>>
>>>>> regards
>>>>> sermj
>>>>>
>>>>>
>>>>> On Wed, Jul 31, 2013 at 1:09 PM, Nandini madhu <sermj2012 at gmail.com>wrote:
>>>>>
>>>>>> Dear Shahzad,
>>>>>>
>>>>>> Thank you for your prompt response. i will follow your suggestions
>>>>>> and let you know thank you.
>>>>>>
>>>>>> regards
>>>>>> sermj
>>>>>>
>>>>>>
>>>>>> On Wed, Jul 31, 2013 at 11:48 AM, Muhammad Shahzad <
>>>>>> shaheryarkh at gmail.com> wrote:
>>>>>>
>>>>>>> Check if,
>>>>>>>
>>>>>>> 1. you have set required module parameters for acc module as well,
>>>>>>> most importantly accounting flags.
>>>>>>> 2. you have set those accounting flags in appropriate routes in
>>>>>>> opensips.cfg.
>>>>>>> 3. you acc table is accessible and permitted for opensips (check
>>>>>>> connection string, the user used in it is allowed to insert rows in acc
>>>>>>> table etc).
>>>>>>> 4. you can connect to mysql or whatever backend you are using, and
>>>>>>> see acc table is being populated by opensips during / end of calls.
>>>>>>> 5. your opensips-cp has correct db connection string set to access
>>>>>>> acc table.
>>>>>>>
>>>>>>> one of above should solve your problem.
>>>>>>>
>>>>>>> Thank you.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Jul 31, 2013 at 8:06 AM, Nandini madhu <sermj2012 at gmail.com>wrote:
>>>>>>>
>>>>>>>> Hi all,
>>>>>>>>
>>>>>>>> I am using opensips-cp 5.0 . domain andrtpproxy modules are working
>>>>>>>> fine on myserver (opensips-1.9.1-tls). But i am unable to see CDRviewer in
>>>>>>>> my GUI.
>>>>>>>>
>>>>>>>> I hav loaded required acc module parameters in opensips.cfg file.
>>>>>>>>
>>>>>>>> Please help me
>>>>>>>>
>>>>>>>> Regards,
>>>>>>>> sermj
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> Users mailing list
>>>>>>>> Users at lists.opensips.org
>>>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Mit freundlichen Grüßen
>>>>>>> Muhammad Shahzad
>>>>>>> -----------------------------------
>>>>>>> CISCO Rich Media Communication Specialist (CRMCS)
>>>>>>> CISCO Certified Network Associate (CCNA)
>>>>>>> Cell: +49 176 99 83 10 85
>>>>>>> MSN: shari_786pk at hotmail.com
>>>>>>> Email: shaheryarkh at googlemail.com
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> Users mailing list
>>>>>>> Users at lists.opensips.org
>>>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Users mailing list
>>>>> Users at lists.opensips.org
>>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Mit freundlichen Grüßen
>>>> Muhammad Shahzad
>>>> -----------------------------------
>>>> CISCO Rich Media Communication Specialist (CRMCS)
>>>> CISCO Certified Network Associate (CCNA)
>>>> Cell: +49 176 99 83 10 85
>>>> MSN: shari_786pk at hotmail.com
>>>> Email: shaheryarkh at googlemail.com
>>>>
>>>> _______________________________________________
>>>> Users mailing list
>>>> Users at lists.opensips.org
>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>>
>>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130804/7952d31f/attachment-0001.htm>


More information about the Users mailing list