Mariadb 10.x compatibility

7 posts / 0 new
Last post
KE0CKW
Mariadb 10.x compatibility

I've been using Mariadb v10.x for some time, and it has shown to be very compatible with mysql based apps.
 .
I installed CQRLOG for the first time the other night and ran across an error thrown during startup. It basically said that it didnt likethe v10.x verion of mariadb but was insteadd needing/looking for the 5.5/5.6 version.
.I've installed the libmysqlclient18, which also seems to have a dependancy to mysql 5.5/5.6.
Any sense on when mariadb 10.x will be supported?
 .
thanks,
Brad

AA6KJ
mariadb

Hi Brad,
At the moment cqrlog does not work with MariaDB 10.x. However, you can get it to run if you do the following:
1) You need to compile cqrlog with fpc 2.7.x (development version) from source (source from the git repo). It is bit of a hassle to install fpc 2.7.x as you need to compile it first.
2) Patch dData.pas, dLogUpload.pas, dDXCluster.pas, fDBConnect.pas such that they do not attempt to read the database server version number & make it use 5.6 directly. (I have these patched files if you need)
In order to produce the correct fix for 2), I would need to remember how to program in pascal. Last time I programmed in pascal was almost 20 years ago!! Petr or Martin will probably fix this at some point when they have time. The issue is that cqrlog should be prepared to receive a variety of different server version responses (needs different data type for storage).
Jussi (AA6KJ)
ps. I do have cqrlog binary that is compiled using the above recipe (on Fedora 21). It might work on your system provided that we don't have too much differences in the shared libraries installed. Drop me an email if you want to try it.
 

ok2cqr
ok2cqr's picture
Re: Mariadb 10.x compatibility

Hi Brad,
 
I just added some changes to CQRLOG source code to handle MariaDB 10 compatibility. It will be part of new version.
 
73 Petr, OK2CQR

KE0CKW
Hi Petr,

Hi Petr,
     Excellent. Thanks much for the quick turn-around on the request.  Looking forward to the next release, so I can start using CQRLOG.  :)
 
Thanks again,
73 KE0KW Brad

AA6KJ
mariadb

Hi,
That's great news Petr! Does one still need to compile it with fpc 2.7.x to get it working? The mysql lib also got confused by the mariadb version string.
Jussi (AA6KJ)
 

ok2cqr
ok2cqr's picture
Re: mariadb

Hi Jussi,
 
no, it will work with current 2.6.4. Version 2.7.1 won't need the files added to src/mysql directory but it's only SVN version. After release as stable, I'll remove files from mysql/ directory.
 
73 Petr

AA6KJ
good job!!

Hi Petr,
Yes, I just compiled it on fedora 21 with fpc 2.6.4 and everything works!! Now if I could get the fedora people to update fpc from 2.6.2 -> 2.6.4 (& lazarus) and use the current git version for mariadb support.
Thanks a lot!
Jussi (AA6KJ)