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
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
/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
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
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 --versionmariadb 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:
OK,
I have rebooting my system, and all it's OK !
Congratulation for CQRLog and thanks for your help.
73's, Geoffroy, ON6GMT.