CentOS 7, x64, DA 1.513 --> MariaDB 10.2?

J

Jeffreyb

Verified User
Joined
May 22, 2017
Messages
15
Hello,

I would like to install MariaDB 10.2.2+ (e.g. 10.2.5) on my CentOS 7 x64 server, however, this version is not (yet) supported I believe?
What is the best way to do this w/o breaking DA?

Best regards,
Jeffrey
 
Hello,

Yes, not supported yet. You can try and it from official repo: https://downloads.mariadb.org/maria...o_release=centos7-amd64--centos7&version=10.2

or try to use custom_versions.txt

Code: 
cd /usr/local/directadmin/custombuild/
./build update
./build clean
./build set mariadb 10.1
./build set mysql_inst mariadb
./build set mysql_backup yes
echo "mariadb10.1:10.2.6:" >> custom_versions.txt

Download rpm-files from http://yum.mariadb.org/10.2/centos7-amd64/rpms/ to /usr/local/directadmin/custombuild/mysql/ then run:

Code: 
./build mysql

p.s. I did not test it yet. So it's on your own risk. Please try first in a dev environment.
 
Yes, the 10.2.6 is mentioned in my post above. It does not exist in custombuild yet.

did you try it already?
 
Last edited:
I've just finished adding early MariaDB 10.2 support into CustomBuild 2.0, rev 1669 on files1.
10.2.6 is also updated to files1 and in the versions.txt.

Although the build script seems to work fine after basic testing, I've not yet confirmed that MariaDB 10.2 works, so I would not recommend it on production box quite yet.

As always, ensure you have full backups of your databases before making any changes to your database version, and also before any changes to the my.cnf.
If needed, CB can do it for you: https://help.directadmin.com/item.php?id=678

John
 
Used zEitEr method, seems to work fine.
upgraded custombuild and used the latest custombuild, all seems still fine. (new server, no previous databases installed on it)

DA is saying 10.2.6 is running, as well as phpmyadmin, no problems found so far!

Tahnk you!
 
zEitEr said:
Yes, the 10.2.6 is mentioned in my post above. It does not exist in custombuild yet.

did you try it already?
Click to expand...

No, not yet. I usually wait until it's in custombuild.

Thanks @John for adding it.
As I don't have a separate dev box installed with DA at the moment and I don't want to risk it on my production environment I probably wait until someone can confirm it works stable.
 
I did the upgrade to MariaDB 10.2.6 on Centos 7 last night (with custombuild), It went smooth as always. :cool:
 
https://github.com/roundcube/roundcubemail/issues/5774

MariaDB 10.2.4+ has "rows" as a reserved word now and can't be used as identified w/o quotes.
DirectAdmin ships (at the moment) with Roundcube 1.2.5, (which uses rows as identifier w/o quotes). The problem is fixed in 1.3.0.
Roundcube 1.3.0 however is still in beta (candidate release).

Code: 
perl -pi -e 's/AS rows/AS `rows`/' /var/www/html/roundcubemail-1.2.5/program/lib/Roundcube/rcube_contacts.php
cat /var/www/html/roundcubemail-1.2.5/program/lib/Roundcube/rcube_contacts.php | grep "SELECT COUNT("
could be used as temp fix... (change rows to `rows` in the query)
 
You must log in or register to reply here.
Back
Top