I am trying to run CQRLOG on my Raspberry Pi 3 B+. I have installed the beta version and when I run it I get a misaligned data access error.
What can I do to fix this?
Here is the debug file from the testing method:
**** DEBUG LEVEL 1 ****
Loading libssl:
Loading libcrypto:
Loading libmysqlclient:
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
[FORMS.PP] ExceptionOccurred
Sender=EBusError
Exception=Bus error or misaligned data access
Stack trace:
$0002F10C
$0006C7FC
TApplication.HandleException Bus error or misaligned data access
Stack trace:
$0002F10C
$0006C7FC
Closing ini file ...
-----
Best Regards,
Kirk
KK6KC
Hi !
Are you using Petr's latest Beta release for rpi ( https://cqrlog.com/comment/6424#comment-6424 ), self compiled from source or some old version loaded from repository elsewhere?
I'm a bit worried about lines:
Loading libssl:
Loading libcrypto:
Loading libmysqlclient:
They should show what versions are loaded. Do you have those packages installed?
At least you need libmysqlclient to get cqrlog work.
Others are needed if LoTW or clublogs (https connects) are needed.
--
Saku
OH1KH
I am using cqrlog_20180421_armhf.tar.gz
libssl was already there.
libcrypto was not, I just installed it now,
libmysqlclient was already there.
It still fails on launch with "Bus error or misaligned data access."
The splash screen says 2.0.2 (001)
-Kirk
Kirk Crawford
KK6KC
Lomita, CA, USA
Hi Kirk,
are you sure you are running the correct cqrlog binary? Tha splash screen should show 2.2.0 or something like that.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
HI!
I'm just getting up cqrlog to my old rpi2 used only as direwolf aprs node so far.
But it so slooooooow....
At first I did apt-get update and upgrade to installed Jessie but finally I get ready to install of cqrlog
First I installed cqrlog from repository and then tared over the latest test binary. Hoping that package installation would solve all dependences and then just replacing the new cqrlog from tar file on top would upgrade all.
But no. Started cqrlog debug=1
Package did bring version with splash 1.8.2 and it did not work. No clear reason shown in debug.
Then checked why version was that and noticed that package installs it as /usr/bin/cqrlog and untaring latest beta installs it as /bin/cqrlog.
So I had 2 cqrlogs.
Staring with /bin/cqrlog debug=1 showed splash 2.2.0 (001) and that llibmysqlclient was missing.
Actually it was there but not in form cqrlog was expecting it to be.
I had to do symlink:
sudo ln -s /usr/lib/arm-linux-gnueabihf/libmysqlclient.so.18 /usr/lib/arm-linux-gnueabihf/libmysqlclient.so
After that cqrlog started normal way (but so sloooooow... compared to my Lenovo Tpad)
It can not be used for anything, but nice to see that it started. Feeling may be different with rpi3 that is faster.
libmysqlclient-dev does no need to be installed.
I still need to find a package for TQSL so that I can test LoTW upload. Compile from source takes too long with this setup.
--
Saku
OH1KH
Hi Saku,
there is no need to create any symlink, just install libmariadbclient-dev-compat package.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
It seems my problem was not uninstalling the old version from the Raspberry Pi Add/Remove Software window. Once I uninstalled that, the beta version started working after I installed the libmariadbclient-dev-compat package.
Though now, i edit preferences and it says:"rictld binary not fount, cannot load list of supported rigs! Fix path to rigctld in TRX control tab" (Note there is a typo in "fount")
What do I have to install to make this work now?
Does the RPI package need to be updated to fix all of this?
-Kirk
Kirk Crawford
KK6KC
Lomita, CA, USA
rigctld utility is part of HamLib. Install libhamlib-utils package and it will work.
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
That fixed the rigctld issue.
It still puts warnings when I open the statistics page. Do I need to worry about those?
Here is the debug log:
**** DEBUG LEVEL 1 ****
SSL libraries:
Loading libmysqlclient:
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/pi/
Program home directory: /home/pi/.config/cqrlog/
Data directory: /home/pi/.config/cqrlog/database/
Memebers directory: /home/pi/.config/cqrlog/members/
ZIP code directory: /share/cqrlog/zipcodes/
Binary dir: /bin/
Share dir: /share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
WARNING: obsolete call to RecreateWnd for TfrmDBConnect
Warning: TWinControl.DestroyHandle frmDBConnect:TfrmDBConnect Handle not Allocated
/usr/sbin/mysqld --defaults-file=/home/pi/.config/cqrlog/database/mysql.cnf --datadir=/home/pi/.config/cqrlog/database/ --socket=/home/pi/.config/cqrlog/database/sock --port=64000
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:1
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
SELECT * FROM cqrlog_config
select * from db_version
[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
select * from cqrlog_common.db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
Settings:
-----------------------------------------------------
RigCtldPath:/usr/bin/rigctld
RigCtldArgs:-m 127 -r /dev/ttyUSB0 -t 4532 -s 38400 --set-conf=data_bits=8,stop_bits=1,serial_handshake=Hardware
RunRigCtld: FALSE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:localhost
RigPoll: 500
RigSendCWR: FALSE
RigId: 127
rigctld started!
Connected to localhost:4532
Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1
rotctld started!
Connected to localhost:4533
FreqmemSql:select id,freq,mode,bandwidth from freqmem order by id
FreqmemFirst:0 FreqmemLast:0
Sending: fmv
CW init
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
select locator from profiles where nr = 1
select locator from profiles where nr = 1
1-DM03UT;Lomita;
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
WARNING: obsolete call to RecreateWnd for TfrmPreferences
Warning: TWinControl.DestroyHandle frmPreferences:TfrmPreferences Handle not Allocated
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
SELECT * FROM profiles WHERE visible > 0 ORDER BY nr
SELECT * FROM profiles WHERE nr = 1
select count(*) from cqrlog001.cqrlog_config
Saving ini file to database
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Sending: fmv
Closing rigs...
1
2
3
4
5
6
Closing Details window
Section:frmQSODetails
Saving window size a position (frmQSODetails) (height|width|top|left):210|266|36|745
Section:frmNewQSO
Saving window size a position (frmNewQSO) (height|width|top|left):659|807|200|136
select count(*) from cqrlog001.cqrlog_config
Saving ini file to database
select count(*) from cqrlog001.cqrlog_config
Saving ini file to database
1
2
3
4
5
6
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Deleting config file: cqrlog.cfg
Deleting config file: 1cqrlog.cfg
Closing dData
/home/pi/.config/cqrlog/database/KirksPi.pid
Command:
kill 9098
Closing ini file ...
Kirk Crawford
KK6KC
Lomita, CA, USA
I mean when opening the settings, not statistics.
Kirk Crawford
KK6KC
Lomita, CA, USA