[SR-Users] Can't connect to db

[Andrew Chen]

Sorry..ignore this.  Found the issue.  The max connection setting on the
RDS was too low.

Thanks

On Tue, Sep 10, 2019 at 5:43 PM Andrew Chen <achen at fuze.com> wrote:

> Hi all,
> 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:
> - SJO location was able to launch fine without any issues.
> - ASH location could not start up kamailio process due to db connection
> failure:
>
> Sep 10 21:24:13 ashmainkama51 /usr/sbin/kamailio[8043]: ERROR: db_mysql
> [km_my_con.c:139]: db_mysql_new_connection(): driver error: Too many
> connections
>
> Sep 10 21:24:13 ashmainkama51 /usr/sbin/kamailio[8043]: ERROR: <core>
> [db.c:319]: db_do_init2(): could not add connection to the pool
>
> Sep 10 21:24:13 ashmainkama51 /usr/sbin/kamailio[8045]: ERROR: db_mysql
> [km_my_con.c:139]: db_mysql_new_connection(): driver error: Too many
> connections
>
> Sep 10 21:24:13 ashmainkama51 /usr/sbin/kamailio[8045]: ERROR: <core>
> [db.c:319]: db_do_init2(): could not add connection to the pool
>
> Sep 10 21:24:13 ashmainkama51 /usr/sbin/kamailio[8045]: ERROR:
> carrierroute [db_carrierroute.c:141]: carrierroute_db_open(): can't connect
> to database.
>
> Sep 10 21:24:13 ashmainkama51 /usr/sbin/kamailio[8045]: 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])
>
> - In ASH instance, I can manually mysql to the RDS host using the
> credentials in the config file.
> - I checked db user permissions and it's opened for the subnet in our ASH
> location (which is also proven using manual connection).
>
> So I don't get why one works and the other doesn't
>
> Thoughts?
>
> --
> Andy Chen
> Sr. Telephony Lead Engineer
>
>

-- 
Andy Chen
Sr. Telephony Lead Engineer
415 516 5535 (M)
achen@ <achen at thinkingphones.com>fuze.com

-- 
*Confidentiality Notice: The information contained in this e-mail and any

attachments may be confidential. If you are not an intended recipient, you

are hereby notified that any dissemination, distribution or copying of this

e-mail is strictly prohibited. If you have received this e-mail in error,

please notify the sender and permanently delete the e-mail and any

attachments immediately. You should not retain, copy or use this e-mail or

any attachment for any purpose, nor disclose all or any part of the

contents to any other person. Thank you.*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.kamailio.org/pipermail/sr-users/attachments/20190910/d19c9941/attachment.html>