CODEWITHSUNDEEP
voiptelecommunicationopensips
Kamal Panhwar
Kamal Panhwar

Reputation: 2399

Saving cdrs manually using avp_db_query in Opensips

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.

Upvotes: 1

Views: 302

Answers (1)

Liviu Chircu
Liviu Chircu

Reputation: 1039

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(...);
}

Upvotes: 1

Related Questions