<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi<div><br></div><div>Well some feedback below. (Fun indeed, but borderline frustration!)</div><div><br></div><div>Rightly or wrongly, I couldn't restore a mysqldump from the percona server to the mariaDB 10.1.</div><div>I kept getting errors involving both innodb table IDs as well as in the script it would make the table, then say it didn't exist. It got kind of frustrating, and time wasting.</div><div><br></div><div>I muddled around, and eventually, figured it simpler to restore the Percona instance, and mysql_upgrade. That was much more successful</div><div><br></div><div>Before running ngcp_update-db-schema, I had to change the password in /etc/mysql/sipwise.cnf to match the old password, and not hte sipwise new installations password.</div><div>/usr/share/ngcp-db-schema/db_scripts/diff/13659.up failed on line 13, duplicate entires<br></div><div><div>it runs ALTER TABLE location ADD UNIQUE ruid_idx (ruid);</div></div><div><br></div><div>I had some static entries, and they had similer iDs, not sure how.</div><div><br></div><div>after that, everything succeeded up to:</div><div><div>"Applying revision script /usr/share/ngcp-db-schema/db_scripts/diff/15444.up: done"</div></div><div><br></div><div>Of course, now I had "messed with the installation, db was different passwords, and I couldn't log in to admin web on port 1443 - it would give an incident error.</div><div><br></div><div>Fixed the soap user in mysql to match the new instalaltion password.</div><div><br></div><div>Then based on that set the password from all those in constants.yml to make a script o tupdate mysql.</div><div><br></div><div>Well also figured out setting passwords syntax has changed a little for mysql.</div><div> <br></div><div>rtcengine, and licensed and fileshare and had no user. Should i make it? </div><div><br></div><div>Then i realised, oh-wait ngcpcfg actually syncs the DB usernames! Cool.</div><div><br></div><div>Had to disable auth_realm checking, as that how my previous config was.</div><div><br></div><div>some services didn't restart even after doing ngcpcfg (like mediator as one, there was another one somewhere else)</div><div><br></div><div>Had some troubles with CDRs not exporting... then realised, the rate-o-mat service wasn't running (originally password issue), figured a reboot was the best fresh start there!</div><div><br></div><div>Interesting problem there was, CDRs were being generated for reseller, but nothing for main platform. Am waiting for next export run to see what happens.</div><div><br></div><div>Will update you further for any other things I come accross.</div><div><br></div><div>Kind Regards</div><div><br></div><div><br></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Wed, 7 Nov 2018 at 17:38, Alex Lutay <<a href="mailto:alutay@sipwise.com">alutay@sipwise.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
Theoretically - yes, but it was never tested.<br>
<br>
Recently there were PRO migration from ~mr3.8 to mr5.5.6<br>
directly by installing mr5.5.6, copying DB and upgrading it with<br>
ngcp-update-db-schema and one issue noticed and fixed already.<br>
<br>
The problem is DB statements which normally executed in<br>
different environments, like<br>
> 2.8 statements executed in Percona<br>
> mr4.5 in default MySQL 5.5<br>
> mr5.5 in MariaDB 10.0<br>
> mr6.5 in MariaDB 10.1<br>
<br>
All those statements were created in different time<br>
during the 5 years and tested in the "proper" mysql version.<br>
<br>
During the direct upgrade all the statements are<br>
executed in target release, e.g. mr6.5.1/MariaDB 10.1<br>
<br>
There is small amount inconsistency you can hit,<br>
like foreign keys handling in different DB versions.<br>
The reported issue has been fixed already, but nobody<br>
tried direct upgrade from deep 2.8, AFAIK.<br>
<br>
I believe you can try it on the test installation<br>
and check how it works. Please share the results here!<br>
<br>
Have fun!<br>
<br>
On 11/7/18 3:06 PM, Matthew Ogden wrote:<br>
> Is there a way to install fresh a latest mr, and then upload/upgrade<br>
> the DB schema from 2.8?<br>
><br>
> Is it more practical to just upgrade all the way (wow, have hit some<br>
> road blocks here!)<br>
<br>
-- <br>
Alex Lutay<br>
_______________________________________________<br>
Spce-user mailing list<br>
<a href="mailto:Spce-user@lists.sipwise.com" target="_blank">Spce-user@lists.sipwise.com</a><br>
<a href="https://lists.sipwise.com/listinfo/spce-user" rel="noreferrer" target="_blank">https://lists.sipwise.com/listinfo/spce-user</a><br>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><p> </p>
<p><span style="font-size:10.0pt;color:gray"><img src="http://www.tenacit.net/googlesig/tenacit.png" width="200" height="65"></span><span lang="EN-ZA" style="font-size:10.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:10.0pt;color:black"> </span></p>
<p><b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">Matthew Ogden</span></b></p>
<p><span style="font-size:10.0pt;color:gray">Management</span></p>
<p><span style="font-size:10.0pt;color:gray">TenacIT
</span></p>
<p><span style="font-size:10.0pt;color:gray"> </span></p>
<p><span style="color:gray;font-size:10pt"> </span><br></p>
<p><b><span lang="EN-ZA">Strategic IT Consulting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> Advanced Networking </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">Virtualisation</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
<p><b><span lang="EN-ZA">Custom Development </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Hosting </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">•</span><b><span lang="EN-ZA"> </span></b><b><span lang="EN-ZA">Syspro Support </span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52">• </span><b><span lang="EN-ZA">MS Licensing</span></b><span lang="EN-ZA" style="font-size:12.0pt;color:#79ae52"> </span><b><span lang="EN-ZA"></span></b></p>
<p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">National Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">041 10 10 100
| </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Cell: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">084 205 4445 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Email: </span><a href="mailto:matthew@tenacit.net" target="_blank"><span style="font-size:9.0pt;color:gray;text-decoration:none">matthew@tenacit.net</span></a><span style="font-size:9.0pt;color:#44546a"> </span><span style="font-size:9.0pt;color:gray"></span></p>
<p><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">CT Tel: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">021 201 0333 | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Skype Name: </span><span lang="EN-ZA" style="font-size:9.0pt;color:gray">matthew.ogden | </span><span lang="EN-ZA" style="font-size:9.0pt;color:#a6a6a6">Web: </span><span lang="EN-ZA" style="font-size:9.0pt;color:#bce292;text-decoration:none"><a href="http://www.tenacit.net/" target="_blank">http://www.tenacit.net</a></span></p><p> <img src="http://www.tenacit.net/googlesig/bottom.png"></p></div></div>