CQRLOG is an advanced ham radio logging application based on a MySQL database. It provides radio interfacing utilizing the hamlib libraries (currently support for 140+ radio types and models), DX cluster connection, band map, QRZ.com/HamQTH.com callbook (XML access), ClubLog and Logbook of the World support, IOTA support, a grayliner, propagation indicator, xplanet support (maps in azimuthal projection centered in your QTH), OK1RR free QSL manager database etc.

CQRLOG Homepage


I initially tried installing the default version available in the Ubuntu universe repository but had problems with a MySQL server version (5.7) not working with CQRLOG.  Uninstalling and reinstalling did not fix the issue.  So I went to the CQRLOG Homepage and did the following as per their instructions.

Add the repository:

sudo add-apt-repository ppa:ok2cqr/ppa

Update the system:

sudo apt-get update

Install CQRLOG:

sudo apt-get install cqrlog

This installed CQRLOG version 2.0.5-1 successfully.  Run CQRLOG and follow the on screen prompts to update the databases.

First time running CQRLOG creates your log database.


First steps after installation

On starting CQRLOG I created a new log file.  The process is simple;

Click on “New Log”, enter a number for the log (e.g. 1) and give the log a name (e.g. VE1CSY). Click “Save” and you’re done.

Now you need to open the log – click on “Open Log” and you should see the main program window.

The first step you need is to set up your log preferences. From the logging window, choose the ‘File’ menu item and ‘Preferences’ (or Ctrl-P).

A multitab window appears, allowing setup of the following parameters:

  • Program
  • Station
  • New QSO
  • Visible columns
  • Bands
  • TRX Control
  • Modes
  • QTH Profiles
  • Export
  • DX Cluster
  • Fonts
  • WAZ, ITU Zones
  • IOTA
  • Membership
  • Bandmap
  • xplanet support
  • Zip code tracking
  • LoTW support
  • CW interface
  • fldigi interface
  • Auto backup
  • External viewers
  • Callbook support
  • RBN support
  • Online log upload support

I edited the “Station” information only at this point as I thought it best to do only what I needed to start.  Simply enter your callsign, name, QTH and Locator and click OK.

The program notified me of several updates including DXCC tables which I downloaded and installed.

Update the DXCC tables in the database.

There was also an update to the QSL Manager database which I also installed.

Update the QSL managers database.

Next I went back into preferences and set the “Bands” to the ones I use. Checked bands are visible in both statistics appearing at the bottom of logging screen (bands/modes of the actual logged station) and main DXCC, WAZ and ITU zones statistics. It also affects the Challenge points at the bottom of the DXCC statistics.

Next I set up a QTH Profile. Your QTH and equipment details can be entered here.  If you are logging a new QSO, choose the appropriate profile. Later, you can see which rig and antenna were used but the main purpose is usage in filters. You can create a filter with QTH Profile as one of the criteria, a later filtering of QSOs made on your portable operation or QRP activity is possible. This method seems more effective than the usual portable log, even if you are using MM0XXX/P as your call it will probably contain a mixture of all portable activities together. With QTH Profile, it is always possible to make a separate ‘log’ for each operation.

Now I configured the DX Cluster settings. This dialog allows an easy setup of the DX cluster spot filtering. Check the bands you want to display and un-check the ones you don’t want. If you want to suppress (filter out) spots for some DX countries, put its prefixes in the box below. Use a semicolon as a separator.

Finally I setup the callbook support adding my username and password for HamQTH.com

For further customization of your preferences, please refer to the help files provided with CQRLOG.

73 de VE1CSY