CQR Log and MariaDB crash

3 posts / 0 new
Last post
ur3iqj
CQR Log and MariaDB crash

After many manipulations with alpha version i have a problem
Error:
TMySQL57Connection : Error executing query: Can't create database 'cqrlog_common' (errno: 2 "No such file or directory").

I reinstall CQR Log with this instructions

1. Remove CQRLog installation with packet manager
2. Remove MariaDB installation with packet manager
3. Delete var/lib/mysql: sudo rm /var/lib/mysql (or rename it: sudo mv /var/lib/mysql /var/lib/mysql.old )
4. Re-install MariaDB with the packet manager
5. Initialise MariaDB with the following commands: (found here: https://manjaro.site/a-complete-guide-to-install-mariadb-server-on-manja... )
sudo mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
sudo systemctl start mariadb
sudo systemctl enable mariadb
sudo mysql_secure_installation
6. Re-install CQRLog with the packet manager
7. Re-initialise database according to SQ6POC:
sudo cp -r /var/lib/mysql/mysql ~/.config/cqrlog/database
sudo chown -R ~/.config/cqrlog/database
cd ~/.config/cqrlog/ctyfiles && touch -t 1901101200 -m *
8. Start CQRLog and update DXCC/IOTA/QSL Managers
9. Restart CQRLog

It's not work for me

cqrlog debug=1
Gtk-Message: 09:46:45.264: Failed to load module "atk-bridge"

(cqrlog:26805): Gtk-WARNING **: 09:46:45.284: Загружаемый модуль тем не найден в module_path: «adwaita»,

Cqrlog Ver:2.4.0 (001) Date:2019-10-27
**** DEBUG LEVEL 1 ****

OS:
Linux version 5.9.0-5-amd64 (debian-kernel@lists.debian.org) (gcc-10 (Debian 10.2.1-1) 10.2.1 20201207, GNU ld (GNU Binutils for Debian) 2.35.1) #1 SMP Debian 5.9.15-1 (2020-12-17)
SSL libraries:
libssl.so
libcrypto.so
Loaded 145770 LoTW users
Loaded 133723 eQSL users
Loaded 34772 SCP calls
*
User home directory: /home/bambr/
Program home directory: /home/bambr/.config/cqrlog/
Data directory: /home/bambr/.config/cqrlog/database/
Memebers directory: /home/bambr/.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/bambr/.config/cqrlog/database/mysql.cnf
--datadir=/home/bambr/.config/cqrlog/database/
--socket=/home/bambr/.config/cqrlog/database/sock
--port=64000

2021-01-04 9:46:47 0 [Note] /usr/sbin/mysqld (mysqld 10.5.8-MariaDB-3) starting as process 26809 ...
select * from tables where table_schema = 'cqrlog_common'

CREATE DATABASE cqrlog_common DEFAULT CHARACTER SET = utf8 DEFAULT COLLATE = utf8_bin;

USE cqrlog_common;

CREATE TABLE bands (
id_bands INT AUTO_INCREMENT PRIMARY KEY,
band VARCHAR(10) DEFAULT '',
b_begin NUMERIC(10,4),
b_end NUMERIC(10,4),
cw NUMERIC(10,4),
rtty NUMERIC(10,4),
ssb NUMERIC(10,4),
rx_offset numeric(10,4) default 0,
tx_offset numeric(10,4) default 0
);
CREATE INDEX band ON bands(band);

CREATE TABLE dxclusters (
id_dxclusters INT AUTO_INCREMENT PRIMARY KEY,
description VARCHAR(100) DEFAULT '',
address VARCHAR(100) DEFAULT '',
port VARCHAR(10) DEFAULT '',
dxcuser VARCHAR(12) DEFAULT '',
dxcpass VARCHAR(20) DEFAULT ''
);
CREATE INDEX description ON dxclusters(description);

CREATE TABLE iota_list (
id_iota_list INT AUTO_INCREMENT PRIMARY KEY,
iota_nr VARCHAR(6) DEFAULT '',
island_name VARCHAR(250) DEFAULT '',
dxcc_ref VARCHAR(15) DEFAULT '',
pref VARCHAR(15) DEFAULT ''
);
CREATE INDEX iota_nr ON iota_list(iota_nr);
CREATE INDEX pref ON iota_list(pref);

CREATE TABLE dxcc_ref (
id_dxcc_ref INT AUTO_INCREMENT PRIMARY KEY,
pref VARCHAR(20) NOT NULL,
name VARCHAR(100) NOT NULL,
cont VARCHAR(6) NOT NULL,
utc VARCHAR(12)NOT NULL,
lat VARCHAR(10) NOT NULL,
longit VARCHAR(10) NOT NULL,
itu VARCHAR(20) NOT NULL,
waz VARCHAR(20) NOT NULL,
adif SMALLINT NOT NULL DEFAULT 0,
deleted SMALLINT NOT NULL DEFAULT 0
);
CREATE INDEX pref ON dxcc_ref(pref);
CREATE INDEX adif ON dxcc_ref(adif);

CREATE TABLE qslmgr (
id_qslmgr INT AUTO_INCREMENT PRIMARY KEY,
callsign VARCHAR(20),
qsl_via VARCHAR(20),
fromdate DATE
);
CREATE INDEX callsign ON qslmgr(callsign);
CREATE INDEX fromdate ON qslmgr(fromdate);

CREATE TABLE log_list (
id_log_list INT AUTO_INCREMENT PRIMARY KEY,
log_nr SMALLINT NOT NULL,
log_name VARCHAR(50) DEFAULT '',
auto_open SMALLINT NOT NULL DEFAULT 0
);
CREATE INDEX log_nr ON log_list(log_nr);

CREATE TABLE db_version
(
nr SMALLINT NOT NULL
);

Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
Closing ini file ...

Anyone please help me with reisntall.
My system is a Latest Debian testing.

oh1kh
CQR Log and MariaDB crash

Hi!
Are you sure you have GTK2, not GTK3 installed?

Have you tried to install:
apt-get install libatk-adaptor

--
Saku
OH1KH

ur3iqj
After full reinstall mariadb

After full reinstall mariadb and CQR Log with reboot and delete ~/.config/cqrlog work fine with alpha 4.0.134 build