<div dir="ltr">Sorry..ignore this.  Found the issue.  The max connection setting on the RDS was too low.<div><br></div><div>Thanks</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Sep 10, 2019 at 5:43 PM Andrew Chen <<a href="mailto:achen@fuze.com">achen@fuze.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Hi all,<div>I just installed kamailio 5.2.4 on two separate aws instances in two separate regions.  Both regions uses the same configuration template and share the same db in AWS RDS.  The issue I see is this:</div><div>- SJO location was able to launch fine without any issues.</div><div>- ASH location could not start up kamailio process due to db connection failure:</div><div><br></div><div>





<p class="gmail-m_-5557174500060819861gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(223,223,223)"><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">Sep 10 </span><span class="gmail-m_-5557174500060819861gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">21:24:13 </span><span class="gmail-m_-5557174500060819861gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(56,185,199)">ashmainkama51 </span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">/usr/sbin/kamailio[</span><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">8043</span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">]: </span><span class="gmail-m_-5557174500060819861gmail-s5" style="font-variant-ligatures:no-common-ligatures;background-color:rgb(133,0,2)">ERROR: db_mysql [km_my_con.c:139]: db_mysql_new_connection(): driver error: Too many connections</span></p>
<p class="gmail-m_-5557174500060819861gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(223,223,223)"><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">Sep 10 </span><span class="gmail-m_-5557174500060819861gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">21:24:13 </span><span class="gmail-m_-5557174500060819861gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(56,185,199)">ashmainkama51 </span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">/usr/sbin/kamailio[</span><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">8043</span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">]: </span><span class="gmail-m_-5557174500060819861gmail-s5" style="font-variant-ligatures:no-common-ligatures;background-color:rgb(133,0,2)">ERROR: <core> [db.c:319]: db_do_init2(): could not add connection to the pool</span></p>
<p class="gmail-m_-5557174500060819861gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(223,223,223)"><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">Sep 10 </span><span class="gmail-m_-5557174500060819861gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">21:24:13 </span><span class="gmail-m_-5557174500060819861gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(56,185,199)">ashmainkama51 </span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">/usr/sbin/kamailio[</span><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">8045</span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">]: </span><span class="gmail-m_-5557174500060819861gmail-s5" style="font-variant-ligatures:no-common-ligatures;background-color:rgb(133,0,2)">ERROR: db_mysql [km_my_con.c:139]: db_mysql_new_connection(): driver error: Too many connections</span></p>
<p class="gmail-m_-5557174500060819861gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(223,223,223)"><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">Sep 10 </span><span class="gmail-m_-5557174500060819861gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">21:24:13 </span><span class="gmail-m_-5557174500060819861gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(56,185,199)">ashmainkama51 </span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">/usr/sbin/kamailio[</span><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">8045</span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">]: </span><span class="gmail-m_-5557174500060819861gmail-s5" style="font-variant-ligatures:no-common-ligatures;background-color:rgb(133,0,2)">ERROR: <core> [db.c:319]: db_do_init2(): could not add connection to the pool</span></p>
<p class="gmail-m_-5557174500060819861gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(223,223,223)"><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">Sep 10 </span><span class="gmail-m_-5557174500060819861gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">21:24:13 </span><span class="gmail-m_-5557174500060819861gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(56,185,199)">ashmainkama51 </span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">/usr/sbin/kamailio[</span><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">8045</span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">]: </span><span class="gmail-m_-5557174500060819861gmail-s5" style="font-variant-ligatures:no-common-ligatures;background-color:rgb(133,0,2)">ERROR: carrierroute [db_carrierroute.c:141]: carrierroute_db_open(): can't connect to database.</span></p>
<p class="gmail-m_-5557174500060819861gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-stretch:normal;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(223,223,223)"><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">Sep 10 </span><span class="gmail-m_-5557174500060819861gmail-s2" style="font-variant-ligatures:no-common-ligatures;color:rgb(57,192,38)">21:24:13 </span><span class="gmail-m_-5557174500060819861gmail-s3" style="font-variant-ligatures:no-common-ligatures;color:rgb(56,185,199)">ashmainkama51 </span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">/usr/sbin/kamailio[</span><span class="gmail-m_-5557174500060819861gmail-s1" style="font-variant-ligatures:no-common-ligatures;color:rgb(202,51,35)">8045</span><span class="gmail-m_-5557174500060819861gmail-s4" style="font-variant-ligatures:no-common-ligatures;color:rgb(209,113,37)">]: </span><span class="gmail-m_-5557174500060819861gmail-s5" style="font-variant-ligatures:no-common-ligatures;background-color:rgb(133,0,2)">ERROR: <core> [core/sr_module.c:847]: init_mod_child(): error while initializing module carrierroute (/usr/lib/x86_64-linux-gnu/kamailio/modules/carrierroute.so) (idx: 30 rank: 18 desc: [tcp receiver (generic) child=9])</span></p></div><div><div><br></div><div>- In ASH instance, I can manually mysql to the RDS host using the credentials in the config file.</div><div>- I checked db user permissions and it's opened for the subnet in our ASH location (which is also proven using manual connection).</div><div><br></div><div>So I don't get why one works and the other doesn't</div><div><br></div><div>Thoughts?</div><div><br></div>-- <br><div dir="ltr" class="gmail-m_-5557174500060819861gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr" style="font-size:12.8px">Andy Chen</div><div dir="ltr" style="font-size:12.8px"><div>Sr. Telephony Lead Engineer</div><div><br></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div dir="ltr" style="font-size:12.8px">Andy Chen</div><div dir="ltr" style="font-size:12.8px"><div>Sr. Telephony Lead Engineer</div><div>415 516 5535 (M)</div><div><a href="mailto:achen@thinkingphones.com" target="_blank">achen@</a><a href="http://fuze.com" target="_blank">fuze.com</a></div><div><br></div></div></div></div></div></div>

<br>
<span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">*Confidentiality Notice: The information contained in this e-mail and any</span><br style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">attachments may be confidential. If you are not an intended recipient, you</span><br style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">are hereby notified that any dissemination, distribution or copying of this</span><br style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">e-mail is strictly prohibited. If you have received this e-mail in error,</span><br style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">please notify the sender and permanently delete the e-mail and any</span><br style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">attachments immediately. You should not retain, copy or use this e-mail or</span><br style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">any attachment for any purpose, nor disclose all or any part of the</span><br style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)"><span style="color:rgb(51,51,51);font-family:Arial,sans-serif;font-size:14px;background-color:rgb(255,255,255)">contents to any other person. Thank you.*</span>