[OpenSIPS-Users] OpenSIPS 3.2 + MySQL - do_accounting()

Wed Mar 2 23:44:17 UTC 2022

Hello,

his is attached SIP-Trace fpr examle call. This is permanent error by 
MySQL use.

--
Mit freundlichen Grüßen,
Best regards

Eugen Prieb

Am 01.03.2022 um 15:28 schrieb Bogdan-Andrei Iancu:
> Hi Eugen,
>
> What is the capture of the call that produced that CDR ? Can you 
> reproduce it ?
>
> Regards,
>
> Bogdan-Andrei Iancu
>
> OpenSIPS Founder and Developer
>   https://www.opensips-solutions.com
> OpenSIPS eBootcamp
>   https://www.opensips.org/Training/Bootcamp
>
> On 2/23/22 11:21 PM, Eugen Prieb via Users wrote:
>> Hello,
>>
>> I will collect all CDRs, also failled, in DB.
>>
>> I see in log follow message:
>> Feb 23 21:58:33 opensips-32 /sbin/opensips[2623292]: 
>> CRITICAL:db_mysql:wrapper_single_mysql_stmt_execute: driver error 
>> (1048): Column 'to_tag' cannot be null
>>
>> As MySQL is MariaDB 10.5.12 installed. Have you any idee?
>>
>>
>
-------------- next part --------------
U 2022/03/02 23:11:52.987389 +0000 176.199.99.57:61172 -> 95.111.248.176:5060

INVITE sip:+493012030000 at 95.111.248.176 SIP/2.0
Via: SIP/2.0/UDP 192.168.178.23:5060;branch=z9hG4bK006c3cd0eb98ec11b76f277d269fdfd3;rport
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
To: <sip:+493012030000 at 95.111.248.176>
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 5 INVITE
Contact: <sip:4901179322878 at 192.168.178.23:5060>
Content-Type: application/sdp
Allow: INVITE, OPTIONS, ACK, BYE, CANCEL, INFO, NOTIFY, MESSAGE, UPDATE
Max-Forwards: 69
Supported: 100rel, replaces, from-change
User-Agent: SIPPER for PhonerLite
P-Preferred-Identity: <sip:4901179322878 at 95.111.248.176>
Content-Length:   417

v=0
o=- 615152551 1 IN IP4 192.168.178.23
s=SIPPER for PhonerLite
c=IN IP4 192.168.178.23
t=0 0
m=audio 5062 RTP/AVP 8 0 2 3 97 110 111 9 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:2 G726-32/8000
a=rtpmap:3 GSM/8000
a=rtpmap:97 iLBC/8000
a=rtpmap:110 speex/8000
a=rtpmap:111 speex/16000
a=rtpmap:9 G722/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=ssrc:3874030355
a=sendrecv

U 2022/03/02 23:11:52.987526 +0000 95.111.248.176:5060 -> 176.199.99.57:61172

SIP/2.0 100 Trying
Via: SIP/2.0/UDP 192.168.178.23:5060;received=176.199.99.57;branch=z9hG4bK006c3cd0eb98ec11b76f277d269fdfd3;rport=61172
To: <sip:+493012030000 at 95.111.248.176>
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 5 INVITE
Server:Class5 OpenSIPS
Content-Length: 0

U 2022/03/02 23:11:52.994924 +0000 95.111.248.176:5060 -> 176.199.99.57:61172

SIP/2.0 407 Proxy Authentication Required
Via: SIP/2.0/UDP 192.168.178.23:5060;received=176.199.99.57;branch=z9hG4bK006c3cd0eb98ec11b76f277d269fdfd3;rport=61172
To: <sip:+493012030000 at 95.111.248.176>;tag=28de.97201e0cc1f84b5f4058acdfba4ae5bf
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 5 INVITE
Proxy-Authenticate: Digest realm="95.111.248.176", nonce="Adg2o5qqx5zG1rXomjs4ijFivSdNo2tetQO2qu9/LRYA"
Server:Class5 OpenSIPS
Content-Length: 0

U 2022/03/02 23:11:53.531998 +0000 176.199.99.57:61172 -> 95.111.248.176:5060

INVITE sip:+493012030000 at 95.111.248.176 SIP/2.0
Via: SIP/2.0/UDP 192.168.178.23:5060;branch=z9hG4bK006c3cd0eb98ec11b770277d269fdfd3;rport
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
To: <sip:+493012030000 at 95.111.248.176>
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 6 INVITE
Contact: <sip:4901179322878 at 192.168.178.23:5060>
Proxy-Authorization: Digest username="4901179322878", realm="95.111.248.176", nonce="Adg2o5qqx5zG1rXomjs4ijFivSdNo2tetQO2qu9/LRYA", uri="sip:+493012030000 at 95.111.248.176", response="f8bbe4488f0bf527d6c21038c021e434", algorithm=MD5
Content-Type: application/sdp
Allow: INVITE, OPTIONS, ACK, BYE, CANCEL, INFO, NOTIFY, MESSAGE, UPDATE
Max-Forwards: 69
Supported: 100rel, replaces, from-change
User-Agent: SIPPER for PhonerLite
P-Preferred-Identity: <sip:4901179322878 at 95.111.248.176>
Content-Length:   417

v=0
o=- 615152551 1 IN IP4 192.168.178.23
s=SIPPER for PhonerLite
c=IN IP4 192.168.178.23
t=0 0
m=audio 5062 RTP/AVP 8 0 2 3 97 110 111 9 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:2 G726-32/8000
a=rtpmap:3 GSM/8000
a=rtpmap:97 iLBC/8000
a=rtpmap:110 speex/8000
a=rtpmap:111 speex/16000
a=rtpmap:9 G722/8000
a=rtpmap:101 telephone-event/8000
a=fmtp:101 0-16
a=ssrc:3874030355
a=sendrecv

U 2022/03/02 23:11:53.532054 +0000 95.111.248.176:5060 -> 176.199.99.57:61172

SIP/2.0 100 Trying
Via: SIP/2.0/UDP 192.168.178.23:5060;received=176.199.99.57;branch=z9hG4bK006c3cd0eb98ec11b770277d269fdfd3;rport=61172
To: <sip:+493012030000 at 95.111.248.176>
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 6 INVITE
Server:Class5 OpenSIPS
Content-Length: 0

U 2022/03/02 23:11:53.882219 +0000 95.111.248.176:5060 -> 176.199.99.57:61172

SIP/2.0 100 Giving it a try
Via: SIP/2.0/UDP 192.168.178.23:5060;received=176.199.99.57;branch=z9hG4bK006c3cd0eb98ec11b770277d269fdfd3;rport=61172
To: <sip:+493012030000 at 95.111.248.176>
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 6 INVITE
Server:Class5 OpenSIPS
Content-Length: 0

U 2022/03/02 23:11:53.884734 +0000 95.111.248.176:5060 -> 127.0.0.1:5080

INVITE sip:493012030000 at 127.0.0.1:5080 SIP/2.0
Record-Route: <sip:95.111.248.176;lr;ftag=2078659750;did=3de.fa0dd947>
Via: SIP/2.0/UDP 95.111.248.176:5060;branch=z9hG4bK30f3.7d39fdf6.0
Via: SIP/2.0/UDP 192.168.178.23:5060;received=176.199.99.57;branch=z9hG4bK006c3cd0eb98ec11b770277d269fdfd3;rport=61172
From: "PhonerLite" <sip:493010050000 at 95.111.248.176>;tag=2078659750
To: <sip:493012030000 at 95.111.248.176>
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 6 INVITE
Contact: <sip:4901179322878 at 176.199.99.57:61172>
Proxy-Authorization: Digest username="4901179322878", realm="95.111.248.176", nonce="Adg2o5qqx5zG1rXomjs4ijFivSdNo2tetQO2qu9/LRYA", uri="sip:+493012030000 at 95.111.248.176", response="f8bbe4488f0bf527d6c21038c021e434", algorithm=MD5
Content-Type: application/sdp
Allow: INVITE, OPTIONS, ACK, BYE, CANCEL, INFO, NOTIFY, MESSAGE, UPDATE
Max-Forwards: 69
Supported: 100rel, replaces, from-change
User-Agent: SIPPER for PhonerLite
P-Preferred-Identity: <sip:4901179322878 at 95.111.248.176>
Content-Length: 436
P-NAT: rtpproxy_offer
P-remote-id: h323-remote-id=class4-dev
P-NextHop-IP: 5.255.95.42
Xpgk-route-retries: 0

v=0
o=- 615152551 1 IN IP4 95.111.248.176
s=SIPPER for PhonerLite
c=IN IP4 95.111.248.176
t=0 0
m=audio 44174 RTP/AVP 8 0 2 3 97 110 111 9 101
a=rtpmap:8 PCMA/8000
a=rtpmap:0 PCMU/8000
a=rtpmap:2 G726-32/8000
a=rtpmap:3 GSM/8000
a=rtpmap:97 iLBC/8000
a=rtpmap:110 speex/8000
a=rtpmap:111 speex/16000
a=rtpmap:9 G722/800
U 2022/03/02 23:11:53.885374 +0000 95.111.248.176:5060 -> 127.0.0.1:5080

U 2022/03/02 23:12:03.995994 +0000 95.111.248.176:5060 -> 176.199.99.57:61172

SIP/2.0 480 Temporarily Unavailable
Via: SIP/2.0/UDP 192.168.178.23:5060;received=176.199.99.57;branch=z9hG4bK006c3cd0eb98ec11b770277d269fdfd3;rport=61172
To: <sip:+493012030000 at 95.111.248.176>;tag=bcaa-16a89e664a922fe2f5878aa869f11a7f
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 6 INVITE
Server:Class5 OpenSIPS
Content-Length: 0

U 2022/03/02 23:12:04.26921 +0000 176.199.99.57:61172 -> 95.111.248.176:5060

ACK sip:+493012030000 at 95.111.248.176 SIP/2.0
Via: SIP/2.0/UDP 192.168.178.23:5060;branch=z9hG4bK006c3cd0eb98ec11b770277d269fdfd3;rport
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
To: <sip:+493012030000 at 95.111.248.176>;tag=bcaa-16a89e664a922fe2f5878aa869f11a7f
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 6 ACK
Content-Length: 0

U 2022/03/02 23:12:04.26968 +0000 176.199.99.57:61172 -> 95.111.248.176:5060

ACK sip:+493012030000 at 95.111.248.176 SIP/2.0
Via: SIP/2.0/UDP 192.168.178.23:5060;branch=z9hG4bK006c3cd0eb98ec11b770277d269fdfd3;rport
From: "PhonerLite" <sip:4901179322878 at 95.111.248.176>;tag=2078659750
To: <sip:+493012030000 at 95.111.248.176>;tag=bcaa-16a89e664a922fe2f5878aa869f11a7f
Call-ID: 006C3CD0-EB98-EC11-B76E-277D269FDFD3 at 192.168.178.23
CSeq: 6 ACK
Content-Length: 0