|
It seems that I posted this before to the wrong group. But here is the place for it:
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
|
I see your log. Let me check into it and see what I can do...
If anyone else has any ideas in the meanwhile...
On Sun, Aug 21, 2022, 6:31 PM Udo Isaenko < dx@...> wrote: It seems that I posted this before to the wrong group. But here is the
place for it:
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
--
-- Dave,?? ? ? ? ? ? ? ? ? ? ? ?Technical Specialist,??--
--??+?? ? ? ? Lifetime Member of??&??&??--
--??--
|
Hi Dave Am 22.08.22 um 01:50 schrieb Dave Slotter, W3DJS: I see your log. Let me check into it and see what I can do...
Many thanks in advance. I can wait. By the way, before starting CQRlog, I changed the system language to german, but I cannot imagine that it has to do with that. I suppose maybe some permission problems? The error is reproductable. Every time I try to start CQRlog, it's the same. If anyone else has any ideas in the meanwhile... It would be interesting if other users have watched the same problem or not? 73 Udo, HB9ERD
|
Hi Dave
Today, I could create another new USB and tried to start CQRlog just after the very first boot, before making any other changes (language, ...) to the installation.
But the problem is still exactly the same. CQRlog cannot create any database.
Strange, as with HamPi, all works well with CQRlog.
73
Udo, HB9ERD
Am 22.08.22 um 02:01 schrieb Udo Isaenko:
toggle quoted message
Show quoted text
Hi Dave
Am 22.08.22 um 01:50 schrieb Dave Slotter, W3DJS:
I see your log. Let me check into it and see what I can do...
Many thanks in advance. I can wait.
By the way, before starting CQRlog, I changed the system language to german, but I cannot imagine that it has to do with that. I suppose maybe some permission problems?
The error is reproductable. Every time I try to start CQRlog, it's the same.
If anyone else has any ideas in the meanwhile... It would be interesting if other users have watched the same problem or not?
73
Udo, HB9ERD
|
Udo
I had a look at the mysqld
config file that is supplied with the HamPC load and it is not configure
correctly which is why it is failing.? You could probably duplicate the
one you are using with HamPI.? you will find that at:
???
/etc/mysql/mysql.conf.d/mysqld.cnf
The [mysql_safe] and [mysqld]
settings are what you will need to duplicate.
you will need super
user access to edit that file.? Then reboot the machine to properly
restart the mysql server.
Udo Isaenko wrote on 8/24/2022
10:26:
toggle quoted message
Show quoted text
Hi Dave
Today, I could create another new USB and tried to start CQRlog just
after the very first boot, before making any other changes (language,
...) to the installation.
But the problem is still exactly the same. CQRlog cannot create any
database.
Strange, as with HamPi, all works well with CQRlog.
73
Udo, HB9ERD
Am 22.08.22 um 02:01 schrieb Udo Isaenko:
Hi Dave
Am 22.08.22 um 01:50 schrieb Dave Slotter, W3DJS:
I see your log. Let me check into it and see
what I can do...
Many thanks in advance. I can wait.
By the way, before starting CQRlog, I changed the system language to
german, but I cannot imagine that it has to do with that. I suppose
maybe some permission problems?
The error is reproductable. Every time I try to start CQRlog, it's
the
same.
If anyone else has any ideas in the
meanwhile...
It would be interesting if other users have watched the same problem
or
not?
73
Udo, HB9ERD
--
Jeff K. Steinkamp
(N7YG)
Tucson, AZ
Scud Missile Coordinates
N32.2319 W110.8477
|
Hi Jeff
Many thanks for the info.
I just took the SD card of my HamPi and the USB stick of my HamPC, mounted both to another Linux machine and copied all the files for mysql and also for MariaDB which are under /etc/mysql from the HamPi to the HamPC.
I started HamPC, but unfortunately, the problem is still there. Same error messages.
I think I will have to investigate this problem further when I find the time for it.
Thanks nevertheless for your hints.
73
Udo, HB9ERD
Am 25.08.22 um 01:29 schrieb Jeff Steinkamp:
toggle quoted message
Show quoted text
Udo
I had a look at the mysqld config file that is supplied with the HamPC load and it is not configure correctly which is why it is failing.? You could probably duplicate the one you are using with HamPI.? you will find that at:
/etc/mysql/mysql.conf.d/mysqld.cnf
The [mysql_safe] and [mysqld] settings are what you will need to duplicate.
you will need super user access to edit that file.? Then reboot the machine to properly restart the mysql server.
Udo Isaenko wrote on 8/24/2022 10:26:
Hi Dave
Today, I could create another new USB and tried to start CQRlog just after the very first boot, before making any other changes (language, ...) to the installation.
But the problem is still exactly the same. CQRlog cannot create any database.
Strange, as with HamPi, all works well with CQRlog.
73
Udo, HB9ERD
Am 22.08.22 um 02:01 schrieb Udo Isaenko:
Hi Dave
Am 22.08.22 um 01:50 schrieb Dave Slotter, W3DJS:
I see your log. Let me check into it and see what I can do...
Many thanks in advance. I can wait.
By the way, before starting CQRlog, I changed the system language to german, but I cannot imagine that it has to do with that. I suppose maybe some permission problems?
The error is reproductable. Every time I try to start CQRlog, it's the same.
If anyone else has any ideas in the meanwhile... It would be interesting if other users have watched the same problem or not?
73
Udo, HB9ERD
--
Jeff K. Steinkamp (N7YG)
Tucson, AZ
Scud Missile Coordinates
N32.2319 W110.8477
|
Udo
Start looking at file/folder
permissions.
Udo Isaenko wrote on 8/25/2022 13:52:
toggle quoted message
Show quoted text
Hi
Jeff
Many thanks for the info.
I just took the SD card of my HamPi and the USB stick of my HamPC,
mounted both to another Linux machine and copied all the files for mysql
and also for MariaDB which are under /etc/mysql from the HamPi to the
HamPC.
I started HamPC, but unfortunately, the problem is still there. Same
error messages.
I think I will have to investigate this problem further when I find
the
time for it.
Thanks nevertheless for your hints.
73
Udo, HB9ERD
Am 25.08.22 um 01:29 schrieb Jeff Steinkamp:
Udo
I had a look at the mysqld config file that is supplied with the
HamPC
load and it is not configure correctly which is why it is failing.? You
could probably duplicate the one you are using with HamPI.? you will
find that at:
/etc/mysql/mysql.conf.d/mysqld.cnf
The [mysql_safe] and [mysqld] settings are what you will need to
duplicate.
you will need super user access to edit that file.? Then reboot the
machine to properly restart the mysql server.
Udo Isaenko wrote on 8/24/2022 10:26:
Hi Dave
Today, I could create another new USB and tried to start CQRlog just
after the very first boot, before making any other changes (language,
...) to the installation.
But the problem is still exactly the same. CQRlog cannot create any
database.
Strange, as with HamPi, all works well with CQRlog.
73
Udo, HB9ERD
Am 22.08.22 um 02:01 schrieb Udo Isaenko:
Hi Dave
Am 22.08.22 um 01:50 schrieb Dave Slotter, W3DJS:
I see your log. Let me check into it and see
what I can do...
Many thanks in advance. I can wait.
By the way, before starting CQRlog, I changed the system language to
german, but I cannot imagine that it has to do with that. I suppose
maybe some permission problems?
The error is reproductable. Every time I try to start CQRlog, it's
the same.
If anyone else has any ideas in the
meanwhile...
It would be interesting if other users have watched the same problem
or not?
73
Udo, HB9ERD
--?
Jeff K. Steinkamp (N7YG)
Tucson, AZ
Scud Missile Coordinates
N32.2319 W110.8477
--
Jeff K. Steinkamp
(N7YG)
Tucson, AZ
Scud Missile Coordinates
N32.2319 W110.8477
|
Udo,
I have been very busy this week, but finally took a look at the issue and see this in the HamPC log:
hampc@hampc:~/.config/cqrlog/database$ cat mysql.err
2022-08-26T19:05:09.203798Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.30-0ubuntu0.22.04.1) starting as process 1837
2022-08-26T19:05:09.241254Z 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-26T19:05:09.241329Z 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-26T19:05:09.251243Z 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: 010d6e66-2572-11ed-9365-2cd26b131660.
2022-08-26T19:05:09.260419Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-08-26T19:05:09.261000Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-08-26T19:05:09.261123Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-08-26T19:05:09.262174Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.30-0ubuntu0.22.04.1) ?(Ubuntu).
That is the error preventing the MySQL server from starting up. What's weird is that HamPC is installing CQRLog as a package, not building it from scratch, so this error should not occur. However, it does, and it fell through not only my QA process, but also presumably that of the upstream package maintainer.
I'm working on a fix for this for HamPC. Please be patient and I will share it as soon as I can. (I promise it will be worth waiting for.)
Thanks and 73,
On Thu, Aug 25, 2022 at 4:52 PM Udo Isaenko < dx@...> wrote: Hi Jeff
Many thanks for the info.
I just took the SD card of my HamPi and the USB stick of my HamPC,
mounted both to another Linux machine and copied all the files for mysql
and also for MariaDB which are under /etc/mysql from the HamPi to the HamPC.
I started HamPC, but unfortunately, the problem is still there. Same
error messages.
I think I will have to investigate this problem further when I find the
time for it.
Thanks nevertheless for your hints.
73
Udo, HB9ERD
Am 25.08.22 um 01:29 schrieb Jeff Steinkamp:
> Udo
>
> I had a look at the mysqld config file that is supplied with the HamPC
> load and it is not configure correctly which is why it is failing.? You
> could probably duplicate the one you are using with HamPI.? you will
> find that at:
>
> /etc/mysql/mysql.conf.d/mysqld.cnf
>
> The [mysql_safe] and [mysqld] settings are what you will need to duplicate.
>
> you will need super user access to edit that file.? Then reboot the
> machine to properly restart the mysql server.
>
> Udo Isaenko wrote on 8/24/2022 10:26:
>> Hi Dave
>>
>> Today, I could create another new USB and tried to start CQRlog just
>> after the very first boot, before making any other changes (language,
>> ...) to the installation.
>>
>> But the problem is still exactly the same. CQRlog cannot create any
>> database.
>>
>> Strange, as with HamPi, all works well with CQRlog.
>>
>> 73
>> Udo, HB9ERD
>>
>> Am 22.08.22 um 02:01 schrieb Udo Isaenko:
>>> Hi Dave
>>>
>>> Am 22.08.22 um 01:50 schrieb Dave Slotter, W3DJS:
>>>> I see your log. Let me check into it and see what I can do...
>>>>
>>>
>>> Many thanks in advance. I can wait.
>>>
>>> By the way, before starting CQRlog, I changed the system language to
>>> german, but I cannot imagine that it has to do with that. I suppose
>>> maybe some permission problems?
>>>
>>> The error is reproductable. Every time I try to start CQRlog, it's
>>> the same.
>>>
>>>> If anyone else has any ideas in the meanwhile...
>>>
>>> It would be interesting if other users have watched the same problem
>>> or not?
>>>
>>> 73
>>> Udo, HB9ERD
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
> --
> Jeff K. Steinkamp (N7YG)
> Tucson, AZ
> Scud Missile Coordinates
> N32.2319 W110.8477
>
-- -- Dave,?? ? ? ? ? ? ? ? ? ? ? ?Technical Specialist,??----??+?? ? ? ? Lifetime Member of??&??&??----??--
|
Hi Dave
Many thanks for all your effort and work investigating this problem.
I highly appreciate this and, no problem, I can wait. Please, don't stress yourself with the correction.
Thanks again and 73 from Switzerland
Udo, HB9ERD
La 26.08.22 je 21:32 skribis Dave Slotter, W3DJS:
toggle quoted message
Show quoted text
Udo,
I have been very busy this week, but finally took a look at the issue and see this in the HamPC log:
|
Dave Slotter, W3DJS