<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Good to remember the remark with multiple network interfaces and
issues to connect, thanks!<br>
<br>
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.<br>
<br>
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.<br>
<br>
Cheers,<br>
Daniel<br>
<br>
<div class="moz-cite-prefix">On 16/10/15 20:22, Ben Fitzgerald
wrote:<br>
</div>
<blockquote
cite="mid:CAFex5Q5sshcr_mr6sJ+GXEzgJbsLh=Jxpccfz9tXg=rv2qpzDA@mail.gmail.com"
type="cite">
<div dir="ltr">I had these errors randomly popup too I'm not sure
if you have the same issue but your description sounds similar.
<div><br>
</div>
<div>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.</div>
</div>
<div class="gmail_extra"><br clear="all">
<div>
<div class="gmail_signature">
<div dir="ltr">
<div style="font-family:Helvetica;font-size:medium">Benjamin
Fitzgerald</div>
<div style="font-family:Helvetica;font-size:medium">LETS
Corporation</div>
<div style="font-family:Helvetica;font-size:medium">(925)
235-1154</div>
<div style="font-family:Helvetica;font-size:medium"><span
style="text-align:-webkit-auto"><a
moz-do-not-send="true" href="mailto:ben@letscorp.us"
style="color:rgb(17,85,204)" target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:ben@letscorp.us">ben@letscorp.us</a></a></span></div>
<div style="font-family:Helvetica;font-size:medium"><br>
</div>
<div style="font-family:Helvetica;font-size:medium"><br>
</div>
<div><img moz-do-not-send="true"
src="https://drive.google.com/a/letscorp.us/uc?export=view&id=0BypXJ2tJXo79c0ZaNXJVUWFlMVk"><br>
</div>
<br style="font-family:Helvetica;font-size:medium">
<span style="font-family:Helvetica;font-size:medium">*******Confidential
Notice: </span><br
style="font-family:Helvetica;font-size:medium">
<span style="font-family:Helvetica;font-size:medium">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 </span><a moz-do-not-send="true"
value="+19255665600"
style="color:rgb(17,85,204);font-family:Helvetica;font-size:medium">(925)
566-5600</a><br>
</div>
</div>
</div>
<br>
<div class="gmail_quote">On Fri, Oct 16, 2015 at 7:11 AM, John
Billings <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:jandrewb@gmail.com" target="_blank">jandrewb@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div>Both boxes are running Debian 8.</div>
<div><br>
</div>
<div>I’m still looking at the mysql logs, but I haven’t
found anything relevant, yet.</div>
<span class="">
<div><br>
</div>
<div><br>
</div>
<div>
<blockquote type="cite">
<div>On Oct 14, 2015, at 5:00 AM, <a
moz-do-not-send="true"
href="mailto:sr-users-request@lists.sip-router.org"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:sr-users-request@lists.sip-router.org">sr-users-request@lists.sip-router.org</a></a>
wrote:</div>
<br>
<div><span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">Hello,</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">do
you have centos+selinux? Because I heard about a
lot of limits with</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">the
combination of the two.</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">Have
you checked the mysqld syslog messages, anything
relevant there?</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">Cheers,</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<span
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">Daniel</span><br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<br
style="font-family:Helvetica;font-size:12px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
</div>
</blockquote>
</div>
<br>
</span></div>
<br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users
mailing list<br>
<a moz-do-not-send="true"
href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a moz-do-not-send="true"
href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users"
rel="noreferrer" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
<br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a>
<a class="moz-txt-link-freetext" href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a>
</pre>
</blockquote>
<br>
<pre class="moz-signature" cols="72">--
Daniel-Constantin Mierla
<a class="moz-txt-link-freetext" href="http://twitter.com/#!/miconda">http://twitter.com/#!/miconda</a> - <a class="moz-txt-link-freetext" href="http://www.linkedin.com/in/miconda">http://www.linkedin.com/in/miconda</a>
Book: SIP Routing With Kamailio - <a class="moz-txt-link-freetext" href="http://www.asipto.com">http://www.asipto.com</a></pre>
</body>
</html>