[asterisk-users] Asterisk and SQL Server (MS SQL) - Asterisk doesn't close connections in pool

Waldemar Gessler waldemar at schrego.com
Fri Mar 2 09:02:28 CST 2012


It's Asterisk 1.6.2.21. 

Do you think, it could work with Asterisk 1.8?

-----Ursprüngliche Nachricht-----
Von: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] Im Auftrag von Kevin P. Fleming
Gesendet: Freitag, 2. März 2012 15:58
An: asterisk-users at lists.digium.com
Betreff: Re: [asterisk-users] Asterisk and SQL Server (MS SQL) - Asterisk doesn't close connections in pool

On 03/02/2012 03:53 AM, Waldemar Gessler wrote:
> Hello everyone,
>
> we have made tests with Asterisk 1.6 and SQL Server (MS SQL) 2008 R2 
> as DB for:

There is no 'Asterisk 1.6'. there are 1.6.0, 1.6.1 and 1.6.2 release branches. Which version are you using?

> ·CDRs
>
> ·Realtime (sipusers)
>
> ·func_odbc - dialplan queries
>
> We use the free_tds driver.
>
> Is there any solution (configuration settings) that makes possible 
> that asterisk closes the opened DB connections in pool after some time 
> of inactivity?

You are using unsupported releases of Asterisk, so unless there is already a configuration option to do what you want, it won't be added to the version you are using. You'd be better off to setup your system using Asterisk 1.8 and determine whether it behaves the way you want.

--
Kevin P. Fleming
Digium, Inc. | Director of Software Technologies
Jabber: kfleming at digium.com | SIP: kpfleming at digium.com | Skype: kpfleming
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA Check us out at www.digium.com & www.asterisk.org

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users





More information about the asterisk-users mailing list