Upgrade to Ubuntu 16.04 LTS - CQRlog error connecting to database

5 posts / 0 new
Last post
K5LY
K5LY's picture
Upgrade to Ubuntu 16.04 LTS - CQRlog error connecting to database

Error during connection to database
Tmysql57connection: server connect failed.

Running CQRlog --debug-- results below.

lee@lee-desktop:~$ cqrlog --debug=1

**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.so
Loading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.so
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.0
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 95084 LoTW users
Loaded 99431 eQSL users
Loaded 45943 SCP calls
*
User home directory: /home/lee/
Program home directory: /home/lee/.config/cqrlog/
Data directory: /home/lee/.config/cqrlog/database/
Memebers directory: /home/lee/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/lee/.config/cqrlog/database/mysql.cnf --datadir=/home/lee/.config/cqrlog/database/ --socket=/home/lee/.config/cqrlog/database/sock --port=64000
Trying to connect to database
160729 19:29:56 [Note] /usr/sbin/mysqld (mysqld 10.0.25-MariaDB-0ubuntu0.16.04.1) starting as process 5021 ...
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 ...
lee@lee-desktop:~$

Any suggestions?

ok2cqr
ok2cqr's picture
Re: Upgrade to Ubuntu 16.04 LTS - CQRlog error connecting to dat

Paste here last 20 lines from ~/.config/cqrlog/database/mysql.err, please.
Open a terminal and enter this command:

tail ~/.config/cqrlog/database/mysql.err -n 20

OH1E
i do have same problem, when

i do have same problem, when using on ubuntu.
not even putting mysql password and error comes with or without it.

screenshot https://gyazo.com/07da3d2ed351883ba78611bf98c05d9c

OH1E
fixed

problem fixed by running sudo add-apt-repository ppa:ok2cqr/ppa;sudo apt-get update;sudo apt-get install cqrlog
it updated to v2 and bug is fixed there

G3SQU
G3SQU's picture
Installed v2 but can't open MySql

I'm having a problem with Ubuntu 16.04 trying to use my backed up version of CQRLOG created under Ubuntu 14.02

The MySQL error file has

170225 13:30:53 [ERROR] mysqld: File '/home/chris/.config/cqrlog/database/' not found (Errcode: 13 "Permission denied")
Where do I go from here?

Chris G3SQU