CQRlog on two different computers

2 posts / 0 new
Last post
NZ0T
CQRlog on two different computers

My understanding from a few years ago is that CQRlog cannot be used with the same callsign on separate computers. I have two different shacks in different rooms - one for my modern gear one for my boat anchor gear. I would prefer to use CQRlog in both shacks on different computers. Is it still not possible to use CQRlog on two computers?

73, Bill NZ0T

oh1kh
CQRlog on two different computers

HI Bill!

Yes you can.
You need SQL server that both can reach to have same log data. So it means both computers must be online, or you need third computer to run MariaDB SQLserver for both shack computers.

Case #1
- start Cqrlog on both computers.
-- First one, "The Master", can "save log data to local machine"
-- Other one, the slave, do NOT use "save log data to local machine".
Instead set "Server name" to be local net IP address of the Master computer. Set port as "64000" . Username and password both "cqrlog" (these are not critical)
Set Remember me and Auto connect and press Connect button. You should see same logs in selection as The Master has.

Case #2
- define mysql user and password and grant privileges to use cqr% named databases to either The Master, The Slave or third computer that is going the be the MariaDB Sql server.
For example see this message https://www.cqrlog.com/comment/11126#comment-11126
-- on Master and on Slave (the anchor PC) set both NOT use "save log data to local machine".
Instead set "Server name" to be local net IP address of the computer you created the mysql user. Set port as 3306. Username and password are ones you created to be with mysql.
(Note that when you installed Cqrlog you installed also "real" SQL server that will run as background service at port 3306 all the time when the computer is powered)

Now you can start Cqrlog on either computer, or both. As long as the computer you selected to be MariaDB sql server with mysql user is running (idle)
Note that the MariaDB sql server may also exit in internet id you have an ISP that offers SQL services.

Case #2 needs more work but is more flexible.

After you have solved where to place your log databases you need to alter the Cqrlog preferences at both computers.
See preferences/Program/Configuration storage settings button.
From there you can set what settings are common fro both computers and what are local to each computer. Assume at least TRXcontrol if you have different rigs in different shacks.

That is it in short.
Make you selection and remember to ask more help if needed.

--
Saku
OH1KH