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 <[email protected]> > 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 >
-- _____________________________________________________________________ -- 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
