<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<div>
<div>
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" dir="ltr">
Do cd /</div>
<div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" dir="ltr">
Locate db.inc.php</div>
</div>
<div id="ms-outlook-mobile-signature">
<div><br>
</div>
<a href="https://aka.ms/o0ukef">Outlook voor iOS</a> downloaden</div>
</div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>Van:</b> Users <users-bounces@lists.opensips.org> namens mrsanvicente <mrsanvicente@gmail.com><br>
<b>Verzonden:</b> Wednesday, December 29, 2021 2:51:07 AM<br>
<b>Aan:</b> Bogdan-Andrei Iancu <bogdan@opensips.org><br>
<b>CC:</b> OpenSIPS users mailling list <users@lists.opensips.org><br>
<b>Onderwerp:</b> Re: [OpenSIPS-Users] how to change mysql data directory to CP</font>
<div> </div>
</div>
<div dir="auto">Hello Bogdan-Andrei / All,
<div><br>
</div>
<div>Sorry for the delay. I just didn’t find a path or var to modify in db.inc.php.</div>
<div><br>
</div>
<div><br>
</div>
<div>But later after a reboot, opensips stop working because it could not find the new path to the db.</div>
<div><br>
</div>
<div>So the source of the problem might be, how to change path to mysql to opensips.<br>
Thanks <br>
<div dir="ltr">Saludos<br>
<div>Mario San Vicente
<div><br>
</div>
</div>
</div>
<div dir="ltr"><br>
<blockquote type="cite">El 17 dic 2021, a la(s) 9:16, Bogdan-Andrei Iancu <bogdan@opensips.org> escribió:<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr"> <font face="monospace">You need to update the DB settings in this file:<br>
<br>
<a class="x_moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips-cp/blob/master/config/db.inc.php">https://github.com/OpenSIPS/opensips-cp/blob/master/config/db.inc.php</a><br>
<br>
Regards,<br>
</font>
<pre class="x_moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="x_moz-txt-link-freetext" href="https://www.opensips-solutions.com">https://www.opensips-solutions.com</a>
OpenSIPS eBootcamp 2021
<a class="x_moz-txt-link-freetext" href="https://opensips.org/training/OpenSIPS_eBootcamp_2021/">https://opensips.org/training/OpenSIPS_eBootcamp_2021/</a></pre>
<div class="x_moz-cite-prefix">On 12/16/21 1:52 AM, mrsanvicente wrote:<br>
</div>
<blockquote type="cite">Yes i did. And restarted mysqld and httpd. But still not working.
<div><br>
</div>
<div><br>
Thanks<br>
<div dir="ltr"><br>
<div>Mario San Vicente
<div><br>
</div>
</div>
</div>
<div dir="ltr"><br>
<blockquote type="cite">El 15 dic 2021, a la(s) 16:14, Joseph Jackson <a class="x_moz-txt-link-rfc2396E" href="mailto:jjackson@aninetworks.net">
<jjackson@aninetworks.net></a> escribió:<br>
<br>
</blockquote>
</div>
<blockquote type="cite">
<div dir="ltr">
<meta name="Generator" content="Microsoft Word 14 (filtered
medium)">
<style>
<!--
@font-face
{font-family:Calibri}
@font-face
{font-family:Tahoma}
p.x_MsoNormal, li.x_MsoNormal, div.x_MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif"}
a:link, span.x_MsoHyperlink
{color:blue;
text-decoration:underline}
a:visited, span.x_MsoHyperlinkFollowed
{color:purple;
text-decoration:underline}
span.x_EmailStyle17
{font-family:"Calibri","sans-serif";
color:#44546A}
.x_MsoChpDefault
{font-family:"Calibri","sans-serif"}
div.x_WordSection1
{}
-->
</style>
<div class="x_WordSection1">
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#44546A">Did you also change the location of the socket file in the my.cnf?</span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#44546A"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#44546A"> </span></p>
<p class="x_MsoNormal"><span style="font-size:11.0pt; font-family:"Calibri","sans-serif"; color:#44546A"> </span></p>
<p class="x_MsoNormal"><b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif"">From:</span></b><span style="font-size:10.0pt; font-family:"Tahoma","sans-serif""> Users [<a class="x_moz-txt-link-freetext" href="mailto:users-bounces@lists.opensips.org">mailto:users-bounces@lists.opensips.org</a>]
<b>On Behalf Of </b>Mario San Vicente<br>
<b>Sent:</b> Wednesday, December 15, 2021 11:27 AM<br>
<b>To:</b> OpenSIPS users mailling list<br>
<b>Subject:</b> [OpenSIPS-Users] how to change mysql data directory to CP</span></p>
<p class="x_MsoNormal"> </p>
<div>
<p class="x_MsoNormal">Hello Everyone,</p>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal">I have changed my mysql directory and a had limited space on the default partition. I applied the change and opensips is working fine. But the control panel is not working and i can not find where to update it.</p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal">Getting the following error:</p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal"><a href="http://x.x.x.x/cp/login.php">http://x.x.x.x/cp/login.php</a><br>
<br>
<span style="font-size:13.5pt; color:black">Error!: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)</span></p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal"><span style="color:black">Any idea, where to update this?</span></p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<div>
<p class="x_MsoNormal">Saludos!</p>
</div>
<div>
<div>
<p class="x_MsoNormal"> </p>
</div>
<p class="x_MsoNormal"> </p>
<div>
<div>
<p class="x_MsoNormal">Mario San Vicente</p>
</div>
<div>
<p class="x_MsoNormal"> </p>
</div>
</div>
</div>
</div>
</div>
<span>_______________________________________________</span><br>
<span>Users mailing list</span><br>
<span><a class="x_moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a></span><br>
<span><a class="x_moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></span><br>
</div>
</blockquote>
</div>
<br>
<fieldset class="x_mimeAttachmentHeader"></fieldset>
<pre class="x_moz-quote-pre">_______________________________________________
Users mailing list
<a class="x_moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="x_moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
<br>
</div>
</blockquote>
</div>
</div>
</body>
</html>