After upgrading to Linux Mint 20 (And downgrading again to 19.3 with timeshift)
When i run cqrlog i get an error:
Error during connection to database: TMySQL57Connection : Server connect failed.
then the database window opens but no logs available
I ran cqrlog with debug here is the output.
reggy@reggy-asus:~$ cqrlog --debug=1
Fontconfig warning: "/etc/fonts/conf.avail/53-monospace-lcd-filter.conf", line 10: Having multiple values in isn't supported and may not work as expected
Cqrlog Ver:2.4.0 (001) Date:2019-10-27
**** DEBUG LEVEL 1 ****
OS:
Linux version 5.4.0-42-generic (buildd@lgw01-amd64-023) (gcc version 7.5.0 (Ubuntu 7.5.0-3ubuntu1~18.04)) #46~18.04.1-Ubuntu SMP Fri Jul 10 07:21:24 UTC 2020
SSL libraries:
libssl.so
libcrypto.so
Loaded 137314 LoTW users
Loaded 127581 eQSL users
Loaded 35084 SCP calls
*
User home directory: /home/reggy/
Program home directory: /home/reggy/.config/cqrlog/
Data directory: /home/reggy/.config/cqrlog/database/
Memebers directory: /home/reggy/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
*
56 us states loaded
Grid map created
/usr/bin/mysqld
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/reggy/.config/cqrlog/database/mysql.cnf
--datadir=/home/reggy/.config/cqrlog/database/
--socket=/home/reggy/.config/cqrlog/database/sock
--port=64000
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:2
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:3
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:4
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:5
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:6
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:7
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
Closing ini file ...
reggy@reggy-asus:~$
Hi!
Open command console and copy this (it is one line) to it and press enter:
/usr/sbin/mysqld --defaults-file=/home/reggy/.config/cqrlog/database/mysql.cnf --datadir=/home/reggy/.config/cqrlog/database/ --datadir=/home/reggy/.config/cqrlog/database/ --socket=/home/reggy/.config/cqrlog/database/sock --port=64000
If I do it with my username and Fedora31 (that has different directtory for mysqld):
[saku@hamtpad ~]$ /usr/libexec/mysqld --defaults-file=/home/saku/.config/cqrlog/database/mysql.cnf --datadir=/home/saku/.config/cqrlog/database/ --datadir=/home/saku/.config/cqrlog/database/ --socket=/home/saku/.config/cqrlog/database/sock --port=64000
I see:
2020-09-02 9:23:43 0 [Note] /usr/libexec/mysqld (mysqld 10.3.22-MariaDB) starting as process 3165 ...
If you see it starting then it is ok. But looking from debug it seems like cqrlog can not start it (not found perhaps?) So many tries, then give up.
Or is there some other error seen from command console. That can not be seen from debug text.
There might be something happened with downgrade.
--
Saku
OH1KH
i tried that command, nothing returned and the program is still not starting(no database)
here is the last couple of lines in mysql.err file
2020-09-01T13:00:08.044450Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 1405064
2020-09-01T13:00:08.045797Z 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.
2020-09-01T13:00:08.045809Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-09-01T13:00:08.058750Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-01T13:00:08.058889Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-01T13:00:08.058940Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T13:00:08.059263Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-09-01T13:03:55.852810Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 1409225
2020-09-01T13:03:55.853604Z 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.
2020-09-01T13:03:55.853613Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-09-01T13:03:55.858961Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-01T13:03:55.859108Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-01T13:03:55.859157Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T13:03:55.859510Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-09-01T13:18:43.385322Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 1425797
2020-09-01T13:18:43.386811Z 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.
2020-09-01T13:18:43.386824Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-09-01T13:18:43.405022Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-01T13:18:43.405183Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-01T13:18:43.405248Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T13:18:43.405616Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-09-01T13:19:12.841184Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 1426323
2020-09-01T13:19:12.841873Z 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.
2020-09-01T13:19:12.841882Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-09-01T13:19:12.853959Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-01T13:19:12.854114Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-01T13:19:12.854179Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-01T13:19:12.854586Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-09-02T18:05:05.911025Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 8434
2020-09-02T18:05:05.911755Z 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.
2020-09-02T18:05:05.911763Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-09-02T18:05:05.931379Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-02T18:05:05.931550Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-02T18:05:05.931625Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-02T18:05:05.932114Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-09-02T18:05:37.482177Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 9001
2020-09-02T18:05:37.482909Z 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.
2020-09-02T18:05:37.482918Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_general_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2020-09-02T18:05:37.488331Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2020-09-02T18:05:37.488446Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-09-02T18:05:37.488499Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-09-02T18:05:37.488797Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
Hello Regin,
it seems mysql 8 cannot start due to security reasons, which is ubuntu related.
You have to change to mariadb (mysql alternative) which is not too much security regulated, hi.
Please check your databases when you really need mysql 8.
Try the following:
sudo apt install libmariadb3 libmariadb-dev mariadb-common mariadb-server-10.3 mariadb-client-10.3 libcanberra-gtk-module
Mysql 8 is replaced with MariaDB and all "db-problems" are gone :-)
--
73 de Martin, DL1MTG