[OpenSIPS-Users] how to change mysql data directory to CP

[Johan De Clercq]

Do cd /
Locate db.inc.php

Outlook voor iOS<https://aka.ms/o0ukef> downloaden
________________________________
Van: Users <users-bounces at lists.opensips.org> namens mrsanvicente <mrsanvicente at gmail.com>
Verzonden: Wednesday, December 29, 2021 2:51:07 AM
Aan: Bogdan-Andrei Iancu <bogdan at opensips.org>
CC: OpenSIPS users mailling list <users at lists.opensips.org>
Onderwerp: Re: [OpenSIPS-Users] how to change mysql data directory to CP

Hello Bogdan-Andrei / All,

Sorry for the delay.  I just didn’t find a path or var to modify in  db.inc.php.


But later after a reboot, opensips stop working because it could not find the new path to the db.

So the source of the problem might be,  how to change path to mysql to opensips.
 Thanks
Saludos
Mario San Vicente


El 17 dic 2021, a la(s) 9:16, Bogdan-Andrei Iancu <bogdan at opensips.org> escribió:

 You need to update the DB settings in this file:

https://github.com/OpenSIPS/opensips-cp/blob/master/config/db.inc.php

Regards,

Bogdan-Andrei Iancu

OpenSIPS Founder and Developer
  https://www.opensips-solutions.com
OpenSIPS eBootcamp 2021
  https://opensips.org/training/OpenSIPS_eBootcamp_2021/

On 12/16/21 1:52 AM, mrsanvicente wrote:
Yes i did.   And restarted mysqld and httpd.  But still not working.


Thanks

Mario San Vicente


El 15 dic 2021, a la(s) 16:14, Joseph Jackson <jjackson at aninetworks.net><mailto:jjackson at aninetworks.net> escribió:



Did you also change the location of the socket file in the my.cnf?







From: Users [mailto:users-bounces at lists.opensips.org] On Behalf Of Mario San Vicente
Sent: Wednesday, December 15, 2021 11:27 AM
To: OpenSIPS users mailling list
Subject: [OpenSIPS-Users] how to change mysql data directory to CP



Hello Everyone,



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.



Getting the following error:





http://x.x.x.x/cp/login.php

Error!: SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)



Any idea, where to update this?



Saludos!





Mario San Vicente



_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



_______________________________________________
Users mailing list
Users at lists.opensips.org<mailto:Users at lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20211229/1b138e61/attachment-0001.html>