Hello,

From what I understand after reading the siptrace and sipcapture modules is the following:

1) My main kamailio server must use the duplicate_uri modparam to send a duplicate of the sip message to the sipcapture server

2) The sipcapture server will receive these messages and store them in the database

3) I will use an instead of trigger on the sipcapture table to insert these messages in a database queue for processing by an external service.

Although SIPtrace already stores a sip message in a database, sipcapture also splits each header in the message to  a separate column. This is exactly what I need.

Regards,

Grant

From: sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] On Behalf Of Daniel-Constantin Mierla
Sent: maandag 28 januari 2013 10:17
To: SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - Users Mailing List
Subject: Re: [SR-Users] Generating logging based on SIP messages

Hello,

siptrace module can store directly to a database. It stores some attributes separately, also it can selectively do it only for some requests based on config file. Looking over that part of code in siptrace can be a starting point.

Cheers,
Daniel

On 1/24/13 12:41 PM, Grant Bagdasarian wrote:

Hello,

A while ago I came across the siptrace and sipcapture modules and thought this would be a good way to generate logging out of all the SIP messages that are passed through Kamailio and stored in the siptrace/sipcapture table.

My idea was to extract certain values from SIP messages and store these in our database. Also each SIP Request or Response would be mapped to a certain status so we would be able to monitor which call is in which state.

I still have a lot of work to do to think this all out, since it’s still only an idea. I’m just wondering if anyone could give me some pointers into what to keep in mind when doing this.

Regards,

Grant

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla - http://www.asipto.com
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Kamailio World Conference, April 16-17, 2013, Berlin
 - http://conference.kamailio.com -