[asterisk-dev] asterisk odbc force sanitysql

marek cervajs64 at gmail.com
Wed Apr 13 10:35:56 CDT 2022


hi,

working on problem with asterisk+odbc through problematic firewall 
(asterisk and DB are on separated machines)

there is some problem with SQL_ATTR_CONNECTION_DEAD . its not detecting 
problematic connection. can be replicated with iptables -I INPUT .. -j DROP

will you accept patch for forcing sanitysql param ?  (force sending 
SELECT 1 test)

if i understand this part of code

https://github.com/asterisk/asterisk/blob/b87c5f51248fddd443ad5487e2857d9c754575fa/res/res_odbc.c#L872

it will not use sanitysql if SQL_ATTR_CONNECTION_DEAD exist in unixODBC

Marek




More information about the asterisk-dev mailing list