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(a)unisys.com
De : David Villasmil <david.villasmil.work(a)gmail.com>
Envoyé : mardi 4 septembre 2018 09:41
À : Kamailio (SER) - Users Mailing List <sr-users(a)lists.kamailio.org>
Cc : Ginhoux, Patrick <patrick.ginhoux(a)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(a)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(a)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
--
Henning Westerholt
https://skalatan.de/blog/
_______________________________________________
Kamailio (SER) - Users Mailing List
sr-users(a)lists.kamailio.org <mailto:sr-users@lists.kamailio.org>
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users