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

[mrsanvicente]

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> 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
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> 
>> 
>> _______________________________________________
>> Users mailing list
>> 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/20211228/46e4e63f/attachment.html>