[asterisk-users] res_odbc crashes asterisk

[Carlos Chavez]

On 2/11/16 12:36 PM, Joshua Colp wrote:
> Carlos Chavez wrote:
>> I use realtime on my asterisk installation. I have always used mysql for
>> my realtime connection but as mysql seems to be on the "soon to be
>> deprecated" list of asterisk features I am trying to move to ODBC (still
>> using MariaDB/Mysql on backend). I find ODBC support in Asterisk very
>> unstable. Just today my asterisk server (a test server and a production
>> server) has crashed often or simply hangs because it says ODBC is
>> disconnected. I can use the isql tool to query my database without any
>> interruptions.
>
> Just as a clarification on the res_config_mysql status. It's been 
> extended support for quite awhile, meaning issues and such are taken 
> care of by the community and not Digium. It hasn't been deprecated and 
> won't be removed, we're just not directly fixing issues in it.
>
>>
>> Is anyone using res_odbc for realtime in Asterisk 13? Both my test
>> server and production server are CentOS 7.2 and I followed the procedure
>> set by the Asterisk Wiki:
>> https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime
>
> <snip>
>
> ODBC is made up of a few parts: res_odbc, the main ODBC library, and 
> the connector. I know of Postgresql being heavily used and it has not 
> seen these problems you appear to be having with MySQL. I'm not saying 
> you need to switch but the problem seems to be with the ODBC MySQL 
> connector itself, so feedback from people using that combination would 
> be more valuable to you than everyone using ODBC. It would also be 
> where you should focus your attention.
>
> Cheers,
>
     Thank you.  I will avoid ODBC for the moment and use Mysql for the 
realtime engine.  Now the problem seems to be that Mysql complains that 
some fields (like qualify_timeout and qualify_frequency) are int(11) and 
it wants type char instead. Since I am using alembic and the table 
definitions that come with Asterisk I wonder why there is a problem.  
Why do the ODBC and Mysql engines require different type fields?

-- 
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161