new user, new install, mysql issue

7 posts / 0 new
Last post
NC4WD
new user, new install, mysql issue

Go easy. I'm new to Linux.

2022-03-05T01:02:47.697523Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28-0ubuntu0.20.04.3) starting as process 10298
2022-03-05T01:02:47.700100Z 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-03-05T01:02:47.700120Z 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-03-05T01:02:47.710778Z 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: f90045e7-9c1f-11ec-9369-a4badbdd36ca.
2022-03-05T01:02:47.717617Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-03-05T01:02:47.717831Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-03-05T01:02:47.717931Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-03-05T01:02:47.718727Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28-0ubuntu0.20.04.3) (Ubuntu).
2022-03-05T01:14:06.414034Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.28-0ubuntu0.20.04.3) starting as process 11709
2022-03-05T01:14:06.416352Z 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-03-05T01:14:06.416372Z 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-03-05T01:14:06.429855Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2022-03-05T01:14:06.430065Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2022-03-05T01:14:06.430155Z 0 [ERROR] [MY-010119] [Server] Aborting
2022-03-05T01:14:06.430910Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.28-0ubuntu0.20.04.3) (Ubuntu).

oh1kh
new user, new install, mysql issue

HI!

It looks like you are having Mysql ver 8.0. Cqrlog does not work any more with Mysql ver.8 and up.
The solution is to install MariaDB. Installing that will remove Mysql8.

If you are using Synaptic packet manager look for following packets:
mariadb-client mariadb-server libmariadb libmariadb-dev-compat

On alternative, command console command goes something like this:
sudo apt-get install mariadb-client mariadb-server libmariadb libmariadb-dev-compat

If you have never used cqrlog before (I.E. no qsos in log) then after you have installed MariaDB before starting cqrlog again
issue command console command:

rm -rf ~/.config/cqrlog

That causes a clean restart.

NEVER do this again if you have already qsos in your log ! It will completely wipe out all logs and settings.

You can do the same delete with your file manager if you set "Show hidden files" ON and then find .config/cqrlog folder from your home directory.

--
Saku
OH1KH

NC4WD
josh@josh-Inspiron-1545:~$

josh@josh-Inspiron-1545:~$ sudo apt-get install mariadb-client mariadb-server libmariadb libmariadb-dev-compat
[sudo] password for josh:
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package libmariadb
josh@josh-Inspiron-1545:~$

oh1kh
new user, new install, mysql issue

HI Josh!

As I do not know your Ubuntu version and I have Fedora here (that has totally different package names) you have to search suitable packet names from here:
https://packages.ubuntu.com/searchsuite=default&section=all&arch=any&key...

Look for closest names and choose them.

--
Saku
OH1KH

oh1kh
new user, new install, mysql issue

Lets try again.
It seems the link in previous message did not work. Lets see if this one is ok:
https://packages.ubuntu.com/search?suite=impish&section=all&arch=any&key...

--
Saku
OH1KH

n3wtk
same problem

I have the same problem here. I uninstalled cqrlog and mysql, removed .config/cqrlog, installed mariadb, re-installed cqrlog. cqrlog still insists on using mysql which doesn't work anymore.

Anyone manage to get this to work?

I have a fresh install of lubuntu 21.1 (impish).

oh1kh
new user, new install, mysql issue

HI!

You should start cqrlog from command-line console as
cqrlog --debug=1

Within about first 100 lines you should see that MariaDB really starts. If there is any mention about "mysql 8" your MariaDB installation has not removed mysql completely.

Another good place to check is also ~/.config/cqrlog/database/mysql.err text file. You can remove it and do new start so that there will be only lines from that latest start.
If any mention "mysql 8" there then you do not have MariaDB installed properly.

Because of new machine, I assume it is empty, the best way is to remove MariaDB and remove all mysql packages too. Then reinstall MariaDB and try again.

--
Saku
OH1KH