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 <[email protected]> wrote: Do cd / Locate db.inc.php Outlook voor iOS <https://aka.ms/o0ukef> downloaden Van: Users <[email protected] <mailto:[email protected]>> namens mrsanvicente <[email protected] <mailto:[email protected]>> Verzonden: Wednesday, December 29, 2021 2:51:07 AM Aan: Bogdan-Andrei Iancu <[email protected] <mailto:[email protected]>> CC: OpenSIPS users mailling list <[email protected] <mailto:[email protected]>> 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 <[email protected] > <mailto:[email protected]>> 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 <[email protected]> >>> <mailto:[email protected]> escribió: >>> >>> >>> Did you also change the location of the socket file in the my.cnf? >>> >>> >>> >>> From: Users [mailto:[email protected] >>> <mailto:[email protected]>] 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 >>> [email protected] <mailto:[email protected]> >>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >>> <http://lists.opensips.org/cgi-bin/mailman/listinfo/users> >> >> >> _______________________________________________ >> Users mailing list >> [email protected] <mailto:[email protected]> >> http://lists.opensips.org/cgi-bin/mailman/listinfo/users >> <http://lists.opensips.org/cgi-bin/mailman/listinfo/users> > _______________________________________________ Users mailing list [email protected] <mailto:[email protected]> http://lists.opensips.org/cgi-bin/mailman/listinfo/users <http://lists.opensips.org/cgi-bin/mailman/listinfo/users>
_______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
