V2.0.2 (001): Executable not found: "mysqld" [Partially Solved]

3 posts / 0 new
Last post
k5wrn
k5wrn's picture
V2.0.2 (001): Executable not found: "mysqld" [Partially Solved]

Recently encountered an issue when starting CQRLog. I receive an error indicating that mysqld cannot be started.

Upon startup I receive the following error messages:

Error during connection to database: TMySQL56Connection : Server connect failed.

Executable not found: "mysqld".

Press OK to ignore and risk data corruption.
Press Cancel to kill the program.

I've updated CQRLog to the most recent build. I've restarted the mysqld daemon. Nothing seems to work. The file mysql.err does not update as mysql is not started.

When started from the terminal I receive the following (Not much different):

**** DEBUG LEVEL 1 ****

Loading libssl: /usr/lib64/libssl.so.10
Loading libcrypto: /usr/lib64/libcrypto.so.10
Loading libmysqlclient: /usr/lib64/mysql/libmysqlclient.so.18
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 93636 LoTW users
Loaded 98114 eQSL users
Loaded 48268 SCP calls
*
User home directory: /home/the_captain/
Program home directory: /home/the_captain/.config/cqrlog/
Data directory: /home/the_captain/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/ // <--- Notice Typo Here
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
mysqld --defaults-file=/home/the_captain/.config/cqrlog/database/mysql.cnf --datadir=/home/the_captain/.config/cqrlog/database/ --socket=/home/the_captain/.config/cqrlog/database/sock --port=64000
TApplication.HandleException Executable not found: "mysqld" // <-- mysql is located in /usr/bin/mysql
Stack trace:
$00000000006B77EA
$000000000051A68B
$000000000044B096
$0000000000430E8F
$0000000000706ED4
$000000000044D0B2
$00000000007127B8
$00000000007048F8
$0000000000704821
$00000000004508B9
$0000000000702E97
$000000000071CF4C
$0000000000719A5E
$000000000044AC1B
$000000000044F786
$0000000000450E67
$00000000004DBFFC
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
Closing ini file ...

Any ideas?

k5wrn
k5wrn's picture
Solved

It turns out that the path to mysqld was not in the PATH environment variable. At some point, when upgrading to Fedora 25, the path to mysqld must have changed.

The new path is /usr/libexec/mysqld. The issue was corrected by added /usr/libexec to PATH

PATH=$PATH:/usr/libexec
export PATH

Fin

Seven-Three,

Michael - K5WRN
Texas, USA

k5wrn
k5wrn's picture
Partially Solved

Had to add the path to /etc/profile.d by creating a new .sh file called mysqld.sh and including the PATH lines from above in the script. This then correctly added the new path for all users.

Seven-Three,

Michael - K5WRN
Texas, USA