Regarding opensips-cp 5.0

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

Regarding opensips-cp 5.0

Nandini
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
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

shaheryarkh
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 <[hidden email]> 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
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

Nandini
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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

Nandini
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

shaheryarkh
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

Nandini
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
[hidden email]
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: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

Mike Tesliuk
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 <[hidden email]>
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

Nandini
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 <[hidden email]> 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 <[hidden email]>
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

Mike Tesliuk-2
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 <[hidden email]>
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 <[hidden email]> 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 <[hidden email]>
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
Reply | Threaded
Open this post in threaded view
|

Re: Regarding opensips-cp 5.0

Mike Tesliuk
In reply to this post by Nandini
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 <[hidden email]>
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 <[hidden email]> 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 <[hidden email]>
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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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 <[hidden email]> 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
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users




_______________________________________________
Users mailing list
[hidden email]
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: <a href="tel:%2B49%20176%2099%2083%2010%2085" value="+4917699831085" target="_blank">+49 176 99 83 10 85
MSN: [hidden email]
Email: [hidden email]

_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
[hidden email]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users