<div dir="ltr"><span style="font-family:monospace,monospace">John,<br>you likely don't have to pay anyone.<br><br>Please see:<br><br><a href="https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843534">https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843534</a><br>and<br><a href="https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843520">https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843520</a><br><br>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?<div style="font-family:monospace,monospace;display:inline" class="gmail_default"> I don't know what the patch will entail to fix broken USER copies (!/.</div><div style="font-family:monospace,monospace;display:inline" class="gmail_default">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.</div><br><br>before running this command, you may want to make a copy of either of these files first.<br>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.<br><br>-----<br>To fix at the system level, use the following 'sed' inline script:<br> sed -i.bak -e '/^\[client\]/isecure_file_priv=\n\n' /etc/akonadi/mysql-global.conf<br><br>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)<br> sed -i.bak -e '/^\[client\]/isecure_file_priv=\n\n' ~/.local/share/akonadi/mysql.conf<br></span><span style="font-family:monospace,monospace"><span style="font-family:monospace,monospace">-----</span><br><br>What this does is include the directive "secure_file_priv=" right before the "[client]" section of the file.<br><div style="font-family:monospace,monospace;display:inline" class="gmail_default">(MySQL uses a standard "INI" style configuration file of the form<br></div><div style="font-family:monospace,monospace;display:inline" class="gmail_default"> [SECTION]<br></div><div style="font-family:monospace,monospace;display:inline" class="gmail_default"> directive=value<br> ...<br></div><div style="font-family:monospace,monospace;display:inline" class="gmail_default">So, you have to get the 'secure_file_priv' directive in the right section.</div><br><br>If you have heavily edited that file, it might not work, and you'd have to do it manually. Please see the example:<br><a href="https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843534#55">https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=843534#55</a><br><br><div style="font-family:monospace,monospace;display:inline" class="gmail_default">It may be most helpful after updating your files to logout and login again (rather than trying to manually start akonadi up)</div><br><br><div style="font-family:monospace,monospace;display:inline" class="gmail_default">Good Luck.</div><br></span><div class="gmail_default"><span style="font-family:monospace,monospace"></span><span style="font-family:monospace,monospace">--stephen</span><br></div><div class="gmail_default"><span style="font-family:monospace,monospace"></span></div><span style="font-family:monospace,monospace"><br></span><div class="gmail_extra"><span style="font-family:monospace,monospace"><br></span><div class="gmail_quote"><span style="font-family:monospace,monospace">On Mon, Nov 14, 2016 at 10:23 PM, John White, Jr. <span dir="ltr"><<a href="mailto:whitelaw@aol.com" target="_blank">whitelaw@aol.com</a>></span> wrote:<br></span><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><span style="font-family:monospace,monospace"><font size="2" color="black">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 (<a href="mailto:john@lawquest.com" target="_blank">john@lawquest.com</a>).
<div><br>
</div>
<div>If anyone is kind enough to help, I will pay at least $100 to get it going and more if need be.</div>
<div><br>
</div>
<div>Since kmail is down, I am having to use my old aol email (<a href="mailto:whitelaw@aol.com" target="_blank">whitelaw@aol.com</a>).</div>
<div><br>
</div>
<div>Thanks</div>
<div><br>
</div>
<div>John White</div>
<div>White Law Chartered</div>
<div>335 W 1st St.</div>
<div>Reno, NV 89503 USA</div>
<div><br>
</div>
<div>775-322-8000 work</div>
<div>775-313-9104 (sip phone)</div>
<div>775-322-1228 (fax)</div>
</font></span></blockquote></div><span style="font-family:monospace,monospace"><br><br clear="all"><br>-- <br></span><div class="gmail_signature"><span style="font-family:monospace,monospace">Stephen Dowdy - Systems Administrator - NCAR/RAL<br>303.497.2869 - <a href="mailto:sdowdy@ucar.edu" target="_blank">sdowdy@ucar.edu</a> - <a href="http://www.ral.ucar.edu/%7Esdowdy/" target="_blank">http://www.ral.ucar.edu/~sdowdy/</a><br><br><br></span></div>
</div></div>