[SR-Users] MySQL Connect Errors

[Daniel-Constantin Mierla]

Good to remember the remark with multiple network interfaces and issues
to connect, thanks!

Just to add that connecting to mysql server is done from inside
libmysqlclient. However, is the kernel that decides the local socket for
that connection, so if there are routes to mysql server ip from many
network interface, then the kernel can select any of them.

On the other hand, my.cnf has a section for client configuration, maybe
there are options to set local network interface to be used for
connecting -- worth checking mysql manual, eventually.

Cheers,
Daniel

On 16/10/15 20:22, Ben Fitzgerald wrote:
> I had these errors randomly popup too I'm not sure if you have the
> same issue but your description sounds similar.
>
> My issue was related to my MySQL server having multiple network
> interfaces with one configured public and one private and these
> connection errors were a result of how I set up the mysql user. I had
> it set up as kamailio@'private.ip' but kamailio was actually
> attempting connection to the public IP (which was not authorized). If
> you have multiple network interfaces I would suggest checking
> kamailio.cfg and the user set up to access mysql and verify your
> IP's/hostnames and maybe even verify on both boxes what interfaces the
> connections our going out/coming in on.
>
> Benjamin Fitzgerald
> LETS Corporation
> (925) 235-1154
> ben at letscorp.us <mailto:ben at letscorp.us>
>
>
>
>
> *******Confidential Notice: 
> This message is intended only for the use of the individual or entity
> to which it is addressed and may contain information that is
> privileged, confidential and exempt from disclosure under applicable
> law. If the reader of this message is not the intended recipient, you
> are hereby notified that any dissemination, distribution or copying of
> this communication is strictly prohibited. If you have received this
> message in error, please delete this message from all computers and
> contact Orion Systems/LETS Corp immediately by return e-mail and/or
> telephone at (925) 566-5600
>
> On Fri, Oct 16, 2015 at 7:11 AM, John Billings <jandrewb at gmail.com
> <mailto:jandrewb at gmail.com>> wrote:
>
>     Both boxes are running Debian 8.
>
>     I’m still looking at the mysql logs, but I haven’t found anything
>     relevant, yet.
>
>
>>     On Oct 14, 2015, at 5:00 AM,
>>     sr-users-request at lists.sip-router.org
>>     <mailto:sr-users-request at lists.sip-router.org> wrote:
>>
>>     Hello,
>>
>>     do you have centos+selinux? Because I heard about a lot of limits
>>     with
>>     the combination of the two.
>>
>>     Have you checked the mysqld syslog messages, anything relevant there?
>>
>>     Cheers,
>>     Daniel
>>
>
>
>     _______________________________________________
>     SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing
>     list
>     sr-users at lists.sip-router.org <mailto:sr-users at lists.sip-router.org>
>     http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
>
>
>
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Book: SIP Routing With Kamailio - http://www.asipto.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20151020/cdc54766/attachment.html>