"TMySQL57Connection : Server connect failed." on startup with CQRLOG 2.3.0 on Ubuntu 18.10

5 posts / 0 new
Last post
WZ4Q
"TMySQL57Connection : Server connect failed." on startup with CQRLOG 2.3.0 on Ubuntu 18.10

I've installed the latest version using the "complete application directory" package on my Ubuntu 18.10 system. However, when I run cqrlog, I see an error related to mysql. Please see below for debug output. Any direction that anyone can provide in troubleshooting the issue is appreciated.

CQRLOG Debug Output

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

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.13
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/pburton/
Program home directory: /home/pburton/.config/cqrlog/
Data directory: /home/pburton/.config/cqrlog/database/
Memebers directory: /home/pburton/.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/pburton/.config/cqrlog/database/mysql.cnf --datadir=/home/pburton/.config/cqrlog/database/ --socket=/home/pburton/.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 connect failed.
Trying:7
Trying to connect to database
TMySQL57Connection : Server connect failed.
Trying:8
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
End dmDXCC
Complete end dmDXCC
Closing dDXCC
Closing dData

DL7OAP
Hi,

Hi,

my guess: ubuntu apparmor denies the acces to mysqld

please try this installation routine:
https://www.cqrlog.com/comment/7452#comment-7452

or have a look into your syslog direct after the mysql error. what is mentioned there (i think it will be apparmor warnings):
tail -100 /var/log/syslog

you can try a small correction like this:
sudo sh -c "echo '@{HOME}/.config/cqrlog/database/ r,' >> /etc/apparmor.d/local/usr.sbin.mysqld"
sudo sh -c "echo '@{HOME}/.config/cqrlog/database/** rwk,' >> /etc/apparmor.d/local/usr.sbin.mysqld"
sudo service apparmor restart

here cqrlog works with 18.04, 18.10, 19.04 and daily build of 19.10. so there is hope it will run ;-)

55 & 73 de DL7OAP, Andreas

DL2KI
Hallo Andres,

Hallo Andres,

nichts für ungut, aber mit Software für Anwender hat das alles nichts mehr zu tun. CQRLOG hat sich zur Software für Systemadministratoren und Datenbankexperten entwickelt. Wir sind aber alle Funkamateure, die nichts weiter wollen als ihrem Hobby nachgehen.

Ich nutze CQRLOG noch und kann mit Deiner Beschreibung ja noch halbwegs was anfangen, aber viele schreckt das nur noch ab. Alles nur noch "herumdoktern" an Symptomen.

Sehr schade.

73, Wolfgang
DL2KI

oh1kh
Linux and free software

Hamradio operators should be (and are) above average people technical level. You must pass an examination to get licence. If you can understand radio technology you have also better changes to understand a bit of computers and programs, too.

Selecting Linux for operating system also indicates that user is willing to spent a bit more time and skills to get things going. Otherwise selection would be Windows and commercial programs that both have organized support help desks.

Most common problem for open software is the lack of proper installation instructions and user help documents. Hobby programmers like programming, not manual writing.

In case they do proper instructions, users do not read them. That has been proved so many times.

And if, in very rare cases, user reads instructions he will try to transform or skip some parts to reach the final faster.

If all these cases are passed we still have problem with so many different distributions of Linux and that users will try to use installation instructions made for one version to their own linux that is not just the same version that instructions are for.

There should be a statement:
"By selecting Linux as operating system, and free of charge open software for programs you accept that you may need to work a bit harder to get everything work"

--
Saku
OH1KH

DL2KI
Hi Saku,

Hi Saku,

wrong answer!

73, Wolfgang
DL2KI