[prev in list] [next in list] [prev in thread] [next in thread]
List: serusers
Subject: Re: [SR-Users] Generating logging based on SIP messages
From: Grant Bagdasarian <GB () cm ! nl>
Date: 2013-01-28 10:32:59
Message-ID: FB7D97A214987F458242ACBDF876140738C049AD78 () clubvirtual40 ! ClubMessage ! local
[Download RAW message or body]
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 al=
so 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 Ma=
iling 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 p=
oint.
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 t=
his would be a good way to generate logging out of all the SIP messages tha=
t 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 certai=
n 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 on=
ly an idea. I'm just wondering if anyone could give me some pointers into w=
hat 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<mailto: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 -
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
color:black;
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;
mso-fareast-language:EN-US;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1003046310;
mso-list-type:hybrid;
mso-list-template-ids:266900958 68354065 68354073 68354075 68354063 68354073 \
68354075 68354063 68354073 68354075;} @list l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level2
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level3
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level4
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level5
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level6
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
@list l0:level7
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level8
{mso-level-number-format:alpha-lower;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;}
@list l0:level9
{mso-level-number-format:roman-lower;
mso-level-tab-stop:none;
mso-level-number-position:right;
text-indent:-9.0pt;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body bgcolor=white lang=NL link=blue \
vlink=purple><div class=WordSection1><p class=MsoNormal><span \
style='color:#1F497D'>Hello,<o:p></o:p></span></p><p class=MsoNormal><span \
style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US \
style='color:#1F497D'>From what I understand after reading the siptrace and \
sipcapture modules is the following:<o:p></o:p></span></p><p class=MsoNormal><span \
lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if \
!supportLists]><span lang=EN-US style='color:#1F497D'><span \
style='mso-list:Ignore'>1)<span style='font:7.0pt "Times New \
Roman"'> </span></span></span><![endif]><span \
lang=EN-US style='color:#1F497D'>My main kamailio server must use the duplicate_uri \
modparam to send a duplicate of the sip message to the sipcapture \
server<o:p></o:p></span></p><p class=MsoListParagraph \
style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span \
lang=EN-US style='color:#1F497D'><span style='mso-list:Ignore'>2)<span \
style='font:7.0pt "Times New Roman"'> \
</span></span></span><![endif]><span lang=EN-US style='color:#1F497D'>The sipcapture \
server will receive these messages and store them in the \
database<o:p></o:p></span></p><p class=MsoListParagraph \
style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span \
lang=EN-US style='color:#1F497D'><span style='mso-list:Ignore'>3)<span \
style='font:7.0pt "Times New Roman"'> \
</span></span></span><![endif]><span lang=EN-US style='color:#1F497D'>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. <o:p></o:p></span></p><p \
class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span lang=EN-US style='color:#1F497D'>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.<o:p></o:p></span></p><p \
class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p \
class=MsoNormal><span lang=EN-US \
style='color:#1F497D'>Regards,<o:p></o:p></span></p><p class=MsoNormal><span \
lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span \
lang=EN-US style='color:#1F497D'>Grant<o:p></o:p></span></p><p class=MsoNormal><span \
lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span \
lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div><div \
style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p \
class=MsoNormal><b><span lang=EN-US \
style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:NL'>From:</span></b><span \
lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";color:windowtext;mso-fareast-language:NL'> \
sr-users-bounces@lists.sip-router.org [mailto:sr-users-bounces@lists.sip-router.org] \
<b>On Behalf Of </b>Daniel-Constantin Mierla<br><b>Sent:</b> maandag 28 januari 2013 \
10:17<br><b>To:</b> SIP Router - Kamailio (OpenSER) and SIP Express Router (SER) - \
Users Mailing List<br><b>Subject:</b> Re: [SR-Users] Generating logging based on SIP \
messages<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal style='margin-bottom:12.0pt'>Hello,<br><br>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.<br><br>Cheers,<br>Daniel<o:p></o:p></p><div><p \
class=MsoNormal>On 1/24/13 12:41 PM, Grant Bagdasarian \
wrote:<o:p></o:p></p></div><blockquote \
style='margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span \
lang=EN-US>Hello,</span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>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.</span><o:p></o:p></p><p \
class=MsoNormal><span lang=EN-US>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.</span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span lang=EN-US>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.</span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US>Regards,</span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US>Grant</span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span \
lang=EN-US> </span><o:p></o:p></p><p class=MsoNormal><span \
style='font-size:12.0pt;font-family:"Times New \
Roman","serif";mso-fareast-language:NL'><br><br><br><o:p></o:p></span></p><pre>_______________________________________________<o:p></o:p></pre><pre>SIP \
Express Router (SER) and Kamailio (OpenSER) - sr-users mailing \
list<o:p></o:p></pre><pre><a \
href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><o:p></o:p></pre><pre><a \
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><o:p></o:p></pre></blockquote><p \
class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New \
Roman","serif";mso-fareast-language:NL'><br><br><o:p></o:p></span></p><pre>-- \
<o:p></o:p></pre><pre>Daniel-Constantin Mierla - <a \
href="http://www.asipto.com">http://www.asipto.com</a><o:p></o:p></pre><pre><a \
href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a \
href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a><o:p></o:p></pre><pre>Kamailio \
World Conference, April 16-17, 2013, Berlin<o:p></o:p></pre><pre> - <a \
href="http://conference.kamailio.com">http://conference.kamailio.com</a> \
-<o:p></o:p></pre></div></body></html>
_______________________________________________
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
--===============0899559071==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic