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> 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> 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@lists.kamailio.org
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users