Keyboard Shortcuts
ctrl + shift + ? :
Show all keyboard shortcuts
ctrl + g :
Navigate to a group
ctrl + shift + f :
Find
ctrl + / :
Quick actions
esc to dismiss
Likes
Search
CQRlog mySQL error
I just tried to open for the first time CQRlog on my freshly installed HamPC stick.
Unless the HamPi (where it worked without any problems last night), I got a severe mySQL error: 2022-08-21T19:23:00.188690Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.22.04.1) starting as process 7165 2022-08-21T19:23:00.191332Z 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-08-21T19:23:00.191354Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead. 2022-08-21T19:23:00.197053Z 0 [Warning] [MY-010075] [Server] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: ab521026-2186-11ed-bccd-84a6c8e3985b. Until here, only some warnings, not so important, but now: 2022-08-21T19:23:00.206528Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory. 2022-08-21T19:23:00.206733Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 2022-08-21T19:23:00.206770Z 0 [ERROR] [MY-010119] [Server] Aborting 2022-08-21T19:23:00.207129Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.22.04.1) (Ubuntu). The databases could not be created and the logbook cannot work. For the moment, I don't know what should I do. Can anybody help me? 73 Udo, HB9ERD |
¿ªÔÆÌåÓýHello Udo, Considering HamPC is a customized version of Ubuntu 22.04 for X86 and not the usual focus of Raspberry Pi OS (and other distros) on Raspberry Pi hardware, it might be best to post this question to the dedicated email list for that ISO at [email protected] .? That said, if you search for "cqrlog 'Failed to find valid data directory'", you'll find several hits: ?? - ::? recommends to use MariaDB instead though this seems like a poor recommendation ?? - :: also recommends to switch to MariaDB ?? - :: again recommends to use MariaDB ?? - :: again recommends to use MariaDB Seems pretty clear that the recommended solution is to switch databases.? That's strange to me so it might be worth asking on the HamPC email list if anyone has ever gotten CQRlog working on this image before.? This might be an issue with the ISO that needs to be corrected. --David KI6ZHD On 08/21/2022 01:04 PM, Udo Isaenko
wrote:
I just tried to open for the first time CQRlog on my freshly installed HamPC stick. |
Hello David
toggle quoted message
Show quoted text
Thanks for the hints and sorry, I indeed clicked on the wrong mailing list address when I quickly described my problem. Later, I remarked my error and sent the same mail to the right list, and W3DJS wrote he will look for a solution. So, this thread can be regarded as "closed" here on this list. By the way, normally, MariaDB (as a free fork of mySQL) is always installed in Distros instead of the original mySQL, with a symlink from mysql to MariaDB. But I have to investigate this, probably, to be sure. 73 Udo, HB9ERD Am 22.08.22 um 03:29 schrieb David Ranch: Hello Udo, |
to navigate to use esc to dismiss