Startup failure

11 posts / 0 new
Last post
dl6fbs
Startup failure

Hello.
I just upgraded my opensuse and now i am unable to start cqrlog.
On startup i get a window with the message "Invalid type cast" and further on
when trying to open or create a database i get
TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (10.0.13-MariaDB).
I checked all the libraries with ldd, they are in place.
When i start cqrlog in a terminal with --debug=1 i see
bernd@jetway:/user/bernd/.config> /usr/bin/cqrlog --debug=1**** DEBUG LEVEL 1 ****Loading libssl: /usr/lib64/libssl.soLoading libcrypto: /usr/lib64/libcrypto.soLoading libmysqlclient: /usr/lib64/libmysqlclient.so.18.0.0**************************MySQL version: 10.**************************Loaded 77109 LoTW usersLoaded 85876 eQSL usersLoaded 45414 SCP calls*User home directory:    /home/bernd/Program home directory: /home/bernd/.config/cqrlog/Data directory:         /home/bernd/.config/cqrlog/database/Memebers directory:     /usr/share/cqrlog/members/ZIP code directory:     /usr/share/cqrlog/zipcodes/Binary dir:             /usr/bin/Share dir:              /usr/share/cqrlog/TConnection to MySQL:   10*TApplication.HandleException Invalid type cast  Stack trace:  $00000000004E4035  $00000000005861DF  $000000000072F17E  $000000000075CF26  $000000000075D7DA  $0000000000587E02  $00000000007E2F07  $00000000007D4E2A  $00007FD634BF4313select * from view_cqrlog_main_by_qsodate LIMIT 500 OFFSET 0TApplication.HandleException TMySQL56Connection can not work with the installed MySQL client version: Expected (5.6), got (10.0.13-MariaDB).  Stack trace:  $000000000093C2EA  $00000000008B37CA  $00000000008DF2F7  $00000000008A00C2  $00000000008DF1AF  $000000000044BDC7  $000000000044AFA0  $000000000042FAF1  $000000000071F2C3  $000000000044CF96  $000000000072CA23  $000000000071C7FF  $000000000071C72D  $0000000000450F4D  $000000000071ADFD  $0000000000738F59  $00000000007353D8Closing DXCluster windowClosing TRXControl windowClosing GrayLine windowClosing dDXCCDeleting config file: cqrlog.cfgClosing dData(cqrlog:28168): GLib-CRITICAL **: Source ID 15 was not found when attempting to remove it(cqrlog:28168): GLib-CRITICAL **: Source ID 14 was not found when attempting to remove it(cqrlog:28168): GLib-CRITICAL **: Source ID 47 was not found when attempting to remove it(cqrlog:28168): GLib-CRITICAL **: Source ID 46 was not found when attempting to remove it(cqrlog:28168): GLib-CRITICAL **: Source ID 52 was not found when attempting to remove it(cqrlog:28168): GLib-CRITICAL **: Source ID 51 was not found when attempting to remove itWARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?Closing ini file ...bernd@jetway:/user/bernd/.config>
 
So anybody out there got a hint for me ? What am i doing wrong ?
Oh by the way i use the recent version of cqrlog 1.8.2
73 Bernd, DL6FBS

ok2cqr
ok2cqr's picture
Re: Startup failure

Hi Bernd,
 
the problem is with your MariaDB version. CQRLOG will work with MariaDB but only version 5.6 not with version 10.0. It seems there are some changes in clinet library that cause this error.
73 Petr

dl6fbs
Re: Re: Startup Failure

Hello Petr.
That´s what i thought, but i can not get rid of this version because a lot of dependencies would be lost :-(( I think something else won´t work when i delet this version.
Is the first error message "Invalid type cast" also an error because of the wrong Database version ?
73 de Bernd, DL6FBS

ok2cqr
ok2cqr's picture
Re: Re: Startup Failure

Hi Bernd,
 
it seems they made some uncompatible changes the the API. It's very common for MySQL, they change the client library with every release. That is the reason why cqrlog needs to hadle version 5.1, 5.5 and 5.6.
 
Maybe it could work when you tell cqrlog to use Mysql 5.6 driver as default. Now when program can't recognize MySQL client library version, it uses library for MySQL 5.1. You can change it in source code and recompile it using make.  It's in https://github.com/ok2cqr/cqrlog/blob/master/src/dData.pas, line 1102.
 
73 Petr

dl6fbs
Startup Failure again

Hi Petr.
Thanks for your comment.
I tried compiling but get an error
after a lot of lines i see:
Compiling resource cqrlog.orcqrlog.lpr(62,1) Error: Error while compiling resourcescqrlog.lpr(62,1) Fatal: There were 1 errors compiling module, stoppingERROR: failed compiling of project /usr/src/cqrlog-1.8.2/src/cqrlog.lpiMakefile:8: recipe for target 'cqrlog' failedmake: *** [cqrlog] Error 2
Im not familiar with those things and have no idea
what i´m doing wrong :-((
 
73 de Bernd, DL6FBS
 

ok2cqr
ok2cqr's picture
Startup Failure again

Hi Bernd,
 
do you have all libraries installed?
List what you need is here: https://github.com/ok2cqr/cqrlog/blob/master/README.md
 
73 Petr

dl6fbs
Re: Startup failure again

Hi Petr.
I have
lazarus 1.2.6-2.3
fpc 2.6.4-2.10
mysql-community-server 5.6.17-2.1.12
mysql-community-server-client 5.6.17-2.1.12
but i can´t find a libmysql-dev none of the repositorities knows such a library
Where may i find it ?
73 de Bernd, DL6FBS

ok2cqr
ok2cqr's picture
Re: Startup failure again

Hi Bernd,
 
libmysql-dev is not needed. Now cqrlog supports loading also library with right name and doesn't need libmysql-dev.
 
73 Petr

k5wrn
k5wrn's picture
Same Issue

Petr,
I am in this same boat.  I'm running Fedora 20 and I have the mysql-community packages installed.
CQRLog fails to access the database.  A new database cannot be created.  I'm going to attempt to roll back to 1.8.1 and see if it will run.  This is a new install on a new machine.
Seven-Three,
Michael - K5WRN

Seven-Three,

Michael - K5WRN
Texas, USA

k5wrn
k5wrn's picture
Might be wrong Mysql Ver

Ok, I rolled back to 1.8.1 and I was greeted with the following:

Error during connection to database: TMySQL55Connection can not work with the installed MySQL client version: Expected (5.5), got (5.6.21).

It's possible I received this error with 1.8.2 as well and I didn't pay attention.  I try to change mysql to ver 5.5 and try again.

Seven-Three,

Michael - K5WRN
Texas, USA

ok2cqr
ok2cqr's picture
Re: Might be wrong Mysql Ver

Version 1.8.2 has MySQL 5.6 support. What error did you get with version 1.8.2? The list of errors should be in ~/.config/cqrlog/database/mysql.err.