[asterisk-users] ODBC connection does not reconnect after network interruption

[Leandro Dardini]

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>