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

[Bogdan-Andrei Iancu]

Hi there, and Happy New Year.

Let's clarify on what version of CP you are using - is is the master 
branch? or the 8.3.2 branch ?

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/29/21 1:42 PM, Tomi Hakkarainen wrote:
> 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 
> <mailto: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/20220103/de949368/attachment-0001.html>