<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Bierstadt;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Bierstadt",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:27292400;
mso-list-type:hybrid;
mso-list-template-ids:-1193277268 1661504540 134807555 134807557 134807553 134807555 134807557 134807553 134807555 134807557;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:-;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Bierstadt",sans-serif;
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">Good Afternoon to you all,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">After I updated MariaDB to 10.5 yesterday, and then it would not start after the update, Michael kindly fixed this for us to get us back up and running,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">I have noticed today we have some issues with MariaDB with some functionality relating to settings in apps . ( sorry for long winded explanation below)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">- MariaDB is running, and all websites are up and running, phpMyAdmin accessing DB fine, however, SWATCH continually showing as MariaDB failed and could not restart -
<br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">- in AVSPAM MySQL settings are blocked out ( error says we do not have privileges to modify this item )<br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">- geo-Ip reporting “no MySQL config “in logs<br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">- in GUI, If I try and stop MariaDB service – It just refreshes the screen and it’s still ticked and active.<br>
<br>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">- In GUI, If I go to MariaDB Settings > CNF editor – and then (without making any changes) click Save – MariaDB server instantly stops,
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">- After MariaDB stopped, – it will not start again when using
<b>“systemctl start Mariadb”</b> - and only error I could find was “no my.cnf file” – I then had to open /etc/my.cnf in pico editor , made no changes , wrote the file out, (overwriting the file) and then ran <b>“systemctl start mariadb”</b> and
mariadb starts up with no errors, and all websites come back on line, <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">- however, SWATCH still reports it as failed, and options still blocking access to enable MYSQL in AVSPAM , and there for GEOIP issues as no SQL settings available.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif">Has anyone any ideas on how I can resolve this please.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-family:"Bierstadt",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">Kind regards<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-ligatures:none">Richard</span><span style="mso-ligatures:none"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:#999999;mso-ligatures:none;mso-fareast-language:EN-GB">______________________________<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Tahoma",sans-serif;color:#999999;mso-ligatures:none;mso-fareast-language:EN-GB">Richard Owen</span><span style="mso-ligatures:none;mso-fareast-language:EN-GB"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>