[Freeswitch-users] Freeswitch

Andri Hadjiefstathiou [IronFX Global] AHadjiefstathiou at IronFX.com
Wed Dec 3 19:48:45 MSK 2014 

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 at IronFX.com<mailto:AHadjiefstathiou at IronFX.com>
IronFX Global Limited
t  +357 25027000 | f  +357 25027001 | w  www.IronFX.com<http://www.IronFX.com>
[cid:image001.jpg at 01D00F29.25424440]<https://www.facebook.com/IronFX> [cid:image002.gif at 01D00F29.25424440] <https://twitter.com/ironfxglobal>  [cid:image003.gif at 01D00F29.25424440] <http://www.youtube.com/ironfxmarketing>  [cid:image004.gif at 01D00F29.25424440] <http://blog.ironfx.com/>  [cid:image005.gif at 01D00F29.25424440] <http://www.linkedin.com/company/ironfxglobal>  [cid:image006.gif at 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 at 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 at lists.freeswitch.org [mailto:freeswitch-users-bounces at 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 at ironfx.com<mailto:AHadjiefstathiou at 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 at IronFX.com<mailto:AHadjiefstathiou at 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 at lists.freeswitch.org [mailto:freeswitch-users-bounces at 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 at 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 at 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 at 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 at 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 at 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 at 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 at 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 at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 808 bytes
Desc: image001.jpg
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0002.jpg 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.gif
Type: image/gif
Size: 296 bytes
Desc: image002.gif
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0005.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.gif
Type: image/gif
Size: 620 bytes
Desc: image003.gif
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0006.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.gif
Type: image/gif
Size: 590 bytes
Desc: image004.gif
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0007.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.gif
Type: image/gif
Size: 1054 bytes
Desc: image005.gif
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0008.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image006.gif
Type: image/gif
Size: 491 bytes
Desc: image006.gif
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0009.gif 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image007.jpg
Type: image/jpeg
Size: 16451 bytes
Desc: image007.jpg
Url : http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20141203/251bcd42/attachment-0003.jpg

Join us at ClueCon 2016 Aug 8-12, 2016
More information about the FreeSWITCH-users mailing list