CQRLOG Error on Raspberry Pi 2

4 posts / 0 new
Last post
kb1vyi
CQRLOG Error on Raspberry Pi 2

This is perhaps one of the best linux software out there for any ham radio user. I have been successfully using it in my shack for the last 3 years in Ubuntu.

I have been exploring the use of a portable system using a raspberry pi 2. I attempted to use Laci's download of 1.9.0 and everything seems to have installed correctly with all of it's dependencies

However, on startup of the program i get an error relating to mysql server. At least I am pretty sure of it, I've spent a good amount of time trying to source the error. My final conclusion that I may need to try next is a slightly older version of mysql.

Upon startup of the software this what the terminal spits out.

IniFile:/home/pi/.config/cqrlog/cqrlog.cfg
LocalIniFile:/home/pi/.config/cqrlog/local.cfg
160215 16:55:35 [Note] /usr/sbin/mysqld (mysqld 5.5.44-0+deb8u1) starting as process 1650 ...
TApplication.HandleException : Error executing query: Table 'cqrlog_common.log_list' doesn't exist
Stack trace:
$004CA9F4
$0051B368
$0051CA64
$0050C210
$004CD588
$0050F1F0
$0017CDEC
$0033AEB0
$0036DAC0
$0036E450
$0017E544
$004016B8
$003F15D8
$767ECE30

At this point I can't do much of anything with the software. If anyone else has a solution to this problem or has some insight it would be very helpful.

Thanks,
Tyler
KB1VYI

ok2cqr
ok2cqr's picture
Re: CQRLOG Error on Raspberry Pi 2

Hi Tyler,

please look to /home/pi/.config/ if there is cqrlog directory. If yes, please rename or delete it. It seems cqrlog found some data but it's broken because it doesn't find database with common data like log list.

73 Petr, OK2CQR

kb1vyi
Re: CQRLOG Error on Raspberry Pi 2

Petr,

Thank you for your assistance,

I continued in the meantime to uninstall everything, reimage my pi, and make sure that mysql was installed and still managed to get to the same place with similar errors. However, to anyone who reads this, do not install the supplied CQR log with gdebi but rather install mysql first using apt-get, then install cqrlog along with any missing dependencies. If you use gdebi then you will install an alternative to mysql which doesn't seem to work. Deleting that CQR log directory did help me get further but when I go to make a new log I continue to get errors. I have not looked to deep into it but I will continue through the night. Here is what the CMD spits out when there is an error.

pi@raspberrypi:~ $ cqrlog

**** DEBUG LEVEL 0 ****
**** CHANGE WITH --debug=1 PARAMETER ****

IniFile:/home/pi/.config/cqrlog/cqrlog.cfg
LocalIniFile:/home/pi/.config/cqrlog/local.cfg
160215 21:33:35 [Note] /usr/sbin/mysqld (mysqld 5.5.44-0+deb8u1) starting as process 9196 ...
TApplication.HandleException : Error executing query: Table 'cqrlog_main' already exists
Stack trace:
$004CA9F4
$0051B368
$0051CA64
$0050C210
$000EEBF8
$0017D38C
$0033AEB0
$0036DAC0
$0036E450
$0036D988
$000441F8
$00329304
$0042B510
$0043C230
$7687CAFC

(cqrlog:9190): GLib-CRITICAL **: Source ID 12 was not found when attempting to remove it

(cqrlog:9190): GLib-CRITICAL **: Source ID 11 was not found when attempting to remove it

(cqrlog:9190): GLib-CRITICAL **: Source ID 44 was not found when attempting to remove it

(cqrlog:9190): GLib-CRITICAL **: Source ID 43 was not found when attempting to remove it

(cqrlog:9190): GLib-CRITICAL **: Source ID 49 was not found when attempting to remove it

(cqrlog:9190): GLib-CRITICAL **: Source ID 48 was not found when attempting to remove it
WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
Invalid file handle
Closing ini file ...

ok2cqr
ok2cqr's picture
Re: CQRLOG Error on Raspberry Pi 2

It seems CQRLOG is trying to create the database again. I have no idea why, what is different on Raspberry Pi 2. I don't have any RaspBerry at home to try and debug where is the problem, I'm sorry.