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 <[email protected]> > 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 > <[email protected]>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 <[email protected]>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 <[email protected]>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 < >>>> [email protected]> 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 <[email protected]>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 >>>>>> [email protected] >>>>>> 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: [email protected] >>>>> Email: [email protected] >>>>> >>>>> _______________________________________________ >>>>> Users mailing list >>>>> [email protected] >>>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>>>> >>>>> >>>> >>> >>> _______________________________________________ >>> Users mailing list >>> [email protected] >>> 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: [email protected] >> Email: [email protected] >> >> _______________________________________________ >> Users mailing list >> [email protected] >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> >> > > _______________________________________________ > Users mailing list > [email protected] > http://lists.opensips.org/cgi-bin/mailman/listinfo/users > >
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
