OK, I got CQRLog installed, however when I start the program a window pops up labeled: Database connection. It wants a user name and password to connect to the MySQLserver. How do I create a user and password? I tried starting MySQL and doing it from the MySQL shell, but it fails to launch, halting with an error. I checked the CQRLog docs and don't see any reference to the window that I see when I launch the program.
Help would be greatly appreciated!
I'm using LinuxMint 20.1 xfce
Thanks,
Jim, K4JIM
Ok I got beyond the problem I thought I had in the initial post. Here's my dilemma: I had my /home directory on a separate drive, so it remains intact. I had to reinstall Linux Mint 20.1 onto my boot drive. I created a new /home on that drive and I re-named the /home directory on the second drive to /Media. My old home directory is intact and I have it mounted. I can find the CQRLog files as: mnt/Media/jim/.config/cqrlog. Is it possible to configure CQRLog to use the existing database and config files???
Hi!
It does not matter in what deivice your /home directory is if it is REALLY "/home" as you said. really means that linux operating system knows it is in path "/home". The "/" at starts tells that "home" is part of filesystem and it is under root directory of filesystem.
Linux does not have drive letters like Windoze. So all your hard drives are under same filesystem if they are mounted for use.
When you started cqrlog did you have "Save log data to local machine" checkbox checked at "database connection" window?
It does not matter if your home directory is even on different networked PC as long as Linux sees it mounted as "/home". It is then "local machine", still.
I have feeling that it is not clear to you how Linux filesystem works. When I started with Linux it took me some time to understand that there are no drive letters for different physical drives. Everything is under same, and ONE, filesystem root looking like subfolders even when the content of subfolder lives in different physical drive.
What you can do?
You have now real home directory as "/home/jim" and then you have directory that you call "/home" at /mnt/Media/jim
You could try to make symlink like:
cd /home/jim/.config
ln -s /mnt/Media/jim/.config/cqrlog cqrlog
That should show your /mnt/Media/jim/.config/cqrlog files when you look to /home/jim/.config/cqrlog
Cqrlog should then work if database connection window has checbox "Save log data to local machine" checked.
Using symlinked cqrlog folder is not tested and it may be that database engine may not work then.
-----
Second way:
Copy your folder /mnt/Media/jim/.config/cqrlog to your real home directory.
cp -a /mnt/Media/jim/.config/cqrlog ~/.config/cqrlog
Cqrlog should then work if database connection window has checbox "Save log data to local machine" checked and you have /mnt/Media/jim/.config/cqrlog as backup forder.
-----
Third way:
Move you /mnt/Media/ to be as your real home directory. I.E. mount it to filesystem root as /home.
You need to touch /etc/mtab file and set your second physical drive to be mounted as /home.
Line is something like below, but depends on your drives partition number, name and filesystem type used:
/dev/sdb1 /home ext4 rw,seclabel,relatime 0 0
And again: Cqrlog should then work if database connection window has checbox "Save log data to local machine" checked.
--
Saku
OH1KH
I was able to use the symlink as you suggested. However, my first attempt failed because cqrlog already existed. So, I renamed it to cqrlog1, then successfully created the symlink to: /mnt/Media/jim. Started CQRLog and all my previous QSO's are visible. Thanks to your suggestion I am back to logging my QSO's!
Thanks again and 73!
Jim, K4JIM