I loaded a drive with FreeBSD and got the cqrlog port and installed. it starts up just fine then throws the MySQL errors out. from mysql.err file :::
2025-05-14T23:23:45.6NZ mysqld_safe Logging to '/home/Chris/.config/cqrlog/database/mysql.err'.
2025-05-14T23:23:45.6NZ mysqld_safe Starting mysqld daemon with databases from /home/Chris/.config/cqrlog/database
2025-05-14T23:23:45.902103Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.41) starting as process 10667
2025-05-14T23:23:45.904120Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2025-05-14T23:23:45.904133Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-05-14T23:23:45.912184Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-05-14T23:23:45.912429Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-05-14T23:23:45.912472Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-05-14T23:23:45.912847Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.41) Source distribution.
2025-05-14T23:23:45.6NZ mysqld_safe mysqld from pid file /home/Chris/.config/cqrlog/database/bitch.pid ended
2025-05-14T23:24:35.6NZ mysqld_safe Logging to '/home/Chris/.config/cqrlog/database/mysql.err'.
2025-05-14T23:24:35.6NZ mysqld_safe Starting mysqld daemon with databases from /home/Chris/.config/cqrlog/database
2025-05-14T23:24:35.964556Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.41) starting as process 10990
2025-05-14T23:24:35.966086Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
2025-05-14T23:24:35.966105Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8mb3_bin' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2025-05-14T23:24:35.974194Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2025-05-14T23:24:35.974454Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-05-14T23:24:35.974503Z 0 [ERROR] [MY-010119] [Server] Aborting
2025-05-14T23:24:35.974867Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.41) Source distribution.
2025-05-14T23:24:35.6NZ mysqld_safe mysqld from pid file /home/Chris/.config/cqrlog/database/bitch.pid ended
from terminal when I run with debug :::
Chris@bitch:~ $ cqrlog --debug=1
Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****
OS:
FreeBSD 14.2-RELEASE amd64
SSL libraries:
libssl.so
libcrypto.so
Loaded 134350 LoTW users
Loaded 125829 eQSL users
Loaded 36919 SCP calls
*
User home directory: /home/Chris/
Program home directory: /home/Chris/.config/cqrlog/
Data directory: /home/Chris/.config/cqrlog/database/
Memebers directory: /home/Chris/.config/cqrlog/members/
ZIP code directory: /usr/local/share/cqrlog/zipcodes/
Binary dir:
Share dir: /usr/local/share/cqrlog/
*
56 us states loaded
Grid map created
mysqld
MySQLProcess.Executable: /usr/local/bin/mysqld_safe Parameters: --defaults-file=/home/Chris/.config/cqrlog/database/mysql.cnf
--datadir=/home/Chris/.config/cqrlog/database/
--socket=/home/Chris/.config/cqrlog/database/sock
--port=64000
Trying to connect to database
2025-05-14T23:33:47.6NZ mysqld_safe Logging to '/home/Chris/.config/cqrlog/database/mysql.err'.
2025-05-14T23:33:47.6NZ mysqld_safe Starting mysqld daemon with databases from /home/Chris/.config/cqrlog/database
2025-05-14T23:33:47.6NZ mysqld_safe mysqld from pid file /home/Chris/.config/cqrlog/database/bitch.pid ended
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
I thought if I ditch mysql and put in mariadb that would work.. but the installer insists on mysql. I had a standalone folder with cqrlog but it too throws the same error .
Thanks for any help !
Chris
Recent comments