Hi there,
I m a newbie in linux and therefor also in CQRLOG.
I installed it an run it for the first time.
the error message tells me .... "" is an invalid integer.
this is the debug log
Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****
SSL libraries:
/usr/lib64/libssl.so.1.0.0
/usr/lib64/libcrypto.so.1.0.0
Loading libmysqlclient: /usr/lib64/libmysqlclient.so
**************************
MySQL version: 10.
**************************
**********************************
MySQL version assigned: 5.6
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/dg0ers/
Program home directory: /home/dg0ers/.config/cqrlog/
Data directory: /home/dg0ers/.config/cqrlog/database/
Memebers directory: /home/dg0ers/.config/cqrlog/members/
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
/usr/sbin/mysqld --defaults-file=/home/dg0ers/.config/cqrlog/database/mysql.cnf --datadir=/home/dg0ers/.config/cqrlog/database/ --socket=/home/dg0ers/.config/cqrlog/database/sock --port=64000
2019-09-01 17:20:38 0 [Note] /usr/sbin/mysqld (mysqld 10.4.7-MariaDB) starting as process 2400 ...
select * from tables where table_schema = 'cqrlog_common'
SELECT log_nr,log_name FROM cqrlog_common.log_list order by log_nr
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
use cqrlog001
SELECT * FROM cqrlog_config
select * from db_version
[UpgradeMainDatabase] Old version: 15 cDB_MAIN_VER: 15
select * from cqrlog_common.db_version
SELECT * FROM cqrlog_common.dxcc_ref ORDER BY ADIF
TApplication.HandleException "" is an invalid integer
Stack trace:
$000000000047033C
$000000000053654A
$00000000006CA63A
$00000000006CAE83
$00000000006CA526
$0000000000431FAF
$0000000000658D8D
$000000000082DB32
$000000000083FB91
anyone an idea and little help for me??
tnx de Enrico
Hi Enrico!
It looks like your DXCC information is not valid.
If you have not used cqrlog before delete hidden folder ~/.config/cqrlog
WARNING! this folder has your logs, so be sure you have not used cqrlog before. I.E. no qsos in log.
Then uninstall and install (reinstall) cqrlog again and start it and see does it work now.
--
Saku
OH1KH
I have delete the folder ~/.config/cqrlog and then uninstall and install cqrlog again. them will create cqrlog a logfile and i get this error message (pic1)
File:
73 de Enrico
first start
File:
73 de Enrico
error message "" is an invalid integer.
File:
73 de Enrico
Hi Enrico !
Can you open command console and give this comand:
ls -l /usr/lib64/libmysqlclient.so
And copy result to next message.
With Mariadb that command should give something like:
/usr/lib64/libmysqlclient.so -> libmariadb.so.3
I just wonder could you have MariaDB and Mysql (or mysqlclient) installed together?
Dump says "(mysqld 10.4.7-MariaDB) starting " and "MySQL version assigned: 5.6". I think it should say 5.7 there.
In your picture 20190907161109.png there is a database creation error and that is the reason log001 does not open, I think.
--
Saku
OH1KH
Hi Saku,
mny tnx for answer. mariasql is running. I thin also the problem is not cqrlog, i meen its a problem with the config of mariadb
"Can you open command console and give this comand:
ls -l /usr/lib64/libmysqlclient.so
And copy result to next message."
[dg0ers@dg0ers ~]$ ls -l /usr/lib64/libmysqlclient.so
lrwxrwxrwx 1 root root 15 31. Jul 07:50 /usr/lib64/libmysqlclient.so -> libmariadb.so.3
and this is the status message of mariadb
mysql Ver 15.1 Distrib 10.4.7-MariaDB, for Linux (x86_64) using readline 5.1
Connection id: 28
Current database:
Current user: dg0ers@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server: MariaDB
Server version: 10.4.7-MariaDB Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8
Conn. characterset: utf8
UNIX socket: /run/mysqld/mysqld.sock
Uptime: 3 hours 25 min 40 sec
Threads: 7 Questions: 106 Slow queries: 0 Opens: 16 Flush tables: 1 Open tables: 10 Queries per second avg: 0.008
--------------
73 de Enrico
Hi !
Looks like it is same problem as in this thread: https://www.cqrlog.com/node/2272
Some kind of solution can be found from this thread https://www.cqrlog.com/node/2269
As you do not have any qsos in log you can delete ~/.config/cqrlog before trying again with suggestions from that thread.
You have to delete folder as long as you are getting 20190907161109.png like error in first start of cqrlog to be sure that log001 is properly created.
After first start goes ok you can also open log001.
--
Saku
OH1KH
ok, thanks, I'll look at the two threads and test the function. I will get back to you later
73 de Enrico