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
You have an error in your SQL syntax; check the manual that corresponds On Mar 23, 2016 11:38 PM, "Mike Diehl" <mdiehlenator at gmail.com> wrote:> 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 > > > -- > _____________________________________________________________________ > -- 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/20160324/ea419585/attachment.html>
Normally, SQL errors don't result in a segfault. I understand that this is a problem with a particular version of the ODBC driver. I just can't find a reference to it at the moment. On Thursday, March 24, 2016 09:54:35 AM ????? ?????? wrote:> You have an error in your SQL syntax; check the manual that corresponds > > On Mar 23, 2016 11:38 PM, "Mike Diehl" <mdiehlenator at gmail.com> wrote: > > 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 > > > > > > -- > > _____________________________________________________________________ > > -- 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-- Mike Diehl Diehlnet Communications, LLC. Voice: (505) 903-5700 Fax: (505) 903-5701
March 24 2016 6:01 PM, "Mike Diehl" <mdiehlenator at gmail.com> wrote:> Normally, SQL errors don't result in a segfault. I understand that this is a > problem with a particular version of the ODBC driver. I just can't find a > reference to it at the moment.Are you tried collect a backtrace? https://wiki.asterisk.org/wiki/display/AST/Getting+a+Backtrace -- Rodrigo Ram?rez Norambuena http://www.rodrigoramirez.com