asterisk users - Mar 2012 - ODBC connection does not reconnect after network interruption

I've got an Asterisk 10.1.2 server using res_odbc to make a connection to a
MSSQL server on a different machine for a timeclock extension we have running. 
The connection works just fine until Asterisk's network path to the MSSQL
server gets disrupted (for whatever reason), and then all future attempts to
contact the MSSQL server cause the timeclock call to hang, until Asterisk is
completely restarted.  Trying to module unload/load res_odbc.so crashes
Asterisk.  I've been using the following config, and tried with preconnect
both on and off:

[timeclock]
enabled => yes
dsn => timeclock
username => notauser
password => stealme
pooling => no
limit => 1
pre-connect => no

Any suggestions on where to try digging in to this?

Thank you,

Noah Engelberth
MetaLINK Technologies

-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20120320/6b88ef2e/attachment.htm>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: AVG Certification.txt
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20120320/6b88ef2e/attachment.txt>

Noah Engelberth wrote:
> Any suggestions on where to try digging in to this?
I don't specify pooling or limit, but I do specify preconnect => yes.  
I've noted when the mysql database isn't available that I does a retry 
until connected.

I'm also still using Asterisk 1.4.x

Doug


-- 

Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."

I am running asterisk 1.8.7.1 with multiple resources and asterisk connect
back and forth to each one until one available is found.

I have:

pre-connect => yes
sanitysql => select 1

Maybe your configuration lacks the sanitysql so asterisk can't detect when
disconnected. I am using mysql.

Leandro

2012/3/20 Noah Engelberth <Noah at directlinkcomputers.com>
>  I?ve got an Asterisk 10.1.2 server using res_odbc to make a connection
> to a MSSQL server on a different machine for a timeclock extension we have
> running.  The connection works just fine until Asterisk?s network path to
> the MSSQL server gets disrupted (for whatever reason), and then all future
> attempts to contact the MSSQL server cause the timeclock call to hang,
> until Asterisk is completely restarted.  Trying to module unload/load
> res_odbc.so crashes Asterisk.  I?ve been using the following config, and
> tried with preconnect both on and off:****
>
> ** **
>
> [timeclock]****
>
> enabled => yes****
>
> dsn => timeclock****
>
> username => notauser****
>
> password => stealme****
>
> pooling => no****
>
> limit => 1****
>
> pre-connect => no****
>
> ** **
>
> Any suggestions on where to try digging in to this?****
>
> ** **
>
> Thank you,****
>
> ** **
>
> Noah Engelberth****
>
> MetaLINK Technologies****
>
> ** **
>
> --
> _____________________________________________________________________
> -- 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20120320/1936e9f6/attachment.htm>