I got those errors recently from our freeswitch server [ERR] mod_commands.c:4063 Error connecting [ERR] sofia_glue.c:6464 Error connecting [ERR] sofia_glue.c:6504 Error Opening DB [WARNING] sofia_glue.c:6464 Max handles 50 What does this means? I have load recently the mod_xml_rpc is this relate with our issue? Also how I can check the correct open DB open connections ? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com<mailto:AHadjiefstathiou@IronFX.com> IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com<http://www.IronFX.com> [cid:image001.jpg@01D00F1C.1FC46550]<https://www.facebook.com/IronFX> [cid:image002.gif@01D00F1C.1FC46550] <https://twitter.com/ironfxglobal> [cid:image003.gif@01D00F1C.1FC46550] <http://www.youtube.com/ironfxmarketing> [cid:image004.gif@01D00F1C.1FC46550] <http://blog.ironfx.com/> [cid:image005.gif@01D00F1C.1FC46550] <http://www.linkedin.com/company/ironfxglobal> [cid:image006.gif@01D00F1C.1FC46550] <https://plus.google.com/+Ironfxglobal> London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol [cid:image007.jpg@01D00F1C.1FC46550] ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- This email has been sent from IronFX Global Limited. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Consider the environment before printing this email.
I got those errors recently from our freeswitch server 2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6376 Error connecting 2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6416 Error Opening DB 2014-11-28 21:19:19.806910 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking.... 2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6376 Error connecting 2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6416 Error Opening DB 2014-11-28 21:19:21.476882 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking.... What does this means? I have load recently the mod_xml_rpc is this relate with our issue? Also how I can check the correct open DB open connections ? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com<mailto:AHadjiefstathiou@IronFX.com> IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com<http://www.IronFX.com> [cid:image001.jpg@01D00F20.26E275D0]<https://www.facebook.com/IronFX> [cid:image002.gif@01D00F20.26E275D0] <https://twitter.com/ironfxglobal> [cid:image003.gif@01D00F20.26E275D0] <http://www.youtube.com/ironfxmarketing> [cid:image004.gif@01D00F20.26E275D0] <http://blog.ironfx.com/> [cid:image005.gif@01D00F20.26E275D0] <http://www.linkedin.com/company/ironfxglobal> [cid:image006.gif@01D00F20.26E275D0] <https://plus.google.com/+Ironfxglobal> London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol [cid:image007.jpg@01D00F20.26E275D0] ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- Consider the environment before printing this email. From: Andri Hadjiefstathiou [IronFX Global] Sent: Wednesday, December 03, 2014 5:11 PM To: 'freeswitch-users@lists.freeswitch.org' Subject: Freeswitch I got those errors recently from our freeswitch server [ERR] mod_commands.c:4063 Error connecting [ERR] sofia_glue.c:6464 Error connecting [ERR] sofia_glue.c:6504 Error Opening DB [WARNING] sofia_glue.c:6464 Max handles 50 What does this means? I have load recently the mod_xml_rpc is this relate with our issue? Also how I can check the correct open DB open connections ? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com<mailto:AHadjiefstathiou@IronFX.com> IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com<http://www.IronFX.com> [cid:image001.jpg@01D00F20.26E275D0]<https://www.facebook.com/IronFX> [cid:image002.gif@01D00F20.26E275D0] <https://twitter.com/ironfxglobal> [cid:image003.gif@01D00F20.26E275D0] <http://www.youtube.com/ironfxmarketing> [cid:image004.gif@01D00F20.26E275D0] <http://blog.ironfx.com/> [cid:image005.gif@01D00F20.26E275D0] <http://www.linkedin.com/company/ironfxglobal> [cid:image006.gif@01D00F20.26E275D0] <https://plus.google.com/+Ironfxglobal> London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol [cid:image007.jpg@01D00F20.26E275D0] ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- This email has been sent from IronFX Global Limited. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Consider the environment before printing this email.
Check your sofia profile(s)- it has the database settings in there (dbname, odbc-dsn, db-*) . Then, verify your database is running and can accept connections. On Wed, Dec 3, 2014 at 10:39 AM, Andri Hadjiefstathiou [IronFX Global] < AHadjiefstathiou@ironfx.com> wrote:
I got those errors recently from our freeswitch server
2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6376 Error connecting
2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6416 Error Opening DB
2014-11-28 21:19:19.806910 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking....
2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6376 Error connecting
2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6416 Error Opening DB
2014-11-28 21:19:21.476882 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking....
What does this means?
I have load recently the mod_xml_rpc is this relate with our issue?
Also how I can check the correct open DB open connections ?
*Andri* *Hadjiefstathiou* | Network and Security Engineer *t *+357 25027607 | *m *+357 96860600 | *e* AHadjiefstathiou@IronFX.com
*IronFX Global Limited t* +357 25027000 | *f* +357 25027001 | *w * www.IronFX.com
<https://www.facebook.com/IronFX> <https://twitter.com/ironfxglobal> <http://www.youtube.com/ironfxmarketing> <http://blog.ironfx.com/> <http://www.linkedin.com/company/ironfxglobal> <https://plus.google.com/+Ironfxglobal>
*London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol*
----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)
IronFX Global Limited is a Member of Eurex Exchange
-----------------------------------------------------------------------------------------------------------------------
*Consider the environment before printing this email.*
*From:* Andri Hadjiefstathiou [IronFX Global] *Sent:* Wednesday, December 03, 2014 5:11 PM *To:* 'freeswitch-users@lists.freeswitch.org' *Subject:* Freeswitch
I got those errors recently from our freeswitch server
[ERR] mod_commands.c:4063 Error connecting
[ERR] sofia_glue.c:6464 Error connecting
[ERR] sofia_glue.c:6504 Error Opening DB
[WARNING] sofia_glue.c:6464 Max handles 50
What does this means?
I have load recently the mod_xml_rpc is this relate with our issue?
Also how I can check the correct open DB open connections ?
*Andri* *Hadjiefstathiou* | Network and Security Engineer *t *+357 25027607 | *m *+357 96860600 | *e* AHadjiefstathiou@IronFX.com
*IronFX Global Limited t* +357 25027000 | *f* +357 25027001 | *w * www.IronFX.com
<https://www.facebook.com/IronFX> <https://twitter.com/ironfxglobal> <http://www.youtube.com/ironfxmarketing> <http://blog.ironfx.com/> <http://www.linkedin.com/company/ironfxglobal> <https://plus.google.com/+Ironfxglobal>
*London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol*
----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)
IronFX Global Limited is a Member of Eurex Exchange
-----------------------------------------------------------------------------------------------------------------------
*This email has been sent from IronFX Global Limited. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.*
*Consider the environment before printing this email.*
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
After we restart the server all fine. But I want to know the root of the problem.. why we got this error??? Recently I have enable mod_xml_rpc is this relate with our issue? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com<mailto:AHadjiefstathiou@IronFX.com> IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com<http://www.IronFX.com> [cid:image001.jpg@01D00F23.751A8A50]<https://www.facebook.com/IronFX> [cid:image002.gif@01D00F23.751A8A50] <https://twitter.com/ironfxglobal> [cid:image003.gif@01D00F23.751A8A50] <http://www.youtube.com/ironfxmarketing> [cid:image004.gif@01D00F23.751A8A50] <http://blog.ironfx.com/> [cid:image005.gif@01D00F23.751A8A50] <http://www.linkedin.com/company/ironfxglobal> [cid:image006.gif@01D00F23.751A8A50] <https://plus.google.com/+Ironfxglobal> London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol [cid:image007.jpg@01D00F23.751A8A50] ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- Consider the environment before printing this email. From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Christopher Rienzo Sent: Wednesday, December 03, 2014 6:00 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Freeswitch Check your sofia profile(s)- it has the database settings in there (dbname, odbc-dsn, db-*) . Then, verify your database is running and can accept connections. On Wed, Dec 3, 2014 at 10:39 AM, Andri Hadjiefstathiou [IronFX Global] <AHadjiefstathiou@ironfx.com<mailto:AHadjiefstathiou@ironfx.com>> wrote: I got those errors recently from our freeswitch server 2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6376 Error connecting 2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6416 Error Opening DB 2014-11-28 21:19:19.806910 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking.... 2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6376 Error connecting 2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6416 Error Opening DB 2014-11-28 21:19:21.476882 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking.... What does this means? I have load recently the mod_xml_rpc is this relate with our issue? Also how I can check the correct open DB open connections ? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607<tel:%2B357%2025027607> | m +357 96860600<tel:%2B357%2096860600> | e AHadjiefstathiou@IronFX.com<mailto:AHadjiefstathiou@IronFX.com> IronFX Global Limited t +357 25027000<tel:%2B357%2025027000> | f +357 25027001<tel:%2B357%2025027001> | w www.IronFX.com<http://www.IronFX.com> <https://www.facebook.com/IronFX> London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- Consider the environment before printing this email. From: Andri Hadjiefstathiou [IronFX Global] Sent: Wednesday, December 03, 2014 5:11 PM To: 'freeswitch-users@lists.freeswitch.org' Subject: Freeswitch I got those errors recently from our freeswitch server [ERR] mod_commands.c:4063 Error connecting [ERR] sofia_glue.c:6464 Error connecting [ERR] sofia_glue.c:6504 Error Opening DB [WARNING] sofia_glue.c:6464 Max handles 50 What does this means? I have load recently the mod_xml_rpc is this relate with our issue? Also how I can check the correct open DB open connections ? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- This email has been sent from IronFX Global Limited. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Consider the environment before printing this email. _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
I don't have any ideas for this particular issue other than general db connection troubleshooting tips. Are you using SQLite or odbc w/ mysql or postgresql? Are database handles being released? Is a new long / inefficient query consuming all your connections? Does the issue go away if you disable mod_xml_rpc? Find out these things to troubleshoot your issue. Also- I noticed you are running an old version of FS based on the line numbers in your logs, so your likelihood of getting free support is not good. On Wed, Dec 3, 2014 at 11:03 AM, Andri Hadjiefstathiou [IronFX Global] < AHadjiefstathiou@ironfx.com> wrote:
After we restart the server all fine.
But I want to know the root of the problem.. why we got this error???
Recently I have enable mod_xml_rpc is this relate with our issue?
*Andri* *Hadjiefstathiou* | Network and Security Engineer *t *+357 25027607 | *m *+357 96860600 | *e* AHadjiefstathiou@IronFX.com
*IronFX Global Limited t* +357 25027000 | *f* +357 25027001 | *w * www.IronFX.com
<https://www.facebook.com/IronFX> <https://twitter.com/ironfxglobal> <http://www.youtube.com/ironfxmarketing> <http://blog.ironfx.com/> <http://www.linkedin.com/company/ironfxglobal> <https://plus.google.com/+Ironfxglobal>
*London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol*
----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)
IronFX Global Limited is a Member of Eurex Exchange
-----------------------------------------------------------------------------------------------------------------------
*Consider the environment before printing this email.*
*From:* freeswitch-users-bounces@lists.freeswitch.org [mailto: freeswitch-users-bounces@lists.freeswitch.org] *On Behalf Of *Christopher Rienzo *Sent:* Wednesday, December 03, 2014 6:00 PM *To:* FreeSWITCH Users Help *Subject:* Re: [Freeswitch-users] Freeswitch
Check your sofia profile(s)- it has the database settings in there (dbname, odbc-dsn, db-*) . Then, verify your database is running and can accept connections.
On Wed, Dec 3, 2014 at 10:39 AM, Andri Hadjiefstathiou [IronFX Global] < AHadjiefstathiou@ironfx.com> wrote:
I got those errors recently from our freeswitch server
2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6376 Error connecting
2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6416 Error Opening DB
2014-11-28 21:19:19.806910 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking....
2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6376 Error connecting
2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6416 Error Opening DB
2014-11-28 21:19:21.476882 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking....
What does this means?
I have load recently the mod_xml_rpc is this relate with our issue?
Also how I can check the correct open DB open connections ?
*Andri* *Hadjiefstathiou* | Network and Security Engineer *t *+357 25027607 | * m *+357 96860600 | *e* AHadjiefstathiou@IronFX.com
*IronFX Global Limited t* +357 25027000 | *f* +357 25027001 | *w * www.IronFX.com
<https://www.facebook.com/IronFX>
*London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol*
-----------------------------------------------------------------------------------------------------------------------
IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)
IronFX Global Limited is a Member of Eurex Exchange
-----------------------------------------------------------------------------------------------------------------------
*Consider the environment before printing this email.*
*From:* Andri Hadjiefstathiou [IronFX Global] *Sent:* Wednesday, December 03, 2014 5:11 PM *To:* '*freeswitch-users@lists.freeswitch.org <freeswitch-users@lists.freeswitch.org>*' *Subject:* Freeswitch
I got those errors recently from our freeswitch server
[ERR] mod_commands.c:4063 Error connecting
[ERR] sofia_glue.c:6464 Error connecting
[ERR] sofia_glue.c:6504 Error Opening DB
[WARNING] sofia_glue.c:6464 Max handles 50
What does this means?
I have load recently the mod_xml_rpc is this relate with our issue?
Also how I can check the correct open DB open connections ?
*Andri* *Hadjiefstathiou* | Network and Security Engineer *t **+357 25027607* | *m **+357 96860600* | *e* *AHadjiefstathiou@IronFX.com*
*IronFX Global Limited t* *+357 25027000* | *f* *+357 25027001* | *w **www.IronFX.com <http://www.IronFX.com>*
*London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol*
-----------------------------------------------------------------------------------------------------------------------
IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10)
IronFX Global Limited is a Member of Eurex Exchange
-----------------------------------------------------------------------------------------------------------------------
*This email has been sent from IronFX Global Limited. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful.*
*Consider the environment before printing this email.*
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: *consulting@freeswitch.org <consulting@freeswitch.org>* *http://www.freeswitchsolutions.com <http://www.freeswitchsolutions.com>*
Official FreeSWITCH Sites *http://www.freeswitch.org <http://www.freeswitch.org>* *http://confluence.freeswitch.org <http://confluence.freeswitch.org>* *http://www.cluecon.com <http://www.cluecon.com>*
FreeSWITCH-users mailing list *FreeSWITCH-users@lists.freeswitch.org <FreeSWITCH-users@lists.freeswitch.org>* *http://lists.freeswitch.org/mailman/listinfo/freeswitch-users <http://lists.freeswitch.org/mailman/listinfo/freeswitch-users>* UNSUBSCRIBE:*http://lists.freeswitch.org/mailman/options/freeswitch-users <http://lists.freeswitch.org/mailman/options/freeswitch-users>* *http://www.freeswitch.org <http://www.freeswitch.org>*
_________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com
Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com
FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
We have mysql. I have enable mod_xml_rpc and after 3 days the issue appeared. The issue go away when I restart the freeswitch .. but to be sure I have disable mod_xml_rpc. How I can check the below: Are database handles being released? Is a new long / inefficient query consuming all your connections? What do you mean about the below and what do you suggest? Also- I noticed you are running an old version of FS based on the line numbers in your logs, so your likelihood of getting free support is not good. Thanks Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com<mailto:AHadjiefstathiou@IronFX.com> IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com<http://www.IronFX.com> [cid:image001.jpg@01D00F29.25424440]<https://www.facebook.com/IronFX> [cid:image002.gif@01D00F29.25424440] <https://twitter.com/ironfxglobal> [cid:image003.gif@01D00F29.25424440] <http://www.youtube.com/ironfxmarketing> [cid:image004.gif@01D00F29.25424440] <http://blog.ironfx.com/> [cid:image005.gif@01D00F29.25424440] <http://www.linkedin.com/company/ironfxglobal> [cid:image006.gif@01D00F29.25424440] <https://plus.google.com/+Ironfxglobal> London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol [cid:image007.jpg@01D00F29.25424440] ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- Consider the environment before printing this email. From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Christopher Rienzo Sent: Wednesday, December 03, 2014 6:18 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Freeswitch I don't have any ideas for this particular issue other than general db connection troubleshooting tips. Are you using SQLite or odbc w/ mysql or postgresql? Are database handles being released? Is a new long / inefficient query consuming all your connections? Does the issue go away if you disable mod_xml_rpc? Find out these things to troubleshoot your issue. Also- I noticed you are running an old version of FS based on the line numbers in your logs, so your likelihood of getting free support is not good. On Wed, Dec 3, 2014 at 11:03 AM, Andri Hadjiefstathiou [IronFX Global] <AHadjiefstathiou@ironfx.com<mailto:AHadjiefstathiou@ironfx.com>> wrote: After we restart the server all fine. But I want to know the root of the problem.. why we got this error??? Recently I have enable mod_xml_rpc is this relate with our issue? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607<tel:%2B357%2025027607> | m +357 96860600<tel:%2B357%2096860600> | e AHadjiefstathiou@IronFX.com<mailto:AHadjiefstathiou@IronFX.com> IronFX Global Limited t +357 25027000<tel:%2B357%2025027000> | f +357 25027001<tel:%2B357%2025027001> | w www.IronFX.com<http://www.IronFX.com> <https://www.facebook.com/IronFX> London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- Consider the environment before printing this email. From: freeswitch-users-bounces@lists.freeswitch.org [mailto:freeswitch-users-bounces@lists.freeswitch.org] On Behalf Of Christopher Rienzo Sent: Wednesday, December 03, 2014 6:00 PM To: FreeSWITCH Users Help Subject: Re: [Freeswitch-users] Freeswitch Check your sofia profile(s)- it has the database settings in there (dbname, odbc-dsn, db-*) . Then, verify your database is running and can accept connections. On Wed, Dec 3, 2014 at 10:39 AM, Andri Hadjiefstathiou [IronFX Global] <AHadjiefstathiou@ironfx.com> wrote: I got those errors recently from our freeswitch server 2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6376 Error connecting 2014-11-28 21:19:19.806910 [ERR] sofia_glue.c:6416 Error Opening DB 2014-11-28 21:19:19.806910 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking.... 2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6376 Error connecting 2014-11-28 21:19:21.476882 [ERR] sofia_glue.c:6416 Error Opening DB 2014-11-28 21:19:21.476882 [WARNING] sofia_glue.c:6376 Max handles 50 exceeded, blocking.... What does this means? I have load recently the mod_xml_rpc is this relate with our issue? Also how I can check the correct open DB open connections ? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- Consider the environment before printing this email. From: Andri Hadjiefstathiou [IronFX Global] Sent: Wednesday, December 03, 2014 5:11 PM To: 'freeswitch-users@lists.freeswitch.org' Subject: Freeswitch I got those errors recently from our freeswitch server [ERR] mod_commands.c:4063 Error connecting [ERR] sofia_glue.c:6464 Error connecting [ERR] sofia_glue.c:6504 Error Opening DB [WARNING] sofia_glue.c:6464 Max handles 50 What does this means? I have load recently the mod_xml_rpc is this relate with our issue? Also how I can check the correct open DB open connections ? Andri Hadjiefstathiou | Network and Security Engineer t +357 25027607 | m +357 96860600 | e AHadjiefstathiou@IronFX.com IronFX Global Limited t +357 25027000 | f +357 25027001 | w www.IronFX.com London | Hong Kong | Sydney | Shanghai | Shenzhen | Shenyang | Frankfurt | Madrid | Warsaw | Lisbon | Prague | Budapest | Bucharest | Athens | Kiev | Minsk | Moscow | St Petersburg | Mumbai | Jakarta | Manila | Ho Chi Minh City | Kuala Lumpur | Baku | Lagos | Johannesburg | Auckland | Sao Paulo | Buenos Aires | Lima | Santiago | Montevideo | Limassol ----------------------------------------------------------------------------------------------------------------------- IronFX Global UK Limited is authorised and regulated by the Financial Conduct Authority (FCA no. 585561) IronFX Global (Australia) Pty Limited is authorised and regulated by ASIC (AFSL no. 417482) IronFX Global (South Africa) (Pty) Ltd is authorized by the Financial Services Board (FSP No 45276) IronFX Global NZ Limited is authorised and regulated by FSP (FSPR no. 298966) IronFX Global (Russia) LLC is a member of CRFIN (Membership no. A-8) IronFX Global (Ukraine) LLC is a member of UCRFIN (Membership no. 5) IronFX Global Limited is authorised and regulated by CySEC (Licence no. 125/10) IronFX Global Limited is a Member of Eurex Exchange ----------------------------------------------------------------------------------------------------------------------- This email has been sent from IronFX Global Limited. The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Consider the environment before printing this email. _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org _________________________________________________________________________ Professional FreeSWITCH Consulting Services: consulting@freeswitch.org http://www.freeswitchsolutions.com Official FreeSWITCH Sites http://www.freeswitch.org http://confluence.freeswitch.org http://www.cluecon.com FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (2)
-
Andri Hadjiefstathiou [IronFX Global]
-
Christopher Rienzo