I get a Error popup message when I start my new CQRLog installation. There is apparently something wrong with my-sql server.
Can someone drive me out of the problem?
2022-02-27T16:50:08.073976Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28-0ubuntu0.21.10.3) starting as process 19124
2022-02-27T16:50:08.074426Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2022-02-27T16:50:08.074430Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-02-27T16:50:08.077721Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-02-27T16:50:08.077843Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-02-27T16:50:08.077873Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-02-27T16:50:08.078086Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28-0ubuntu0.21.10.3) (Ubuntu).
2022-02-27T17:41:57.403014Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28-0ubuntu0.21.10.3) starting as process 2546
2022-02-27T17:41:57.408112Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2022-02-27T17:41:57.408118Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-02-27T17:41:57.412074Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-02-27T17:41:57.412151Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-02-27T17:41:57.412180Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-02-27T17:41:57.412400Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28-0ubuntu0.21.10.3) (Ubuntu).
2022-02-27T17:45:59.013786Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28-0ubuntu0.21.10.3) starting as process 2933
2022-02-27T17:45:59.014253Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2022-02-27T17:45:59.014257Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2022-02-27T17:45:59.017572Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-02-27T17:45:59.017703Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-02-27T17:45:59.017733Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-02-27T17:45:59.017937Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28-0ubuntu0.21.10.3) (Ubuntu).
I installed mariadb-server. That helped. The documentation requests mysql-server...???
Anyway problem seems to be solved.
You are right, I just updated FAQ and changed MySQL to mariadb. Thanks a lot!
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Have you a few minutes to help me connect to my ftdx101d?
Blair
HI Blair!
Without knowing your Linux brand and Yeasu rig there are few common things.
At cqrlog side (using latest Hamlib and Cqrlog) start settings can be:
There are two main things. Is your rgctld in path /usr/local/bin or is the path /usr/bin ?
Opening a command console and typing:
whereis rigctld
Tells that.
Other thing is the port where your Yeasu is connected. If you have USB connection the simplest way is to connect powered Yaesu, then in command console type:
ls /dev/tty*
Disconnet Yaesu cable from PC and type same command again. One /dev/tty disappeared and that was your Yeasu.
When command console is still open type
groups
It shows your user groups. You should find group called dialout from those. Then you are able to start rigctld so that it can use the Yaesu port. If it is not you can add yourself to that group with command
sudo usermod -a -G dialout $USER
After these remains the Yaesu.
Does it have some special settings for CAT? I do not know. Assume that it is worth do test first without doing any changes to rig's setup.
Of course rig manual is always preferred reading!
--
Saku
OH1KH
I finally got it. Warm thanks Saku.
I have attached an answer to most of these questions Saku. I can connect to the radio with hamlib using:
/usr/local/bin/rigctl -m 1040 -r /dev/ttyUSB0 -s 9600
So we know we have the port. HRD does not list radio 1040 in the choices....
And thank Saku for stepping up to help here. I have spent so many hours after the crash....
File:
Blair
Hi Blair!
Answered to you at other message chain (I did read that first) but your picture here confirms my guess.
You have two versions of Hamlib in your system. In /usr/bin and /usr/local/bin
That may cause problems later. See the other message chain.
--
Saku
OH1KH
Now I'm trying to get my SDR radio connected CQRLog and others. I find many examples in the forum, but none where the rigctld is connected to the EXpert SDR. There is no serial port listed in Ssdr software to connect to rigctld. All examples assume the radio is attached to pc via a cable like /dev/ttyUSB0. Seems like there would need to be an implimentation of some virtual port thru socat or the like. Has anyone got this running?
Thanks Blair. ki4yy
Blair
Hi Blair!
If you need tcp conect instead of /dev/ttyUSBx you can type the address and port to device column.
It is actually poorly documented in rigctld man pages. I.E. there is no mention about it !
how ever if you open rigctl (without "d") man pages you will see:
-r, --rig-file=device
Use device as the file name of the port connected to the radio.
Often a serial port, but could be a USB to serial adapter. Typi‐
cally /dev/ttyS0, /dev/ttyS1, /dev/ttyUSB0, etc. on Linux, COM1,
COM2, etc. on MS Windows. The BSD flavors and Mac OS/X have
their own designations. See your system's documentation.
Can be a network address:port, e.g. 127.0.0.1:12345
The special string “uh-rig” may be given to enable micro-ham de‐
vice support.
It works also with Cqrlog. Instead of typing in "/dev/ttyUSBx" you can type ipv4 address and port like "192.168.60.1:4532" if that is what you want.
How ever then "run rigctld when program starts" should be checked and this leads to situation where Cqrlog starts ricgtld that connects via TCP to another rigctld (or sdr's rigctld simulator) in given address and port.
In some cases this may be needed because that way using chained rigctlds some functions not supprted by sdr rigctld sipulator may be fixed.
These cases the Rig model must be selected from "real rig" models so that it fits to srd simulator program that is usually acting like some known Kenwood model(or other rig)
How ever if you need direct connection from Cqrlog to srd rigctld simulator program you can uncheck "run rigctld when program starts" and place your sdr simulator's ip addrss to "Host" column of preferences/trxcontrol and the port to port column.
Normally there are values localhost and 4532.
In that case your sdr simulator program must be 100% rigctld compatible
In that case you have to select rig model as #2 Net Hamlib rigctld, unless your SDR is directly supported by rigctld (it seems that it is not)
2040 OpenHPSDR PiHPSDR 20220602.1 Stable RIG_MODEL_HPSDR
2048 FlexRadio/ANAN PowerSDR/Thetis 20220516.0 Stable RIG_MODEL_POWERSDR
2051 SDRPlay SDRUno 20220602.2 Stable RIG_MODEL_SDRUNO
23001 Flex-radio SDR-1000 20200323.0 Alpha RIG_MODEL_SDR1000
25007 Elektor Elektor SDR-USB 20200112.0 Stable RIG_MODEL_ELEKTOR507
25011 KTH-SDR kit Si570 PIC-USB 20200112.0 Stable RIG_MODEL_SI570PICUSB
25012 FiFi FiFi-SDR 20200112.0 Stable RIG_MODEL_FIFISDR
25014 N2ADR HiQSDR 20200323.0 Alpha RIG_MODEL_HIQSDR
25015 Funkamateur FA-SDR 20200112.0 Beta RIG_MODEL_FASDR
Without knowing ExpertSDR program I hope these did answer your question.
--
Saku
OH1KH
I need the help of your app games developers on how to download this game because after downloading it there are a lot of errors that are not resolved. So please guide me on how to download this game
I am now focusing on research CTO as a service . A CTO has to be not only a senior developer but a person with a broad range of expert knowledge.