<div dir="auto">A hint. When I did this some time ago I just used haproxy to work around this problem. Haproxy also has the advantage to auto switch to a live host. </div><div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, 29 Dec 2022 at 17:10, Jon Bonilla (Manwe) <<a href="mailto:manwe@sipdoc.net">manwe@sipdoc.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-style:solid;padding-left:1ex;border-left-color:rgb(204,204,204)">El Wed, 28 Dec 2022 19:58:38 +0100 (CET)<br>
"<a href="mailto:cappellari@connectlife.it" target="_blank">cappellari@connectlife.it</a>" <<a href="mailto:cappellari@connectlife.it" target="_blank">cappellari@connectlife.it</a>> escribió:<br>
<br>
> Hi, I'm moving MySQL databases to a dedicated Galera cluster. I copied all<br>
> the databases, created the users on the new cluster and assigned the related<br>
> permissions for each DB. <br>
> <br>
> I'm running into two problems: <br>
> <br>
> 1. Redis tries to connect to cluster port 6379 instead of localhost, what is<br>
> the custom TT to change to connect to localhost? 2. while sending the ngcpcfg<br>
> apply command, some errors appear relating to the mysql.proc table (functions<br>
> are missing). There are other databases on the cluster, is it recommended to<br>
> dedicate the cluster only to Sipwise? Thank you <br>
<br>
<br>
Be careful with moving the db outside the ngcp system.<br>
<br>
When dumping to the external host make sure you also dump functions and<br>
triggers because the ngcp dbschema heavily relies on them.<br>
<br>
I'm not sure how is in recent releases but in the past redis and mysql were<br>
pointed to the same host by the templates. If you want redis and mysql in<br>
different hosts you'll need customtt files for all redis connections<br>
<br>
Some scripts like cleanup may not work well outside the host. Check that all<br>
scripts that affect db use the external host and no connection is hardcoded to<br>
localhost. Check that ngcp-update-db-schema works with the external host<br>
<br>
Check the sipwise user permissions in the galera database. You might need to<br>
tweak them and also include "localhost" as host for some functions/procedures.<br>
<br>
<br>
In general, I would not recommend using an external galera system unless you<br>
know what you're doing.<br>
<br>
<br>
cheers,<br>
<br>
Jon<br>
<br>
<br>
-- <br>
PekePBX, the multitenant PBX solution<br>
<a href="https://pekepbx.com" rel="noreferrer" target="_blank">https://pekepbx.com</a><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="http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com" rel="noreferrer" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><br>
</blockquote></div></div>-- <br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><img src="https://scribe-mail.myrepublic.net/s2/ywna1b07.gif" width="1" height="1" alt="Email header"> <table dir="ltr" width="500" cellspacing="0" cellpadding="0" style="border:0"> <tr> <td height="16" style="line-height:0px" colspan="2"></td> </tr> <tr> <td style="width:1%;padding-right:24px" valign="top"> <a href="https://scribe-mail.myrepublic.net/s2/axf8hvuz" style="text-decoration:none;line-height:88px;font-size:0px" target="_blank"><img src="https://scribe-mail.myrepublic.net/s2/7vi90rnb.png" height="88" width="144" border="0" alt="Company logo" style="display:block"></a> </td> <td valign="top"> <table cellspacing="0" cellpadding="0" style="border:0"> <tr> <td style="color:#7c04fc;font-size:15px;line-height:18px;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif;font-weight:bold" align="left"> Walter Klomp </td> </tr> <tr> <td style="color:#7c838b;font-size:14px;line-height:21px;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif" align="left"> Head of Voice Network </td> </tr> <tr><td height="16" style="line-height:0px"></td></tr> <tr> <td> <table cellspacing="0" cellpadding="0" style="border:0"> <tr> <td width="20" valign="middle"><img src="https://scribe-mail.myrepublic.net/s2/j5bnwhgx.png" width="10" height="10" alt="Phone"></td> <td style="color:#364a61;font-size:14px;line-height:21px;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif"><a href="tel:+6568161120" style="color:#364a61;text-decoration:none;font-weight:normal" target="_blank"><strong style="color:#364a61;text-decoration:none;font-weight:normal">+6568161120</strong></a></td> </tr> <tr> <td width="20" valign="middle"><img src="https://scribe-mail.myrepublic.net/s2/41j4ffwb.png" width="10" height="10" alt="Phone"></td> <td style="color:#364a61;font-size:14px;line-height:21px;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif"><a href="mailto:walter@myrepublic.net" style="color:#364a61;text-decoration:none;font-weight:normal" target="_blank"><strong style="color:#364a61;text-decoration:none;font-weight:normal">walter@myrepublic.net</strong></a></td> </tr> </table> </td> </tr> <tr><td height="16" style="line-height:0px"></td></tr> <tr> <td style="font-size:14px;line-height:21px;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif;color:#364a61" align="left"> Beyond Work: <span style="color:#7c04fc">VR Sim Racing, F1, Travel</span> </td> </tr> <tr><td height="16" style="line-height:0px"></td></tr> <tr> <td style="font-size:14px;line-height:21px;color:#8d8f99;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif" align="left"> 11 Lorong 3 Toa Payoh, #04-11/15, Jackson Square, Block B, Singapore 319579 </td> </tr> <tr> <td style="font-size:14px;line-height:21px;color:#364a61;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif" align="left"> <a href="https://scribe-mail.myrepublic.net/s2/z0zrbzi8" style="color:#364a61;text-decoration:none;font-weight:normal" target="_blank"><strong style="color:#364a61;text-decoration:none;font-weight:normal">www.myrepublic.net</strong></a> </td> </tr> <tr> <td valign="top" style="padding-top:16px"> <table cellspacing="0" cellpadding="0" style="border:0"> <tr> <td valign="middle" width="30" style="line-height:0px;color:#7c04fc;margin-right:6px;margin-bottom:1px" align="left"><a href="https://scribe-mail.myrepublic.net/s2/29x4dvjv" style="text-decoration:none;color:#7c04fc" target="_blank"> <strong style="text-decoration:none;font-weight:normal;color:#7c04fc"><img style="display:block" width="24" height="24" alt="facebook-f" src="https://scribe-mail.myrepublic.net/s2/wzp14gw6.png"> </strong> </a></td> <td valign="middle" width="36" style="line-height:0px;color:#7c04fc;margin-left:6px;margin-right:6px;margin-bottom:1px" align="center"><a href="https://scribe-mail.myrepublic.net/s2/0d3lbnxt" style="text-decoration:none;color:#7c04fc" target="_blank"> <strong style="text-decoration:none;font-weight:normal;color:#7c04fc"><img style="display:block" width="24" height="24" alt="instagram" src="https://scribe-mail.myrepublic.net/s2/lrif4x8i.png"> </strong> </a></td> <td valign="middle" width="36" style="line-height:0px;color:#7c04fc;margin-left:6px;margin-right:6px;margin-bottom:1px" align="center"><a href="https://scribe-mail.myrepublic.net/s2/ijwwdstc" style="text-decoration:none;color:#7c04fc" target="_blank"> <strong style="text-decoration:none;font-weight:normal;color:#7c04fc"><img style="display:block" width="24" height="24" alt="twitter" src="https://scribe-mail.myrepublic.net/s2/5izp6wvd.png"> </strong> </a></td> <td valign="middle" width="30" style="line-height:0px;color:#7c04fc;margin-left:6px;margin-right:1px;margin-bottom:1px" align="right"><a href="https://scribe-mail.myrepublic.net/s2/3ljl3jmh" style="text-decoration:none;color:#7c04fc" target="_blank"> <strong style="text-decoration:none;font-weight:normal;color:#7c04fc"><img style="display:block" width="24" height="24" alt="linkedin-in" src="https://scribe-mail.myrepublic.net/s2/uu1c8ot8.png"> </strong> </a></td> </tr> </table> </td> </tr> <tr><td height="16" style="line-height:0px"></td></tr> <tr><td height="12" style="border-top:1px solid #f5f5f5"></td></tr> <tr> <td style="font-size:11px;line-height:16px;font-family:Helvetica,'Helvetica Neue',Arial,sans-serif;color:#9e9ea6"> The information in this message is privileged and confidential. If you are not the intended recipient of this email, please don't read, copy, use, distribute or tell anyone about it; kindly destroy it and notify the sender by return email. Please advise immediately if you or your employer does not consent to email for messages of this kind. Any content that is not concerned with MyRepublic business reflects the views of the sender only and not those of MyRepublic. </td> </tr> </table> </td> </tr> <tr> <td height="40" colspan="2"></td> </tr> </table></div>
<br>
<span style="color:rgb(34,34,34);font-family:sans-serif;background-color:rgb(255,255,255)"><font size="1"><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">The contents of this email and any attachments are confidential and may also be privileged. You must not disseminate the contents of this email and any attachments without permission of the sender. If you have received this email by mistake, please delete all copies and inform the sender immediately. You may refer to our company's Privacy Policy </span><span style="color:rgb(102,102,102);font-family:Arial;font-style:italic;vertical-align:baseline;white-space:pre-wrap"><a href="https://myrepublic.net/sg/legal/terms-of-use-policies/privacy-policy/" target="_blank">here</a></span><span style="font-family:Arial;color:rgb(102,102,102);font-style:italic;vertical-align:baseline;white-space:pre-wrap">.</span></font></span>