Saving cdrs manually using avp_db_query in Opensips

Question

Is there a way to record cdrs manually using avp_db_query in opensips. I am using ACC table to record cdrs and than running procedure to transfer data to another table. But this put a lot of overhead on my DB due to too many calls. So is there any way that I can put directly cdrs in my actual table using AVP_DB_QUERY, I am doing for missing and not accepted calls but don't know how to do it for Answered calls.

Answer 1

You can program OpenSIPS to push CDR events over to the event interface instead of writing them to the database with:

do_accounting("evi", "cdr|failed");

Next, using the event_route module, you may subscribe to the E_ACC_CDR event by defining the route below, where you can perform your avp_db_query:

event_route [E_ACC_CDR]
{
    fetch_event_params(...);
    avp_db_query(...);
}