<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class="elementToProof">
<span style="font-size:12pt;margin:0px;background-color:rgb(255, 255, 255)" class="ContentPasted0">You're hitting the length limit for one of the database columns, it's probably one of these.</span>
<div style="font-size:12pt;margin:0px;background-color:rgb(255, 255, 255)"><br class="ContentPasted0">
</div>
<div class="ContentPasted0" style="font-size:12pt;margin:0px;background-color:rgb(255, 255, 255)">
/usr/src/freeswitch/src/mod/endpoints/mod_sofia/sofia_glue.c
<div class="ContentPasted0" style="margin:0px"> " call_id VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " presence_hosts VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " status VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " ping_status VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " rpid VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " user_agent VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " server_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " server_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " profile_name VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " network_ip VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_username VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_realm VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " mwi_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " mwi_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " orig_server_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " orig_hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sub_host VARCHAR(255)\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " status VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " rpid VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " user_agent VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " profile_name VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " network_ip VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " open_closed VARCHAR(255)\n"</div>
<div class="ContentPasted0" style="margin:0px"> " call_id VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " uuid VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_to_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_to_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_from_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_from_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " contact_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " contact_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " state VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " direction VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " user_agent VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " profile_name VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " contact VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " presence_id VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " presence_data VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " call_info VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " call_info_state VARCHAR(255) default '',\n"</div>
<div class="ContentPasted0" style="margin:0px"> " status VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " rpid VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_to_tag VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_from_tag VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " proto VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sip_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sub_to_user VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " sub_to_host VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " presence_hosts VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " event VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " call_id VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " full_from VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " full_via VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " user_agent VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " accept VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " profile_name VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " network_ip VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " orig_proto VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " full_to VARCHAR(255)\n"</div>
<div class="ContentPasted0" style="margin:0px"> " nonce VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " profile_name VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " subscriber VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " call_id VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " aor VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " profile_name VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " contact_str VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " network_ip VARCHAR(255)\n"</div>
<div class="ContentPasted0" style="margin:0px"> " profile_name VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " hostname VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " contact_str VARCHAR(255),\n"</div>
<div class="ContentPasted0" style="margin:0px"> " call_id VARCHAR(255),\n"</div>
" network_ip VARCHAR(255),\n"</div>
</div>
<div id="appendonsend"></div>
<div style="font-family:Calibri,Arial,Helvetica,sans-serif; font-size:12pt; color:rgb(0,0,0)">
<br>
</div>
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" style="font-size:11pt"><b>From:</b> FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> on behalf of Äèëÿí Ïàëàóçîâ <dpa-freeswitch@aegee.org><br>
<b>Sent:</b> Sunday, November 20, 2022 12:25<br>
<b>To:</b> freeswitch-users <freeswitch-users@lists.freeswitch.org><br>
<b>Subject:</b> [Freeswitch-users] mod_pgsql.c:552 Error executing query: value too long for type character varying(255) on INVITE from LinphoneAndroid/4.6.14</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt">
<div class="PlainText">Hello,<br>
<br>
upon receiving from Linphone this packet:<br>
<br>
[91/1982]<br>
recv 1548 bytes from udp/[192.168.0.146]:60979 at 13:18:42.024773:
<br>
------------------------------------------------------------------------
<br>
INVITE sip:13@192.168.0.199 SIP/2.0
<br>
Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport
<br>
From: "17" <sip:17@192.168.0.199>;tag=4gQEL2Gnu
<br>
To: sip:13@192.168.0.199
<br>
CSeq: 21 INVITE
<br>
Call-ID: JjCHrXlix2
<br>
Max-Forwards: 70
<br>
Supported: replaces, outbound, gruu
<br>
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO, PRACK, UPDATE
<br>
Content-Type: application/sdp
<br>
Content-Length: 425
<br>
Contact: <sip:17@192.168.0.146:60979;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jb<br>
jFMiooS9jYqM2-3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0;<br>
transport=udp>;expires=600;+sip.instance="<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>"
<br>
User-Agent: LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0)
<br>
Proxy-Authorization: Digest realm="192.168.0.199", nonce="23e41321-96a8-46a0-aae3-9a4d35e55b66", algorithm=MD5, username="17", uri="si<br>
p:13@192.168.0.199", response="b0d38675f5541fd7e8bd4f2e15ad141d", cnonce="mqgfEEfiJeT~XLy7", nc=00000001, qop=auth
<br>
<br>
v=0
<br>
o=17 743 229 IN IP4 192.168.0.146
<br>
s=Talk<br>
c=IN IP4 192.168.0.146<br>
t=0 0<br>
a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics<br>
m=audio 7078 RTP/AVP 96 97 0 8 3 9 18 98 101<br>
a=rtpmap:96 speex/16000<br>
a=fmtp:96 vbr=on<br>
a=rtpmap:97 speex/8000<br>
a=fmtp:97 vbr=on<br>
a=fmtp:18 annexb=yes<br>
a=rtpmap:98 telephone-event/16000<br>
a=rtpmap:101 telephone-event/8000<br>
a=rtcp-fb:* trr-int 1000<br>
a=rtcp-fb:* ccm tmmbr<br>
<br>
<br>
2022-11-20 13:18:42.030423 95.90% [ERR] mod_pgsql.c:552 Error executing query:<br>
ERROR: value too long for type character varying(255)<br>
<br>
The system logs the above two lines. Or rather, when “sofia profile internal siptrace on” is active, fs_cli prints the above text in a row.<br>
<br>
I am using the latest FreeSwitch (commit bb682fc5b4c4fe67a).<br>
<br>
Greetings<br>
Äèëÿí<br>
<br>
_________________________________________________________________________<br>
<br>
The FreeSWITCH project is sponsored by SignalWire <a href="https://signalwire.com" data-auth="NotApplicable">
https://signalwire.com</a><br>
Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services.<br>
Build your next product on our scalable cloud platform.<br>
<br>
Join our online community to chat in real time <a href="https://signalwire.community" data-auth="NotApplicable">
https://signalwire.community</a><br>
<br>
Professional FreeSWITCH Services<br>
sales@freeswitch.com<br>
<a href="https://freeswitch.com" data-auth="NotApplicable">https://freeswitch.com</a><br>
<br>
Official FreeSWITCH Sites<br>
<a href="https://freeswitch.com/oss" data-auth="NotApplicable">https://freeswitch.com/oss</a><br>
<a href="https://freeswitch.org/confluence" data-auth="NotApplicable">https://freeswitch.org/confluence</a><br>
<a href="https://cluecon.com" data-auth="NotApplicable">https://cluecon.com</a><br>
<br>
FreeSWITCH-users mailing list<br>
FreeSWITCH-users@lists.freeswitch.org<br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" data-auth="NotApplicable">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users<br>
<a href="https://freeswitch.com" data-auth="NotApplicable">https://freeswitch.com</a></div>
</span></font></div>
</body>
</html>