Hello all,
I've read a few threads regarding CQRLOG on Linux Mint and to be honest this is really a major PITA.
I have unterstood, that it can run standalone with MariaDB and without MySQL, but right now, there seems no way to install MariaDB without MySQL on Linux Mint 21.2 or at least I don't know how.
When I do this:
sudo apt install mariadb-server mariadb-client
Linux Mint 21.2 gives me this:
The following NEW packages will be installed
libdbd-mysql-perl libmariadb3 libmysqlclient21 mariadb-client mariadb-client-10.6
mariadb-client-core-10.6 mariadb-common mariadb-server mariadb-server-10.6
mariadb-server-core-10.6 mysql-common
When I then install cqrlog with this:
sudo apt install cqrlog
Linux Mint 21.2 gives me this:
The following packages will be REMOVED
mariadb-client mariadb-client-10.6 mariadb-client-core-10.6 mariadb-server
mariadb-server-10.6 mariadb-server-core-10.6
The following NEW packages will be installed
cqrlog cqrlog-data default-mysql-server libevent-core-2.1-7 libevent-pthreads-2.1-7
libhamlib-utils libmariadb-dev libmariadb-dev-compat libmecab2 libnetpbm10 libssl-dev
mecab-ipadic mecab-ipadic-utf8 mecab-utils mysql-client-8.0 mysql-client-core-8.0
mysql-server-8.0 mysql-server-core-8.0 xplanet xplanet-images
So, now I have MariaDB and MySQL and when I try to start CQRLOG (no cqrlog folder in ~/.config/) and clicking YES when being asked to save it locally, it fails because "MySQL could not be started".
When I try to remove MySQL with this:
sudo apt remove mysql-common
Linux Mint gives me this:
The following packages will be REMOVED
cqrlog default-mysql-server libdbd-mysql-perl libmariadb-dev libmariadb-dev-compat
libmariadb3 libmysqlclient21 mariadb-common mysql-client-8.0 mysql-common mysql-server-8.0
I'm clueless ... does anybody know what to do?
73
Ulf DK5TX
Hi Ulf!
It is real pity that package makers do not test their products before releasing them.
Have you tried to install other way?
Install Cqrlog and after that update mysql to MariaDB.
That is the usual way users have done after finding out that Mysql does not work. You can see many threads about that way from this forum.
You can run Cqrlog with both database engines if you do not check "save log data to local machine'.
Then you just need to create mysql user with password and grant all privileges for databases starting cqr* .
Address is localhost and port 3306, so logs are actuality in local machine but not in ~/config/cqrlog/database folder. Then complete backup needs also mysqldump in addition of copying ~/config/cqrlog/
Latest cqrlog's offer this at first start as 2nd option of three choices.)
--
Saku
OH1KH
Hello Saku,
tnx for your help and comments. Yes, it is really a pity with some packages in Linux Mint.
After trying a lot yesterday, I did it like you proposed (which I obviously haven't done so far) and guess what .... it works now :-)
So, just for those who are running into the same problem with the installation of CQRLOG in Linux Mint, this simple two commands in the right order did the trick:
sudo apt install cqrlog
sudo apt install mariadb-client mariadb-server
The first command installs CQRLOG along with MySQL. The second command installs MariaDB and removes MySQL again.
Before starting CQRLOG I doublechecked, there was no cqrlog folder in ~/.config/
TNX!
73
Ulf DK5TX
Fine!
Now, before you start using Cqrlog you could upgrade to Alpha 119.
It is easy over working Cqrlog.
Go https://github.com/OH1KH/cqrlog/tree/loc_testing/compiled and select newupdate.zip and download it.
After unzip start newupdate.sh in command terminal and select version suitable for you.
--
Saku
OH1KH
After upgrading mint I typed the following in the terminal :- sudo apt install mariadb-common mariadb-server mariadb-client
and cqrlog worked. since then I have found big squares in statistics does not work on 2 different machines.
john zl3aau
john-zl3aau
Hi John!
How does it not work?
What is the version of Cqrlog?
--
Saku
OH1KH
Hi Saku, cqrlog v 2.5.2(001). Error message on big Squares, access violation. press OK to ignore and risk data corruption. Press abort to kill program.OK comes up with blank Big Squares page, abort shuts down cqrlog.
John ZL3AAU
john-zl3aau
OK John!
Quite old version.
With quick checout I found that I have done some fixes for Big Squares. There was some kind of problem, but I cant remember what it was.
These are included in my Alpha 119 version
--
Saku
OH1KH
Then there is also earlier fix that is allready in official source:
CQRLOG 2.6.0 (2022-05-29)
--
Saku
OH1KH
If there is an official source for 2.6.0 then why is there no release?