CQRLOG had been working fine but today I get an error with mySQL when I start.
here is the output of cqrlog -debug=1
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/libmysqlclient.so.20
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 132665 LoTW users
Loaded 124677 eQSL users
Loaded 37246 SCP calls
*
User home directory: /home/kenny/
Program home directory: /home/kenny/.config/cqrlog/
Data directory: /home/kenny/.config/cqrlog/database/
Memebers directory: /home/kenny/.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/kenny/.config/cqrlog/database/mysql.cnf --datadir=/home/kenny/.config/cqrlog/database/ --socket=/home/kenny/.config/cqrlog/database/sock --port=64000
Trying to connect to database
mysqld: Error on realpath() on '/var/lib/mysql-files' (Error 2 - No such file or directory)
2019-08-29T01:46:13.615402Z 0 [Warning] Changed limits: max_open_files: 1024 (requested 5000)
2019-08-29T01:46:13.615467Z 0 [Warning] Changed limits: max_connections: 214 (requested 256)
2019-08-29T01:46:13.779643Z 0 [Warning] The syntax '--log_warnings/-W' is deprecated and will be removed in a future release. Please use '--log_error_verbosity' instead.
2019-08-29T01:46:13.779687Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-08-29T01:46:13.779775Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
2019-08-29T01:46:13.779801Z 0 [ERROR] Aborting
2019-08-29T01:46:13.779817Z 0 [Note] Binlog end
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
Closing ini file ...
any help would be appreciated.
Thanks,
Kenny
KB9TT
Hi Kenny!
Have you updated your linux, or do you have auto updates enabled ?
Looks like something has happened to your MySql.
2019-08-29T01:46:13.779775Z 0 [ERROR] Failed to access directory for --secure-file-priv. Please make sure that directory exists and is accessible by MySQL Server. Supplied value : /var/lib/mysql-files
Here has been discussions about latest versions of Mysql (MariaDB) and how it ""makes living harder".
I have not noticed that by myself, but I run my logs on separate database server and that makes things a bit different.
So this is just my guess.
--
Saku
OH1KH
HI Kenny!
Check also this:
https://stackoverflow.com/questions/32737478/how-should-i-tackle-secure-...
--
Saku
OH1KH
based on the website: https://stackoverflow.com/questions/32737478/how-should-i-tackle-secure-...
I added:
secure-file-priv = ""
to my mysql.conf file and now it runs!
Thanks and 73
Kenny
KB9TT