Just built a new PC with Minit 17.1. As my prevous version of CQRLog used MySQL I installed MySql 5.6. Then I installed CQRLog V. 1.8.3. That Installed MariaDB. I was able to run and import my log into CQRLog OK. As I use MySQL databases in other projects I imported my MySQL database to MySQL using MySQL Workbench. Now when I start CQRLog I get the error "Access violation, Press OK and risk data corruption or press Cancel to kill program". Pressing either option kills the program. Not too worried about the log as I still have a backup.
I suspect this is a conflict between MariaDB and MySQL. How do I fix this? I'd like to have the features of 1.8.3 but have it run in MySQL.
Regards,
Marty
Thu, 2015-02-19 21:32
#1
CQRLog error "Access Violation"
Tried to run CQRLog on a second PC with an existing installation. This does not run either. Got "Error cannot conect to database server failure". Then "Appears you are using Apparmor". Add line @{Home}/.config/cqrlog/database/**rwk, into etc/apparmor.d/usr.sbin.mysqdd. Or run /user/share/cqrlog/cqrtest-apparmor-fix. Did the later no change. Looked at the file /etc/apparmor.d/usr.bin.mysqdd it is empty and tels me that it is disabled by default.
I say again that this was a running instance of CQRLog. Some thing has changed. Perhaps an update to MariaDB.
Now the PC mention in the issue above works. Did nothing but reboot the PC this morning. Strange that it's happening on two seperate PC's. I'll try to restart the second PC later this morning.
Marty
Marty, N3MOW
Hi Marty,
I already solved similar problem on my father's computer with old Ubuntu 10.04. Something happened and file usr.sbin.mysqld was empty. I had to use file from my computer to fix it.
Here is the content of the file:
# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>
/usr/sbin/mysqld {
#include <abstractions/base>
#include <abstractions/nameservice>
#include <abstractions/user-tmp>
#include <abstractions/mysql>
#include <abstractions/winbind>
capability dac_override,
capability sys_resource,
capability setgid,
capability setuid,
network tcp,
/etc/hosts.allow r,
/etc/hosts.deny r,
/etc/mysql/*.pem r,
/etc/mysql/conf.d/ r,
/etc/mysql/conf.d/* r,
/etc/mysql/*.cnf r,
/usr/lib/mysql/plugin/ r,
/usr/lib/mysql/plugin/*.so* mr,
/usr/sbin/mysqld mr,
/usr/share/mysql/** r,
/var/log/mysql.log rw,
/var/log/mysql.err rw,
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
/var/log/mysql/ r,
/var/log/mysql/* rw,
/var/run/mysqld/mysqld.pid rw,
/var/run/mysqld/mysqld.sock w,
/run/mysqld/mysqld.pid rw,
/run/mysqld/mysqld.sock w,
/sys/devices/system/cpu/ r,
# Site-specific additions and overrides. See local/README for details.
#include <local/usr.sbin.mysqld>
@{HOME}/.config/cqrlog/database/** rwk,
}
Save it to /etc/apparmor.d/usr.sbin.mysqld and use cqrlog-apparmor-fix script.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr,
The fix worked. From the comments in the origial file (Below) I think this may occur each time MariaDB updates.
# This file is intensionally empty to disable apparmor by default for newer# versions of MariaDB, while providing seamless upgrade from older versions# and from mysql, where apparmor is used.## By default, we do not want to have any apparmor profile for the MariaDB# server. It does not provide much useful functionality/security, and causes# several problems for users who often are not even aware that apparmor# exists and runs on their system.## Users can modify and maintain their own profile, and in this case it will# be used.## When upgrading from previous version, users who modified the profile# will be promptet to keep or discard it, while for default installs# we will automatically disable the profile.
Still not sure why I had trouble with the new install on Mint 17.1. That PC has both MySQL and MariaDB and Workbench running. It still appears to be working. Will be setting up rig contron next.
Again Thanks for your help.
Marty, N3MOW
Marty, N3MOW
I have same failure, and I can't fix it.. I do not know how to do... Working Linux Mint17 Qiana.. Mint woud not let me edit the file or insert the lines Petr has writtn for his father...
I know how to start my pc.. and push button to start CQR log... and thats is it... ( tryed with Gnome Commander to edit the file / copy the file... but got the message Cant save or rename,, so I have a logprogram witch is not working and I hacve not hne mood for trying a new logprogram.
Sorry for my spelling
OZ1HYI Willy
Hi Willy,
send me an email to petr@ok2cqr.com and I will sned you the file you can copy to it's location. You have to do it as root user (using sudo command).
73 Petr, OK2CQR
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Willy,
The reason you cannot edit the file is that you must do it as root. If you are totaly new to Linux, get a good book on it before you edit files as root. Also you should do it from the terminal window. Maybe there is a Linux guru in your area who can help you get started.
Regards,
Marty
Marty, N3MOW
Hi everybody!
I have got the "access violation" error. Up to this evening cqrlog was working properly. But now after "creating filter" always i read the error message.
I created new database, but some problem. I do not have ideas what is happaning now in my system.
(it were not any update or similar thing....)
Could somebody help me?
The debug output:
It takes about 0 minutes and 15 seconds 484 miliseconds
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
WARNING: TGtk2WidgetSet.InvalidateRect refused invalidating during paint message: TDBGrid
TApplication.HandleException Access violation
Stack trace:
$000000000042622A
$0000000000523027
$000000000044AE19
$0000000000449F0A
$000000000042E6D1
$000000000074A551
$000000000044C0A8
$000000000075821D
$000000000074791A
$0000000000747840
$00000000004501C0
$0000000000745E68
$0000000000764BEA
$0000000000760F38
$0000000000449A72
$000000000044EAD2
$0000000000450763
WARNING: TLCLComponent.Destroy with LCLRefCount>0. Hint: Maybe the component is processing an event?
TApplication.HandleException: there was another exception during showing the first exception
Stack trace:
$000000000314E0E8
$00000000005CD2AF
$000000000080903E
$00000000005CCF4B
$000000000077201A
$0000000000772939
$000000000042E6D1
$00000000007E3599
$00000000008A84C5
Closing ini file ...
(cqrlog:19161): GLib-CRITICAL **: Source ID 16 was not found when attempting to remove it
(cqrlog:19161): GLib-CRITICAL **: Source ID 15 was not found when attempting to remove it
(cqrlog:19161): GLib-CRITICAL **: Source ID 48 was not found when attempting to remove it
(cqrlog:19161): GLib-CRITICAL **: Source ID 47 was not found when attempting to remove it
(cqrlog:19161): GLib-CRITICAL **: Source ID 53 was not found when attempting to remove it
(cqrlog:19161): GLib-CRITICAL **: Source ID 52 was not found when attempting to remove it
[TGtk2WidgetSet.Destroy] WARNING: There are 1 TimerInfo structures left, I'll free them
Hi!
Today, i think program updated DXCC database or something.. soon after that i got the access violation and now no start.
debug gives me this? cqrlog --debug=1**** DEBUG LEVEL 1 ****Loading libssl: /usr/lib/x86_64-linux-gnu/libssl.soLoading libcrypto: /usr/lib/x86_64-linux-gnu/libcrypto.soLoading libmysqlclient: /usr/lib/x86_64-linux-gnu/libmysqlclient.so.20.3.3**************************MySQL version: 5.7************************************************************MySQL version assigned: 5.7**********************************[FORMS.PP] ExceptionOccurred Sender=EAccessViolation Exception=Access violation Stack trace: $0000000000428E65 $000000000045B965 TApplication.HandleException Access violation Stack trace: $0000000000428E65 $000000000045B965 Closing ini file ...
Thanks to OH1KH for this. Delete /home/your_username/.config/cqrlog/lotw1.txt and start again
WORKS!
Had the same issue tonight. Removed the lotw1.txt and it starts again.
Running 2.0.1 I just saw this issue is fixed in the newest version. I guess it's time to update.
Marc
I've the same problem directly after the automatically update of the DXCC database.
Fortunately I've a backup available. After reinstallation all works properly again.
Must be Friday the 13th! I had an access violation pop up while running WSJT-X in remote mode and when I went to restart cqrlog if was given an immediate access violation error. The usr.sbin.mysqld was indeed empty, and I copied in the file details from Petr as listed earlier in the thread. That failed to fix it, but I then found and deleted the lotw1.txt file and I was back in business. So OH1KH has earned his beer!
73,
Pierre VE3KTB
Pierre Fogal
VE3KTB/KC0IGY
on Arch Linux