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 <jo...@democon.be> wrote: Do cd / Locate db.inc.php Outlook voor iOS <https://aka.ms/o0ukef> downloaden Van: Users <users-boun...@lists.opensips.org <mailto:users-boun...@lists.opensips.org>> namens mrsanvicente <mrsanvice...@gmail.com <mailto:mrsanvice...@gmail.com>> Verzonden: Wednesday, December 29, 2021 2:51:07 AM Aan: Bogdan-Andrei Iancu <bog...@opensips.org <mailto:bog...@opensips.org>> CC: OpenSIPS users mailling list <users@lists.opensips.org <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 <bog...@opensips.org > <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 <jjack...@aninetworks.net> >>> <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
