CQRLOG 2.3 on RaspberryPi continuing install problems

10 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