CQR LOG and MYSQL problems after updating Ubuntu 18.04 to 20.04 or clean install on Ubuntu 20.04

 I supopse there are lot of HAM operators who upgraded from Ubuntu 18.04 to 20.4 do some clean install on ham software they use, including CQR Log.

I faced problems with MySql database in reports saying it could not initialise database or similar.

Looks like instead of MySql , CQR Log use Mariana DB .

So I tried first to install mariana db:

sudo apt install mariadb-server-10.3

and then to install CQLog.

Looks like it works. Mariana db also uninstall mysql from your computer so it should also work if you have previously installed cqrlog and had the problem with database.

73 Z34PEC

How to fully backup and restore your android device without root

 

How to fully backup your Android smartphone or tablet without root |

How to enable USB debugging |

1. Go to your Settings menu
2. Scroll down and tap on System
3. Select About phone
4. Tap on the device’s Build number multiple times until it enables Developer options. Newer devices will require you to enter your PIN/password/pattern
5. Hit the back button and select Developer options within the System menu
6. Make sure Developer options is toggled on. Scroll down and toggle USB debugging on

How to backup your Android device’s data |

1. Plug your Android device into your computer
2. Using either Command Prompt or Terminal, navigate to the folder in which the ADB tools are located and type in “ADB devices“. A pop-up on the Android device will appear if you need to grant your computer permission to interact with the phone or tablet. You will know if the command worked on your computer if it returns with the connected device’s identification number
3. Type in “adb backup -apk -shared -all -f <filepath>/backup.ab“
4. Your Android device will now show the full backup window. Here you can encrypt your backup with a password (which is recommended)
5. Tap on Back up my data
6. This process can take several minutes and when completed, a new file will be placed on your computer

How to restore your Android device’s data |

1. Plug your Android device into your computer
2. Using either Command Prompt or Terminal, navigate to the folder in which the ADB tools are located and type in “ADB devices“. A pop-up on the Android device will appear if you need to grant your computer permission to interact with the phone or tablet. You will know if the command worked on your computer if it returns with the connected device’s identification number
3. Type in “adb restore <filepath>/backup.ab“
4. Your Android device will now show the full restore window. If you added a password to your backup file, enter it in the space given
5. Tap on Restore my data
6. This process can take several minutes and when completed, most if not all of your previously installed applications will be present on your device as well as photos and other data.

With respect: (c) Justin Duino

Optocoupler RF protection module for RS232 CAT control for Kenwood TS480HX

 My new shack is more than a year installed on my new location near to old one.

I knew I had some RF noise coming from my PC but I did not pay too much attention till these days. It finally had it turn to be solved.

Main noise source is coming from my RS232 (DB9 female-female) CAT cable. This is simple straight DB9 serial cable that could be bought in every electronic shop.

Discussing with my collegue Z35O (Goran Trajanovski) how to eliminate this coming noise, usually at 7.140MHz, we made a conclusion:

1. To use torroide and to make couple of turns on serial cable

2. To use some new solution base on experience from users using it on Kenwood TS450S ( Interfacing Kenwood TS-450S to your soundcard ) 

Option 1 is rejected because ordering FT torroide and waiting for it in these days situation will took too long.

So , Goran Z35O suggested to try second option.

And we made it. Yet not tested but assembled and waiting for test period.

I would like to share this idea with other HAM operators (also aplicable for other radios) and post their experience with it. 

Used Pins: 2,3,5,7 and 8. Used material: 4xR470, 4 LED, 4x4N33 optocouplers.

Note: Pin 5, GND is closed loop separated for each side (it is not coming from PC to radio).

Many thanks for Goran Z35O for making this module.

Update 08.March.2021 : unfortunately this idea does not work. Looks like compared to ts450 that is using ttl levels of signals, ts480hx is using other signals type. 

Maybe this idea will inspire other amateur to try some other way and make proper working connection with galvanic-optocoupler protection.

73