WARNING: this is an automatic post retrieved from the Asterisk-Users Mailing List, not an authored post
Mailing-list Collector
March 20, 2012
Asterisk-Users
Tags: asterisk, connection, engelberth, extension, interruption, metalink technologies, ms exchange server, mssql server
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
The message does not contain any threats
AVG for MS Exchange Server (2012.0.1913 – 2114/4882)