<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:"Segoe UI Emoji";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@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.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Aptos",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;
mso-ligatures:none;}
@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">Resolved. Certain services like ngcp-tast-agent,.. were inactive. I restarted them. Ooohhh, very long day. I managed to resolve every task I posted in the previous email. It wasn’t easy. Ready for the next
task! Ready to see how sipwise works now. !! sorry for bothering everyone !<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"><o:p> </o:p></span></p>
<div>
<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"> Pa Ka <pa.ka12@outlook.com>
<br>
<b>Sent:</b> Thursday, June 13, 2024 4:00 PM<br>
<b>To:</b> Pa Ka <pa.ka12@outlook.com>; Dario Busso <dbusso@sipwise.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>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">This is also resolved. Drop databases; recreated them.
<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">However, I cannot log into sipwise with administrator password. the error “ Unexpected error
</span><span style="font-size:11.0pt;font-family:"Segoe UI Emoji",sans-serif">😱</span><span style="font-size:11.0pt">: Cannot read properties of undefined (reading 'error') (Thu Jun 13 2024 15:55:06 GMT-0400 (Eastern Daylight Time))” is returned<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">Below is ngcp-api-admins --op list --login administrator:<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>
<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"> Pa Ka <<a href="mailto:pa.ka12@outlook.com">pa.ka12@outlook.com</a>>
<br>
<b>Sent:</b> Thursday, June 13, 2024 12:47 PM<br>
<b>To:</b> <a href="mailto:pa.ka12@outlook.com">pa.ka12@outlook.com</a>; Dario Busso <<a href="mailto:dbusso@sipwise.com">dbusso@sipwise.com</a>><br>
<b>Cc:</b> <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<b>Subject:</b> RE: [EXTERNAL] [Spce-user] database error<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:11.0pt">Updates. <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 managed to re-install the db by using
</span><span style="font-size:11.0pt;font-family:Roboto;color:#333333;background:white">ngcp-update-db-schema</span><span style="font-size:11.0pt">. Some DB were missing. I did a DB reset but returns<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">ERROR 1045 (28000): Access denied for user 'sipwise'@'localhost' (using password: YES)<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">Any guidance? I think it is related to permission. Not sure how to fix this one.<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">Thanks<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"> "_embedded" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "ngcp:admins" : [<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"> "_links" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "collection" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "href" : "/api/admins/"<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"> "curies" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "href" : <a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}">
http://purl.org/sipwise/ngcp-api/#rel-{rel}</a>,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "name" : "ngcp",<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "templated" : true<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"> "ngcp:admins" : [<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"> "href" : "/api/admins/1"<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"> "ngcp:journal" : [<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"> "href" : "/api/admins/1/journal/"<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"> "ngcp:resellers" : [<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"> "href" : "/api/resellers/1"<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"> "profile" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "href" : <a href="http://purl.org/sipwise/ngcp-api/">
http://purl.org/sipwise/ngcp-api/</a><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"> "self" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "href" : "/api/admins/1"<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"> "billing_data" : true,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "call_data" : true,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "can_reset_password" : true,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "email" : <a href="mailto:myemail@email.com">
myemail@email.com</a>,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "id" : 1,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "is_active" : true,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "is_ccare" : false,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "is_master" : true,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "is_superuser" : true,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "is_system" : true,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "lawful_intercept" : false,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "login" : "administrator",<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "read_only" : false,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "reseller_id" : 1,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "role" : "system",<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "show_passwords" : true<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"> "_links" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "curies" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "href" : <a href="http://purl.org/sipwise/ngcp-api/#rel-{rel}">
http://purl.org/sipwise/ngcp-api/#rel-{rel}</a>,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "name" : "ngcp",<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "templated" : true<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"> "ngcp:admins" : [<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"> "href" : "/api/admins/1"<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"> "profile" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "href" : <a href="http://purl.org/sipwise/ngcp-api/">
http://purl.org/sipwise/ngcp-api/</a><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"> "self" : {<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt"> "href" : "/api/admins/?page=1&rows=10&login=administrator"<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"> "total_count" : 1<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt">}<o:p></o:p></span></p>
<div>
<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"> Pa Ka <<a href="mailto:pa.ka12@outlook.com">pa.ka12@outlook.com</a>>
<br>
<b>Sent:</b> Thursday, June 13, 2024 11:34 AM<br>
<b>To:</b> Dario Busso <<a href="mailto:dbusso@sipwise.com">dbusso@sipwise.com</a>><br>
<b>Cc:</b> <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><br>
<b>Subject:</b> RE: [EXTERNAL] [Spce-user] database error<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<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 <<a href="mailto:dbusso@sipwise.com">dbusso@sipwise.com</a>>
<br>
<b>Sent:</b> Thursday, June 13, 2024 3:17 AM<br>
<b>To:</b> Pa Ka <<a href="mailto:pa.ka12@outlook.com">pa.ka12@outlook.com</a>><br>
<b>Cc:</b> <a href="mailto:spce-user@lists.sipwise.com">spce-user@lists.sipwise.com</a><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-top:5.0pt;margin-right:0in;margin-bottom:5.0pt">
<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>