cqrlog - All New Created Databases / Logs are Corrupted!

8 posts / 0 new
Last post
VA2FB
cqrlog - All New Created Databases / Logs are Corrupted!

I am new to crqlog. It looks like it is exactly what I need for my logging needs.

I just installed crqlog 2.3.0-2 via apt on my old 32-bit PC running anti-X Linux.
(Anti-X 19 is based on Debian Buster).

The installation of cqrlog and all its dependencies was successful.

But when I try to open a new Database / Logfile, I see the following error:

"" is an invalid integer.
Press OK to ignore and risk data corruption.
Press Abort to kill the program"

I press OK and nothing happens.

I tried creating a new database / log and get the same result.

I would like in upgrade to the latest version 2.5.2 but only a 64-bit binary is provided.
Will cqrlog run on 32-bit Linux Debian based PCs?

How can I easily compile the deb.src.tar.gz file? Once I have the 32-bit binary deb file, I can try to install it using dpkg.
I do have devscripts and dpkg-dev installed needed for compiling.

P.S. I also tried to delete all the logs and start over but cqrlog will not let me delete the first log!
Where can I find the logs and delete all of them manually?

VA2FB
I uninstalled cqrlog 2.3.0

I uninstalled cqrlog 2.3.0 using apt.

And I finally was able to compile cqrlog 2.5.2 on my 32-bit PC running anti-X Linux using "debuild -b -uc -u". Before it would compile, I had to install a number of build dependencies including Lazarus and a number of free Pascal packages.

But when I tried to install the resulting 32-bit binary .deb, the installation failed.

sudo dpkg -i cqrlog_2.5.2-1_i386.deb
Selecting previously unselected package cqrlog.
(Reading database ... 449069 files and directories currently installed.)
Preparing to unpack cqrlog_2.5.2-1_i386.deb ...
Unpacking cqrlog (2.5.2-1) ...
Setting up cqrlog (2.5.2-1) ...
/var/lib/dpkg/info/cqrlog.postinst: 3: /var/lib/dpkg/info/cqrlog.postinst: /usr/share/cqrlog/cqrlog-apparmor-fix: not found
dpkg: error processing package cqrlog (--install):
installed cqrlog package post-installation script subprocess returned error exit status 127
Errors were encountered while processing:
cqrlog

The problem appears to relate to apparmor. I do not think Anti-X Armour even uses apparmor!

Any ideas?

oh1kh
I uninstalled cqrlog 2.3.0

Hi !
I do not like to be wise afterwards but you have done lots of work that is not needed.
I have written few messages how to update Ubuntu, Mint and Rpi and I believe same rules go for your debian.

1) install lazarus and git from package. If you packages are well designed this will automatic add all needed dependencies.
2) clone source from github. Console command: git clone https://github.com/ok2cqr/cqrlog.git
3) using same console: cd cqrlog to dive into source root
4) issue command: make
5) issue command: make install

If you have working cqrlog (2.3.0 or other) do not remove it. Then you do not need to create the install package .deb. Just make and make install over existing cqrlog.

When done 1-5) and when ever you see there are new fixes or properties added in source you just:
6) cd cqrlog
7) git pull
8) make
9) make install

and you have again latest cqrlog in use.

Now it is hard to say what shoud be done to easiest fix. I would first be sure that I have ~/.config/cqrlog folder copied with command "cp -a" as backup.
Then, if you package manager is not broken now I would install 2.3.0 back, check that it runs ok and then do steps 1-5). you can pass some of them as you now have lazarus/fpc installed. If you did not get source with "git clone" command I would do that part again to get it with git (for later "git pull"s work ok).

--
Saku
OH1KH

VA2FB
Many thanks for the reply!

Many thanks for the reply!

And yes I did a lot of needless work. Why didn't I think about using git in the first place! :-)

I installed cqrlog v2.3.0 using the Debian Buster repos on my Anti-X Linux 32-bit PC. Then I installed crqlog 2.5.2 using git as you suggested.

I ran cqrlog. The splash screen appeared showing that v2.5.2 was being loaded.

cqrlog noticed that I ran cqrlog for the first time and asked whether I wanted to create a new local database. I clicked YES.

But I get the following error:

"MySQL could not be started, please check if the mySQL server is installed properly"

attached is the mysql.err file

Any help you can give would be greatly appreciated!

File: 

VA2FB
FYI -- I clicked "Close" on

FYI -- I clicked "Close" on the error window, and volia cqrlog opened up.
Progress!

I can enter new and save QSO's. I can see the DXCC info etc. I can change Preferences.

But once I save a QSO, it does NOT appear above in the list of QSOs.
So I cannot see any of my previously logged QSOs.
So the mySQL database appears NOT to be working properly.

Any Ideas?

VA2FB
Hmm. Looks like cqrlog is

Hmm. Looks like cqrlog is working properly after all.

I thought the list above the QSO entry pane showed all previously logged QSO's.
As you know, it does not. It shows all previous QSO's with the same station being logged.

One must click Window -> QSO list. Then a second window appears showing all my QSOs logged to date.

So cqrlog appears to be working properly now.

I still do not know why I received the error message regarding mySQL when I first ran cqrlog. It sure looks like a bug. I hope you can track it down.

FYI -- cqrlog 2.3.0 in the Debian Buster repos will not run properly - at least on 32-bit PCs. It installs using apt (or apt-get) without any errors. But when you run it, you get the same mySQL error message and when you try to load the log database, cqrlog refuses and reports that the database is corrupted (see my first post in this thread). So the solution appears to be upgrading to v2.5.2 using git.

Now I need to learn how to use cqrlog!

Many thanks for all your hard work developing a great logging program for Linux!

oh1kh
Hmm. Looks like cqrlog is

Fine!

Check preferences/NewQSO.
There you can check refresh after logging that will update QSO list, and also the qso list settings for top of NewQSO.

And of course recommended reading is help. From menu at the top right of NewQSO or same selection in several other windows.

--
Saku
OH1KH

dk9he
dk9he's picture
upgrade to 2.5.2

Hi Saku,
I just followed your instruction and its was great done!
With Kubuntu 18.04 cqrlo 2.5.2 running fine now.

Many thanks for all you great contributions.

73
Andy DK9HE