[OpenSIPS-Users] acc not writing INVITE to db

[Răzvan Crainea]

Hi, Marcin!

CDRs are based on dialog support. Can you confirm you are creating the 
dialog for the call?

Best regards,

Răzvan Crainea
OpenSIPS Core Developer
http://www.opensips-solutions.com

On 2/16/22 16:53, Marcin Groszek wrote:
> I have narrow down to this route that prevents acc from writing Invite 
> to db,
> 
> When I bypass it Invite gets written to db on BYE:
> 
>   DBG:avpops:ops_dbquery_avps: query [SELECT balance,credit FROM 
> customer  WHERE id = '1';]
>   DBG:db_mysql:mysql_raise_event: MySQL status has not changed: connected
>   DBG:core:db_new_result: allocate 48 bytes for result set at 
> 0x7f7b8a67bbf0
>   DBG:db_mysql:db_mysql_get_columns: 2 columns returned from the query
>   DBG:core:db_allocate_columns: allocate 56 bytes for result columns at 
> 0x7f7b8a67bc50
>   DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7f7b8a67bc60)[0]=[balance]
>   DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
>   DBG:db_mysql:db_mysql_get_columns: RES_NAMES(0x7f7b8a67bc70)[1]=[credit]
>   DBG:db_mysql:db_mysql_get_columns: use DB_STRING result type
>   DBG:core:db_allocate_rows: allocate 80 bytes for result rows and 
> values at 0x7f7b8a67bcb8
>   DBG:db_mysql:db_mysql_str2val: converting STRING [10.096950003999979]
>   DBG:db_mysql:db_mysql_str2val: converting STRING [10]
>   DBG:avpops:db_query_avp_print_results: rows [1]
>   DBG:avpops:db_query_avp_print_results: row [0]
>   DBG:avpops:db_close_query: close avp query
>   DBG:core:db_free_columns: freeing result columns at 0x7f7b8a67bc50
>   DBG:core:db_free_rows: freeing 1 rows
>   DBG:core:db_free_row: freeing row values at 0x7f7b8a67bcc8
>   DBG:core:db_free_rows: freeing rows at 0x7f7b8a67bcb8
>   DBG:core:db_free_result: freeing result set at 0x7f7b8a67bbf0
>   DBG:mathops:w_evaluate_exp: Evaluating expression: 10.096950003999979 
> + 10
>   DBG:mathops:w_evaluate_exp: Evaluating expression: 0.002 * 1000000
>   DBG:mathops:w_evaluate_exp: Evaluating expression: 20.0969500040 * 
> 1000000
>   DBG:mathops:w_evaluate_exp: Evaluating expression: 0.002 / 60
>   DBG:mathops:w_evaluate_exp: Evaluating expression: 0.0000333333 * -1
>   DBG:mathops:w_evaluate_exp: Evaluating expression: 0.0005 / 60
>   DBG:core:comp_scriptvar: int 25 : 2000 / 0
>   DBG:mathops:w_evaluate_exp: Evaluating expression: -0.0000333333 + 
> 0.0000083333
>   DBG:core:comp_scriptvar: int 25 : 2000 / 0
> 
> Any help would be appreciated.
> 
> 
> On 2/15/2022 6:19 PM, Marcin Groszek wrote:
>> I have been using  v3.1.5 and acc module is not behaving as expected:
>>
>> do_accounting("db","cdr|failed");
>>
>> it writes to db on cancel when it hits failure_route[missed_call]
>>
>> But not on BYE. Is there a document how to troubleshoot acc module 
>> behavior?  Can a progress of the module be traced or followed as it 
>> progresses via config script?
>>
>> I see not attempts to write to db upon end of the call, so this is not 
>> an value or extra_fields issue.
>>
>> It has been working for months until I upgraded opensips to 3.1.7, 
>> then I reverse the upgrade and the acc module stopped working. mariadb 
>> has been also upgraded at the same time , but i see all other modules 
>> using same database with no issue.
>>
>>
>>
>>