Error during connection to database: TMySQL57Connection

6 posts / 0 new
Last post
ON6GMT
Error during connection to database: TMySQL57Connection

Hello,

I have installed the new version of Ubuntu (22.04) today, but i have one error during connection to database.
After lanching CQRLog with the command 'cqrlog --debug=1', i have this response :

./cqrlog --debug=1

Cqrlog Ver:2.6.0 (109) Gtk2 Date:2023-01-26
**** DEBUG LEVEL 1 ****

OS:
Linux version 5.15.0-60-generic (buildd@lcy02-amd64-054) (gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #66-Ubuntu SMP Fri Jan 20 14:29:49 UTC 2023
SSL libraries:
libssl.so
libcrypto.so
Loaded 184455 LoTW users
Loaded 161300 eQSL users
Loaded 74760 SCP calls
*
User home directory: /home/geoffroy/
Program home directory: /home/geoffroy/.config/cqrlog/
Data directory: /home/geoffroy/.config/cqrlog/database/
Memebers directory: /home/geoffroy/.config/cqrlog/members/
ZIP code directory: /home/geoffroy/.config/share/cqrlog/zipcodes/
Binary dir: /home/geoffroy/.config/cqrlog/
Share dir: /home/geoffroy/.config/share/cqrlog/
*
Loaded mode conversion files:
submode=mode
for_import_only
ex_mode=cqrlogmode
56 us states loaded
Grid map created
/home/geoffroy/.config/cqrlog/mysqld
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/geoffroy/.config/cqrlog/database/mysql.cnf
--datadir=/home/geoffroy/.config/cqrlog/database/
--socket=/home/geoffroy/.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
Exception at 0000000000641DDE: EAccessViolation:
Access violation.
Closing dDXCC
Closing dData

The problem is MariaDB. how to install it correctly ?

Thanks.
Geoffroy - Ubuntu 22.04

oh1kh
Error during connection to database: TMySQL57Connection

HI Geoffroy!

First check your mysql version with command console:
/usr/sbin/mysqld --version

It should say MariaDB something,

If not try to install:
sudo apt install mariadb-common mariadb-server mariadb-client

--
Saku
OH1KH

ON6GMT
/usr/sbin/mysqld Ver 8.0.32

/usr/sbin/mysqld Ver 8.0.32-0ubuntu0.22.04.2 for Linux on x86_64 ((Ubuntu))

but it's not possible to install MariaDB with your command, the pack of mariadb-client it's not disponible. :

"The package ' mariadb-server ' does not have an installable version."

Geoffroy

oh1kh
HI!

HI!

Here is somewhat similar quide:
https://www.makeuseof.com/install-set-up-mariadb-on-ubuntu/

How ever there are two things that I am not so sure:
1) sudo apt-get install wget software-properties-common dirmngr ca-certificates apt-transport-https -y
Guide says these are needed By MariaDB. How ever if Mariadb package is designed properly it should load all needed dependencies automated.

2)sudo mysql_secure_installation
I would not do this without knowing what happens.
The problem with MySQL (that is now installed in your system) is that it's security prevents using database from your home folder, I.E. ~/.config/cqrlog/database where your logs exists.
Now if you run this "2)" it may do perhaps the same for MariaDB

Usually the command:
sudo apt install mariadb-common mariadb-server mariadb-client
Has been enough for Ubuntu Cqrlog users. (I do not have Ubuntu here)
Yo could first try:
sudo apt update && sudo apt upgrade
This should not do any harm and puts your system up to date.
After that try again:
sudo apt install mariadb-common mariadb-server mariadb-client

By this list:
https://packages.ubuntu.com/search?keywords=mariadb&searchon=names&suite...
There should be all three packages for your Ubuntu 22

--
Saku
OH1KH

ON6GMT
Hi Saku !

I do not know this website : https://www.makeuseof.com/install-set-up-mariadb-on-ubuntu/

But I realized that the "universe" repository was not activated.
Now, MariaDB is installed :

mariadb --version

mariadb Ver 15.1 Distrib 10.6.12-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper

but when I launch CQRLog, I find my self in this situation :

File: 

ON6GMT
Sorry...

OK,

I have rebooting my system, and all it's OK !

Congratulation for CQRLog and thanks for your help.

73's, Geoffroy, ON6GMT.