<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:"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:Aptos;}
@font-face
{font-family:Roboto;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:12.0pt;
font-family:"Aptos",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.m3697591932007511437hljs-attr
{mso-style-name:m_3697591932007511437hljs-attr;}
span.m3697591932007511437hljs-string
{mso-style-name:m_3697591932007511437hljs-string;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt">Thank you for letting me know that external db is not supported for NGCP CE version. Now, I am facing this issue during the installion of ngcp, the database wasn’t created maybe due to mariadb.service down.
I fixed this later after the installation. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">No db when (mysl>show databases;<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Only returns <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">+--------------------+<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">| information_schema |<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">| mysql |<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">| performance_schema |<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">| sys<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">I did ngcp-reset-db , it returns
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">mysqldump: Got error: 1045: "Access denied for user 'sipwise'@'localhost' (using password: YES)" when trying to connect<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">ERROR: Error backing up DB 'accounting' to /ngcp-data/backup/db_backup.sql-20240613_172742<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Do I need to create ngcp database first? What command should I use?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Thank you !<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Dario Busso <dbusso@sipwise.com>
<br>
<b>Sent:</b> Thursday, June 13, 2024 3:17 AM<br>
<b>To:</b> Pa Ka <pa.ka12@outlook.com><br>
<b>Cc:</b> spce-user@lists.sipwise.com<br>
<b>Subject:</b> Re: [EXTERNAL] [Spce-user] database error<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">Deat Pa.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">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><o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">The usage of external DB is not supported for the NGCP CE version.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">KR<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Dario<o:p></o:p></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">On Thu, Jun 13, 2024 at 8:50<span style="font-family:"Arial",sans-serif"> </span>AM Pa Ka <<a href="mailto:pa.ka12@outlook.com">pa.ka12@outlook.com</a>> wrote:<o:p></o:p></p>
</div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Hello team,
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">Could you please assist me with this ? using mr12.3.1<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto">In constant.yml file I edit the database as follows:<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span class="m3697591932007511437hljs-attr">database:</span>
<o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"> <span class="m3697591932007511437hljs-attr">local:</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span class="m3697591932007511437hljs-attr">
</span> <span class="m3697591932007511437hljs-attr">dbhost:</span> <span class="m3697591932007511437hljs-string">
IP.address.of.my.db</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span class="m3697591932007511437hljs-string"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span class="m3697591932007511437hljs-string"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Roboto;color:#333333;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. </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Roboto;color:#333333;background:white"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Roboto;color:#333333;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 .
</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Roboto;color:#333333;background:white"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Roboto;color:#333333;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</span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Roboto;color:#333333;background:white"> </span><o:p></o:p></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span style="font-family:Roboto;color:#333333;background:white">where can I get this db host, what am I doing wrong? thanks</span><o:p></o:p></p>
</div>
</div>
<p class="MsoNormal">-- <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" target="_blank">http://lists.sipwise.com/mailman/listinfo/spce-user_lists.sipwise.com</a><o:p></o:p></p>
</div>
</blockquote>
</div>
</div>
</body>
</html>