TMySQL56Connection : Server connect failed.

15 posts / 0 new
Last post
ke5dfk
TMySQL56Connection : Server connect failed.

TMySQL56Connection : Server connect failed.

Ubuntu Mint
CRQLOG 2.3.0(001)

I can't launch the program I get ...
TMySQL56Connection : Server connect failed....
error when trying to load the database.
The database connection is empty.

What is the fix?
Where is the log database location and file name?
If I update CRQLOG will I lose my logbook?

Thanks
Carlos
KE5DFK

DF1NIF
Hi Carlos,

Hi Carlos,

MariaDb/MySQL Version? Local stored or on a Server? Local is saved in ~/.config/cqrlog/database

What did you see when you start cqrlog with -debug=1?

73 de Tobias, DF1NIF

ke5dfk
Debug Results

Tobias, thanks.
This what I get, once I get to the end it gives me the error.

Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** 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/libmariadbclient.so
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 130254 LoTW users
Loaded 122980 eQSL users
Loaded 37393 SCP calls
*
User home directory: /home/carlos/
Program home directory: /home/carlos/.config/cqrlog/
Data directory: /home/carlos/.config/cqrlog/database/
Memebers directory: /home/carlos/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.6
*
56 us states loaded
/usr/sbin/mysqld --defaults-file=/home/carlos/.config/cqrlog/database/mysql.cnf --datadir=/home/carlos/.config/cqrlog/database/ --socket=/home/carlos/.config/cqrlog/database/sock --port=64000
Trying to connect to database
Warning: World-writable config file '/home/carlos/.config/cqrlog/database/mysql.cnf' is ignored
2019-08-25 16:17:32 140276159442048 [Note] /usr/sbin/mysqld (mysqld 10.1.40-MariaDB-0ubuntu0.18.04.1) starting as process 4113 ...
2019-08-25 16:17:32 140276159442048 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4184)
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-08-25 16:17:32 140276159442048 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: The InnoDB memory heap is disabled
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: Using Linux native AIO
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: Using SSE crc32 instructions
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2019-08-25 16:17:32 140276159442048 [Note] InnoDB: Completed initialization of buffer pool
2019-08-25 16:17:33 140276159442048 [Note] InnoDB: Highest supported file format is Barracuda.
2019-08-25 16:17:33 140276159442048 [Note] InnoDB: The log sequence number 101361251 in ibdata file do not match the log sequence number 101361441 in the ib_logfiles!
2019-08-25 16:17:33 140276159442048 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2019-08-25 16:17:33 140276159442048 [Note] InnoDB: 128 rollback segment(s) are active.
2019-08-25 16:17:33 140276159442048 [Note] InnoDB: Waiting for purge to start
2019-08-25 16:17:33 140276159442048 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.43-84.3 started; log sequence number 101361441
2019-08-25 16:17:33 140276159442048 [Note] Plugin 'FEEDBACK' is disabled.
2019-08-25 16:17:33 140276159442048 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2019-08-25 16:17:33 140276159442048 [Note] Recovering after a crash using tc.log
2019-08-25 16:17:33 140276159442048 [Note] Starting crash recovery...
2019-08-25 16:17:33 140276159442048 [Note] Crash recovery finished.
2019-08-25 16:17:33 140275397687040 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-08-25 16:17:33 140276159442048 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-08-25 16:17:33 140276159442048 [Note] Server socket created on IP: '::'.
2019-08-25 16:17:33 140276159442048 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
TMySQL56Connection : Server connect failed.
Trying:1
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:2
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:3
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:4
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:5
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:6
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:7
Trying to connect to database
TMySQL56Connection : Server connect failed.
Trying:8

Thanks
Carlos KE5DFK

DF1NIF
Good morning,

Good morning,

sorry for the late delay...

I am not sure but maybe there is a problem with your database files and your MariaDB server tried to fix the problem. Or another solution is, that you got a new version and the startup script tries to upgrade automatically the database files which does not work because you have no mysql database.

Have you tried to save the database folder, create a complete new and empty database? This should work if the database files are destroyed or cannot converted to a new format. After that, you can import a backup of your log.

73 de Tobias, DF1NIF

ke5dfk
New db created. But.....

When I open the new log and go ...........Utilities>>>Import>>>>>find old db>>>>select the old db.....I don't find any .ini files that the import format is looking for.
Thanks
Carlos

oh1kh
New db created. But.....

Hi Carlos!
Utilities>>>Import at "Database connection" window is for importing log settings that must first be created by exporting them from another log. They do not exist by default.

If you want a new log with same settings as your old log first select your old log and export settings ini file.
Then create a new log and import settings to that log.

Please check this message before doing it: https://www.cqrlog.com/comment/6716#comment-6716

--
Saku
OH1KH

DF1NIF
Why do you not use File ->

Why do you not use File -> Import -> ADIF and use a backup file of your old database?

ke5dfk
I was not able to open the

I was not able to open the program so I was not able to make an ADIF backup. The only thing I was able to do was to move the db folder to another location as Tobias suggested. Once I did I was able to created a new db and was able to open the program again.
Thanks
Carlos

DF1NIF
No backup? :-O No pity!

No backup? :-O No pity!

Then you can only try to repair your database with an "real" MariaDB server and hope, that this will work. You can look into the thread about the ArchLinux problems with the upgrade to MariaDB 10.4. The process is the same you have to do here.

iu1bow
I've a similar problem

I'm using Ubuntu 19.10 "eoan ermine" and I have a similar problem.

Below my debug and in attachment the mysql.err

----

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

OS:
Linux version 5.3.0-19-generic (buildd@lgw01-amd64-053) (gcc version 9.2.1 20191008 (Ubuntu 9.2.1-9ubuntu2)) #20-Ubuntu SMP Fri Oct 18 09:04:39 UTC 2019
SSL libraries:
libssl.so
libcrypto.so
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/corrado/
Program home directory: /home/corrado/.config/cqrlog/
Data directory: /home/corrado/.config/cqrlog/database/
Memebers directory: /home/corrado/.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/corrado/.config/cqrlog/database/mysql.cnf
--datadir=/home/corrado/.config/cqrlog/database/
--socket=/home/corrado/.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 conn

------

Have you any idea?

I've also adif backup of my log.

Thanks to all.
Corrado

File: 

iu1bow
Any solutions?

No one have a solution?

on5hb
on5hb's picture
Looks to me MariaDB isn't installed.

The problem is probably because maria-db isn't installed, that has replaced MySQL for some time now.
Try this:

>> sudo apt update <<
>> sudo apt install mariadb-server <<

That should install Mariadb instead of MySQL, say yes to all questions and CQRlog should work after.

I had this problem too.

BTW, MariaDB and MySQL are compatible for client programs, but MySQL was sold and people forked it into MariaDB.

Greetings, Bas. ON5HB

iu1bow
[Solved] TMySQL56Connection : Server connect failed

Hello
with your suggestion:

>> sudo apt update <<
>> sudo apt install mariadb-server <<

now it's works

Thanks
Corrado

on5hb
on5hb's picture
Glad to hear that. Thanks.

Glad to hear that.
Thanks.

Greetings, Bas. ON5HB

la6zk
TMySQL56Connection : Connection can not work...

...can not work with the installed MySQL client version:Exspected (5.6) got (5.7.1)