<p>For example when ip is "200.108.217.174", destination_ip is stored in sip_capture_call_20170405 as "0.108.217.174"<br>
(testing module sipcapture in kamailio 4.4.0)</p>
<p>here it is: "full sql code sended to mysql in storing", (Captured with tcpdump at port 3306)</p>
<p>insert into <code>sip_capture_rest_20170405</code> (<code>date</code>,<code>micro_ts</code>,<code>method</code>,<code>reply_reason</code>,<code>ruri</code>,<code>ruri_user</code>,<code>from_user</code>,<code>from_tag</code>,<code>to_user</code>,<code>to_tag</code>,<code>pid_user</code>,<code>contact_user</code>,<code>auth_user</code>,<code>callid</code>,<code>callid_aleg</code>,<code>via_1</code>,<code>via_1_branch</code>,<code>cseq</code>,<code>reason</code>,<code>content_type</code>,<code>auth</code>,<code>user_agent</code>,<code>source_ip</code>,<code>source_port</code>,<code>destination_ip</code>,<code>destination_port</code>,<code>contact_ip</code>,<code>contact_port</code>,<code>originator_ip</code>,<code>originator_port</code>,<code>proto</code>,<code>family</code>,<code>rtp_stat</code>,<code>type</code>,<code>node</code>,<code>correlation_id</code>,<code>from_domain</code>,<code>to_domain</code>,<code>ruri_domain</code>,<code>msg</code> ) values ('2017-04-05 12:17:27',1491394647138116,'NOTIFY','','sip:vhcau2pu@200.108.217.174:49507;transport=ws','vhcau2pu','1002','Hg4cF3a42j4rQ','1002','','','mod_sofia','','ac8031c3-949c-1235-2d9c-0655eb53760b','','SIP/2.0/WSS 169.57.161.254;branch=z9hG4bK9b9b.7c3c72afaf2a4d99a510a2c40fbe419a.0','z9hG4bK9b9b.7c3c72afaf2a4d99a510a2c40fbe419a.0','105361259 NOTIFY','','application/simple-message-summary','','2600hz','169.57.161.254',5060,<strong>'0.108.217.174'</strong>,'49507,'169.57.161.252',11000,'',0,3,2,'',1,'homer01:1','ac8031c3-949c-1235-2d9c-0655eb53760b','ZeroUY.sp.xentric.co','ZeroUY.sp.xentric.co','200.108.217.174','NOTIFY sip:vhcau2pu@200.108.217.174:49507;transport=ws SIP/2.0\r\nVia: SIP/2.0/WSS 169.57.161.254;branch=z9hG4bK9b9b.7c3c72afaf2a4d99a510a2c40fbe419a.0\r\nVia: SIP/2.0/UDP 169.57.161.252:11000;received=169.57.161.252;rport=11000;branch=z9hG4bKXmF1Fv8y0D91B\r\nMax-Forwards: 50\r\nFrom: sip:1002@ZeroUY.sp.xentric.co;tag=Hg4cF3a42j4rQ\r\nTo: sip:1002@ZeroUY.sp.xentric.co\r\nCall-ID: ac8031c3-949c-1235-2d9c-0655eb53760b\r\nCSeq: 105361259 NOTIFY\r\nContact: sip:mod_sofia@169.57.161.252:11000\r\nUser-Agent: 2600hz\r\nAllow: INVITE, ACK, BYE, CANCEL, OPTIONS, MESSAGE, INFO, UPDATE, REGISTER, REFER, NOTIFY, PUBLISH, SUBSCRIBE\r\nSupported: path, replaces\r\nEvent: message-summary\r\nAllow-Events: talk, hold, conference, presence, as-feature-event, dialog, line-seize, call-info, sla, include-session-description, presence.winfo, message-summary, refer\r\nSubscription-State: terminated;reason=noresource\r\nContent-Type: application/simple-message-summary\r\nContent-Length: 98\r\n\r\nMessages-Waiting: no\r\nMessage-Account: sip:<a href="mailto:1002@ZeroUY.sp.xentric.co">1002@ZeroUY.sp.xentric.co</a>\r\nVoice-Message: 0/1 (0/0)\r\n\r\n')</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">—<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/kamailio/kamailio/issues/1058">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AF36ZXGHqGPaDO2mB9SuTxznU-iX4fc6ks5rs4mPgaJpZM4M0K89">mute the thread</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/AF36ZbdMnVGv1VOlmOKzLrWjbhWUJL_Kks5rs4mPgaJpZM4M0K89.gif" width="1" /></p>
<div itemscope itemtype="http://schema.org/EmailMessage">
<div itemprop="action" itemscope itemtype="http://schema.org/ViewAction">
  <link itemprop="url" href="https://github.com/kamailio/kamailio/issues/1058"></link>
  <meta itemprop="name" content="View Issue"></meta>
</div>
<meta itemprop="description" content="View this Issue on GitHub"></meta>
</div>

<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/kamailio/kamailio","title":"kamailio/kamailio","subtitle":"GitHub repository","main_image_url":"https://cloud.githubusercontent.com/assets/143418/17495839/a5054eac-5d88-11e6-95fc-7290892c7bb5.png","avatar_image_url":"https://cloud.githubusercontent.com/assets/143418/15842166/7c72db34-2c0b-11e6-9aed-b52498112777.png","action":{"name":"Open in GitHub","url":"https://github.com/kamailio/kamailio"}},"updates":{"snippets":[{"icon":"DESCRIPTION","message":"sipcapture: destination_ip is truncated when its length is 15 (xxx.xxx.xxx.xxx)  (#1058)"}],"action":{"name":"View Issue","url":"https://github.com/kamailio/kamailio/issues/1058"}}}</script>