Mint Cinnamon 18.3
CQLog installed via Software Manager.
Error Messages follow:
Error Messages When Running CQRLOG First Time
----------------------------------------------------------------------------------------------
It looks like apparmor is running in your system. CQRLOG needs to add this :
@{HOME}/.config/cqrlog/database/** rwk,
into /etc/apparmor.d/usr.sbin.mysqld
You can do that by running /usr/share/cqrlog/cqrtest-apparmor-fix or you can add the line and restart apparmor manually.
Click OK to continue (program may not work correctly) or Cancel and modify the file first.
---------------------------------
On running /usr/share/cqrlog/cqrtest-apparmor-fix
ed@linux-desktop ~ $ /usr/share/cqrlog/cqrtest-apparmor-fix
bash: /usr/share/cqrlog/cqrtest-apparmor-fix: No such file or directory
ed@linux-desktop ~ $
------------------------------------
Error:
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
-----------------------------------
Error
MySQL could not be started, please check if the MySQL server is installed properly
------------------------------------
Error Messages After Adding the line and restarting sql
----------------------------------
Error
Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation.
----------------------------------------------------------
Error
MySQL could not be started, please check if the MySQL server is installed properly
-----------------------------------------------------------
Note: Mysql-Server and Mysql-Client were installed prior attempt to install CQRLog.
Any help here? I must be doing something wrong... I am a newbie, just installed Linux Mint a week ago, determined not to return to Windows.
Ed
Hi
As it says:
On running /usr/share/cqrlog/cqrtest-apparmor-fix
ed@linux-desktop ~ $ /usr/share/cqrlog/cqrtest-apparmor-fixn
bash: /usr/share/cqrlog/cqrtest-apparmor-fix: No such file or directory
ed@linux-desktop ~ $
Check that there really is that fix file. Either with your favorite file browser or from console with command
ls /usr/share/cqrlog/
If file is there try to run it using sudo from console.
sudo /usr/share/cqrlog/cqrtest-apparmor-fix
If it is not there copy it from https://github.com/ok2cqr/cqrlog/blob/master/tools/cqrlog-apparmor-fix
Check running permissions with console. command
chmod 777 cqrtest-apparmor-fix
And then run it with sudo.
Properly run apparmor-fix should give running cqrlog.
--
Saku
OH1KH
--
Saku
OH1KH
Hi Ed,
what version of CQRLOG are you using?
As far as I know, Mint doesn't have AppArmor installed, you can ignore the information about the script. I think I've removed the message from cqrlog some time ago so you are probably using old version of CQRLOG. Please add my ppa to your system and update it.
sudo add-apt-repository ppa:ok2cqr/ppa;sudo apt-get update;sudo apt-get install cqrlog
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr,
I just set up ubuntu 17.10, then download CQRlog from their software store. It came up with the error "could not load default mysql library - libmysqlclient.so.16 , libmysqlclient.so".
I just ran your repository script , but still get the same error. CQRlog version is 2.2.0-1~artful. error log hopefully attached.
73 Mike
File:
Mike Daeges
Mike,
do you have any data in cqrlog? If not, you can delete cqrlog directory in ~/.config/. After new cqrlog start, it will create the directory again with correct MySQL config file.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Petr,
After doing a clean install of Mint Cinnamon 18.3 I did as you said and added your repo, ppa, updated and installed cqrlog. When I started cqlog an error msg came up: "MySQL could not be started, please check if the MySQL server is installed correctly." I didn't find the answer in the faq so I am attaching the last 20 lines from the mysql.err file as requested.
Since we were responding via email I didn't think to check this forum... my apology to all who responded here, not receiving a reply from me. I had expected to be notified when new replies were made... I'll check here in future. Please hang in here with me... I'm new to Linux but am staying with it.
73,
Ed - ad7gr
File:
73,
Ed - AD7GR
Additional info: When I attempted to closed cqrlog this error message came up -
"Error during connection to database: Can not load default MySQL library ("libmysqlclient.so.16" or "libmysqlclient.so"). Check your installation."
Ed
73,
Ed - AD7GR
Please try to install libmariadbclient-dev package. It could help.
73 Petr
--
http://HamQTH.com/ok2cqr
https://ok2cqr.com
Sorry to be so dense... I am a Linux newbie. libmariadbclient-dev is not found in Synaptic or Program Manager. How do I install it?
73,
Ed
73,
Ed - AD7GR
Petr,
Thank you very much for all your attempts to help me. It all came out okay in the end, it's running, and you've a great log. Now I need to learn how to make good use of it.
73,
Ed - AD7GR
Thanks Petr,
I too am a linux noob. I figured out how to remove the cqrlog directory but that by itself didn't solve the problem.
but when I deleted it and installed the libmariadbclient-dev, it came up and ran with no problems.
(ad7gr - Ed - I did a search for libmariadbclient-dev in synaptic and was able to install it from there.)
73 Mike ki7luh
Mike Daeges
Mike,
In Synaptic when I search for libmariadbclient-dev I only find libmariadb-client-lgpl-dev and it is installed.
I'm glad it working for you but it sure is not for me. I have installed Mint Cinnamon 18.3 three times already to have a fresh start and have been working with this issue for days and it's not getting any better.
Very discouraging.
73,
Ed - ad7gr
73,
Ed - AD7GR
Ed,
Your almost there, it only took me five days. In Synaptic it was listed as - libmariadbclient-dev 10.1.25-1 . I'm running ubuntu 17.10 now but started five days ago with 16.04.
synaptic might hide files your os doesn't like ( just a guess, i really don't know). You might get some help from Mariadb website.
good luck
73 Mike
Mike Daeges
Mike,
Shoot... I'm still fumbling around in this forum... maybe I'll get it figured out where to click [Reply]
I am wondering if Mint 18.3 is somehow messing me up. I don't have libmariadbclient-dev listed in Synaptic or Program Manager... nor do I have hamlibs and I don't know how to get them. It's been years since I worked any Linux and it was so bad an experience that I gave it up then. Now I don't have a choice... this computer has only Mint 18 on it. Mariadb website... I'll check on that in the morning... been working with this mess since 5:00 this morning and I'm shot.
73, Ed
73,
Ed - AD7GR
Ed,
Hang in there, it will come together. Ham Radio is my new hobby, I gave myself a goal of WAS on CW in twenty years, so not being in any hurry, I'm just enjoying the journey.
73 Mike
Mike Daeges
Mike,
Oh, I 'm hanging in here... will keep nibbling until there's a breakthrough of some sort. I like what I have seen of CQRLog on the Internet and want it for my general logger. I still need RI and NH for my SKCC WAS... that's CW straight key WAS. I can highly recommend the SKCC (http://www.skccgroup.com/)... great bunch of friendly folks for the most part and willing to QRS for those of us that need it.
Hey... I'm not sure where Amity, OR is but I'm in the NE part of the state near Baker City.
Best call it for the night...
73,
Ed - ad7gr
73,
Ed - AD7GR
Found the way but it failed...
sudo apt-get update
sudo apt-get install libmariadbclient-dev
ed@ed-den ~ $ sudo apt-get install libmariadbclient-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
E: Unable to locate package libmariadbclient-dev
ed@ed-den ~ $
I'm not making much headway here...
Ed
73,
Ed - AD7GR
Additional info... when I ran ls /usr/share/cqrlog it returned cqrlog-apparmor-fix ... not cqrlogtest-apparmor-fix as per your post. The fix was attempted to the override file but it had already been modified.
73,
Ed
73,
Ed - AD7GR
Debugging Results Attached...
File:
73,
Ed - AD7GR
HI!
Seems that libmysqlclient is lost.
Try this console command:
dpkg -S libmysqlclient
In my "small server" (Lubuntu) it gives:
aku@servo2:~$ dpkg -S libmysqlclient
libmysqlclient20:i386: /usr/share/doc/libmysqlclient20/NEWS.Debian.gz
libmysqlclient20:i386: /usr/share/doc/libmysqlclient20/copyright
libmysqlclient20:i386: /usr/share/doc/libmysqlclient20/changelog.Debian.gz
libmysqlclient20:i386: /usr/lib/i386-linux-gnu/libmysqlclient.so.20.3.7
libmysqlclient20:i386: /usr/lib/i386-linux-gnu/libmysqlclient.so.20
libmysqlclient20:i386: /usr/share/doc/libmysqlclient20
saku@servo2:~$ l
You will have something other in path than /usr/lib/i386-linux-gnu/
With using your path try to make symlink:
sudo ln -s /usr/lib/i386-linux-gnu/libmysqlclient.so.20 /usr/lib/i386-linux-gnu/libmysqlclient.so
then check:
ls -l /usr/lib/i386-linux-gnu/libmysqlclient.s*
should give something like:
saku@servo2:~$ ls -l /usr/lib/i386-linux-gnu/libmysqlclient.s*
lrwxrwxrwx 1 root root 44 tammi 1 15:43 /usr/lib/i386-linux-gnu/libmysqlclient.so -> /usr/lib/i386-linux-gnu/libmysqlclient.so.20
lrwxrwxrwx 1 root root 24 loka 18 19:59 /usr/lib/i386-linux-gnu/libmysqlclient.so.20 -> libmysqlclient.so.20.3.7
-rw-r--r-- 1 root root 4071856 loka 18 19:59 /usr/lib/i386-linux-gnu/libmysqlclient.so.20.3.7
That may, or may not help. (Sorry I'm not Debian based system user, just have one test Lubuntu. I use Fedora as main distro)
See this message:
https://www.cqrlog.com/node/1915
It has lot of similarities. Worth of trying.
--
Saku
OH1KH
--
Saku
OH1KH
"Seems that libmysqlclient is lost."
Saku,
Thank you for spotting that. libmysqlclient was not installed. Since it was not available via my LM 18.3 Synaptic I searched for and found it at https://community.linuxmint.com/software/view/libmysqlclient-dev. Downloaded and installed... now CQRLog is up and running.
Again, thank you... my appreciation to you.
73,
Ed - ad7gr
73,
Ed - AD7GR
Great !
Happy new year. Enjoy!
--
Saku
OH1KH
--
Saku
OH1KH
Thanks for the help that solved the issue for CQRLOG on both Ubuntu 17.10 and Mint 18.2. Now to go have some fun.
Warren
KC0GU
Glad it helped you Warren.
My thanks to Petr's patience with me through this.
73,
Ed - ad7gr
73,
Ed - AD7GR