[SR-Users] Can't connect to local MySQL server (13 "Permission denied")
Ginhoux, Patrick
patrick.ginhoux at fr.unisys.com
Tue Sep 4 10:43:38 CEST 2018
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 at 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 at unisys.com
De : David Villasmil <david.villasmil.work at gmail.com>
Envoyé : mardi 4 septembre 2018 09:41
À : Kamailio (SER) - Users Mailing List <sr-users at lists.kamailio.org>
Cc : Ginhoux, Patrick <patrick.ginhoux at 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 at gmail.com <mailto:david.villasmil.work at 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 at kamailio.org <mailto:hw at 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 at lists.kamailio.org <mailto:sr-users at lists.kamailio.org>
https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180904/24ea9053/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 7876 bytes
Desc: not available
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20180904/24ea9053/attachment.bin>
More information about the sr-users
mailing list