<div dir="ltr"><div>Deat Pa.<br></div><div>From the Handbook: <a href="https://www.sipwise.com/doc/mr12.3.1/spce/ce/mr12.3.1/appendices-main/appendices-main.html#_constants_yml_overview">https://www.sipwise.com/doc/mr12.3.1/spce/ce/mr12.3.1/appendices-main/appendices-main.html#_constants_yml_overview</a></div><div>The usage of external DB is not supported for the NGCP CE version.</div><div>KR<br></div><div>Dario<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 13, 2024 at 8:50 AM Pa Ka <<a href="mailto:pa.ka12@outlook.com">pa.ka12@outlook.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div class="msg3697591932007511437">





<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="m_3697591932007511437WordSection1">
<p class="MsoNormal">Hello team, <u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Could you please assist me with this ? using mr12.3.1<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">In constant.yml file I edit the database as follows:<u></u><u></u></p>
<p class="MsoNormal"><span class="m_3697591932007511437hljs-attr">database:</span> <u></u><u></u></p>
<p class="MsoNormal">    <span class="m_3697591932007511437hljs-attr">local:<u></u><u></u></span></p>
<p class="MsoNormal"><span class="m_3697591932007511437hljs-attr">       </span> <span class="m_3697591932007511437hljs-attr">dbhost:</span>
<span class="m_3697591932007511437hljs-string">IP.address.of.my.db<u></u><u></u></span></p>
<p class="MsoNormal"><span class="m_3697591932007511437hljs-string"><u></u> <u></u></span></p>
<p class="MsoNormal"><span class="m_3697591932007511437hljs-string"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:Roboto;color:rgb(51,51,51);background:white">ngcp-update-db-schema save the db scheme to my db server. But doesn’t create users. I suppose not even all tables are created.
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Roboto;color:rgb(51,51,51);background:white"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:Roboto;color:rgb(51,51,51);background:white">ngcp-reset-db returns [ mysqldump: Got error: 2002: "Can't connect to server on 'localhost' (111)" when trying to connect ] not sure where localhost is coming from. Yet I changed
 the db host in constant.yml file . <u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Roboto;color:rgb(51,51,51);background:white"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:Roboto;color:rgb(51,51,51);background:white">also, mariadb.cnf, my.cnf, grants.yml both from /etc/mysql have been updated. I set mydbip address in those file. But still when I tried to create db to my db server by using
 ngcp-reset-db it returns localhost access error, above<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-family:Roboto;color:rgb(51,51,51);background:white"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-family:Roboto;color:rgb(51,51,51);background:white">where can I get this db host, what am I doing wrong? thanks</span><u></u><u></u></p>
</div>
</div>

-- <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>
</div></blockquote></div>