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: 17240
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
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18579
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: 17240
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
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18579
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: 17240
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
SugarCRM integration - Customization and Add-ons - We Bring It All Together.
http://www.PoundTeam.com # 352-269-0000 # +44 (203) 769-2294 # +506 4001-8914
williamconley
 
Posts: 18579
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Development

Who is online

Users browsing this forum: No registered users and 2 guests