I see where this is an issue with Ubuntu 16.4, however, it may be an issue also with Raspbian (debian) 'Jessie'.
(Note: I've had no problem running CQRLOG 2.0.1 (001) in Linux Mint 17.2.)
--
After installing CQRLOG 1.8.2 from the default repository on my raspberry pi 2B (Raspbian 'Jessie'), I started the program and got a 'Cannot connect to server' error when trying to create a new log. From reading the posts on this forum, I found out that the 'libmysqlclient-dev' package needed to be installed. I did that, and I still got the 'Cannot connect to server' error.
After deleting the ~/.configure/cqrlog folder, I unsuccessfully trying get past the new log creation, I decided that the problem was with the 'root password' in mysql. After removing the 'root password, I tried again and had the same result. I then decided to give 'pi' (default user) mysql administrator's rights. After doing that and removing the ~/.configure/cqrlog folder, I tried again and had the same result.
Below is what I got when starting cqrlog with debug in a root terminal session (note that I did 'x out' of cqrlog after the error):
root@raspberrypi:~# cqrlog --debug=1
**** DEBUG LEVEL 1 ****
Loading libssl:
Loading libcrypto:
Loading libmysqlclient:
**************************
MySQL version: 5.5
**************************
Ctyfiles dir: /usr/share/cqrlog/ctyfiles/
Local ctyfiles dir: /root/.config/cqrlog/ctyfiles/
Loaded 73758 LoTW users
Loaded 83806 eQSL users
Loaded 43229 SCP calls
*
User home directory: /root/
Program home directory: /root/.config/cqrlog/
Data directory: /root/.config/cqrlog/database/
Memebers directory: /usr/share/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.5
*
160814 21:49:22 [Note] /usr/sbin/mysqld (mysqld 5.5.50-0+deb8u1) starting as process 2471 ...
160814 21:49:22 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
160814 21:49:22 [ERROR] Aborting
160814 21:49:22 [Note] /usr/sbin/mysqld: Shutdown complete
Closing DXCluster window
Closing TRXControl window
Closing GrayLine window
Closing dDXCC
Closing dData
(cqrlog:2371): GLib-CRITICAL **: Source ID 11 was not found when attempting to remove it
(cqrlog:2371): GLib-CRITICAL **: Source ID 10 was not found when attempting to remove it
(cqrlog:2371): GLib-CRITICAL **: Source ID 43 was not found when attempting to remove it
(cqrlog:2371): GLib-CRITICAL **: Source ID 42 was not found when attempting to remove it
(cqrlog:2371): GLib-CRITICAL **: Source ID 48 was not found when attempting to remove it
(cqrlog:2371): GLib-CRITICAL **: Source ID 47 was not found when attempting to remove it
Closing ini file ...
root@raspberrypi:~#
(I am going to try to update from 1.8.2 to 2.0.1, if I can find an updated debian version.)
Bobby
de KN4I
https://www.cqrlog.com/download
Hope this helps!
73,
w6tux, I am not sure you can use regular debian packages for the raspbian OS. I know that there was an issue with the how the original raspberry pi did floating point processing that the debian-based packages did not take into account. I do not know if the newer RPis have the same issue, or not.
Sorry Bobby, I should have read more closely. (DOH!) Good luck with your project!
73, dave
Hi Bobby,
there is no need to run CQRLOG as root. MySQL won't run as root without any other parameters. Another problem is here:
Loading libssl:
Loading libcrypto:
Loading libmysqlclient:
It seems CQRLOG didn't find the libraries. Did you install also mysql client libraries? Nort devel versions only. Install also libssl-devel package.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr, it appears that the four packages that you pointed out in your reply are not in the Raspbian repository. Oh well....
At this point, I will not use my Raspberry Pi for logging. I will periodically check to see if the packages end up in the repository. If so, I will try again.
--
Thank you for developing CQRLOG. I have used it on my laptop to track DX, but have yet to make an entry. (I think that I have a transformer on my Softrock Ensemble RXTX that has reverse polarity on one of its secondary windings, which is not allowing me to transmit. I need to dig into this a little more.)