Hi Sebastian,


Thanks, that's what I would like to avoid =)


/Tobias




From: sr-users <sr-users-bounces@lists.sip-router.org> on behalf of Sebastian Damm <damm@sipgate.de>
Sent: Wednesday, January 25, 2017 9:47 AM
To: Daniel-Constantin Mierla; Kamailio (SER) - Users Mailing List
Subject: Re: [SR-Users] Event when acc is written?
 
Hi,

On Wed, Jan 25, 2017 at 9:26 AM, Daniel-Constantin Mierla <miconda@gmail.com> wrote:
To some extent you may be able to do it in configuration file by replacing the acc default behaviour with sqlops. The records are written by mysql when 200ok is received (which can be caught via an onreply_route) or a final negative response is handled (which can be caught via a failure_route). There you can use acc_db_request() to write the record to database and then sqlops to retrieve the ID. Just an idea by now, but it seems to be doable ...

Be careful with own-built accounting. We did this on a system once, and you really have to make sure you account the correct reply. For instance if the call is forked by kamailio, you might get a 486 from one device and later a 200 OK from the other one. If you only take the first reply, you might end up with wrong call state. 

Regards,
Sebastian