Re: [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 <mailto:jo...@democon.be>> wrote:


Do cd /
Locate db.inc.php

Outlook voor iOS <https://aka.ms/o0ukef>downloaden

*Van:*Users <mailto:users-boun...@lists.opensips.org>> namens mrsanvicente 
mailto:mrsanvice...@gmail.com>>

*Verzonden:*Wednesday, December 29, 2021 2:51:07 AM
*Aan:*Bogdan-Andrei Iancu <mailto:bog...@opensips.org>>
*CC:*OpenSIPS users mailling list <mailto:users@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 
mailto:bog...@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 
<mailto:jjack...@aninetworks.net>escribió:



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

*From:*Users [mailto:users-boun...@lists.opensips.org 
<mailto:users-boun...@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@lists.opensips.org <mailto:Users@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@lists.opensips.org  <mailto:Users@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@lists.opensips.org <mailto:Users@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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [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  wrote:

Do cd /
Locate db.inc.php

Outlook voor iOS <https://aka.ms/o0ukef> downloaden
Van: Users mailto:users-boun...@lists.opensips.org>> namens mrsanvicente 
mailto:mrsanvice...@gmail.com>>
Verzonden: Wednesday, December 29, 2021 2:51:07 AM
Aan: Bogdan-Andrei Iancu mailto:bog...@opensips.org>>
CC: OpenSIPS users mailling list mailto:users@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  <mailto:bog...@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  
>>> <mailto:jjack...@aninetworks.net> escribió:
>>> 
>>> 
>>> Did you also change the location of the socket file in the my.cnf?
>>>  
>>>  
>>>  
>>> From: Users [mailto:users-boun...@lists.opensips.org 
>>> <mailto:users-boun...@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@lists.opensips.org <mailto:Users@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@lists.opensips.org <mailto:Users@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@lists.opensips.org <mailto:Users@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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [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  namens mrsanvicente 

Verzonden: Wednesday, December 29, 2021 2:51:07 AM
Aan: Bogdan-Andrei Iancu 
CC: OpenSIPS users mailling list 
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  
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 
<mailto:jjack...@aninetworks.net> escribió:



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







From: Users [mailto:users-boun...@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@lists.opensips.org<mailto:Users@lists.opensips.org>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users



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


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Re: [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  
> 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  
>>> escribió:
>>> 
>>> 
>>> Did you also change the location of the socket file in the my.cnf?
>>>  
>>>  
>>>  
>>> From: Users [mailto:users-boun...@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@lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>> 
>> 
>> ___
>> Users mailing list
>> Users@lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
> 
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

[Bogdan-Andrei Iancu]

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 
 escribió:




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

*From:*Users [mailto:users-boun...@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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users


___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

[Johan De Clercq]

Isn't there a ...db.inc.php?

On Thu, Dec 16, 2021, 00:56 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 
> escribió:
>
> 
>
> Did you also change the location of the socket file in the my.cnf?
>
>
>
>
>
>
>
> *From:* Users [mailto:users-boun...@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@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
> ___
> Users mailing list
> Users@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

[mrsanvicente]

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  
> escribió:
> 
> 
> Did you also change the location of the socket file in the my.cnf?
>  
>  
>  
> From: Users [mailto:users-boun...@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@lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
___
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

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

[Joseph Jackson]

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



From: Users [mailto:users-boun...@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@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users