Comments (15)
adubovikov
commented on August 16, 2024
did u compile kamailio or use the package ?
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
Compiled, like described here https://github.com/sipcapture/homer/blob/homer5/INSTALL.md#kamailio
from homer-api.
adubovikov
commented on August 16, 2024
can you please check this git ?
https://github.com/adubovikov/kamailio
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
That was fast :-] Thanks a lot for the fix!
from homer-api.
adubovikov
commented on August 16, 2024
thanks for the report
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
Recompiled and reinstalled. Now syslog bombing with from_tag column:
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
from homer-api.
adubovikov
commented on August 16, 2024
can u run ngrep on port 3306 and show me an INSERT ?
On 10 July 2015 at 17:53, vasyl-shumskyi [email protected] wrote:
Recompiled and reinstalled. Now syslog bombing with:
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 15:51:16 homer kamailio[30317]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'from_tag' at row 1
Jul 10 15:51:16 homer kamailio[30317]: ERROR: [db_query.c:235]: db_do_insert_cmd(): error while submitting query—
Reply to this email directly or view it on GitHub
#24 (comment)
.
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
yup-yup. see below:
~ kamailio-adubovikov]# ngrep 3306 | sed 's/[0-9]/X/g'
interface: ethX (XXX.XX.X.X/XXX.XXX.XXX.X)
match: XXXX
###########################################################################################################################################################################################################################################################################################################################################################################################################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O........O...............d..................Ju$......$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......INVITE sip:[email protected] SIP/X.X..Via: SIP/X.X/UDP XX.XXX.X
X.XX:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: <sip:[email protected]>;tag=asXfXXfXcd..To: <sip:[email protected]>..Contact: <sip:[email protected]:XXXX>..Call-ID: XeXXXXXXXXX
[email protected]:XXXX..CSeq: XXX INVITE..User-Agent: Asterisk PBX XX.X.X..Date: Fri, XX Jul XXXX XX:XX:XX GMT..Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUB
LISH, MESSAGE..Supported: replaces, timer..Content-Type: application/sdp..Content-Length: XXX....v=X..o=root XXXXXXXXX XXXXXXXXX IN IPX XX.XXX.XX.XX..s=Asterisk PBX XX.X.X..c=IN IPX XX.XXX.XX.XX..t=X X..m=a
udio XXXXX RTP/AVP X X XX X XXX..a=rtpmap:X PCMU/XXXX..a=rtpmap:X PCMA/XXXX..a=rtpmap:XX GXXX/XXXX..a=fmtp:XX annexb=no..a=rtpmap:X GSM/XXXX..a=rtpmap:XXX telephone-event/XXXX..a=fmtp:XXX X-XX..a=maxptime:X
XX..a=sendrecv..
#################################################################################################################################################################################################################################################################################################################################################################################################################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O........|...............d........Ju$................$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR.....-SIP/X.X XXX Trying..Via: SIP/X.X/UDP XX.XXX.XX.XX:XXXX;branch=zXhGXbKXX
XaXXef;rport..From: <sip:[email protected]>;tag=asXfXXfXcd..To: <sip:[email protected]>..Call-ID: [email protected]:XXXX..CSeq: XXX INVITE..User-Agent: DNL-Switch..Con
tent-Length: X....
##################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX.(....................................U..O........................d........Ju$................$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......SIP/X.X XXX Service Unavailable..Via: SIP/X.X/UDP XX.XXX.XX.XX:XXXX;bra
nch=zXhGXbKXXXaXXef;rport..From: <sip:[email protected]>;tag=asXfXXfXcd..To: <sip:[email protected]>;tag=attjXXXDXNvNN..Call-ID: [email protected]:XXXX..CSeq: XXX INVI
TE..User-Agent: DNL-Switch..Accept: application/sdp..Allow: INVITE, ACK, BYE, CANCEL, OPTIONS, INFO..Supported: timer..Content-Length: X....
#
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O........................d..................Ju$......$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......ACK sip:[email protected] SIP/X.X..Via: SIP/X.X/UDP XX.XXX.XX.X
X:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: <sip:[email protected]>;tag=asXfXXfXcd..To: <sip:[email protected]>;tag=attjXXXDXNvNN..Contact: <sip:[email protected]:XXXX>..Call-
ID: [email protected]:XXXX..CSeq: XXX ACK..User-Agent: Asterisk PBX XX.X.X..Content-Length: X....
###################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX.n....................................U..O.........:..............d........Jx_................$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......SIP/X.X XXX Ringing..Via: SIP/X.X/UDP XX.XXX.XX.XX:XXXX;branch=zXhGXbKX
ffbfXXb;rport=XXXX..From: <sip:[email protected]>;tag=asXXdaXXXX..To: <sip:[email protected]>;tag=gKXXXcXcXe..Call-ID: [email protected]:XXXX..CSeq: XXX INVITE..Contac
t: <sip:[email protected]:XXXX>..Allow: INVITE,ACK,CANCEL,BYE,REGISTER,REFER,INFO,SUBSCRIBE,NOTIFY,PRACK,UPDATE,OPTIONS..Content-Length: XXX..Content-Disposition: session; handling=required..Conten
t-Type: application/sdp....v=X..o=Sonus_UAC XXXXX XXXX IN IPX XX.XXX.XX.XXX..s=SIP Media Capabilities..c=IN IPX XX.XXX.XX.XXX..t=X X..m=audio XXXX RTP/AVP X XXX..a=rtpmap:X PCMU/XXXX..a=rtpmap:XXX telephone
-event/XXXX..a=fmtp:XXX X-XX..a=sendrecv..a=ptime:XX..
#######
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O.........K..............d..................h........$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR.....?SIP/X.X XXX Ringing..Via: SIP/X.X/UDP XXX.XXX.XXX.XXX;branch=zXhGXbKSXg
BcXXXBHpZS;received=XXX.XXX.XXX.XXX;rport=XXXX..From: <sip:[email protected]:XXXX>;tag=NXaKSKFXrrXNF..To: <sip:[email protected]:XXXX>;tag=asXaceXXXd..Call-ID: XX-XXdXXXcX-XXXXfXXb-XeXdXdbX-XXX
XXbXX..CSeq: XXXXXXXX INVITE..Server: Asterisk PBX XX.X.X..Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE..Supported: replaces, timer..Session-Expires: XXXX;refre
sher=uas..Contact: <sip:XXXXXXXXXXX;[email protected]:XXXX>..Content-Length: X....
###################################################################
U XXX.XX.XX.XX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................_S.......X......U..O........K...............d...........J.......].x.....$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR.....XXXXXXXaXXXXcXXbXXXdXcXXXXXcXXXXX@XX.X.X.XXX:XXXX......{ "ssrc":XXXXXXXX
X,"type":XXX, "report_blocks":[{"source_ssrc":XXXXXXXXX,"highest_seq_no":XXX,"fraction_lost":X,"ia_jitter":X,"packets_lost":X,"lsr":X,"dlsr":X}],"report_count":X,"sdes_ssrc":XXXXXXXXX,"sdes_chunk_ssrc":XXXX
XXXX,"sdes_information": [],"sdes_report_count":X}
#############################################
from homer-api.
adubovikov
commented on August 16, 2024
i have asked port 3306 and not match 3306
ngrep -W byline -d any port 3306
On 10 July 2015 at 18:06, vasyl-shumskyi [email protected] wrote:
yup-yup. see below:
[root@homer kamailio-adubovikov]# ngrep 3306 | sed 's/[0-9]/X/g'
interface: ethX (XXX.XX.X.X/XXX.XXX.XXX.X)
match: XXXX
###########################################################################################################################################################################################################################################################################################################################################################################################################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O........O...............d..................Ju$......$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......INVITE sip:[email protected] SIP/X.X..Via: SIP/X.X/UDP XX.XXX.X
X.XX:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: sip:[email protected];tag=asXfXXfXcd..To: sip:[email protected]..Contact: sip:[email protected]:XXXX..Call-ID: XeXXXXXXXXX
[email protected]:XXXX..CSeq: XXX INVITE..User-Agent: Asterisk PBX XX.X.X..Date: Fri, XX Jul XXXX XX:XX:XX GMT..Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUB
LISH, MESSAGE..Supported: replaces, timer..Content-Type: application/sdp..Content-Length: XXX....v=X..o=root XXXXXXXXX XXXXXXXXX IN IPX XX.XXX.XX.XX..s=Asterisk PBX XX.X.X..c=IN IPX XX.XXX.XX.XX..t=X X..m=a
udio XXXXX RTP/AVP X X XX X XXX..a=rtpmap:X PCMU/XXXX..a=rtpmap:X PCMA/XXXX..a=rtpmap:XX GXXX/XXXX..a=fmtp:XX annexb=no..a=rtpmap:X GSM/XXXX..a=rtpmap:XXX telephone-event/XXXX..a=fmtp:XXX X-XX..a=maxptime:X
XX..a=sendrecv..
#################################################################################################################################################################################################################################################################################################################################################################################################################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O........|...............d........Ju$................$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR.....-SIP/X.X XXX Trying..Via: SIP/X.X/UDP XX.XXX.XX.XX:XXXX;branch=zXhGXbKXX
XaXXef;rport..From: sip:[email protected];tag=asXfXXfXcd..To: sip:[email protected]..Call-ID: [email protected]:XXXX..CSeq: XXX INVITE..User-Agent: DNL-Switch..Con
tent-Length: X....
##################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX.(....................................U..O........................d........Ju$................$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......SIP/X.X XXX Service Unavailable..Via: SIP/X.X/UDP XX.XXX.XX.XX:XXXX;bra
nch=zXhGXbKXXXaXXef;rport..From: sip:[email protected];tag=asXfXXfXcd..To: sip:[email protected];tag=attjXXXDXNvNN..Call-ID: [email protected]:XXXX..CSeq: XXX INVI
TE..User-Agent: DNL-Switch..Accept: application/sdp..Allow: INVITE, ACK, BYE, CANCEL, OPTIONS, INFO..Supported: timer..Content-Length: X....U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O........................d..................Ju$......$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......ACK sip:[email protected] SIP/X.X..Via: SIP/X.X/UDP XX.XXX.XX.X
X:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: sip:[email protected];tag=asXfXXfXcd..To: sip:[email protected];tag=attjXXXDXNvNN..Contact: sip:[email protected]:XXXX..Call-
ID: [email protected]:XXXX..CSeq: XXX ACK..User-Agent: Asterisk PBX XX.X.X..Content-Length: X....
###################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################################
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX.n....................................U..O.........:..............d........Jx_................$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR......SIP/X.X XXX Ringing..Via: SIP/X.X/UDP XX.XXX.XX.XX:XXXX;branch=zXhGXbKX
ffbfXXb;rport=XXXX..From: sip:[email protected];tag=asXXdaXXXX..To: sip:[email protected];tag=gKXXXcXcXe..Call-ID: [email protected]:XXXX..CSeq: XXX INVITE..Contac
t: sip:[email protected]:XXXX..Allow: INVITE,ACK,CANCEL,BYE,REGISTER,REFER,INFO,SUBSCRIBE,NOTIFY,PRACK,UPDATE,OPTIONS..Content-Length: XXX..Content-Disposition: session; handling=required..Conten
t-Type: application/sdp....v=X..o=Sonus_UAC XXXXX XXXX IN IPX XX.XXX.XX.XXX..s=SIP Media Capabilities..c=IN IPX XX.XXX.XX.XXX..t=X X..m=audio XXXX RTP/AVP X XXX..a=rtpmap:X PCMU/XXXX..a=rtpmap:XXX telephone
-event/XXXX..a=fmtp:XXX X-XX..a=sendrecv..a=ptime:XX..
#######
U XXX.XX.XX.XXX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................................U..O.........K..............d..................h........$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR.....?SIP/X.X XXX Ringing..Via: SIP/X.X/UDP XXX.XXX.XXX.XXX;branch=zXhGXbKSXg
BcXXXBHpZS;received=XXX.XXX.XXX.XXX;rport=XXXX..From: sip:[email protected]:XXXX;tag=NXaKSKFXrrXNF..To: sip:[email protected]:XXXX;tag=asXaceXXXd..Call-ID: XX-XXdXXXcX-XXXXfXXb-XeXdXdbX-XXX
XXbXX..CSeq: XXXXXXXX INVITE..Server: Asterisk PBX XX.X.X..Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE..Supported: replaces, timer..Session-Expires: XXXX;refre
sher=uas..Contact: sip:XXXXXXXXXXX;npdi=[email protected]:XXXX..Content-Length: X....
###################################################################
U XXX.XX.XX.XX:XXXXX -> XXX.XX.XX.XXX:XXXX
HEPX......................_S.......X......U..O........K...............d...........J.......].x.....$XVXTCZxUSXtXXXXXHhuXwCXXXXXunR.....XXXXXXXaXXXXcXXbXXXdXcXXXXXcXXXXX@XX.X.X.XXX:XXXX......{ "ssrc":XXXXXXXX
X,"type":XXX, "report_blocks":[{"source_ssrc":XXXXXXXXX,"highest_seq_no":XXX,"fraction_lost":X,"ia_jitter":X,"packets_lost":X,"lsr":X,"dlsr":X}],"report_count":X,"sdes_ssrc":XXXXXXXXX,"sdes_chunk_ssrc":XXXX
XXXX,"sdes_information": [],"sdes_report_count":X}
#############################################—
Reply to this email directly or view it on GitHub
#24 (comment)
.
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
Actually there are no inserts ^^ I think i should be more specific..
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
Yeah, noticed this as well once commented..
kamailio-adubovikov]# ngrep -W byline -d any port 3306 | sed 's/[0-9]/X/g' | head -100
interface: any
filter: ( port XXXX ) and (ip or ipX)
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
......Ch#....
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
......Dh#....
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
[....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'XXX','Trying','','','XXXXXXXXXXX','aXXcXXe-coXXXX-INSXXX','+XXXXXXXXXXX','','','+XXXXXXXXXXX;npdi=yes','','[email protected]','','SIP/X.X/UDP XXX.XX.XX.XXX:XXXX;branch=zXhGXbKXcXXXXXXXllaXcaXXINVaXXcXXeXXdX;received=XXX.XX.XX.XXX;rport=XXXX','zXhGXbKXcXXXXXXXllaXcaXXINVaXXcXXeXXdX','XXXXXX INVITE','','','','','XXX.XX.XX.XXX',XXXX,'XXX.XX.XX.XXX',XXXX,'XX.XXX.XXX.XXX',XXXX,'',X,X,X,'',X,'homerXX:XXX','[email protected]','SIP/X.X XXX Trying\r\nVia: SIP/X.X/UDP XXX.XX.XX.XXX:XXXX;branch=zXhGXbKXcXXXXXXXllaXcaXXINVaXXcXXeXXdX;received=XXX.XX.XX.XXX;rport=XXXX\r\nFrom: \"VXXXXXXXXXXXXXXXXXX\"<sip:[email protected];user=phone;noa=national>;tag=aXXcXXe-coXXXX-INSXXX\r\nTo: <sip:[email protected];user=phone;noa=national>\r\nCall-ID: [email protected]\r\nCSeq: XXXXXX INVITE\r\nServer: Asterisk PBX XX.X.X\r\nAllow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, SUBSCRIBE, NOTIFY, INFO, PUBLISH, MESSAGE\r\nSupported: replaces, timer\r\nContact: <sip:+XXXXXXXXXXX;[email protected]:XXXX>\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;[email protected]:XXXX','XXXXXXXXXXX;npdi=yes','XXXXXXXXXX','XNXZDXaHFXXcp','XXXXXXXXXXX','asXXXcbeeX','','','','XX-XXXXXdbX-XXXfXXeX-XfXacXXX-XXXeXcXb','','SIP/X.X/UDP XXX.XXX.XXX.XXX;rport;branch=zXhGXbKXXyHUpHXyNZmj','zXhGXbKXXyHUpHXyNZmj','XXXXXXXX ACK','','','','','XXX.XXX.XXX.XXX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','XX-XXXXXdbX-XXXfXXeX-XfXacXXX-XXXeXcXb','ACK sip:XXXXXXXXXXX;[email protected]:XXXX SIP/X.X\r\nVia: SIP/X.X/UDP XXX.XXX.XXX.XXX;rport;branch=zXhGXbKXXyHUpHXyNZmj\r\nMax-Forwards: XX\r\nFrom: <sip:[email protected]:XXXX>;tag=XNXZDXaHFXXcp\r\nTo: <sip:[email protected]:XXXX>;tag=asXXXcbeeX\r\nCall-ID: XX-XXXXXdbX-XXXfXXeX-XfXacXXX-XXXeXcXb\r\nCSeq: XXXXXXXX ACK\r\nContent-Length: X\r\n\r\n')
##
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
......Eh#....
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
......Fh#....
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
.............
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....INSERT INTO stats_ip_mem ( method, source_ip, total) VALUES('INVITE', 'XXX.XX.XX.XXX', X) ON DUPLICATE KEY UPDATE total=total+X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'XXX','Trying','','','XXXXXXXXXXX','asXfaXeXXX','+XXXXXXXXXXX','gKXXbXXXfX','','','','[email protected]:XXXX','','SIP/X.X/UDP XX.XXX.XXX.XXX:XXXX;branch=zXhGXbKXeXbXXXX;rport=XXXX','zXhGXbKXeXbXXXX','XXX INVITE','','','','','XXX.XX.XXX.XX',XXXX,'XXX.XX.X.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','[email protected]:XXXX','SIP/X.X XXX Trying\r\nVia: SIP/X.X/UDP XX.XXX.XXX.XXX:XXXX;branch=zXhGXbKXeXbXXXX;rport=XXXX\r\nFrom: <sip:[email protected]>;tag=asXfaXeXXX\r\nTo: <sip:[email protected]>;tag=gKXXbXXXfX\r\nCall-ID: [email protected]:XXXX\r\nCSeq: XXX INVITE\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone','XXXXXXXXXXX','XXXXXXXXXXX','SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl','XXXXXXXXXXX','asXXcXXXXd','','','','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','','SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','XXXX ACK','','','','','XX.XX.XXX.XX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','ACK sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone SIP/X.X\r\nVia: SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X\r\nCSeq: XXXX ACK\r\nFrom: <sip:[email protected]:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:[email protected]:XXXX>;tag=asXXcXXXXd\r\nCall-ID: SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX\r\nMax-Forwards: XX\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
......
....
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....INSERT INTO stats_useragent_mem (useragent, method, total) VALUES('FreeSWITCH-mod_sofia/X.X.X+git~XXXXXXXXTXXXXXXZ~aaXfbXXfXX', 'INVITE', X) ON DUPLICATE KEY UPDATE total=total+X
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
X....~.#XXXXXData too long for column 'from_tag' at row X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone','XXXXXXXXXXX','XXXXXXXXXXX','SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl','XXXXXXXXXXX','asXXcXXXXd','','','','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','','SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','XXXX ACK','','','','','XX.XX.XXX.XX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','ACK sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone SIP/X.X\r\nVia: SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X\r\nCSeq: XXXX ACK\r\nFrom: <sip:[email protected]:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:[email protected]:XXXX>;tag=asXXcXXXXd\r\nCall-ID: SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX\r\nMax-Forwards: XX\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
...........
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'INVITE','','sip:XXXXXXXXXX;[email protected]:XXXX','XXXXXXXXXX;npdi=yes','XXXXXXXXXX','NBcgXejXFFXUN','XXXXXXXXXXXXXXXX;npdi=yes','','XXXXXXXXXX','mod_sofia','','XXXbXXXX-aXcX-XXXX-XcXX-XXXXXbXXXeXX','','SIP/X.X/UDP XXX.XX.XX.XXX:XXXX;branch=zXhGXbKXfXf.XXXXcXXX.X','zXhGXbKXfXf.XXXXcXXX.X','XXXXXXXX INVITE','','application/sdp','','FreeSWITCH-mod_sofia/X.X.X+git~XXXXXXXXTXXXXXXZ~aaXfbXXfXX','XXX.XX.XX.XXX',XXXX,'XXX.XX.XX.XXX',XXXX,'XXX.XX.XX.XXX',XXXX,'',X,X,X,'',X,'homerXX:XXX','XXXbXXXX-aXcX-XXXX-XcXX-XXXXXbXXXeXX','INVITE sip:XXXXXXXXXX;[email protected]:XXXX SIP/X.X\r\nRecord-Route: <sip:XXX.XX.XX.XXX;lr;did=Xec.XXafXXXX>\r\nVia: SIP/X.X/UDP XXX.XX.XX.XXX:XXXX;branch=zXhGXbKXfXf.XXXXcXXX.X\r\nVia: SIP/X.X/UDP XXX.XX.XX.XXX;received=XXX.XX.XX.XXX;rport=XXXX;branch=zXhGXbKXUDgXcpjmtFac\r\nMax-Forwards: XX\r\nFrom: \"XXXXXXXXXX\" <sip:[email protected]>;tag=NBcgXejXFFXUN\r\nTo: <sip:XXXXXXXXXXXXXXXX;[email protected]:XXXX>\r\nCall-ID: XXXbXXXX-aXcX-XXXX-XcXX-XXXXXbXXXeXX\r\nCSeq: XXXXXXXX INVITE\r\nContact: <sip:[email protected]:XXXX>\r\nUser-Agent: FreeSWITCH-mod_sofia/X.X.X+git~XXXXXXXXTXXXXXXZ~aaXfbXXfXX\r\nAllow: INVITE, ACK, BYE, CANCEL, OPTIONS, MESSAGE, INFO, UPDATE, NOTIFY\r\nSupported: timer, precondition, path, replaces\r\nAllow-Events: talk, hold, conference, refer\r\nPrivacy: none\r\nContent-Type: application/sdp\r\nContent-Disposition: session\r\nContent-Length: XXX\r\nX-FS-Support: update_display,send_info\r\nP-Asserted-Identity: \"XXXXXXXXXX\" <sip:[email protected]>\r\n\r\nv=X\r\no=FreeSWITCH XXXXXXXXX XXXXXXXXX IN IPX XXX.XX.XX.XXX\r\ns=FreeSWITCH\r\nc=IN IPX XXX.XX.XX.XXX\r\nt=X X\r\nm=audio XXXXX RTP/AVP X XXX\r\na=rtpmap:X PCMU/XXXX\r\na=rtpmap:XXX telephone-event/XXXX\r\na=fmtp:XXX X-XX\r\na=ptime:XX\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
X....~.#XXXXXData too long for column 'from_tag' at row X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone','XXXXXXXXXXX','XXXXXXXXXXX','SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl','XXXXXXXXXXX','asXXcXXXXd','','','','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','','SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','XXXX ACK','','','','','XX.XX.XXX.XX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','ACK sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone SIP/X.X\r\nVia: SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X\r\nCSeq: XXXX ACK\r\nFrom: <sip:[email protected]:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:[email protected]:XXXX>;tag=asXXcXXXXd\r\nCall-ID: SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX\r\nMax-Forwards: XX\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
X....~.#XXXXXData too long for column 'from_tag' at row X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone','XXXXXXXXXXX','XXXXXXXXXXX','SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl','XXXXXXXXXXX','asXXcXXXXd','','','','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','','SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','XXXX ACK','','','','','XX.XX.XXX.XX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','ACK sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone SIP/X.X\r\nVia: SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X\r\nCSeq: XXXX ACK\r\nFrom: <sip:[email protected]:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:[email protected]:XXXX>;tag=asXXcXXXXd\r\nCall-ID: SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX\r\nMax-Forwards: XX\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
X....~.#XXXXXData too long for column 'from_tag' at row X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone','XXXXXXXXXXX','XXXXXXXXXXX','SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl','XXXXXXXXXXX','asXXcXXXXd','','','','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','','SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','XXXX ACK','','','','','XX.XX.XXX.XX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','ACK sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone SIP/X.X\r\nVia: SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X\r\nCSeq: XXXX ACK\r\nFrom: <sip:[email protected]:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:[email protected]:XXXX>;tag=asXXcXXXXd\r\nCall-ID: SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX\r\nMax-Forwards: XX\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
X....~.#XXXXXData too long for column 'from_tag' at row X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone','XXXXXXXXXXX','XXXXXXXXXXX','SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl','XXXXXXXXXXX','asXXcXXXXd','','','','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','','SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','XXXX ACK','','','','','XX.XX.XXX.XX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','ACK sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone SIP/X.X\r\nVia: SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X\r\nCSeq: XXXX ACK\r\nFrom: <sip:[email protected]:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:[email protected]:XXXX>;tag=asXXcXXXXd\r\nCall-ID: SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX\r\nMax-Forwards: XX\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
X....~.#XXXXXData too long for column 'from_tag' at row X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'ACK','','sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone','XXXXXXXXXXX','XXXXXXXXXXX','SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl','XXXXXXXXXXX','asXXcXXXXd','','','','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','','SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','zXhGXbKiXXXtvXXdXXhgdXXpXrX.X','XXXX ACK','','','','','XX.XX.XXX.XX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX','ACK sip:XXXXXXXXXXX;npdi=yes;[email protected]:XXXX;user=phone SIP/X.X\r\nVia: SIP/X.X/UDP XX.XX.XXX.XX:XXXX;branch=zXhGXbKiXXXtvXXdXXhgdXXpXrX.X\r\nCSeq: XXXX ACK\r\nFrom: <sip:[email protected]:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:[email protected]:XXXX>;tag=asXXcXXXXd\r\nCall-ID: SDXXbpXXX-XXXeXaXdXceXXeXXXXXbecbXXfXeeXXX-XXaXXdX\r\nMax-Forwards: XX\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
X....~.#XXXXXData too long for column 'from_tag' at row X
#
T XXX.X.X.X:XXXXX -> XXX.X.X.X:XXXX [AP]
.....insert into `sip_capture_call_XXXXXXXX` (`date`,`micro_ts`,`method`,`reply_reason`,`ruri`,`ruri_user`,`from_user`,`from_tag`,`to_user`,`to_tag`,`pid_user`,`contact_user`,`auth_user`,`callid`,`callid_aleg`,`via_X`,`via_X_branch`,`cseq`,`reason`,`content_type`,`auth`,`user_agent`,`source_ip`,`source_port`,`destination_ip`,`destination_port`,`contact_ip`,`contact_port`,`originator_ip`,`originator_port`,`proto`,`family`,`rtp_stat`,`type`,`node`,`correlation_id`,`msg` ) values ('XXXX-XX-XX XX:XX:XX',XXXXXXXXXXXXXXXX,'XXX','Not Found','','','XXXXXXXXXXX','asXXXffXfX','+XXXXXXXXXXX','gKXXafXXXb','','','','[email protected]:XXXX','','SIP/X.X/UDP XX.XX.XX.XXX:XXXX;branch=zXhGXbKXXXXXbfX;rport=XXXX','zXhGXbKXXXXXbfX','XXX INVITE','','','','','XX.XXX.X.XXX',XXXX,'XXX.XX.XX.XX',XXXX,'',X,'',X,X,X,'',X,'homerXX:XXX','[email protected]:XXXX','SIP/X.X XXX Not Found\r\nVia: SIP/X.X/UDP XX.XX.XX.XXX:XXXX;branch=zXhGXbKXXXXXbfX;rport=XXXX\r\nFrom: <sip:[email protected]>;tag=asXXXffXfX\r\nTo: <sip:[email protected]>;tag=gKXXafXXXb\r\nCall-ID: [email protected]:XXXX\r\nCSeq: XXX INVITE\r\nContent-Length: X\r\n\r\n')
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
.............
#
T XXX.X.X.X:XXXX -> XXX.X.X.X:XXXXX [AP]
.............
from homer-api.
adubovikov
commented on August 16, 2024
so, your from_tag is tooooooo big.
SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl
change the field size to bigger value...
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
Okay. Will do so..
| from_tag | varchar(64) | NO | | | |
Also, will future rotated tables be affected with a change globally?
from homer-api.
adubovikov
commented on August 16, 2024
Yes, the rotation script should be changed as well. Or disable mysql strict
mode.
With mobile regards,
On Jul 10, 2015 18:51, "vasyl-shumskyi" [email protected] wrote:
Okay. Will do so..
| from_tag | varchar(64) | NO | | | |
Also, will future rotated tables be affected with a change globally?
—
Reply to this email directly or view it on GitHub
#24 (comment)
.
from homer-api.
vasyl-shumskyi
commented on August 16, 2024
Yeah, I've tried to increase from_tag / to_tag varchar 64 > 128 > 256 > 512 > 1024 in a row (each iteration of modifying field took like 15 min, which is sucks)
..and issue seems to be still there :) (but log started to overflow much slower with error)
Disabling strict_mode will prevent such behaviour globally, and safe us if more short fields appear in the future..
Thanks for your help, @adubovikov Much appreciated!
from homer-api.
Related Issues (20)
- Alarms config HOT 1
- Can't create alarm HOT 1
- Ipv6 calls are showing 0.0.0.0 ip when exported as pcap HOT 5
- Export search type uses current local time zone regardless of time zone selected in UI HOT 3
- Search uses "local" time instead of selected timezone if Export selected HOT 1
- click on Call-ID field does not display entire dialog if call started > 15 minutes before packet clicked HOT 3
- Wrong MOS calculation HOT 7
- incorrect content-length on json widget download (off by one) HOT 5
- Large INVITEs > 1500 bytes not being saved HOT 11
- homer_mysql_rotate fails. HOT 2
- NO msg field when retrieved call details using GET/POST http://localhost/api/v1/search/data HOT 1
- homer-api not connecting to the database HOT 3
- LDAP Authentication
- Homer 5 Install guide HOT 2
- Back-End homer-api for Java ? HOT 3
- unable to send json using statstrmr to homer api HOT 1
- does possible homer authenticat via microsoft active directory? HOT 2
- Duplicated records on homer 5 HOT 2
- homer_pgsql_rotate.pl no longer works HOT 7
- MySQL 8: function PASSWORD() removed. HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from homer-api.