<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">Hi, <div class=""><br class=""></div><div class=""><br class=""></div><div class="">I second Mario.</div><div class=""><br class=""></div><div class="">Its not so simple…. With these instructions provided to this thread.</div><div class=""><br class=""></div><div class="">There is no that kind of config on the file db.inc.php</div><div class=""><br class=""></div><div class="">But I guess if you can connect from cli to the MYSQL with the creds you have on that db.inc.php file -> also the connection with php/CP should work… or else there is something else preventing the connection.</div><div class=""><br class=""></div><div class="">Tomi</div><div class=""><br class=""><div><br class=""><div class="">On 29. Dec 2021, at 12.37, Johan De Clercq <<a href="mailto:johan@democon.be" class="">johan@democon.be</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><meta charset="UTF-8" class=""><div style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><div class=""><div dir="ltr" style="background-color: rgb(255, 255, 255);" class="">Do cd /</div><div dir="ltr" style="background-color: rgb(255, 255, 255);" class="">Locate db.inc.php</div></div><div id="ms-outlook-mobile-signature" class=""><div class=""><br class=""></div><a href="https://aka.ms/o0ukef" style="color: purple; text-decoration: underline;" class="">Outlook voor iOS</a><span class="Apple-converted-space"> </span>downloaden</div></div><hr tabindex="-1" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; display: inline-block; width: 1360.234375px;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class=""></span><div id="divRplyFwdMsg" dir="ltr" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><font face="Calibri, sans-serif" style="font-size: 11pt;" class=""><b class="">Van:</b><span class="Apple-converted-space"> </span>Users <<a href="mailto:users-bounces@lists.opensips.org" style="color: purple; text-decoration: underline;" class="">users-bounces@lists.opensips.org</a>> namens mrsanvicente <<a href="mailto:mrsanvicente@gmail.com" style="color: purple; text-decoration: underline;" class="">mrsanvicente@gmail.com</a>><br class=""><b class="">Verzonden:</b><span class="Apple-converted-space"> </span>Wednesday, December 29, 2021 2:51:07 AM<br class=""><b class="">Aan:</b><span class="Apple-converted-space"> </span>Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org" style="color: purple; text-decoration: underline;" class="">bogdan@opensips.org</a>><br class=""><b class="">CC:</b><span class="Apple-converted-space"> </span>OpenSIPS users mailling list <<a href="mailto:users@lists.opensips.org" style="color: purple; text-decoration: underline;" class="">users@lists.opensips.org</a>><br class=""><b class="">Onderwerp:</b><span class="Apple-converted-space"> </span>Re: [OpenSIPS-Users] how to change mysql data directory to CP</font><div class=""> </div></div><div dir="auto" style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class="">Hello Bogdan-Andrei / All,<div class=""><br class=""></div><div class="">Sorry for the delay. I just didn’t find a path or var to modify in db.inc.php.</div><div class=""><br class=""></div><div class=""><br class=""></div><div class="">But later after a reboot, opensips stop working because it could not find the new path to the db.</div><div class=""><br class=""></div><div class="">So the source of the problem might be, how to change path to mysql to opensips.<br class=""> Thanks <br class=""><div dir="ltr" class="">Saludos<br class=""><div class="">Mario San Vicente<div class=""><br class=""></div></div></div><div dir="ltr" class=""><br class=""><blockquote type="cite" class="">El 17 dic 2021, a la(s) 9:16, Bogdan-Andrei Iancu <<a href="mailto:bogdan@opensips.org" style="color: purple; text-decoration: underline;" class="">bogdan@opensips.org</a>> escribió:<br class=""><br class=""></blockquote></div><blockquote type="cite" class=""><div dir="ltr" class=""><span class="Apple-converted-space"> </span><font face="monospace" class="">You need to update the DB settings in this file:<br class=""><br class=""><a class="x_moz-txt-link-freetext" href="https://github.com/OpenSIPS/opensips-cp/blob/master/config/db.inc.php" style="color: purple; text-decoration: underline;">https://github.com/OpenSIPS/opensips-cp/blob/master/config/db.inc.php</a><br class=""><br class="">Regards,<br class=""></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/" style="color: purple; text-decoration: underline;">https://www.opensips-solutions.com</a>
OpenSIPS eBootcamp 2021
<a class="x_moz-txt-link-freetext" href="https://opensips.org/training/OpenSIPS_eBootcamp_2021/" style="color: purple; text-decoration: underline;">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 class=""></div><blockquote type="cite" class="">Yes i did. And restarted mysqld and httpd. But still not working.<div class=""><br class=""></div><div class=""><br class="">Thanks<br class=""><div dir="ltr" class=""><br class=""><div class="">Mario San Vicente<div class=""><br class=""></div></div></div><div dir="ltr" class=""><br class=""><blockquote type="cite" class="">El 15 dic 2021, a la(s) 16:14, Joseph Jackson<span class="Apple-converted-space"> </span><a class="x_moz-txt-link-rfc2396E" href="mailto:jjackson@aninetworks.net" style="color: purple; text-decoration: underline;"><jjackson@aninetworks.net></a><span class="Apple-converted-space"> </span>escribió:<br class=""><br class=""></blockquote></div><blockquote type="cite" class=""><div dir="ltr" class=""><div class="x_WordSection1"><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(68, 84, 106);" class="">Did you also change the location of the socket file in the my.cnf?</span></div><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(68, 84, 106);" class=""> </span></p><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(68, 84, 106);" class=""> </span></p><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"><span style="font-size: 11pt; font-family: Calibri, sans-serif; color: rgb(68, 84, 106);" class=""> </span></p><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><b class=""><span style="font-size: 10pt; font-family: Tahoma, sans-serif;" class="">From:</span></b><span style="font-size: 10pt; font-family: Tahoma, sans-serif;" class=""><span class="Apple-converted-space"> </span>Users [<a class="x_moz-txt-link-freetext" href="mailto:users-bounces@lists.opensips.org" style="color: purple; text-decoration: underline;">mailto:users-bounces@lists.opensips.org</a>]<span class="Apple-converted-space"> </span><b class="">On Behalf Of<span class="Apple-converted-space"> </span></b>Mario San Vicente<br class=""><b class="">Sent:</b><span class="Apple-converted-space"> </span>Wednesday, December 15, 2021 11:27 AM<br class=""><b class="">To:</b><span class="Apple-converted-space"> </span>OpenSIPS users mailling list<br class=""><b class="">Subject:</b><span class="Apple-converted-space"> </span>[OpenSIPS-Users] how to change mysql data directory to CP</span></div><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">Hello Everyone,</div><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">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.</div></div><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">Getting the following error:</div></div><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><a href="http://x.x.x.x/cp/login.php" style="color: purple; text-decoration: underline;" class="">http://x.x.x.x/cp/login.php</a><br class=""><br class=""><span style="font-size: 13.5pt;" class="">Error!: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)</span></div></div><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class=""><span style="" class="">Any idea, where to update this?</span></div></div><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">Saludos!</div></div><div class=""><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p><div class=""><div class=""><div style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;" class="">Mario San Vicente</div></div><div class=""><p class="x_MsoNormal" style="margin: 0in 0in 0.0001pt; font-size: 12pt; font-family: "Times New Roman", serif;"> </p></div></div></div></div></div><span class="">_______________________________________________</span><br class=""><span class="">Users mailing list</span><br class=""><span class=""><a class="x_moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org" style="color: purple; text-decoration: underline;">Users@lists.opensips.org</a></span><br class=""><span class=""><a class="x_moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" style="color: purple; text-decoration: underline;">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></span><br class=""></div></blockquote></div><br class=""><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" style="color: purple; text-decoration: underline;">Users@lists.opensips.org</a>
<a class="x_moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" style="color: purple; text-decoration: underline;">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre></blockquote><br class=""></div></blockquote></div></div><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">_______________________________________________</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><span style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none; float: none; display: inline !important;" class="">Users mailing list</span><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="mailto:Users@lists.opensips.org" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">Users@lists.opensips.org</a><br style="caret-color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration: none;" class=""><a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" style="color: purple; text-decoration: underline; font-family: Helvetica; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px;" class="">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a></div></div><br class=""></div></body></html>