<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=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Courier;
panose-1:2 7 4 9 2 2 5 2 4 4;}
@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:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman",serif;}
span.apple-converted-space
{mso-style-name:apple-converted-space;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;}
span.apple-tab-span
{mso-style-name:apple-tab-span;}
span.E-MailFormatvorlage22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></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=DE-AT link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'>No problem ;)<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> Thomas Odorfer [mailto:odotom@gmail.com] <br><b>Gesendet:</b> Sonntag, 15. Jänner 2017 11:15<br><b>An:</b> Spce-user <spce-user@lists.sipwise.com><br><b>Cc:</b> Matthias Hohl <matthias.hohl@telematica.at><br><b>Betreff:</b> Re: [Spce-user] mr4.5.3 upgrade issue - synchronizing mysql grants<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks for the hint -solved -<o:p></o:p></p><div><p class=MsoNormal>thought that update schema (ngcp-update-db-schema) will be performed automatically.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Am 14.01.2017 um 23:32 schrieb Matthias Hohl <<a href="mailto:matthias.hohl@telematica.at">matthias.hohl@telematica.at</a>>:<o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>Hey,</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>did you it with this?</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>apt-get update && apt-get upgrade && ngcp-update-db-schema && ngcp-update-cfg-schema && ngcpcfg apply 'Hotfix Update'</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'>don’t sure but this but an idea, that the problem ist he db schema</span><o:p></o:p></p></div><div><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D'> </span><o:p></o:p></p></div><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm'><div><p class=MsoNormal><b><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Von:</span></b><span class=apple-converted-space><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'> </span></span><span lang=DE style='font-size:11.0pt;font-family:"Calibri",sans-serif'>Spce-user [<a href="mailto:spce-user-bounces@lists.sipwise.com">mailto:spce-user-bounces@lists.sipwise.com</a>]<span class=apple-converted-space> </span><b>Im Auftrag von<span class=apple-converted-space> </span></b>Thomas Odorfer<br><b>Gesendet:</b><span class=apple-converted-space> </span>Samstag, 14. Jänner 2017 23:10<br><b>An:</b><span class=apple-converted-space> </span>Spce-user <<a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a>><br><b>Betreff:</b><span class=apple-converted-space> </span>[Spce-user] mr4.5.3 upgrade issue - synchronizing mysql grants</span><o:p></o:p></p></div></div></div><div><p class=MsoNormal> <o:p></o:p></p></div><div><p class=MsoNormal>After performing an apt-upgrade on mr4.5.3 the following happened during ngcpcfg apply:<o:p></o:p></p></div><div><div><p class=MsoNormal> <o:p></o:p></p></div></div><div><pre style='font-variant-ligatures: normal;orphans: 2;widows: 2;-webkit-user-select: text'>2017-01-14 22:47:10:Synchronizing MySQL grants/credentials<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_tag' doesn't exist<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_tag_data' doesn't exist<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_relation' doesn't exist<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_relation_data' doesn't exist<o:p></o:p></pre><pre> --> revoke all from: exporter@localhost<o:p></o:p></pre><div><pre style='font-variant-ligatures: normal;orphans: 2;widows: 2;-webkit-user-select: text'>2017-01-14 22:47:10: Synchronizing MySQL grants/credentials<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_tag' doesn't exist<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_tag_data' doesn't exist<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_relation' doesn't exist<o:p></o:p></pre><pre>Warning: Cannot apply grant: Table 'accounting.events_relation_data' doesn't exist<o:p></o:p></pre><pre> -<span class=apple-tab-span> </span><o:p></o:p></pre><div><div><p class=MsoNormal> <o:p></o:p></p></div></div></div></div><div><div><div><p class=MsoNormal><span style='font-family:Courier'>2017-01-14 22:47:10: Synchronizing MySQL grants/credentials</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-family:Courier'>Warning: Cannot apply grant: Table 'accounting.events_tag' doesn't exist</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-family:Courier'>Warning: Cannot apply grant: Table 'accounting.events_tag_data' doesn't exist</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-family:Courier'>Warning: Cannot apply grant: Table 'accounting.events_relation' doesn't exist</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-family:Courier'>Warning: Cannot apply grant: Table 'accounting.events_relation_data' doesn't exist</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-family:Courier'> --> revoke all from: exporter@localhost</span><o:p></o:p></p></div></div><div><div><p class=MsoNormal><span style='font-family:Courier'> --> grant select,update on accounting.cdr to exporter@localhost </span><o:p></o:p></p></div></div></div><div><div><p class=MsoNormal><br><br><br><o:p></o:p></p></div></div><div><div><p class=MsoNormal>(Repeatable with ngcpcfg apply)<o:p></o:p></p></div></div></div></div><p class=MsoNormal><o:p> </o:p></p></div></div></body></html>