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

[Tomi Hakkarainen]

Hi, 


I second Mario.

Its not so simple…. With these instructions provided to this thread.

There is no that kind of config on the file db.inc.php

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.

Tomi


On 29. Dec 2021, at 12.37, Johan De Clercq <johan at democon.be> wrote:

Do cd /
Locate db.inc.php

Outlook voor iOS <https://aka.ms/o0ukef> downloaden
Van: Users <users-bounces at lists.opensips.org <mailto:users-bounces at lists.opensips.org>> namens mrsanvicente <mrsanvicente at gmail.com <mailto:mrsanvicente at gmail.com>>
Verzonden: Wednesday, December 29, 2021 2:51:07 AM
Aan: Bogdan-Andrei Iancu <bogdan at opensips.org <mailto:bogdan at opensips.org>>
CC: OpenSIPS users mailling list <users at lists.opensips.org <mailto: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 <mailto: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 <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 <https://www.opensips-solutions.com/>
> OpenSIPS eBootcamp 2021 
>   https://opensips.org/training/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 <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 <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 <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 <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 <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/f44c8eaa/attachment.html>