Hello to all.
I'm using Open Suse Tumbleweed (fresh install)
I have installed CQRLOG from repos (last version), when i try to connect to database (i have my database in a server in my LAN...) i always obtain the same error:
Error during connection to database: TMySQL57Connection : Server connect failed.
If i try to start the program with a local database, it works fine, create the new database and starts the program normal.
I leave here some debug info:
abraham@localhost:/usr/bin> ./cqrlog --debug=1
Cqrlog Ver:2.5.2 (001) Date:2021-02-12
**** DEBUG LEVEL 1 ****
OS:
Linux version 6.16.0-1-default (geeko@buildhost) (gcc (SUSE Linux) 15.1.1 20250801, GNU ld (GNU Binutils; openSUSE Tumbleweed) 2.43.1.20241209-10) #1 SMP PREEMPT_DYNAMIC Thu Aug 7 07:54:52 UTC 2025 (49fcd7f)
SSL libraries:
libssl.so
libcrypto.so
Ctyfiles dir: /usr/share/cqrlog/ctyfiles/
Local ctyfiles dir: /home/abraham/.config/cqrlog/ctyfiles/
Loaded 134350 LoTW users
Loaded 125829 eQSL users
Loaded 36919 SCP calls
*
User home directory: /home/abraham/
Program home directory: /home/abraham/.config/cqrlog/
Data directory: /home/abraham/.config/cqrlog/database/
Memebers directory: /home/abraham/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
*
56 us states loaded
Grid map created
No more info appears when i try to connect to my Mariadb LAN server, just the window with the error.
Here is Mariadb version in the Opensuse Tumbleweed PC:
mariadb from 11.8.2-MariaDB, client 15.2 for Linux (x86_64) using EditLine wrapper
I'm using another PC with Kubuntu 22.04 and the CQRLOG works fine and connect with my Mariadb server in my LAN.
73 de EA5FHT,
Abraham.
Hi Abraham!
You say you have your log database on LAN MariaDB server. That is same kind of setup I have here.
First of all "Save data to local machine" must be UNchecked.
After that enter the IP addess or DNS name to "Server name" with proper "Port", usually 3306.
"User name" and "password" should be filled also with values you have created to your LAN server.
Check "Remember me" and "Auto connect" and press button "Connect" (as first time) to get connected.
For user name and password in LAN server you must do following in mysql console with LAN server admin accout:
CREATE USER IF NOT EXISTS 'cqrlog'@'localhost' IDENTIFIED BY 'cqrlog';
GRANT ALL PRIVILEGES ON *.* TO 'cqrlog'@'localhost';
FLUSH PRIVILEGES;
QUIT;
You can also alter GRANT to give all privileges just for cqr%.* instead of *.* to get little more security (all cqrlog databases begin with "cqrlog").
You must change "localhost" to your Cqrlog-PC's LAN address (if you have your LAN MariaDB server and Cqrlog program running in same PC you can use "localhost" in commands then)
Of course you can use different username and password than "cqrlog"
Once you have created user and password to LAN server try to connect mysql from your Cqrlog-PC console:
mysql -hYour_LAN_SERVER_IP -uYour_username -pYour_password
like:
mysql -h192.168.60.4 -ucqrlog -pmy_passwd
If you can connect from command terminal then you can connect from cqrlog program too with same values.
--
Saku
OH1KH