Re: [SR-Users] Can't connect to db
On 9/10/19 5:43 PM, Andrew Chen wrote: > Hi all, > ... > 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 > Looks like you have a connections setting issue on the DB... try increasing it. --fred ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
Re: [SR-Users] Can't connect to db
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 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: > [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: > [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/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@ 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.* ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users
[SR-Users] Can't connect to db
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: [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: [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/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 -- *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.* ___ Kamailio (SER) - Users Mailing List sr-users@lists.kamailio.org https://lists.kamailio.org/cgi-bin/mailman/listinfo/sr-users