search

sipcapture / homer-api

HOMER 5: Back-End (API) DEPRICATED - use sipcapture/homer-app
http://sipcapture.org
27 stars 67 forks source link

ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query #24

Closed vasyl-shumskyi closed 9 years ago

vasyl-shumskyi commented 9 years ago

Hello,

I noticed that search stoped giving back up-to-date results. Found below insertion error to mysql:

Jul 10 13:06:15 homer kamailio[20754]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 13:06:15 homer kamailio[20754]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'correlation_id' at row 1
Jul 10 13:06:15 homer kamailio[20754]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 13:06:15 homer kamailio[20754]: ERROR: sipcapture [sipcapture.c:1476]: sip_capture_store(): failed to insert into database(second attempt)
Jul 10 13:06:15 homer kamailio[20754]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'correlation_id' at row 1
Jul 10 13:06:15 homer kamailio[20754]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 13:06:15 homer kamailio[20754]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'correlation_id' at row 1
Jul 10 13:06:15 homer kamailio[20754]: ERROR: <core> [db_query.c:235]: db_do_insert_cmd(): error while submitting query
Jul 10 13:06:15 homer kamailio[20754]: ERROR: db_mysql [km_dbase.c:121]: db_mysql_submit_query(): driver error on query: Data too long for column 'correlation_id' at row 1

It looks like it rather kamailio issue.. Any help greatly appreciated!

adubovikov commented 9 years ago

did u compile kamailio or use the package ?

vasyl-shumskyi commented 9 years ago

Compiled, like described here https://github.com/sipcapture/homer/blob/homer5/INSTALL.md#kamailio

adubovikov commented 9 years ago

can you please check this git ?

https://github.com/adubovikov/kamailio

vasyl-shumskyi commented 9 years ago

That was fast :-] Thanks a lot for the fix!

adubovikov commented 9 years ago

thanks for the report

vasyl-shumskyi commented 9 years ago

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
adubovikov commented 9 years ago

can u run ngrep on port 3306 and show me an INSERT ?

On 10 July 2015 at 17:53, vasyl-shumskyi notifications@github.com 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 https://github.com/sipcapture/homer-api/issues/24#issuecomment-120442658 .

vasyl-shumskyi commented 9 years ago

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:XXXXXXXXXXX@XX.XXX.XX.XXX SIP/X.X..Via: SIP/X.X/UDP XX.XXX.X
  X.XX:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: <sip:XXXXXXX@XX.XXX.XX.XX>;tag=asXfXXfXcd..To: <sip:XXXXXXXXXXX@XX.XXX.XX.XXX>..Contact: <sip:XXXXXXX@XX.XXX.XX.XX:XXXX>..Call-ID: XeXXXXXXXXX
  aXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:XXXXXXX@XX.XXX.XX.XX>;tag=asXfXXfXcd..To: <sip:XXXXXXXXXXX@XX.XXX.XX.XXX>..Call-ID: XeXXXXXXXXXaXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:XXXXXXX@XX.XXX.XX.XX>;tag=asXfXXfXcd..To: <sip:XXXXXXXXXXX@XX.XXX.XX.XXX>;tag=attjXXXDXNvNN..Call-ID: XeXXXXXXXXXaXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:XXXXXXXXXXX@XX.XXX.XX.XXX SIP/X.X..Via: SIP/X.X/UDP XX.XXX.XX.X
  X:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: <sip:XXXXXXX@XX.XXX.XX.XX>;tag=asXfXXfXcd..To: <sip:XXXXXXXXXXX@XX.XXX.XX.XXX>;tag=attjXXXDXNvNN..Contact: <sip:XXXXXXX@XX.XXX.XX.XX:XXXX>..Call-
  ID: XeXXXXXXXXXaXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:unknown@XX.XXX.XX.XX>;tag=asXXdaXXXX..To: <sip:XXXXXXXXXXX@XX.XXX.XX.XXX>;tag=gKXXXcXcXe..Call-ID: XXXXXXXeXXacdfXfXfddXXdXXfXXdXXb@XX.XXX.XX.XX:XXXX..CSeq: XXX INVITE..Contac
  t: <sip:XXXXXXXXXXX@XX.XXX.XX.XXX: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:unknown@XXX.XXX.XXX.XXX:XXXX>;tag=NXaKSKFXrrXNF..To: <sip:XXXXXXXXXXX@XX.XXX.XX.XX: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=yes@XX.XXX.XX.XX: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}
#############################################
adubovikov commented 9 years ago

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 notifications@github.com 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:XXXXXXXXXXX@XX.XXX.XX.XXX SIP/X.X..Via: SIP/X.X/UDP XX.XXX.X X.XX:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: sip:XXXXXXX@XX.XXX.XX.XX;tag=asXfXXfXcd..To: sip:XXXXXXXXXXX@XX.XXX.XX.XXX..Contact: sip:XXXXXXX@XX.XXX.XX.XX:XXXX..Call-ID: XeXXXXXXXXX aXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:XXXXXXX@XX.XXX.XX.XX;tag=asXfXXfXcd..To: sip:XXXXXXXXXXX@XX.XXX.XX.XXX..Call-ID: XeXXXXXXXXXaXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:XXXXXXX@XX.XXX.XX.XX;tag=asXfXXfXcd..To: sip:XXXXXXXXXXX@XX.XXX.XX.XXX;tag=attjXXXDXNvNN..Call-ID: XeXXXXXXXXXaXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:XXXXXXXXXXX@XX.XXX.XX.XXX SIP/X.X..Via: SIP/X.X/UDP XX.XXX.XX.X X:XXXX;branch=zXhGXbKXXXaXXef;rport..Max-Forwards: XX..From: sip:XXXXXXX@XX.XXX.XX.XX;tag=asXfXXfXcd..To: sip:XXXXXXXXXXX@XX.XXX.XX.XXX;tag=attjXXXDXNvNN..Contact: sip:XXXXXXX@XX.XXX.XX.XX:XXXX..Call- ID: XeXXXXXXXXXaXXXXXXeXXXXXXXXcccXX@XX.XXX.XX.XX: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:unknown@XX.XXX.XX.XX;tag=asXXdaXXXX..To: sip:XXXXXXXXXXX@XX.XXX.XX.XXX;tag=gKXXXcXcXe..Call-ID: XXXXXXXeXXacdfXfXfddXXdXXfXXdXXb@XX.XXX.XX.XX:XXXX..CSeq: XXX INVITE..Contac t: sip:XXXXXXXXXXX@XX.XXX.XX.XXX: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:unknown@XXX.XXX.XXX.XXX:XXXX;tag=NXaKSKFXrrXNF..To: sip:XXXXXXXXXXX@XX.XXX.XX.XX: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=yes@XX.XXX.XX.XX: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 https://github.com/sipcapture/homer-api/issues/24#issuecomment-120445712 .

vasyl-shumskyi commented 9 years ago

Actually there are no inserts ^^ I think i should be more specific..

vasyl-shumskyi commented 9 years ago

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','','XXXXXXXcXdXabaaXXXcXaXXXXXXXeXXa@ens.com','','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','XXXXXXXcXdXabaaXXXcXaXXXXXXXeXXa@ens.com','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:XXXXXXXXXXX@XXX.XX.XX.XXX;user=phone;noa=national>;tag=aXXcXXe-coXXXX-INSXXX\r\nTo: <sip:+XXXXXXXXXXX@XX.XXX.XXX.XXX;user=phone;noa=national>\r\nCall-ID: XXXXXXXcXdXabaaXXXcXaXXXXXXXeXXa@ens.com\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;npdi=yes@XX.XXX.XXX.XXX: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;npdi=yes@XX.X.X.XXX: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;npdi=yes@XX.X.X.XXX:XXXX SIP/X.X\r\nVia: SIP/X.X/UDP XXX.XXX.XXX.XXX;rport;branch=zXhGXbKXXyHUpHXyNZmj\r\nMax-Forwards: XX\r\nFrom: <sip:XXXXXXXXXX@XXX.XXX.XXX.XXX:XXXX>;tag=XNXZDXaHFXXcp\r\nTo: <sip:XXXXXXXXXXX@XX.X.X.XXX: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','','','','XXfcaaXXXXaXfXXXXeeddacdXXfbbbXe@XX.XXX.XXX.XXX: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','XXfcaaXXXXaXfXXXXeeddacdXXfbbbXe@XX.XXX.XXX.XXX:XXXX','SIP/X.X XXX Trying\r\nVia: SIP/X.X/UDP XX.XXX.XXX.XXX:XXXX;branch=zXhGXbKXeXbXXXX;rport=XXXX\r\nFrom: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX>;tag=asXfaXeXXX\r\nTo: <sip:+XXXXXXXXXXX@XXX.XX.XXX.XX>;tag=gKXXbXXXfX\r\nCall-ID: XXfcaaXXXXaXfXXXXeeddacdXXfbbbXe@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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:XXXXXXXXXXX@XX.XX.XXX.XX:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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:XXXXXXXXXXX@XX.XX.XXX.XX:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX: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;npdi=yes@XX.XXX.XX.XXX: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;npdi=yes@XX.XXX.XX.XXX: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:XXXXXXXXXX@XXX.XX.XX.XXX>;tag=NBcgXejXFFXUN\r\nTo: <sip:XXXXXXXXXXXXXXXX;npdi=yes@XXX.XX.XX.XXX:XXXX>\r\nCall-ID: XXXbXXXX-aXcX-XXXX-XcXX-XXXXXbXXXeXX\r\nCSeq: XXXXXXXX INVITE\r\nContact: <sip:mod_sofia@XXX.XX.XX.XXX: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:XXXXXXXXXX@XXX.XX.XX.XXX>\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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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:XXXXXXXXXXX@XX.XX.XXX.XX:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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:XXXXXXXXXXX@XX.XX.XXX.XX:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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:XXXXXXXXXXX@XX.XX.XXX.XX:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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:XXXXXXXXXXX@XX.XX.XXX.XX:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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;rn=XXXXXXXXXXX@XX.XXX.XXX.XXX: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:XXXXXXXXXXX@XX.XX.XXX.XX:XXXX>;tag=SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl\r\nTo: <sip:XXXXXXXXXXX@XX.XXX.XXX.XXX: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','','','','XcXXbXdXXXXbeXXfXXXXXXXXXXdXcXXX@XX.XX.XX.XXX: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','XcXXbXdXXXXbeXXfXXXXXXXXXXdXcXXX@XX.XX.XX.XXX: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:XXXXXXXXXXX@XX.XX.XX.XXX>;tag=asXXXffXfX\r\nTo: <sip:+XXXXXXXXXXX@XX.XXX.X.XXX>;tag=gKXXafXXXb\r\nCall-ID: XcXXbXdXXXXbeXXfXXXXXXXXXXdXcXXX@XX.XX.XX.XXX: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]

.............
adubovikov commented 9 years ago

so, your from_tag is tooooooo big.

SDXXbpXXX-XXXXXXXXX_C-oXXo-mjqhkprdlhufgklokijtoukeghgkjiegudgieinqcjcuuXuniilullgl

change the field size to bigger value...

vasyl-shumskyi commented 9 years ago

Okay. Will do so.. 

| from_tag         | varchar(64)         | NO   |     |                     |                |

Also, will future rotated tables be affected with a change globally?

adubovikov commented 9 years ago

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" notifications@github.com 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 https://github.com/sipcapture/homer-api/issues/24#issuecomment-120457377 .

vasyl-shumskyi commented 9 years ago

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!