ODBC connection does not reconnect after network interruption

Home » Asterisk Users » ODBC connection does not reconnect after network interruption
Asterisk Users 2 Comments

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)

2 thoughts on - ODBC connection does not reconnect after network interruption

  • Noah Engelberth wrote:

    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

  • 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