MariaDB upgrade

All installation and configuration problems and questions

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

MariaDB upgrade

Postby Stinger554 » Fri Jul 20, 2018 1:26 pm

Hello,

We are looking into upgrading our MariaDB version from 5.5.33 to at least MariaDB 10.1 and just wanted to see if there were any known issues that would occur from this upgrade. I spend some time looking searching but didn't really see any results and just want to see/verify that there were any known issues.

Thanks
VERSION: 2.14-675a
BUILD: 180520-1749
Asterisk Version: 1.8.32.2-vici
Stinger554
 
Posts: 17
Joined: Wed Oct 12, 2016 3:40 pm

Re: MariaDB upgrade

Postby mflorell » Fri Jul 20, 2018 3:32 pm

There are some behavior changes in how queries are treated, like the SQL_MODE that defaults to strict settings, which will not work with VICIdial's code.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: MariaDB upgrade

Postby Stinger554 » Fri Jul 20, 2018 4:59 pm

mflorell wrote:There are some behavior changes in how queries are treated, like the SQL_MODE that defaults to strict settings, which will not work with VICIdial's code.


Understood. Are you aware of any configuration changes inside MariaDB that can be made to accommodate Vicidial's code or should we just not upgrade MariaDB?
VERSION: 2.14-675a
BUILD: 180520-1749
Asterisk Version: 1.8.32.2-vici
Stinger554
 
Posts: 17
Joined: Wed Oct 12, 2016 3:40 pm

Re: MariaDB upgrade

Postby mflorell » Fri Jul 20, 2018 7:18 pm

The settings changes are covered in this Issue Tracker ticket:
http://www.vicidial.org/VICIDIALmantis/view.php?id=1108

After you change the SQL_MODE setting, it should work with VICIdial.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 69 guests