CQRLOG 2.3 on RaspberryPi continuing install problems

17 posts / 0 new
Last post
KC3KHA
CQRLOG 2.3 on RaspberryPi continuing install problems

I'm stilll trying to install CQRLOG 2.3.0-1 on my Raspberry Pi 3B ver. 1.2, as I reported in post https://www.cqrlog.com/node/2084. I'm using the
Raspberry Pi .deb package at https://www.cqrlog.com/download. I'm using Raspian 8.0 (jessie).

I've tried both Mysql and Mariadb, both version 5.5 and 10.0. On my last attempt, I installed MariaDB 10.0. The last output of 'cqrlog --debug=1' was:
--------
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:8
WARNING: obsolete call to RecreateWnd for TfrmDbError
Warning: TWinControl.DestroyHandle frmDbError:TfrmDbError Handle not Allocated

----------
Yet, MariaDB seems to be installed correctly. Here's the last output of mysql.err:
----------
180730 11:16:47 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
180730 11:16:47 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
180730 11:16:47 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
180730 11:16:47 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
180730 11:16:47 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist
180730 11:16:47 [Note] Reading of all Master_info entries succeded
180730 11:16:47 [Note] Added new Master_info '' to hash table
180730 11:16:47 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.0.35-MariaDB-0+deb8u1' socket: '/home/pi/.config/cqrlog/database/sock' port: 64000 (Raspbian)

---------
And, here's some MySQL output:
---------
pi@raspberrypi:~ $ mysql -u root -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 35
Server version: 10.0.35-MariaDB-0+deb8u1 (Raspbian)
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
MariaDB [(none)]> Bye
pi@raspberrypi:~ $

-----------------
From this, it doesn't look as if the MariaDB CQRLOG databases were intialized at all.

Can anyone help sort this out? According to the change logs, MariaDB has been supported since CQRLOG version 1.8. Are there other diagnostics I can run to help resolve this issue?

Thanks for any help or suggestions.

-Kevin
KC3KZ (was KC3KHA)

GM4NFI
I have the same issue.

Hi
I replied to the previous postings.
I am having exactly the same problem trying to install V.2.3.0
I previously had version 2.0 running without Mariadb installed.
What I don't understand is why V2.3.0 needs Mariadb as I thought CQRLog used MySQL as the backend database.

Currently I am thinking of compiling from source.
or
trying V2.3.0 in a clean install under another version of Linux.

73
Dave
GM4NFI

KC3KHA
Hi, Dave, I saw your response

Hi, Dave, I saw your response to my initial posting.

I'm not sure how to use the older version packages of CQRLOG. You're right, they don't come as armhf.deb packages, so I don't know how to install them. I didn't want to install Pascal on my Raspberry Pi to compile the source.

I'm going to try to install MySQL today, to see if I get the same diagnostic messages that I got from MariaDB, and confirm that CQRLOG 2.3.0 doesn't work, out of the box, on either one of them.

Thanks for your feedback.

-Kevin
KC3KZ

KC3KHA
Trying with MySQL 5.5

Here's the similar output after 'sudo apt-get remove mariadb*' and purging, and installing MySQL 5.5:
-----------------------
pi@raspberrypi:~ $ sudo dpkg -i Downloads/cqrlog_2.3.0-1_armhf.deb
Selecting previously unselected package cqrlog.
(Reading database ... 119151 files and directories currently installed.)
Preparing to unpack .../cqrlog_2.3.0-1_armhf.deb ...
Unpacking cqrlog (2.3.0-1) ...
dpkg: dependency problems prevent configuration of cqrlog:
cqrlog depends on libhamlib-utils (>= 1.2.10); however:
Package libhamlib-utils is not installed.
cqrlog depends on libmariadbclient-dev; however:
Package libmariadbclient-dev is not installed.
cqrlog depends on libmariadbclient-dev-compat; however:
Package libmariadbclient-dev-compat is not installed.
dpkg: error processing package cqrlog (--install):
dependency problems - leaving unconfigured
Processing triggers for gnome-menus (3.13.3-6) ...
Processing triggers for desktop-file-utils (0.22-1) ...
Processing triggers for mime-support (3.58) ...
Processing triggers for man-db (2.7.5-1~bpo8+1) ...
Errors were encountered while processing:
cqrlog
pi@raspberrypi:~ $

-------------------------------
Here's the output of running CQRLOG with --debug=1:
---------------------
pi@raspberrypi:~ $ cqrlog --debug=1
Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****
SSL libraries:
Loading libmysqlclient:
FATAL ERROR: Can not get MySQL client library version version!
Setting to default version (5.1)
**********************************
MySQL version assigned: 5.1
**********************************
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: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.1
*
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
180801 10:47:17 [Note] /usr/sbin/mysqld (mysqld 5.5.60-0+deb8u1) starting as process 15483 ...
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:1
...
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:8
WARNING: obsolete call to RecreateWnd for TfrmDbError
Warning: TWinControl.DestroyHandle frmDbError:TfrmDbError Handle not Allocated
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
Closing ini file ...

----------------------------------------
MySQL seems to be installed correctly and operating:
---------------------------------------
pi@raspberrypi:~ $ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 44
Server version: 5.5.60-0+deb8u1 (Raspbian)
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
+--------------------+
3 rows in set (0.00 sec)
mysql>

--------------------------------------------------------------------------
However, again, the databases don't seem to be initialized. /var/log/mysql.err was present, but competely empty.

Any further tests or diagnostics to run?

Thanks for any help, advice or suggestions.

-Kevin
KC3KZ

GM4NFI
CQRLog

OK I did not realise that the source was in the Delphi dialec of Pascal just assumed "C".
Don't think I will now try compiling from source.
The last time I used a Pascal compiler with an ARM processor was in the early 1990s with the original ARM processors and that was with ISO Pascal.

What I am going to try next is a "clean" install of Ubuntu Linux 18.04 on an old Laptop.
(Clean because I want to see exactly what dependancies CQRLog needs and I want to start with nil.)

Then I am going to try to install CQRLog V2.3.0 and see/document what dependancies it needs.

That way I might get some idea of what is going on/needed when CQRLog is installed on a RPi under Raspbian.

See https://www.cqrlog.com/node/1857
For V2.1.0

( https://www.dropbox.com/s/pp613nzsqai7ond/cqrlog_2.1.0-1_armhf.deb?dl=0.)

I still have V.1.9.0 as an armhf.deb file. This version installs fine on my RPi but it is getting quite old now.

73

Dave
GM4NFI

KC3KHA
Some success with ver 2.1.0

Hi, Dave,

Thanks for the pointer to the .deb package for version 2.1.0. I think I had some success with it. Please forgive the long cut-n-paste below, as I try to document what I did.

I started with MySQL5.5 installed and running correctly. I downloaded the 2.1.0 .deb package and tried to install it:
---------------------------------------------
pi@raspberrypi:~/Downloads $ sudo dpkg -i cqrlog_2.1.0-1_armhf.deb
Selecting previously unselected package cqrlog.
(Reading database ... 119152 files and directories currently installed.)
Preparing to unpack cqrlog_2.1.0-1_armhf.deb ...
Unpacking cqrlog (2.1.0-1) ...
dpkg: dependency problems prevent configuration of cqrlog:
cqrlog depends on libhamlib-utils (>= 1.2.10); however:
Package libhamlib-utils is not installed.
cqrlog depends on libmariadbclient-dev | libmysqlclient-dev; however:
Package libmariadbclient-dev is not installed.
Package libmysqlclient-dev is not installed.
dpkg: error processing package cqrlog (--install):
dependency problems - leaving unconfigured
Processing triggers for man-db (2.7.5-1~bpo8+1) ...
Processing triggers for gnome-menus (3.13.3-6) ...
Processing triggers for desktop-file-utils (0.22-1) ...
Processing triggers for mime-support (3.58) ...
Errors were encountered while processing:
cqrlog

-----------------------------------------
I went back to try to install the hamlib package, but was stopped:
----------------------------------------
pi@raspberrypi:~/Downloads $ sudo apt-get install libhamlib-utils
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
cqrlog : Depends: libmariadbclient-dev but it is not going to be installed or
libmysqlclient-dev but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

------------------------------------------
I followed the directions:
---------------------------------------------
pi@raspberrypi:~/Downloads $ sudo apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
libhamlib-utils libmariadbclient-dev libmariadbclient18 mariadb-common
The following NEW packages will be installed:
libhamlib-utils libmariadbclient-dev libmariadbclient18 mariadb-common
0 upgraded, 4 newly installed, 0 to remove and 6 not upgraded.
1 not fully installed or removed.
Need to get 0 B/1,856 kB of archives.
After this operation, 10.3 MB of additional disk space will be used.
Do you want to continue? [Y/n]
Selecting previously unselected package libhamlib-utils.
(Reading database ... 119524 files and directories currently installed.)
Preparing to unpack .../libhamlib-utils_1.2.15.3-2+b1_armhf.deb ...
Unpacking libhamlib-utils (1.2.15.3-2+b1) ...
Selecting previously unselected package mariadb-common.
Preparing to unpack .../mariadb-common_10.0.35-0+deb8u1_all.deb ...
Unpacking mariadb-common (10.0.35-0+deb8u1) ...
Selecting previously unselected package libmariadbclient18:armhf.
Preparing to unpack .../libmariadbclient18_5.5.39-2_armhf.deb ...
Unpacking libmariadbclient18:armhf (5.5.39-2) ...
Selecting previously unselected package libmariadbclient-dev.
Preparing to unpack .../libmariadbclient-dev_5.5.39-2_armhf.deb ...
Unpacking libmariadbclient-dev (5.5.39-2) ...
Processing triggers for man-db (2.7.5-1~bpo8+1) ...
Setting up libhamlib-utils (1.2.15.3-2+b1) ...
Setting up mariadb-common (10.0.35-0+deb8u1) ...
Setting up libmariadbclient18:armhf (5.5.39-2) ...
Setting up libmariadbclient-dev (5.5.39-2) ...
Setting up cqrlog (2.1.0-1) ...
Processing triggers for libc-bin (2.19-18+deb8u10) ...

--------------------------------------------------
Then, when I tried to install ver 2.1.0 again, it seemed to work:
---------------------------------------------------
pi@raspberrypi:~/Downloads $ sudo dpkg -i cqrlog_2.1.0-1_armhf.deb
(Reading database ... 119852 files and directories currently installed.)
Preparing to unpack cqrlog_2.1.0-1_armhf.deb ...
Unpacking cqrlog (2.1.0-1) over (2.1.0-1) ...
Setting up cqrlog (2.1.0-1) ...
Processing triggers for man-db (2.7.5-1~bpo8+1) ...
Processing triggers for gnome-menus (3.13.3-6) ...
Processing triggers for desktop-file-utils (0.22-1) ...
Processing triggers for mime-support (3.58) ...
pi@raspberrypi:~/Downloads $

-----------------------------------------
Running 'cqrlog --debug=1' gives:
------------------------------------------
pi@raspberrypi:~/Downloads $ cqrlog --debug=1
**** DEBUG LEVEL 1 ****
SSL libraries:
Loading libmysqlclient:
FATAL ERROR: Can not get MySQL client library version version!
Setting to default version (5.1)
**********************************
MySQL version assigned: 5.1
**********************************
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: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.1
*
56 us states loaded
/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
180802 10:04:02 [Note] /usr/sbin/mysqld (mysqld 5.5.60-0+deb8u1) starting as process 20951 ...
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:1
...
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
Trying:8
TApplication.HandleException List index (0) out of bounds NOTE: clicked 'REPAIR DATABASE'
Stack trace:
$00094794
$003178E4
$00041270
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
Invalid file handle
Closing ini file ...
pi@raspberrypi:~/Downloads $

--------------------------------------------
So, I still get database errors, the database is not initialized (like it was for mariaDB?) and CQRLOG is still unusable.

Thanks for the suggestion and your work. Let me know if there's anything I can do.

-Kevin
KC3KZ

GM4NFI
CQRLog on Raspberry Pi

Hi Kevin

Thanks for the update. I have not tried V2.1.0 but its interesting that it also needs "bits" from MariaDB.
I am sure that V1.9.0 which installed fine did not need these dependancies.
I think I still have a working version of V1.9.0 on an SD card so will have a look.

V1.9.0 definitely works fine on a Raspberry Pi.

Currently I have "broken" the boot on my laptop setting up the dual boot so I am no further on until I get that fixed.
I had a dual boot Win7/Ubuntu 15.04 working fine. I installed Ubuntu 18.04 as I direct replacement for 15.04 and it broke the boot.

Regards
Dave
GM4NFI

GM4NFI
SUCCESS

Well after spending days with the above issues I decided on a fresh start.
A clean SD card.
I downloaded the latest version of Raspbian V9 "Stretch" and wrote it onto the clean SD Card
That booted up fine. Bit different to V8 Jessie.
Now I installed mysql-server
and mysql client.

This install is different to previous installs. It seems to install MariaDB
Now I tried to install CQRLog it installed fine. In used to .deb file using gdebi as the front end.
No missing dependencies. It installed fine and starts to run.

However it is giving an error when I try to create a log as it cant create a database.
Says mysql server is not present.
Anyway thats progress.

73
Dave
GM4NFI

GM4NFI
MARIADB or MySQL?

Well now I have CQRLog installing and running BUT it is giving an error that MySQL is not present. Not surprising see below.

With Raspian V9 if do
sudo app-get install mysql-server
and
sudo app-get install mysql-client

You get MariaDB and NOT mysql - strange!

Now when I did exactly what I did above with Raspbian V8 (a year back)
mysql installed and not MariaDB

The Raspian forums have a lot of people commenting about this.
Though MariaDB and mySQL seem compatible if you have another app. that uses mysql it will not be happy with MariaDB.

73
Dave
GM4NFI

GM4NFI
Now Running

Well after a re-boot CQRLog seems quite happy to use MariaDB.

Still working on getting Rig Control working.
Have downloaded hamlib and installed rigctl.
Going to get flrig running to check that I have working rig control.
Easier to use than rigctl from the command line.

Progress
73
Dave

KC3KHA
Success with CQRLOG 2.3.0 and Raspian V9 'Stretch'

Thanks for the suggestion of trying the updated Raspian V9 'Stretch.' That worked like a champ for me. I bought a new 64GB microSDcard, installed Raspian V9 on it directly (not through NOOB, but I don't think this is significant), and downloaded CQRLOG 2.3.0 .deb package. First attempt at installing had a lot of errors for missing packages:

pi@raspberrypi:~/Downloads $ sudo apt-get install mariadb-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt --fix-broken install' to correct these.
The following packages have unmet dependencies:
cqrlog : Depends: libssl-dev but it is not going to be installed
Depends: mariadb-client but it is not going to be installed or
mysql-client but it is not going to be installed
Depends: libhamlib2 (>= 1.2.10) but it is not going to be installed
Depends: libhamlib-utils (>= 1.2.10) but it is not going to be installed
Depends: libmariadbclient-dev but it is not going to be installed
Depends: libmariadbclient-dev-compat but it is not going to be installed
mariadb-server : Depends: mariadb-server-10.1 (>= 10.1.23-9+deb9u1) but it is not going to be installed
E: Unmet dependencies. Try 'apt --fix-broken install' with no packages (or specify a solution).
pi@raspberrypi:~/Downloads $

I used 'apt --fix-broken install mariadb-server' to install both the server and client. Tried to install CQRLOG again, and this time it didn't complain at all:

pi@raspberrypi:~/Downloads $ sudo dpkg -i cqrlog_2.3.0-1_armhf.deb
(Reading database ... 110496 files and directories currently installed.)
Preparing to unpack cqrlog_2.3.0-1_armhf.deb ...
Unpacking cqrlog (2.3.0-1) over (2.3.0-1) ...
Setting up cqrlog (2.3.0-1) ...
Changes removed from /etc/apparmor.d/usr.sbin.mysqld
cat: /etc/apparmor.d/local/usr.sbin.mysqld: No such file or directory
/usr/share/cqrlog/cqrlog-apparmor-fix: line 44: /etc/apparmor.d/local/usr.sbin.mysqld: No such file or directory
/usr/share/cqrlog/cqrlog-apparmor-fix: line 45: /etc/apparmor.d/local/usr.sbin.mysqld: No such file or directory
File /etc/apparmor.d/local/usr.sbin.mysqld was modified, restarting apparmor
it seems apparmor is not installed, restarting skipped
Processing triggers for gnome-menus (3.13.3-9) ...
Processing triggers for desktop-file-utils (0.23-1) ...
Processing triggers for mime-support (3.60) ...
Processing triggers for man-db (2.7.6.1-2) ...
pi@raspberrypi:~/Downloads $

I fired CQRLOG up from the Accessories menu, and it initially complained about not finding MySQL, but it then moved on to initialize the database correctly, it seems. Subsequent starts of CQRLOG found the database and started up normally.

Looking forward to working with CQRLOG, especially with WSJT-X and fldigi.

Thanks, again, to all who made suggestions.

-Kevin
KC3KZ (was KC3KHA)

GM4NFI
Working Fine

Hi Kevin
What I did to get it working was.
1 New SD Card 32GB
1 Installed Raspbian V9 Stretch.
2 Installed Gparted
3 sudo apt-get install mysql-server
4 sudo apt-get install mysql-clent
5 Now the strange bit when I run mysql I get MariaDB from what I have read Debian have decided to have MariaDB and not Mysql in their repository.
mysql -V gives 15.1 Distr 10.1.23
MariaDB
6 sudo apt get install gdebi
7 Now I downloaded cqrlog as a .deb file for the RPi and used gdebi to install it.
8 CQRLOG now working without rigcontrol.
9 downloaded and installed hamlib-3.2.tar.gz
10 installed parts of fldigi have flrig working ut as I am not a datamodes person have not bothered with the whole package.
All now working still have a few issues to sort out.

Keep me updated with how it goes.
Once you have it basically working I would like to discuss some small issues with you.

73

Dave

GM4NFI

KC3KHA
Is it working to upload to LoTW?

Hi, Dave, I also have CQRLOG 2.3.0 working (without rig control; my only radio is a Kenwood TS-430S without CAT). It also works with WSJT-X correctly. I'm working on fldigi today.

However, can you upload your logs to LoTW? That's my only remaining problem. See my notes at https://www.cqrlog.com/node/2079 for further information.

I'm happy to discuss other issues with you. I don't have much experience with the Raspberry Pi or with amateur radio in general. This is my rookie year with both.

-Kevin
KC3KZ

GM4NFI
LoTW

Hi Kevin
Great you have it working now. I used to have an TS 430S but it had terrible dry joint issues and it had to be sold "spares or repair"
Now I use an TS 590S in the shack.
A TS 570D for IOTA
and a FT 817 for SOTA.
Fortunately first two have the same CAT control.

I have not tried uploading to LoTW but last weekend I was /P for the ILLW and will have a fairly big log to upload to ILLW.
I still have to look at getting LoTW TQSL installed for Linux.
Next step is to get WSJT-X running. I only want WSPR for antenna testing.
Previously I had it installed under Raspbian V8 using a Signalink to the FT 817.
It was going over to TX OK but I had no RF output. It seemed like a CODEC issue as no audio was being produced.

Now my other CQRLOG issue seems to have gone. I have posted details at
https://www.cqrlog.com/node/2110

73
Dave
GM4NFI

G4AON
Codec issue?

Dave
I am fairly new to Raspberry Pies, but now have CQRLOG, FLDigi and WSJT-X running. My initial rig for test purposes is a TS-480 which is going to be the same as your 590. My rig data connection is a generic "soap on a rope" FTDI chipset USB to RS232 cable. No specific drivers were needed.

Regarding audio, I use an external interface which seemed easy to setup. It's a G4ZLP Datalink.

73 Dave

GM4NFI
WSPR

Hi Dave
TNX fer advice. As WSJT-X is a bit "off topic" for a CQRLOG Forum I will drop you an email.
73
Dave
GM4NFI

GM4NFI
WSPR

Hi Dave
TNX fer advice. As WSJT-X is a bit "off topic" for a CQRLOG Forum I will drop you an email.
73
Dave
GM4NFI