Bug 1173261 - cqrlog is incompatible with the current mariadb
Summary: cqrlog is incompatible with the current mariadb
Keywords:
Status: CLOSED NEXTRELEASE
Alias: None
Product: Fedora
Classification: Fedora
Component: cqrlog
Version: 21
Hardware: All
OS: Linux
unspecified
urgent
Target Milestone: ---
Assignee: Richard Shaw
QA Contact: Fedora Extras Quality Assurance
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2014-12-11 18:53 UTC by Jussi Eloranta
Modified: 2015-02-20 19:25 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2015-02-20 19:25:32 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1161177 0 unspecified CLOSED Request for update to 2.6.4 2021-02-22 00:41:40 UTC
Red Hat Bugzilla 1161178 0 unspecified CLOSED Request update of lazarus to 1.2.4 or higher. 2021-02-22 00:41:40 UTC

Internal Links: 1161177 1161178

Description Jussi Eloranta 2014-12-11 18:53:12 UTC
Description of problem:

The current version of cqrlog provided with fedora 21 is 1.8.1. This does not seem to work anymore with the mariadb version in F21. Whenever one tries to start cqrlog, you get a dialog stating:

Error during connection to database: TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (10.0.14-MariaDB).
Version-Release number of selected component (if applicable):

And the program is unable to connect to the database.

How reproducible:

Everytime you start cqrlog.

Steps to Reproduce:
1. Install cqrlog
2. Try to start it
3.

Actual results:

Unable to connect to database.

Expected results:

It should connect to the database as before.

Additional info:

I don't know if this would be fixed in the new cqrlog versions but these apparently are pending for the new version free pascal & lazarus.

Comment 1 Jussi Eloranta 2014-12-12 17:28:42 UTC
I did some poking around the cqrlog source. Here is why it does not work:

1) Free pascal compile 2.6.x version sql routines cannot deal with the new mariadb version. You would either patch 2.6.x to accept the current mariadb version number and proceed or use 2.7.x (experimental).
2) The version number returned by the new mariadb server differs from the usual format major version.minor version. cqrlog uses the currency datatype for version numbers and this non-standard version string does not fit into that. For that reason, one has to change the source code such that it either: 1) only uses 5.6 stuff or 2) uses a different datatype for storing the version string and making appropriate comparisons (the right way to do it).

So, for short, the new mariadb is incompatible with cqrlog (or with free pascal for that matter).

I did mangage to procude a working version of cqrlog after doing the above. However, fpc 2.7.x has some stability issues and I need to look how to get the mariadb patch into fpc.2.6.4. By the way, fedora is still stuck at 2.6.2 (also new lazarus is needed).

Those who use fedora for ham radio should NOT upgrade to 21 until this one is sorted out.

Comment 2 Jussi Eloranta 2014-12-12 17:34:10 UTC
I must be still asleep, change:

You would either patch 2.6.x to accept the current mariadb version number and proceed or use 2.7.x (experimental).

to

You should either patch 2.6.x to accept the current mariadb version number or use 2.7.x (experimental), which already includes this patch.

Comment 3 Jussi Eloranta 2014-12-25 21:15:36 UTC
Some good news. The cqrlog authors have developed a workaround for the mariadb server response issue. The new version is already in the git repository and I have verified that it works correctly. This will compile only with fpc 2.6.4 (and new lazarus) and not with 2.6.2. So, *please* update fpc and lazarus packages for fedora so that we can get cqrlog working again.

Comment 4 Jussi Eloranta 2015-01-15 03:20:31 UTC
OK, new cqrlog version (1.8.3) is available and it contains the mariadb fix.
So, new fpc, lazarus and cqrlog are need in order to get cqrlog to work on F21.

Comment 5 Jussi Eloranta 2015-01-29 04:24:49 UTC
Could someone please look into this? This is the single most important application for ham radio. We will have an installfest geared toward hams soon and I would have to switch to some other distro just because of things are lagging behind.

Comment 6 Richard Shaw 2015-01-30 21:02:11 UTC
The lazarus and fpc issues are being tracked separately so I added them as "see also" instead of blockers.

I haven't had much time to deal with this and ideally fpc and lazarus would be updated but if it comes down to it I may setup a COPR repository as a stop-gap.

Comment 7 Richard Shaw 2015-02-07 04:01:29 UTC
Ok, building what should have been a minor update (fpc 2.6.2 -> 2.6.4) was problematic. Seeing how it builds I really wish cqrlog was written in C :)

After that lazarus and cqrlog were easy, you can enable the COPR repository below:

https://copr.fedoraproject.org/coprs/hobbes1069/cqrlog/

This is intended to be a temporary fix, hopefully the fpc and lazarus maintainers will eventually get the packages updated.

Comment 8 Jussi Eloranta 2015-02-07 19:16:55 UTC
Works great - thank you!!!!

Comment 9 Jussi Eloranta 2015-02-16 04:36:52 UTC
I noticed that only intel binaries are available. All the components compile on ARM as well and some people were asking for a working cqrlog for this architecture. Any chance you could compile this for ARM too?

Comment 10 Richard Shaw 2015-02-16 13:30:48 UTC
Unfortunately COPR does not provide an ARM target so there's not much I can do.

Comment 11 Richard Shaw 2015-02-20 19:25:32 UTC
Ok, I'm going to go ahead and close this one. Once the fpc and lazarus issues are fixed, this one should be a non-issue.


Note You need to log in before you can comment on or make changes to this bug.