[asterisk-users] ODBC crashing asterisk

[Mike Diehl]

Hi all,

I've got a new server up, but it's not staying up....

After a day or so, it segfaults with:

[Mar 22 23:17:49] WARNING[12177]: res_odbc.c:1406 _ast_odbc_request_obj2: 
SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC 5.2(a) 
Driver]You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near '7' at line 1


I'm using ODBC for sip and voice mail configuration.

I'm running Asterisk 11.20.0-rc3.

I've been told that there is a particular version of odbc that is stable.  In 
the mean time, I'm trying to run unixODBC 2.3.2.

What version SHOULD I use?

TIA,


-- 
Mike Diehl
Diehlnet Communications, LLC.
Voice: (505) 903-5700
Fax: (505) 903-5701