MySQL trouble

7 posts / 0 new
Last post
K9ELM
MySQL trouble

Have been having a rough time getting LoTW working with CQRLog. Restarted my computer today and was told MySQL couldn't be started. Here's the last lines of the mysqr.err file:

2023-04-08 13:21:24 0 [Note] Starting MariaDB 10.6.12-MariaDB-0ubuntu0.22.04.1 source revision as process 2452
2023-04-08 13:21:24 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-04-08 13:21:24 0 [Note] InnoDB: Number of pools: 1
2023-04-08 13:21:24 0 [Note] InnoDB: Using generic crc32 instructions
2023-04-08 13:21:24 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2023-04-08 13:21:24 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-08 13:21:33 0 [Note] InnoDB: 128 rollback segments are active.
2023-04-08 13:21:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-08 13:21:34 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-08 13:21:34 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-04-08 13:21:34 0 [Note] InnoDB: 10.6.12 started; log sequence number 62087947; transaction id 3544
2023-04-08 13:21:34 0 [Note] InnoDB: Loading buffer pool(s) from /home/brandon/.config/cqrlog/database/ib_buffer_pool
2023-04-08 13:21:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-08 13:21:34 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2023-04-08 13:21:34 0 [Note] Server socket created on IP: '0.0.0.0'.
2023-04-08 13:21:34 0 [Note] Server socket created on IP: '::'.
2023-04-08 13:21:34 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2023-04-08 13:21:34 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2023-04-08 13:21:34 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.12-MariaDB-0ubuntu0.22.04.1' socket: '/home/brandon/.config/cqrlog/database/sock' port: 64000 Ubuntu 22.04
2023-04-08 13:21:36 0 [Note] InnoDB: Buffer pool(s) load completed at 230408 13:21:36

oh1kh
MySQL trouble

Hi!
Do you have some kind of replication with databases?

"InnoDB: 10.6.12 started; log sequence number 62087947; transaction id 3544"2023-04-08 13:21:34 1
" [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory") "

If you start cqrlog from command terminal with:
cqrlog --debug=1
What the debug text shows?

--
Saku
OH1KH

K9ELM
brandon@Brandon-Linux:~$

brandon@Brandon-Linux:~$ cqrlog --debug=1

(cqrlog:3462): GLib-GObject-WARNING **: 16:25:58.238: ../../../gobject/gsignal.c:2613: signal 'populate-popup' is invalid for instance '0x2e53180' of type 'GtkCellView'

(cqrlog:3462): GLib-GObject-WARNING **: 16:25:58.239: ../../../gobject/gsignal.c:2613: signal 'populate-popup' is invalid for instance '0x2e53220' of type 'GtkCellView'

Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****

OS:
Linux version 5.15.0-69-generic (buildd@lcy02-amd64-080) (gcc (Ubuntu 11.3.0-1ubuntu1~22.04) 11.3.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #76-Ubuntu SMP Fri Mar 17 17:19:29 UTC 2023
SSL libraries:
libssl.so
libcrypto.so
Loaded 186425 LoTW users
Loaded 162580 eQSL users
Loaded 84248 SCP calls
*
User home directory: /home/brandon/
Program home directory: /home/brandon/.config/cqrlog/
Data directory: /home/brandon/.config/cqrlog/database/
Memebers directory: /home/brandon/.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/brandon/.config/cqrlog/database/mysql.cnf
--datadir=/home/brandon/.config/cqrlog/database/
--socket=/home/brandon/.config/cqrlog/database/sock
--port=64000

Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:1
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

use cqrlog001

SELECT * FROM cqrlog_config

select * from db_version

[UpgradeMainDatabase] Old version: 18 cDB_MAIN_VER: 18
select * from cqrlog_common.db_version

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF

SELECT * FROM cqrlog_common.bands

Settings:
-----------------------------------------------------
RigCtldPath:/usr/local/bin/rigctld
RigCtldArgs:-m 1036 -r /dev/ttyUSB0 -t 4532 -s 38400 --set-conf=stop_bits=2,serial_parity=Mark,serial_handshake=None
RunRigCtld: TRUE
RigDevice: /dev/ttyUSB0
RigCtldPort:4532
RigCtldHost:127.0.0.1
RigPoll: 500
RigSendCWR: FALSE
RigId: 1036

Starting RigCtld ...
rigProcess.Executable: /usr/local/bin/rigctld
Parameters:
-m
1036
-r
/dev/ttyUSB0
-t
4532
-s
38400
--set-conf=stop_bits=2,serial_parity=Mark,serial_handshake=None

rigctld started!
Connected to rigctld @ 127.0.0.1:4532
Radio1 CW settings:
CW init keyer type:0
CW keyer reloaded by TRControl radio1 change

Settings:
-----------------------------------------------------
RotCtldPath:/usr/bin/rotctld
RotCtldArgs:-m 1 -t 4533
RunRotCtld: FALSE
RotDevice:
RotCtldPort:4533
RotCtldHost:localhost
RotPoll: 500
RotId: 1

Not started rotctld process. (Run is set FALSE)
Connected to rotctld @ localhost:4533
FreqmemSql:select id,freq,mode,bandwidth,info from freqmem order by id

FreqmemNR:0=0
FreqmemFirst:0 FreqmemLast:0
Sending: fmv

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

SELECT * FROM profiles WHERE visible > 0 ORDER BY nr

SELECT * FROM profiles WHERE nr = -1

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

Sending: fmv

oh1kh
MySQL trouble

HI Barandon!

Your Cqrlog debug looks normal. I can not see anything else but that your rig does not react polling (Sending fmv has no answer)

What is the actual problem now?
Is it database or rig that fails?

--
Saku
OH1KH

KG4IIC
MySQL trouble

DITTO!

Fails attempt to startup CQRLog.
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so-20" or libmysqlclient.so")

2023-04-12 15:56:29 0 [Note] InnoDB: Uses event mutexes
2023-04-12 15:56:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-04-12 15:56:29 0 [Note] InnoDB: Number of pools: 1
2023-04-12 15:56:29 0 [Note] InnoDB: Using generic crc32 instructions
2023-04-12 15:56:29 0 [Note] InnoDB: Using Linux native AIO
2023-04-12 15:56:29 0 [Note] InnoDB: Initializing buffer pool, total size = 83886080, chunk size = 83886080
2023-04-12 15:56:29 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-12 15:56:29 0 [Note] InnoDB: 128 rollback segments are active.
2023-04-12 15:56:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-12 15:56:29 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-12 15:56:29 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2023-04-12 15:56:29 0 [Note] InnoDB: 10.5.15 started; log sequence number 252946057; transaction id 172860
2023-04-12 15:56:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-12 15:56:29 0 [Note] InnoDB: Loading buffer pool(s) from /home/pi/.config/cqrlog/database/ib_buffer_pool
2023-04-12 15:56:29 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2023-04-12 15:56:29 0 [Note] Server socket created on IP: '::'.
2023-04-12 15:56:29 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2023-04-12 15:56:29 1 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2023-04-12 15:56:29 0 [Note] Reading of all Master_info entries succeeded
2023-04-12 15:56:29 0 [Note] Added new Master_info '' to hash table
2023-04-12 15:56:29 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.5.15-MariaDB-0+deb11u1' socket: '/home/pi/.config/cqrlog/database/sock' port: 64000 Raspbian 11
2023-04-12 15:56:29 0 [Note] InnoDB: Buffer pool(s) load completed at 230412 15:56:29

cqrlog --debug=1

pi@raspberrypi:~ $ cqrlog --debug=1
Gtk-Message: 16:15:07.628: Failed to load module "gail"

** (cqrlog:2376): WARNING **: 16:15:07.649: (../atk-adaptor/bridge.c:1018):atk_bridge_adaptor_init: runtime check failed: (root)

Cqrlog Ver:2.6.0 (001) Gtk2 Date:2022-07-05
**** DEBUG LEVEL 1 ****

OS:
Linux version 6.1.21-v8+ (dom@buildbot) (aarch64-linux-gnu-gcc-8 (Ubuntu/Linaro 8.4.0-3ubuntu1) 8.4.0, GNU ld (GNU Binutils for Ubuntu) 2.34) #1642 SMP PREEMPT Mon Apr 3 17:24:16 BST 2023
SSL libraries:
libssl.so
libcrypto.so
Loaded 186425 LoTW users
Loaded 162580 eQSL users
Loaded 84248 SCP calls
*
User home directory: /home/pi/
Program home directory: /home/pi/.config/cqrlog/
Data directory: /home/pi/.config/cqrlog/database/
Memebers directory: /home/pi/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
*
Loaded mode conversion files:
submode=mode
for_import_only
ex_mode=cqrlogmode
56 us states loaded
Grid map created
/usr/bin/mysqld
MySQLProcess.Executable: /usr/sbin/mysqld Parameters: --defaults-file=/home/pi/.config/cqrlog/database/mysql.cnf
--datadir=/home/pi/.config/cqrlog/database/
--socket=/home/pi/.config/cqrlog/database/sock
--port=64000

Trying to connect to database
2023-04-12 16:15:12 0 [Note] /usr/sbin/mysqld (mysqld 10.5.15-MariaDB-0+deb11u1) starting as process 2472 ...
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:1
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:2
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:3
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:4
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:5
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:6
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:7
Trying to connect to database
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
/home/pi/.config/cqrlog/database/raspberrypi.pid
p.Executable: kill Parameters: 2472

Thread error

I'm running Raspberry Pi 4B 4GB. Raspbian Bullseye v11.
This began after I did sudo apt-get update & upgrade then autoremove.
Is there a fix?

Thanks in advance.
Russ - kg4iic

oh1kh
MySQL trouble

HI Russ!
As you error text says:
Can not load default MySQL library ("libmysqlclient.so.20" or "libmysqlclient.so"). Check your installation.
libmysqlclient is missing from your RPi.
Look for libmysqlclient with Synaptic packet manager and install it.

--
Saku
OH1KH

K9ELM
Since Russ so kindly hijacked

Since Russ so kindly hijacked my thread, I guess I'll have to find a solution elsewhere, or switch logging programs. Common courtesy seems to be a lost trait now days...