mod_pgsql.c:552 Error executing query: value too long for type character varying(255) on INVITE from LinphoneAndroid/4.6.14
Hello, upon receiving from Linphone this packet: [91/1982] recv 1548 bytes from udp/[192.168.0.146]:60979 at 13:18:42.024773: ------------------------------------------------------------------------ INVITE sip:13@192.168.0.199 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport From: "17" <sip:17@192.168.0.199>;tag=4gQEL2Gnu To: sip:13@192.168.0.199 CSeq: 21 INVITE Call-ID: JjCHrXlix2 Max-Forwards: 70 Supported: replaces, outbound, gruu Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO, PRACK, UPDATE Content-Type: application/sdp Content-Length: 425 Contact: <sip:17@192.168.0.146:60979;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jb jFMiooS9jYqM2-3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0; transport=udp>;expires=600;+sip.instance="<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>" User-Agent: LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0) Proxy-Authorization: Digest realm="192.168.0.199", nonce="23e41321-96a8-46a0-aae3-9a4d35e55b66", algorithm=MD5, username="17", uri="si p:13@192.168.0.199", response="b0d38675f5541fd7e8bd4f2e15ad141d", cnonce="mqgfEEfiJeT~XLy7", nc=00000001, qop=auth v=0 o=17 743 229 IN IP4 192.168.0.146 s=Talk c=IN IP4 192.168.0.146 t=0 0 a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics m=audio 7078 RTP/AVP 96 97 0 8 3 9 18 98 101 a=rtpmap:96 speex/16000 a=fmtp:96 vbr=on a=rtpmap:97 speex/8000 a=fmtp:97 vbr=on a=fmtp:18 annexb=yes a=rtpmap:98 telephone-event/16000 a=rtpmap:101 telephone-event/8000 a=rtcp-fb:* trr-int 1000 a=rtcp-fb:* ccm tmmbr 2022-11-20 13:18:42.030423 95.90% [ERR] mod_pgsql.c:552 Error executing query: ERROR: value too long for type character varying(255) 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. I am using the latest FreeSwitch (commit bb682fc5b4c4fe67a). Greetings Дилян
Greetings, Please file an issue here https://github.com/signalwire/freeswitch/issues, Also check out our community forum here https://forum.signalwire.community/c/freeswitch/17 Thanks, Brian On Sun, Nov 20, 2022 at 5:26 AM Дилян Палаузов <dpa-freeswitch@aegee.org> wrote:
Hello,
upon receiving from Linphone this packet:
[91/1982] recv 1548 bytes from udp/[192.168.0.146]:60979 at 13:18:42.024773:
------------------------------------------------------------------------
INVITE sip:13@192.168.0.199 SIP/2.0
Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport
From: "17" <sip:17@192.168.0.199>;tag=4gQEL2Gnu
To: sip:13@192.168.0.199
CSeq: 21 INVITE
Call-ID: JjCHrXlix2
Max-Forwards: 70
Supported: replaces, outbound, gruu
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO, PRACK, UPDATE Content-Type: application/sdp
Content-Length: 425
Contact: <sip:17@192.168.0.146:60979 ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jb
jFMiooS9jYqM2-3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0; transport=udp>;expires=600;+sip.instance="<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>"
User-Agent: LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0) Proxy-Authorization: Digest realm="192.168.0.199", nonce="23e41321-96a8-46a0-aae3-9a4d35e55b66", algorithm=MD5, username="17", uri="si p:13@192.168.0.199", response="b0d38675f5541fd7e8bd4f2e15ad141d", cnonce="mqgfEEfiJeT~XLy7", nc=00000001, qop=auth
v=0
o=17 743 229 IN IP4 192.168.0.146
s=Talk c=IN IP4 192.168.0.146 t=0 0 a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics m=audio 7078 RTP/AVP 96 97 0 8 3 9 18 98 101 a=rtpmap:96 speex/16000 a=fmtp:96 vbr=on a=rtpmap:97 speex/8000 a=fmtp:97 vbr=on a=fmtp:18 annexb=yes a=rtpmap:98 telephone-event/16000 a=rtpmap:101 telephone-event/8000 a=rtcp-fb:* trr-int 1000 a=rtcp-fb:* ccm tmmbr
2022-11-20 13:18:42.030423 95.90% [ERR] mod_pgsql.c:552 Error executing query: ERROR: value too long for type character varying(255)
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.
I am using the latest FreeSwitch (commit bb682fc5b4c4fe67a).
Greetings Дилян
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
-- Brian West | Co-founder and Developer Need Commercial support? email sales@freeswitch.com FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045 <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g> Email: brian@freeswitch.com Mobile: 918-424-9378 Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/> [image: https://www.facebook.com/signalwireinc?src=email] <https://www.facebook.com/freeswitch> [image: https://twitter.com/freeswitch] <https://twitter.com/freeswitch>
Hello Brian, When I run freeSWITCH under strace it prints: [pid 84702] sendto(42, "Q\0\0\3\202insert into sip_dialogs (call_id,uuid,sip_to_user,sip_to_host,sip_to_tag,sip_from_user,sip_from_host, sip_from_tag,contact_user,contact_host,state,direction,user_agent,profile_name,hostname,contact,presence_id,presence_data,call_info,rcd, call_info_state) values('OgQbJfQIl-','7aa8f029-9094-4727-a53e-b2e1a0cc0aa5','13','192.168.0.199','','17','192.168.0.199','-1l6slefi','17 ','192.168.0.146','confirmed','inbound','LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0)','internal','d','<sip:17@19 2.168.0.146:58882;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2-3COnS ngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0;transport=udp>;expi res=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"','17@192.168.0.199','','',1669041504,'')\0", 899, MSG_NOSIGNAL , NULL, 0 <unfinished ...> [pid 84702] <... sendto resumed>) = 899 [pid 81942] <... clock_gettime resumed>{tv_sec=7522, tv_nsec=214678884}) = 0 [pid 84702] recvfrom(42, <unfinished ...> [pid 81942] read(35, <unfinished ...> [pid 84702] <... recvfrom resumed>0x7f7c7c00f0e0, 16384, 0, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable) [pid 84702] poll([{fd=42, events=POLLIN|POLLPRI|POLLERR|POLLHUP|POLLNVAL|POLLRDNORM|POLLRDBAND}], 1, 10000) = 1 ([{fd=42, revents=POLLIN |POLLRDNORM}]) [pid 84702] recvfrom(42, "E\0\0\0cSERROR\0VERROR\0C22001\0Mvalue too long for type character varying(255)\0Fvarchar.c\0L632\0Rvarchar\0\ 0Z\0\0\0\5I", 16384, 0, NULL, NULL) = 106 In the sip_dialogs table in Postgresql all columns are character varying(255), except the columns expires of type bigint and rcd of type int. In INSERT INTO sip_dialogs (call_id,uuid,sip_to_user,sip_to_host,sip_to_tag,sip_from_user,sip_from_host,sip_from_tag,contact_user,contact_host,state,direction,user_agent,profile _name,hostname,contact,presence_id,presence_data,call_info,rcd,call_info_state) VALUES('OgQbJfQIl-','7aa8f029-9094-4727-a53e-b2e1a0cc0aa5','13','192.168.0.199','','17','192.168.0.199','- 1l6slefi','17','192.168.0.146','confirmed','inbound','LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0)','internal','d', '<sip:17@192.168.0.146:58882;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2- 3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn- timeout=0;transport=udp>;expires=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"', '17@192.168.0.199','','',1669041504,'') The string <sip:17@192.168.0.146:58882;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2- 3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn- timeout=0;transport=udp>;expires=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\" is 355 bytes and is inserted into column contact. The sip_dialogs table is created in src/mod/endpoints/mod_sofia/sofia_glue.c:2486 I think the right fix would be changing CREATE TABLE sip_dialgo in src/mod/endpoints/mod_sofia/sofia_glue.c:2486, Greetings Дилян -----Original Message----- From: Brian West <brian@freeswitch.com> Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] mod_pgsql.c:552 Error executing query: value too long for type character varying(255) on INVITE from LinphoneAndroid/4.6.14 Date: 11/20/2022 07:38:47 PM Greetings, Please file an issue here https://github.com/signalwire/freeswitch/issues, Also check out our community forum here https://forum.signalwire.community/c/freeswitch/17 Thanks, Brian On Sun, Nov 20, 2022 at 5:26 AM Дилян Палаузов <dpa-freeswitch@aegee.org> wrote:
Hello,
upon receiving from Linphone this packet:
[91/1982] recv 1548 bytes from udp/[192.168.0.146]:60979 at 13:18:42.024773: ------------------------------------------------------------------------ INVITE sip:13@192.168.0.199 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport From: "17" <sip:17@192.168.0.199>;tag=4gQEL2Gnu To: sip:13@192.168.0.199 CSeq: 21 INVITE Call-ID: JjCHrXlix2 Max-Forwards: 70 Supported: replaces, outbound, gruu Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO, PRACK, UPDATE Content-Type: application/sdp Content-Length: 425 Contact: <sip:17@192.168.0.146:60979;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jb jFMiooS9jYqM2-3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0; transport=udp>;expires=600;+sip.instance="<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>" User-Agent: LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0) Proxy-Authorization: Digest realm="192.168.0.199", nonce="23e41321-96a8-46a0-aae3-9a4d35e55b66", algorithm=MD5, username="17", uri="si p:13@192.168.0.199", response="b0d38675f5541fd7e8bd4f2e15ad141d", cnonce="mqgfEEfiJeT~XLy7", nc=00000001, qop=auth
v=0 o=17 743 229 IN IP4 192.168.0.146 s=Talk c=IN IP4 192.168.0.146 t=0 0 a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics m=audio 7078 RTP/AVP 96 97 0 8 3 9 18 98 101 a=rtpmap:96 speex/16000 a=fmtp:96 vbr=on a=rtpmap:97 speex/8000 a=fmtp:97 vbr=on a=fmtp:18 annexb=yes a=rtpmap:98 telephone-event/16000 a=rtpmap:101 telephone-event/8000 a=rtcp-fb:* trr-int 1000 a=rtcp-fb:* ccm tmmbr
2022-11-20 13:18:42.030423 95.90% [ERR] mod_pgsql.c:552 Error executing query: ERROR: value too long for type character varying(255)
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.
I am using the latest FreeSwitch (commit bb682fc5b4c4fe67a).
Greetings Дилян
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
-- Brian West | Co-founder and Developer Need Commercial support? email sales@freeswitch.com FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045 Email: brian@freeswitch.com Mobile: 918-424-9378 Website: https://www.FreeSWITCH.com https://www.facebook.com/signalwireinc?src=email https://twitter.com/freeswitch _________________________________________________________________________ The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform. Join our online community to chat in real time https://signalwire.community Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
Please file it. On Mon, Nov 21, 2022 at 8:52 AM Дилян Палаузов <dpa-freeswitch@aegee.org> wrote:
Hello Brian,
When I run freeSWITCH under strace it prints:
[pid 84702] sendto(42, "Q\0\0\3\202insert into sip_dialogs (call_id,uuid,sip_to_user,sip_to_host,sip_to_tag,sip_from_user,sip_from_host,
sip_from_tag,contact_user,contact_host,state,direction,user_agent,profile_name,hostname,contact,presence_id,presence_data,call_info,rcd, call_info_state) values('OgQbJfQIl-','7aa8f029-9094-4727-a53e-b2e1a0cc0aa5','13','192.168.0.199','','17','192.168.0.199','-1l6slefi','17 ','192.168.0.146','confirmed','inbound','LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0)','internal','d','<sip:17@19 2.168.0.146:58882 ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2-3COnS
ngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0;transport=udp>;expi
res=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"',' 17@192.168.0.199','','',1669041504,'')\0", 899, MSG_NOSIGNAL , NULL, 0 <unfinished ...> [pid 84702] <... sendto resumed>) = 899 [pid 81942] <... clock_gettime resumed>{tv_sec=7522, tv_nsec=214678884}) = 0 [pid 84702] recvfrom(42, <unfinished ...> [pid 81942] read(35, <unfinished ...> [pid 84702] <... recvfrom resumed>0x7f7c7c00f0e0, 16384, 0, NULL, NULL) = -1 EAGAIN (Resource temporarily unavailable) [pid 84702] poll([{fd=42, events=POLLIN|POLLPRI|POLLERR|POLLHUP|POLLNVAL|POLLRDNORM|POLLRDBAND}], 1, 10000) = 1 ([{fd=42, revents=POLLIN |POLLRDNORM}]) [pid 84702] recvfrom(42, "E\0\0\0cSERROR\0VERROR\0C22001\0Mvalue too long for type character varying(255)\0Fvarchar.c\0L632\0Rvarchar\0\ 0Z\0\0\0\5I", 16384, 0, NULL, NULL) = 106
In the sip_dialogs table in Postgresql all columns are character varying(255), except the columns expires of type bigint and rcd of type int. In
INSERT INTO sip_dialogs
(call_id,uuid,sip_to_user,sip_to_host,sip_to_tag,sip_from_user,sip_from_host,sip_from_tag,contact_user,contact_host,state,direction,user_agent,profile
_name,hostname,contact,presence_id,presence_data,call_info,rcd,call_info_state)
VALUES('OgQbJfQIl-','7aa8f029-9094-4727-a53e-b2e1a0cc0aa5','13','192.168.0.199','','17','192.168.0.199','- 1l6slefi','17','192.168.0.146','confirmed','inbound','LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0)','internal','d', '<sip:17@192.168.0.146:58882 ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2-
3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-
timeout=0;transport=udp>;expires=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"', '17@192.168.0.199','','',1669041504,'')
The string
<sip:17@192.168.0.146:58882 ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jbjFMiooS9jYqM2-
3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-
timeout=0;transport=udp>;expires=600;+sip.instance=\"<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>\"
is 355 bytes and is inserted into column contact. The sip_dialogs table is created in src/mod/endpoints/mod_sofia/sofia_glue.c:2486
I think the right fix would be changing CREATE TABLE sip_dialgo in src/mod/endpoints/mod_sofia/sofia_glue.c:2486,
Greetings Дилян
-----Original Message----- From: Brian West <brian@freeswitch.com> Reply-To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> To: FreeSWITCH Users Help <freeswitch-users@lists.freeswitch.org> Subject: Re: [Freeswitch-users] mod_pgsql.c:552 Error executing query: value too long for type character varying(255) on INVITE from LinphoneAndroid/4.6.14 Date: 11/20/2022 07:38:47 PM
Greetings,
Please file an issue here https://github.com/signalwire/freeswitch/issues, Also check out our community forum here https://forum.signalwire.community/c/freeswitch/17
Thanks, Brian
On Sun, Nov 20, 2022 at 5:26 AM Дилян Палаузов <dpa-freeswitch@aegee.org> wrote:
Hello,
upon receiving from Linphone this packet:
[91/1982]
recv 1548 bytes from udp/[192.168.0.146]:60979 at 13:18:42.024773:
------------------------------------------------------------------------
INVITE sip:13@192.168.0.199 SIP/2.0
Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport
From: "17" <sip:17@192.168.0.199>;tag=4gQEL2Gnu
To: sip:13@192.168.0.199
CSeq: 21 INVITE
Call-ID: JjCHrXlix2
Max-Forwards: 70
Supported: replaces, outbound, gruu
Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO, PRACK, UPDATE Content-Type: application/sdp
Content-Length: 425
Contact: <sip:17@192.168.0.146:60979 ;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jb
jFMiooS9jYqM2-3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0;
transport=udp>;expires=600;+sip.instance="<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>"
User-Agent: LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0) Proxy-Authorization: Digest realm="192.168.0.199", nonce="23e41321-96a8-46a0-aae3-9a4d35e55b66", algorithm=MD5, username="17", uri="si p:13@192.168.0.199", response="b0d38675f5541fd7e8bd4f2e15ad141d", cnonce="mqgfEEfiJeT~XLy7", nc=00000001, qop=auth
v=0
o=17 743 229 IN IP4 192.168.0.146
s=Talk c=IN IP4 192.168.0.146 t=0 0 a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics m=audio 7078 RTP/AVP 96 97 0 8 3 9 18 98 101 a=rtpmap:96 speex/16000 a=fmtp:96 vbr=on a=rtpmap:97 speex/8000 a=fmtp:97 vbr=on a=fmtp:18 annexb=yes a=rtpmap:98 telephone-event/16000 a=rtpmap:101 telephone-event/8000 a=rtcp-fb:* trr-int 1000 a=rtcp-fb:* ccm tmmbr
2022-11-20 13:18:42.030423 95.90% [ERR] mod_pgsql.c:552 Error executing query: ERROR: value too long for type character varying(255)
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.
I am using the latest FreeSwitch (commit bb682fc5b4c4fe67a).
Greetings Дилян
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
--
Brian West | Co-founder and Developer Need Commercial support? email sales@freeswitch.com FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045 Email: brian@freeswitch.com Mobile: 918-424-9378 Website: https://www.FreeSWITCH.com https://www.facebook.com/signalwireinc?src=email https://twitter.com/freeswitch _________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
_________________________________________________________________________
The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform.
Join our online community to chat in real time https://signalwire.community
Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com
Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
-- Brian West | Co-founder and Developer Need Commercial support? email sales@freeswitch.com FreeSWITCH Solutions | 17345 Civic Drive #2531 Brookfield, WI 53045 <https://maps.google.com/?q=17345+Civic+Drive+%232531+Brookfield,+WI+53045&entry=gmail&source=g> Email: brian@freeswitch.com Mobile: 918-424-9378 Website: https://www.FreeSWITCH.com <https://www.freeswitch.com/> [image: https://www.facebook.com/signalwireinc?src=email] <https://www.facebook.com/freeswitch> [image: https://twitter.com/freeswitch] <https://twitter.com/freeswitch>
You're hitting the length limit for one of the database columns, it's probably one of these. /usr/src/freeswitch/src/mod/endpoints/mod_sofia/sofia_glue.c " call_id VARCHAR(255),\n" " sip_user VARCHAR(255),\n" " sip_host VARCHAR(255),\n" " presence_hosts VARCHAR(255),\n" " status VARCHAR(255),\n" " ping_status VARCHAR(255),\n" " rpid VARCHAR(255),\n" " user_agent VARCHAR(255),\n" " server_user VARCHAR(255),\n" " server_host VARCHAR(255),\n" " profile_name VARCHAR(255),\n" " hostname VARCHAR(255),\n" " network_ip VARCHAR(255),\n" " sip_username VARCHAR(255),\n" " sip_realm VARCHAR(255),\n" " mwi_user VARCHAR(255),\n" " mwi_host VARCHAR(255),\n" " orig_server_host VARCHAR(255),\n" " orig_hostname VARCHAR(255),\n" " sub_host VARCHAR(255)\n" " sip_user VARCHAR(255),\n" " sip_host VARCHAR(255),\n" " status VARCHAR(255),\n" " rpid VARCHAR(255),\n" " user_agent VARCHAR(255),\n" " profile_name VARCHAR(255),\n" " hostname VARCHAR(255),\n" " network_ip VARCHAR(255),\n" " open_closed VARCHAR(255)\n" " call_id VARCHAR(255),\n" " uuid VARCHAR(255),\n" " sip_to_user VARCHAR(255),\n" " sip_to_host VARCHAR(255),\n" " sip_from_user VARCHAR(255),\n" " sip_from_host VARCHAR(255),\n" " contact_user VARCHAR(255),\n" " contact_host VARCHAR(255),\n" " state VARCHAR(255),\n" " direction VARCHAR(255),\n" " user_agent VARCHAR(255),\n" " profile_name VARCHAR(255),\n" " hostname VARCHAR(255),\n" " contact VARCHAR(255),\n" " presence_id VARCHAR(255),\n" " presence_data VARCHAR(255),\n" " call_info VARCHAR(255),\n" " call_info_state VARCHAR(255) default '',\n" " status VARCHAR(255),\n" " rpid VARCHAR(255),\n" " sip_to_tag VARCHAR(255),\n" " sip_from_tag VARCHAR(255),\n" " proto VARCHAR(255),\n" " sip_user VARCHAR(255),\n" " sip_host VARCHAR(255),\n" " sub_to_user VARCHAR(255),\n" " sub_to_host VARCHAR(255),\n" " presence_hosts VARCHAR(255),\n" " event VARCHAR(255),\n" " call_id VARCHAR(255),\n" " full_from VARCHAR(255),\n" " full_via VARCHAR(255),\n" " user_agent VARCHAR(255),\n" " accept VARCHAR(255),\n" " profile_name VARCHAR(255),\n" " hostname VARCHAR(255),\n" " network_ip VARCHAR(255),\n" " orig_proto VARCHAR(255),\n" " full_to VARCHAR(255)\n" " nonce VARCHAR(255),\n" " profile_name VARCHAR(255),\n" " hostname VARCHAR(255),\n" " subscriber VARCHAR(255),\n" " call_id VARCHAR(255),\n" " aor VARCHAR(255),\n" " profile_name VARCHAR(255),\n" " hostname VARCHAR(255),\n" " contact_str VARCHAR(255),\n" " network_ip VARCHAR(255)\n" " profile_name VARCHAR(255),\n" " hostname VARCHAR(255),\n" " contact_str VARCHAR(255),\n" " call_id VARCHAR(255),\n" " network_ip VARCHAR(255),\n" ________________________________ From: FreeSWITCH-users <freeswitch-users-bounces@lists.freeswitch.org> on behalf of Дилян Палаузов <dpa-freeswitch@aegee.org> Sent: Sunday, November 20, 2022 12:25 To: freeswitch-users <freeswitch-users@lists.freeswitch.org> Subject: [Freeswitch-users] mod_pgsql.c:552 Error executing query: value too long for type character varying(255) on INVITE from LinphoneAndroid/4.6.14 Hello, upon receiving from Linphone this packet: [91/1982] recv 1548 bytes from udp/[192.168.0.146]:60979 at 13:18:42.024773: ------------------------------------------------------------------------ INVITE sip:13@192.168.0.199 SIP/2.0 Via: SIP/2.0/UDP 192.168.0.146:60979;branch=z9hG4bK.8Jt0a~Mrl;rport From: "17" <sip:17@192.168.0.199>;tag=4gQEL2Gnu To: sip:13@192.168.0.199 CSeq: 21 INVITE Call-ID: JjCHrXlix2 Max-Forwards: 70 Supported: replaces, outbound, gruu Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER, NOTIFY, MESSAGE, SUBSCRIBE, INFO, PRACK, UPDATE Content-Type: application/sdp Content-Length: 425 Contact: <sip:17@192.168.0.146:60979;pn-prid=cYbkaRFUTAKJlPRczanb5L:APA91bG-OBwFYa6vlrpuDFSqFW9pV_EdbrfU-vAMMOdbvoKQFf_8N5iummtpMPsFU7jb jFMiooS9jYqM2-3COnSngw9eoL-xckOKsNcmX6VzxVIoNSdG1ds9oOeq2dyXCngCsobMmwCl;pn-provider=fcm;pn-param=929724111839;pn-silent=1;pn-timeout=0; transport=udp>;expires=600;+sip.instance="<urn:uuid:f2f5a3cf-a0fb-0047-be50-740fb9bdc562>" User-Agent: LinphoneAndroid/4.6.14 (CLT-L09) LinphoneSDK/5.1.62 (tags/5.1.62^0) Proxy-Authorization: Digest realm="192.168.0.199", nonce="23e41321-96a8-46a0-aae3-9a4d35e55b66", algorithm=MD5, username="17", uri="si p:13@192.168.0.199", response="b0d38675f5541fd7e8bd4f2e15ad141d", cnonce="mqgfEEfiJeT~XLy7", nc=00000001, qop=auth v=0 o=17 743 229 IN IP4 192.168.0.146 s=Talk c=IN IP4 192.168.0.146 t=0 0 a=rtcp-xr:rcvr-rtt=all:10000 stat-summary=loss,dup,jitt,TTL voip-metrics m=audio 7078 RTP/AVP 96 97 0 8 3 9 18 98 101 a=rtpmap:96 speex/16000 a=fmtp:96 vbr=on a=rtpmap:97 speex/8000 a=fmtp:97 vbr=on a=fmtp:18 annexb=yes a=rtpmap:98 telephone-event/16000 a=rtpmap:101 telephone-event/8000 a=rtcp-fb:* trr-int 1000 a=rtcp-fb:* ccm tmmbr 2022-11-20 13:18:42.030423 95.90% [ERR] mod_pgsql.c:552 Error executing query: ERROR: value too long for type character varying(255) 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. I am using the latest FreeSwitch (commit bb682fc5b4c4fe67a). Greetings Дилян _________________________________________________________________________ The FreeSWITCH project is sponsored by SignalWire https://signalwire.com Enhance your FreeSWITCH install with disruptive priced SMS and PSTN services. Build your next product on our scalable cloud platform. Join our online community to chat in real time https://signalwire.community Professional FreeSWITCH Services sales@freeswitch.com https://freeswitch.com Official FreeSWITCH Sites https://freeswitch.com/oss https://freeswitch.org/confluence https://cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users https://freeswitch.com
participants (3)
-
Brian West
-
Shaun Stokes
-
Дилян Палаузов