25 Jan
2017
25 Jan
'17
11:26 a.m.
Hello,
On 24/01/2017 18:03, Tobias wrote:
Hi Daniel,
I'd still like the acc record to be written, and then get notified
about that writing was completed, including the mysql ID, callid and
maybe something more, perhaps the whole record written? I'd like a
notification for all writes, i.e. doesn't matter if it's acc.acc or
acc.missed_calls, INVITEs or BYE, etc.
the MySQL ID is specific to MySQL (and maybe few other database
engines), but not involving acc at all. So you can't get that in the
config right now with acc module -- for example the acc module uses the
same mechanism to write the record to syslog or send it to radius, where
no ID is involved.
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 ...
Cheers,
Daniel
Kind regards,
/Tobias
------------------------------------------------------------------------
*From:* sr-users <sr-users-bounces(a)lists.sip-router.org> on behalf of
Daniel-Constantin Mierla <miconda(a)gmail.com>
*Sent:* Tuesday, January 24, 2017 3:02 PM
*To:* Kamailio (SER) - Users Mailing List
*Subject:* Re: [SR-Users] Event when acc is written?
Hello,
On 24/01/2017 12:23, Tobias wrote:
--
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com
Hi!
I'm wondering if there is a way for the acc-module to notify/send an
event to Kamailio (so I can pick it up from the config, similar to
event_route) once the acc-module has performed a write?
As an example I'm using acc and db-mysql to store acc data in MySQL,
but instead of having a service polling the MySQL for new acc's
written I'd like to make Kamailio send an event once an acc-row has
been written. I realize this could most likely be done by using MySQL
triggers "ON INSERT", but I'm wondering if there is another
(reliable) way to do this directly from within Kamailio?
I haven't tested it, but I would guess that if I tried to use for
example event_route[dialog:end] there could be times where the event
would hit Kamailio before the acc-module have written to missed_calls?
Do you still want the acc record to be written in the database or
catch the event before storing and directing it somewhere else?
Cheers,
Daniel
--
Daniel-Constantin Mierla
www.twitter.com/miconda -- www.linkedin.com/in/miconda
Kamailio Advanced Training - Mar 6-8 (Europe) and Mar 20-22 (USA) - www.asipto.com
Kamailio World Conference - May 8-10, 2017 - www.kamailioworld.com
Kamailio World - Our site will be launched soon
<http://www.kamailioworld.com/>
www.kamailioworld.com
the 5th edition May 8-10, 2017 - Berlin, Germany. Website of the event
and more details will be available very soon!
Daniel-Constantin Mierla | LinkedIn <http://www.linkedin.com/in/miconda>
www.linkedin.com
View Daniel-Constantin Mierla’s professional profile on LinkedIn.
LinkedIn is the world's largest business network, helping
professionals like Daniel-Constantin Mierla discover inside
connections to recommended job candidates, industry experts, and
business partners.
miconda (@miconda) | Twitter <http://www.twitter.com/miconda>
www.twitter.com
The latest Tweets from miconda (@miconda). Co-founder and leader of
Kamailio SIP Server project (former OpenSER). C Dev. Open Source RTC
advocate. SIP, VoIP, VoLTE and WebRTC consultancy at Asipto. Berlin,
Germany