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?
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
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