Hi!
Played a little bit with NanoPi-Neo I just got from ebay.
NanoPi is a raspberryPi like small computer http://wiki.friendlyarm.com/wiki/index.php/NanoPi_NEO#Introduction
After loading image from wiki.friendlyarm.com (Ubuntu variant) and made apt-get update and apt-get upgrade it was time to try cqrlog (raspberry version).
How ever NanoPi does not have display connection. Vnc server must be installed. In that way it is able to run graphical display on another pc's vnc client. I accessed vncserver via ssh tunnel (sshd config -> allow Xforwarding at NanoPi side)
When vnc was working I did try to install rasberry .deb package. It was telling me about required packages and I did install them manually one by one.
How ever I did not find libmariadbclient-dev-compat and that's why I was not able to install cqrlog from .deb package either.
I downloaded the tar version of rasperry-cqrlog and copied that to NanoPI (in fact I feel that more comfortable than installing package(as blind) as I know what is happening)
Below connection to NanoPi is done with ssh that forwards port 5965 from NanoPi to localhost:5964 of vnc client computer. So vnc client is started with connect to localhost:64
[saku@tupu ~]$ ssh -L 5964:localhost:5964 192.168.60.5
_____ _ _ _ _____ _ _____ ____
| ___| __(_) ___ _ __ __| | |_ _| ____| | | ____/ ___|
| |_ | '__| |/ _ \ '_ \ / _` | | | | | _| | | | _|| |
| _|| | | | __/ | | | (_| | | |_| | |___| |___| |__| |___
|_| |_| |_|\___|_| |_|\__,_|_|\__, |_____|_____|_____\____|
|___/
Welcome to Ubuntu 16.04.5 LTS 4.14.52
System load: 19.12 Up time: 1 hour Local users: 2
Memory usage: 44 % of 491Mb Swap usage: 26 % of 511Mb IP: 192.168.60.5
CPU temp: 43°C
Usage of /: 23% of 15G
* Documentation: http://wiki.friendlyarm.com/Ubuntu
* Forum: http://www.friendlyarm.com/Forum/
Last login: Fri Aug 31 07:30:06 2018 from 192.168.60.228
saku@NanoPi-Neo:~$
Cqrlog started normally until that point where it asks to store logs locally. Starting mariadb causes cqrlog crash. And finally it crashes whole NanoPi.
After trying few times I decided to try my cqrlog database on my network server.
I opened a console at NanoPi's desktop and took connection to my server with ssh and port forward. This time I was frowarding servers sql port 3306 to NanoPi's localhost 33060. I could not use 3306 at NanoPi as it's own mariadb was running at that port.
saku@NanoPi-Neo:~$ ssh -L 33060:localhost:3306 192.168.60.1
That way cqrlog was working ok !! (see image)
Next test is to make cqrlog database to NanoPi's mariadb server, not using cqrlog's way to start a new protected database thread, but making a database to existing server running on port 3306 of NanoPI.
It might work that way if it works with network servers database without problems.
I'll let you know...
Here is the image that I could not include when starting a new thread.
Why there was no button for include file??
Now when "answering" to myself I have add file button !!!
File:
--
Saku
OH1KH
I removed ~/.config/cqrlog and started testing as new cqrlog user.
There seems to be some kind of memory problem as if I start Xvnc4 server with command lxsession (that gives desktop properties, start menus etc.) then cqrlog will always stop:
SSL libraries:
Loading libmysqlclient:
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Ctyfiles dir: /usr/share/cqrlog/ctyfiles/
Local ctyfiles dir: /home/saku/.config/cqrlog/ctyfiles/
Loaded 118377 LoTW users
Killed
When there is no lxsession running (vnc desktop is grey and mouse right click gives simple start menu) cqrlog will start, but at 1st time it will also then stop at same place, but at second start goes further:
cqrlog -debug=1
Cqrlog Ver:2.3.0 (001) Date:2018-06-17
**** DEBUG LEVEL 1 ****
SSL libraries:
Loading libmysqlclient:
**************************
MySQL version: 5.7
**************************
**********************************
MySQL version assigned: 5.7
**********************************
Loaded 118377 LoTW users
Loaded 115544 eQSL users
Loaded 40133 SCP calls
*
User home directory: /home/saku/
Program home directory: /home/saku/.config/cqrlog/
Data directory: /home/saku/.config/cqrlog/database/
Memebers directory: /home/saku/.config/cqrlog/members/
ZIP code directory: /usr/share/cqrlog/zipcodes/
Binary dir: /usr/bin/
Share dir: /usr/share/cqrlog/
TConnection to MySQL: 5.7
*
56 us states loaded
WARNING: obsolete call to RecreateWnd for TfrmDBConnect
Warning: TWinControl.DestroyHandle frmDBConnect:TfrmDBConnect Handle not Allocated
At that point it asks that "you have never used cqrlog before would you like to save logs on local computer".
You should answer NO. Mysql_safe will not run properly (small memory ?).
Instead open console and give:
sudo mysql
If your mysql-server is properly installed and running you should get prompt:
saku@NanoPi-Neo:~$ sudo mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 38
Server version: 10.0.36-MariaDB-0ubuntu0.16.04.1 Ubuntu 16.04
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]>
Then write line:
GRANT ALL PRIVILEGES ON *.* TO 'cqrlog'@'%' IDENTIFIED BY 'cqrlog';
You will get response like:
Query OK, 0 rows affected (0.04 sec)
Then type:
quit
Go back to cqrlog "Database connection" window. Keep address 127.0.0.1 but change port from 64000 to 3306.
username is cqrlog and password is cqrlog.
uncheck (if checked, it shouldn't be at that stage) "Save log data to local machine"
Press connect-button. Button stays pressed.
At that point, if you started cqrlog with debug=1 you should see how cqrlog starts to build databases.
It will take 5 to 10minutes for NanoPi and finally cqrlog001 appear to list and you can open and use it.
When cqrlog asks to load new dxcc and qslmgr do not do it. Those are larger than default files and at that point it is unknown why memory (swap too small?) gets full and cqrlog will be killed.
This must be fixed next.
--
Saku
OH1KH
Adding swap file size from 512MB to 1GB does not fix memory overflow caused by LoTW calls.
--
Saku
OH1KH