TMySQL57Connection:Server connection failed.

6 posts / 0 new
Last post
KF4RX
TMySQL57Connection:Server connection failed.

I'm trying to do a new install on Lubuntu 18.04. I can't seem to get MySQL going. The mysql.err file tells me "no such file or directory". I tried installing MySQL Workbench just to be sure I had everything MySQL wanted, but still no luck getting CQRlog to open. Any help appreciated. Jim, KF4RX

ok2cqr
ok2cqr's picture
Re: TMySQL57Connection:Server connection failed.

Hi Jim,

open a console and run cqrlog with --debug=1 parameter. There will be a lot of information. Copy and paste it here. Thanks!

73 Petr

f1mxe
Hello,

Hello,

using ubuntu18.04lts 64b

i have today the same problem !
i can not open CQRLOG.....

Error during connection to database: TMySQL57Connection : Server connect failed

/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 121877 LoTW users
Loaded 117881 eQSL users
Loaded 39430 SCP calls
*
User home directory: /home/f1mxe/
Program home directory: /home/f1mxe/.config/cqrlog/
Data directory: /home/f1mxe/.config/cqrlog/database/
Memebers directory: /home/f1mxe/.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

thanks for your help and sorry for my bad english
73
didier f1mxe jn05gq

File: 

f1mxe
also in terminal

also in terminal
All-Series:~$ cqrlog --debug=1
Gtk-Message: 17:14:49.213: Failed to load module "canberra-gtk-module"

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****

PY2ZA
Re: TMySQL57Connection:Server connection failed

Hi,

I formatted my machine and upgraded Linux Mint this week. I had the same problem when I opened CQRLOG.

Solved today as follows, I uninstalled all CQRLOG, deleted all folders (including in /.config/...), ensure that the MySQL server and client were installed, I reinstalled CQRLOG and when I opened I asked to create a new database.

Now it opened normally and then I imported my ADIF.

dl1wil
TMySQL57Connection : Server connect failed.

Hello,

I'v got the same problem:

-------------------------------------------------------------

dl1wil@dl1wil:~$ cqrlog --debug1

(cqrlog:5568): Gtk-WARNING **: 18:30:29.034: Unable to locate theme engine in module_path: "adwaita",

(cqrlog:5568): Gtk-WARNING **: 18:30:29.038: Unable to locate theme engine in module_path: "adwaita",

**** DEBUG LEVEL 1 ****

SSL libraries:
/usr/lib/x86_64-linux-gnu/libssl.so.1.0.0
/usr/lib/x86_64-linux-gnu/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.11
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/dl1wil/
Program home directory: /home/dl1wil/.config/cqrlog/
Data directory: /home/dl1wil/.config/cqrlog/database/
Memebers directory: /usr/share/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/dl1wil/.config/cqrlog/database/mysql.cnf --datadir=/home/dl1wil/.config/cqrlog/database/ --socket=/home/dl1wil/.config/cqrlog/database/sock --port=64000
Trying to connect to database
mysqld: [ERROR] Could not open required defaults file: /home/dl1wil/.config/cqrlog/database/mysql.cnf
mysqld: [ERROR] Fatal error in defaults handling. Program aborted!
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
Invalid file handle
Closing ini file ...
dl1wil@dl1wil:~$

-------------------------------------------------------------

Maybe in this forum is a link to resolve it.

Tnx de Wil