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.
--
Best Regards:
Marcin Groszek
Business Voip Resource.
http://www.voipplus.net
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
