Web lists-archives.com

Re: Willing to pay for kmail help




John,
you likely don't have to pay anyone.

Please see:

https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843534
and
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843520

This was a regression in akonadi due to a security fix in MySQL.  The patch for this is being put through the Debian security channels and should be out soon?
​  I don't know what the patch will entail to fix broken USER copies (!/.​
​local/share/akonadi/mysql.conf) automatically, and maybe it won't, so see below for a quick command to fix the files in question to work with the new version of MySQL.​


before running this command, you may want to make a copy of either of these files first.
The 'sed' below will try to save a copy with the suffix '.bak', but if you run the command twice and something goes wrong, you'll overwrite the .bak again with what could be a mangled edit.

-----
To fix at the system level, use the following 'sed' inline script:
  sed -i.bak -e '/^\[client\]/isecure_file_priv=\n\n'   /etc/akonadi/mysql-global.conf

To fix for an individual user:  (you'll likely have to do this for all users, as it appears akonadi creates this file the first time it starts for a user by copying from /etc/akonadi/mysql-global.conf.  It likely never checks that file again, unless the user's copy of it gets deleted)
  sed -i.bak -e '/^\[client\]/isecure_file_priv=\n\n' ~/.local/share/akonadi/mysql.conf
-----

What this does is include the directive "secure_file_priv=" right before the "[client]" section of the file.
​(MySQL uses a standard "INI" style configuration file of the form
  [SECTION]
  directive=value
  ...
So, you have to get the 'secure_file_priv' directive in the right section.​


If you have heavily edited that file, it might not work, and you'd have to do it manually.  Please see the example:
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843534#55

​It may be most helpful after updating your files to logout and login again (rather than trying to manually start akonadi up)​


​Good Luck.​

​​--stephen


On Mon, Nov 14, 2016 at 10:23 PM, John White, Jr. <whitelaw@xxxxxxx> wrote:
I run a small business and use kmail  Today it just quit, saying that akonadi won't start.  I can't start it and thus can't get to my email (john@xxxxxxxxxxxx).

If anyone is kind enough to help, I will pay at least $100 to get it going and more if need be.

Since kmail is down, I am having to use my old aol email (whitelaw@xxxxxxx).

Thanks

John White
White Law Chartered
335 W 1st St.
Reno, NV 89503 USA

775-322-8000 work
775-313-9104 (sip phone)
775-322-1228 (fax)



--
Stephen Dowdy  -  Systems Administrator  -  NCAR/RAL
303.497.2869   -  sdowdy@xxxxxxxx        -  http://www.ral.ucar.edu/~sdowdy/