New SIP logging features and updated database requirement

Discussions about development of VICIDIAL and astGUIclient

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

New SIP logging features and updated database requirement

Postby mflorell » Thu May 30, 2019 12:57 pm

I usually don't comment much on pending development, but this one is going to require database software from 2012 or newer, either MySQL 5.6+ or MariaDB 5.3+. That's when "microseconds" support was added in each. Current VICIdial code requires only MySQL 5.1+(from 2005), and I know a lot of premise clients that are using very old versions like this.

This will be for some new SIP logging features that will hopefully help to be able to better identify FAS(False Answer Supervision) and PDD(Post Dial Delay).

Any comments?

https://dev.mysql.com/doc/refman/5.6/en ... conds.html
https://mariadb.com/kb/en/library/micro ... n-mariadb/
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: New SIP logging features and updated database requiremen

Postby williamconley » Mon Jun 03, 2019 11:05 pm

Anyone running a system that old (and sticking to it fiercely) should be able to put their DB on a separate server running a newer version of mysql. Unless there's a challenge with the mysql-client version, that should allow legacy systems to continue to upgrade without re-customizing their systems (which is the usual reason for refusal to upgrade). IMHO.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: New SIP logging features and updated database requiremen

Postby mflorell » Tue Jun 04, 2019 5:32 am

Yes, this shouldn't be a deal-breaker for most clients, but I know of several of our clients that are running older databases, which is one of the main reasons I posted this. The new features were actually committed to svn/trunk on Friday and are running in production for a couple of our clients already.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: New SIP logging features and updated database requiremen

Postby williamconley » Tue Jun 04, 2019 10:27 am

Are these logs optional and off by default so there won't be any crashes until the new feature is activated?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: New SIP logging features and updated database requiremen

Postby mflorell » Tue Jun 04, 2019 2:15 pm

Yes, these new features are optional, are disabled by default and have to be enabled in several places before the logging will occur.

The results so far are fascinating, and we haven't even written any reporting for it yet. One example is a phone call placed by a client today that went from INVITE to 200-OK in 0.177043 seconds(without any ringing), which should be fairly impossible and is almost certainly FAS.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: New SIP logging features and updated database requiremen

Postby williamconley » Tue Jun 04, 2019 2:25 pm

Useful tool. Until the FASsholes find out about it and learn to mimic a real call better. Although it's likely that most of them will never bother. So very cool. I expect a client to request an "alert" system eventually for when they begin to crop up.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: New SIP logging features and updated database requiremen

Postby dreedy » Fri Aug 16, 2019 11:38 am

I am trying to enable this on my test system and having an issue. SIP_EVENT_LOGGING.txt says to patch asterisk 13 with the patch in the in the extras folder. I have tried to apply it via patch sip_logging.patch. it seems to be looking for a directory that doesn't exist. it seems like it is looking for asterisk 13.21.1 and i am running the current one of 13.27.0. do i need to update the patch to apply it? if so what would the current dir of the asterisk that it is trying to use be at?
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici |VERSION: 2.14-900a | BUILD: 231115-1636 | svn 3787 |dbschema 1702
dreedy
 
Posts: 168
Joined: Tue Nov 24, 2015 10:16 pm

Re: New SIP logging features and updated database requiremen

Postby mflorell » Fri Aug 16, 2019 11:56 am

You often have to alter the path to fit your own directory structure, we have tested the patch on 13.17 and it does apply cleanly, so give it a try.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: New SIP logging features and updated database requiremen

Postby dreedy » Fri Aug 16, 2019 1:36 pm

ok, thank you i will see if i can track down the asterisk path that it is calling for. this seems like a great addition.
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici |VERSION: 2.14-900a | BUILD: 231115-1636 | svn 3787 |dbschema 1702
dreedy
 
Posts: 168
Joined: Tue Nov 24, 2015 10:16 pm

Re: New SIP logging features and updated database requiremen

Postby dhijrwn » Tue Aug 25, 2020 10:14 am

Hello, How can I disable this on manual dialing?
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: New SIP logging features and updated database requiremen

Postby mflorell » Tue Aug 25, 2020 7:31 pm

Are you saying you want this to be active for auto-dialing but disabled for all manual dial calls through the agent screen?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: New SIP logging features and updated database requiremen

Postby dhijrwn » Wed Aug 26, 2020 1:20 am

mflorell wrote:Are you saying you want this to be active for auto-dialing but disabled for all manual dial calls through the agent screen?


yes, is this possible :?: :D
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: New SIP logging features and updated database requiremen

Postby mflorell » Wed Aug 26, 2020 6:14 am

Yes, I just went ahead and added that last night, so you'll need to upgrade to the latest svn/trunk revision.

The changes in how you configure it in the Settings Container are detailed in the doc,
http://vicidial.org/docs/SIP_EVENT_LOGGING.txt
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: New SIP logging features and updated database requiremen

Postby dhijrwn » Wed Aug 26, 2020 6:28 am

mflorell wrote:Yes, I just went ahead and added that last night, so you'll need to upgrade to the latest svn/trunk revision.

The changes in how you configure it in the Settings Container are detailed in the doc,
http://vicidial.org/docs/SIP_EVENT_LOGGING.txt


Nice! Which server will I update? Thank you :D
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: New SIP logging features and updated database requiremen

Postby mflorell » Wed Aug 26, 2020 7:16 am

Well, I don't know what servers you have so I can't say :)

When you upgrade to a more recent svn/trunk revision, you should always upgrade all servers in a cluster, never just one.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: New SIP logging features and updated database requiremen

Postby dhijrwn » Wed Aug 26, 2020 7:49 am

mflorell wrote:Well, I don't know what servers you have so I can't say :)

When you upgrade to a more recent svn/trunk revision, you should always upgrade all servers in a cluster, never just one.


Haha, I see, Thank you. I tried on my express server first, i tried to autodial 200 calls and 10 manual dial, it doesn't show the records on sip event logging but it shows total number of records @_@.
Cluster setup i7-9700 cpu @ 3.00ghz 32GB ram 1xDB WEB ARCH 11xTEL 4core
ViciBox v.9.0.3 ISO VERSION:2.14-853a BUILD: 220328-1420
SVN: 3595 DB Schema: 1657 | Asterisk 13.29.2-vici
Zoiper 5 | VICIPhone| No Digium/Sangoma Hardware
dhijrwn
 
Posts: 149
Joined: Tue Jan 07, 2020 6:12 am

Re: New SIP logging features and updated database requiremen

Postby dreedy » Fri Apr 21, 2023 1:56 pm

is there a write up on how to patch the asterisk?
1- mysql/apache Server (ViciBox 11) Dell R640
1- Dialer (Vicibox 11) Dell R620
1- Archive Server Drobo 810n

Asterisk 16.30.0-vici |VERSION: 2.14-900a | BUILD: 231115-1636 | svn 3787 |dbschema 1702
dreedy
 
Posts: 168
Joined: Tue Nov 24, 2015 10:16 pm


Return to Development

Who is online

Users browsing this forum: No registered users and 24 guests