HRD Logbook Accepts But Fails To Log Contacts

Chris VK2BYI

I have been made aware of two QSO Relay users (Ian, MI1CCU/EI3HFB and Panos, SV8JNL) who are experiencing a problem with HRD Logbook not logging contacts.  They are both using Maria DB as the back-end database server.

Here is a snippet from a session tracing log captured by Ian, that shows the problem that both Ian and Panos are experiencing.  Some of the detail has been removed for clarity and replaced with 4-dot ellipses (....)

A contact from JTAlert is received:

2017-05-24 10:45:18.1993 Processing received data
<CALL:5>DF8JK .... <EOR>

The contact is written to QSO Relay SQLite database file:

2017-05-24 10:45:18.1998 Logging contact in SQLite

Insert Into [Log] ( QsoId, .... , '' );

2017-05-24 10:45:18.5675 Contact successfully logged in SQLite

The contact is relayed from QSO Relay to HRD Logbook.  Here is the conversation between QSO Relay and the HRD Logbook command line interface:

2017-05-24 10:45:18.5675 Relaying contact to HRD

[c] ver

Ham Radio Deluxe Version Release


db add "MI1CCU" { CALL="DF8JK" .... }

Found 31 Valid Fields...

Added 31 Fields to MI1CCU...           <--- NOTE HRD Logbook indicates that 31 fields will be added to the 'MI1CCU' database




2017-05-24 10:45:21.9301 Contact successfully relayed to HRD

QSO Relay then tries to verify that the contact has in fact been written to the database:
2017-05-24 10:45:21.9301 Verifying contact was logged by HRD

2017-05-24 10:45:21.9306 Checking HRD Logbook for DF8JK, 20170524, 094000, 20m, JT65

2017-05-24 10:45:26.1767 Retrying...

2017-05-24 10:45:27.1825 Retrying...

2017-05-24 10:45:28.1870 Retrying...

2017-05-24 10:45:29.1885 Retrying...

2017-05-24 10:45:30.1918 Retrying...

2017-05-24 10:45:31.1941 Retrying...

2017-05-24 10:45:32.1955 Retrying...

2017-05-24 10:45:33.1969 Retrying...

2017-05-24 10:45:34.1982 Retrying...

2017-05-24 10:45:35.2000 Retrying...

2017-05-24 10:45:37.9388 WARNING: Contact was not verified as logged in HRD

However, after 10 attempts at 1 second intervals, the contact cannot be found in the database.  A direct query of the database confirms the record has not been written.

I have never experienced this issue myself, but a close friend recently has, and he fixed it by completely uninstalling Ham Radio Deluxe using the freeware version of Revo Uninstaller, before re-installing it.  Although, he uses Microsoft SQL Server and not Maria DB.

Ian is going to attempt the reinstall as well.  Panos tried that, and that worked fine for him initially, but he now reports the same problem has returned.

Maria DB server is made by the original developers of MySQL, and is reportedly a binary compatible replacement for MySQL.  I have tested Maria DB on my development system with QSO Relay and HRD Logbook, and it works without any problems at all using MySQL Connection String properties.

I am aware of a long-standing issue in HRD Logbook, where a contact is only partially logged if an ADDRESS field contains carriage return and/or line feed characters.  However, in this case there is no ADDRESS field supplied in the data being sent to HRD Logbook, and it fails to log anything at all.

I am confident the issue lies within HRD Logbook and I have searched the HRDLLC Support Forum for an answer, but to no avail.  I would raise a ticket with HRD if I could reproduce the problem, but I can’t.

If any members reading this post can share their experiences and advice re Maria DB and HRD Logbook, I am sure Ian and Panos would be grateful.

73 Chris

Join to automatically receive all group messages.