New Ubuntu and latest cqrlog

4 posts / 0 new
Last post
oh1kh
New Ubuntu and latest cqrlog

Hi!

This evening I played with virtualbox creating a new virtual PC for testing how difficult Ubuntu and cqrlog install is.

First problem was to find Ubuntu LTS 20.04 net install media. After reading a long debate of angry users who had not found net install image for LTS 20 any more I finally found a message containing a link to still existing net install image "mini.iso".
Down loaded that and connected it as virusl PC's CD rom and started install.

"mini.iso" worked only as text based install. Problem perhaps in mini.iso, or my virtual PC display. Anyway text based install was very convenient as I am used to work with console.
"mini.iso" installed a minimal LTS 20.04 without graphical GUI. No problem! Just one command
sudo apt-get install lxde
because I am used to work with simple lxde desktop and like it.
After that I had a running LTS 20.04 with graphical desktop and minimal amount of programs.

Prepare for cqrlog:
While lxde was installing I checked from cqrlog forum how people have succeeded with mariadb installations. Collected a command line to use:
sudo apt-get install mariadb-client-10.3 mariadb-server-10.3 libmariadb3 libssl-dev

After that we need HamLib:
sudo apt-get install libhamlib2 libhamlib-utils

Then we want the latest version of cqrlog It means we have to compile it from GitHub source. It is a way ahead of any package installed versions. For that we need tools. All we need to is "lazarus" and "git" that will give everything else needed:
sudo apt-get install lazarus git

When that is done we just get the latest cqrlog source:
git clone https://github.com/ok2cqr/cqrlog.git

If that command is issued when being in users home directory (where the console normally opens) /home/username then a new folder was created by git named "cqrlog" ( /home/username/cqrlog ). Next we move to it:
cd cqrlog
Then we compile cqrlog source. Not rocket science just type command:
make
After compile is over we install compiled cqrlog:
sudo make install

Then it is time to start our cqrlog by typing:
cqrlog

Then Ubuntu hits us! As usual "can not connect to database"! This is what I have seen so many times here.
At this time my install was done without package and I cannot blame package makers.
After few starts as cqrlog debug=1 it cleared out that cqrlog cannot find a link to mariadb libraries. Link was not there where cqrlog expects it to be. A symlink was needed to fix this:
sudo ln -s /usr/lib/x86_64-linux-gnu/libmysqlclient.so.21 /lib/libmysqlclient.so

After that cqrlog started nicely! Just type in all settings in preferences.
Of course TQSL must be loaded after that if LoTW connection is needed.

It was the whole story from empty virtual PC to running cqrlog.

If you have running previous installation of cqrlog you can update it to latest version using just these five console commands:
sudo apt-get install lazarus git
git clone https://github.com/ok2cqr/cqrlog.git
cd cqrlog
make
sudo make install

Of course your did backup your ~/.config/cqrlog folder before doing this.!
If the new one does not work as expected you can return to old by reinstalling the package you used to install cqrlog at first place.

dl1mtg
dl1mtg's picture
New Ubuntu and latest cqrlog

There seems to be some difference between "mini.iso" and "ubuntu-20.04.1-desktop-amd64.iso"

Try to install "libmariadb-dev-compat" and you do not need a symlink.

--
73 de Martin, DL1MTG

oh1kh
New Ubuntu and latest cqrlog

Hi Martin!

Yep. they say that mini.iso is not officially supported. Perhaps that is the reason. How ever I did not wnat to download Gbs size image for just one test. Net install is the best way as it gives always latest updates immediately.

Thanks for pointing up that package.

I just wanted to show that installing latest cqrlog (much newer than any package has) is not so difficult. If one version of cqrlog is already installed and running updating from source is very easy and does not cause database problems like first install may do.

--
Saku
OH1KH

nn9k
nn9k's picture
ADIF Export problem

OK, thanks that did solve my ADI State and county problem.

Peter, NN9K