Hi,
Looking at your message, I checked again the installation and mainly the symlink I had created for Kamailio to get the socket file.
For some reason, this link were corrupted. Hereafter what was the issue:
The initial symlink for the socket file was : ln -s /myqdata/mysiprdb/data/mysiprdb.sock /var/lib/mysql/mysql.sock
But actually a locate command : returns strange
locate *.sock
/myqdata/mysiprdb/data/mysiprdb.sock
/var/lib/gssproxy/default.sock
/var/lib/mysql/mysql.sock
/var/lib/mysql/mysql.sock/mysiprdb.sock
The “/var/lib/mysql/mysql.sock/mysiprdb.sock” doesn’t make sense here.
And the “/var/lib/mysql/mysql.sock” was actually a directoty
[root@in52inmvt2router1 ~]# ll /var/lib/mysql/
total 4
drwx------ 2 root root 4096 Sep 4 10:21 mysql.sock
Removing all of these files/directories, then recreate the symlink have fixed the issue.
Thanks everybody for your ideas of things to check..
Cordialement.
Patrick GINHOUX
Unisys | +33 1 46 69 52 12 | +33 6 60 32 24 74 | patrick.ginhoux@unisys.com
De : David Villasmil david.villasmil.work@gmail.com Envoyé : mardi 4 septembre 2018 09:41 À : Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org Cc : Ginhoux, Patrick patrick.ginhoux@fr.unisys.com Objet : Re: [SR-Users] Can't connect to local MySQL server (13 "Permission denied")
You should paste your failing cfg line.
On Tue, Sep 4, 2018, 08:39 David Villasmil <david.villasmil.work@gmail.com mailto:david.villasmil.work@gmail.com > wrote:
Make sure the password is correct and try with "localhost" and if that doesn't work, try with 127.0.0.1
On Tue, Sep 4, 2018, 07:35 Henning Westerholt <hw@kamailio.org mailto:hw@kamailio.org > wrote:
Am Freitag, 31. August 2018, 21:01:13 CEST schrieb Ginhoux, Patrick:
Usually I connect on a command line like this ;
su- mysql
mysql
use siprouter;
If now I use
mysql -u siprouter -p
Enter password:
mysql:siprouter:(none)> use siprouter;
Database changed
So I can connect the local server.
Hello Patrick,
just some ideas to help you troubleshoot the problem:
- maybe there is an issue with the socket file, that kamailio uses the wrong socket file? - maybe kamailio don't have file system access rights to the socket file? - maybe there is a mistake in the kamailio cfg or an old cfg file is used? - enable mysql server logging and try to spot something in the log during the kamailio start
Best regards,
Henning