New install (1.8.2) on RPi 2B - Cannot connect to server (mySQL)

6 posts / 0 new
Last post
KN4I
New install (1.8.2) on RPi 2B - Cannot connect to server (mySQL)

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

w6tux
Debian package pretty easy to find

https://www.cqrlog.com/download

Hope this helps!

73,

KN4I
New install (1.8.2) on RPi 2B - Cannot connect to server (mySQL)

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.

w6tux
Apologies

Sorry Bobby, I should have read more closely. (DOH!) Good luck with your project!

73, dave

ok2cqr
ok2cqr's picture
Re: New install (1.8.2) on RPi 2B - Cannot connect to server (my

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

KN4I
New install (1.8.2) on RPi 2B - Cannot connect to server (mySQL)

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.)