I am having trouble installing CQRLOG on my Raspberry Pi 4 Buster. When I go to add/remove software, CQRlog shows up, and when I try to install it, it says :loading caches" and then says downloading software for about a half second. Then...nuthin. sup with that?!
I have also tried dowloading cqrlog_2.3.0-1_armhf.deb directly from this site and after I download it, and try to install it, it loads caches and then says, "failed to download". Again, sup with that?!
EDIT: I just found this info about dependecies in the online help section. If you put this info in the download section, then everyone wouldn't have to first try to install the program and have it fail and then go do more research on the internet to figure out why the program doesn't install. Also, when you try to install the program from the add/remove software section of the pi and you right click on it to see the prerequisite programs, 186 programs should up that were required to be installed in order to get CQRLOG working. Obviously that is incorrect as well.
Dependencies:
HamLib - must be installed even if you don't want radio control. The sources are available at http://hamlib.sourceforge.net/, however precompiled packages are available for almost all major Linux distributions.
MySQL server and client - The MySQL client must be installed, without this the program will not work at all. A MySQL server must be reachable, either on the local machine or via a network.
libssl-devel needed if you want to use LoTW and/or online log upload
It's been over a week. I am struggling to get the mysql installed. When I search in the add/remove software in the pi 4, over 100 programs show up to install. Some are probably what I need, some are not.
PLEASE, can someone help with this. I have no idea how to do this. Like I said in the OG post, I can right click on CQRlog package in the add/remove software section of Raspbian and see all the required and dependent progrmas but I have no way to install them from that screen. It's 186 files. HOW the heck do I do this. I have combed this webiste help section and this process is still very unlcear? I have installed at least 15 ham related programs on the pi, and this is the only program that is not clear.
Hi !
I have seen this problem for long time ago. You can ask, but get reply very seldom.
That's why I'm trying to answer as much as I can. How ever certain areas like RPi (I have only ver 2 that is too slow), online logs and ubuntu specific questions are not well supported here.
On end of your 1st message you list dependencies that must be installed before cqrlog works. Sometimes those are called with different names in different Linuxes.
Also you can have Mysql or MariaDB as database engine.
That all is rather confusing.
That is why packet managers should do all this job and user just needs to tell packet manager that he needs one program like cqrlog. How ever it is unfortunately common that packets are old or broken and installing does not work automated.
You just have to Google right names for needed library packages used in your linux distribution and then install them manually one by one.
Installing Mysql/MariaDB server/client to RPi has many instruction pages, just use Google for help with words: install Mysql server client raspberry pi
You will find many pages like https://www.stewright.me/2016/04/install-mysql-server-raspberry-pi/ and even videos how to do it.
It is normal that program like cqrlog needs a library to install (like Mysql) and when you install that library it needs 100 other packages to install or update.
Just allow installer to do it. Do not expect that if you need library XXXX installer installs just that one package because that package may have other dependencies that must also be installed.
Did this give any help at all?
--
Saku
OH1KH
this is where im at now. i got cqrlog to install but i get an error at start up saying, my sql server could not be started, check installation. it seems to be installed. i installed it from add software in raspbian.
Here are the last 20 lines of code in the mysql.err file
Any clue what my next steps should be?
2019-11-10 12:54:00 0 [Note] InnoDB: Using Linux native AIO
2019-11-10 12:54:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-11-10 12:54:00 0 [Note] InnoDB: Uses event mutexes
2019-11-10 12:54:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-10 12:54:00 0 [Note] InnoDB: Number of pools: 1
2019-11-10 12:54:00 0 [Note] InnoDB: Using generic crc32 instructions
2019-11-10 12:54:00 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2019-11-10 12:54:00 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-10 12:54:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-11-10 12:54:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-10 12:54:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-10 12:54:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-10 12:54:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-11-10 12:54:00 0 [Note] InnoDB: 10.3.17 started; log sequence number 1603977; transaction id 9
2019-11-10 12:54:00 0 [Note] InnoDB: Loading buffer pool(s) from /home/pi/.config/cqrlog/database/ib_buffer_pool
2019-11-10 12:54:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-10 12:54:00 0 [Note] InnoDB: Buffer pool(s) load completed at 191110 12:54:00
2019-11-10 12:54:01 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-11-10 12:54:01 0 [Note] Server socket created on IP: '::'.
2019-11-10 12:54:01 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2019-11-10 12:54:01 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2019-11-10 12:54:01 0 [Note] Reading of all Master_info entries succeeded
2019-11-10 12:54:01 0 [Note] Added new Master_info '' to hash table
2019-11-10 12:54:01 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.17-MariaDB-0+deb10u1' socket: '/home/pi/.config/cqrlog/database/sock' port: 64000 Raspbian 10
this is where im at now. i got cqrlog to install but i get an error at start up saying, my sql server could not be started, check installation. it seems to be installed. i installed it from add software in raspbian.
Here are the last 20 lines of code in the mysql.err file
Any clue what my next steps should be?
2019-11-10 12:54:00 0 [Note] InnoDB: Using Linux native AIO
2019-11-10 12:54:00 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2019-11-10 12:54:00 0 [Note] InnoDB: Uses event mutexes
2019-11-10 12:54:00 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-11-10 12:54:00 0 [Note] InnoDB: Number of pools: 1
2019-11-10 12:54:00 0 [Note] InnoDB: Using generic crc32 instructions
2019-11-10 12:54:00 0 [Note] InnoDB: Initializing buffer pool, total size = 80M, instances = 1, chunk size = 80M
2019-11-10 12:54:00 0 [Note] InnoDB: Completed initialization of buffer pool
2019-11-10 12:54:00 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2019-11-10 12:54:00 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-11-10 12:54:00 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-11-10 12:54:00 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-11-10 12:54:00 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2019-11-10 12:54:00 0 [Note] InnoDB: 10.3.17 started; log sequence number 1603977; transaction id 9
2019-11-10 12:54:00 0 [Note] InnoDB: Loading buffer pool(s) from /home/pi/.config/cqrlog/database/ib_buffer_pool
2019-11-10 12:54:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-11-10 12:54:00 0 [Note] InnoDB: Buffer pool(s) load completed at 191110 12:54:00
2019-11-10 12:54:01 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2019-11-10 12:54:01 0 [Note] Server socket created on IP: '::'.
2019-11-10 12:54:01 0 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them
2019-11-10 12:54:01 6 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1017: Can't find file: './mysql/' (errno: 2 "No such file or directory")
2019-11-10 12:54:01 0 [Note] Reading of all Master_info entries succeeded
2019-11-10 12:54:01 0 [Note] Added new Master_info '' to hash table
2019-11-10 12:54:01 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.3.17-MariaDB-0+deb10u1' socket: '/home/pi/.config/cqrlog/database/sock' port: 64000 Raspbian 10
Do a clean install via the suggested SD formating program then NOOB.
Copy (cqrlog_2.3.0-1_armhf.deb) found on the download page to your PI
Click on the (cqrlog_2.3.0-1_armhf.deb ) file and it will self install.
Answer the questions with a YES.
I expect that will get CQRLOG running for you.
I recommend not turning on any automatic updates in the preferences at first.
At present I am working on creating an ADIF of my Libre Office Calc spreadsheet log.
Have you tried simply by installing >> sudo apt install cqrlog libmariadb3 libmariadb-dev mariadb-common mariadb-server << ?
Normally CQRlog is supported from within Ubuntu and should install everything you need.
Also, MySQL has been replaced by MariaDB for some time now.
See what happens.
Greetings, Bas. ON5HB