Re: [asterisk-users] ODBC crashing asterisk
On Mar 24 2016, at 6:01 pm, Mike Diehl mdiehlena...@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 -- _ -- 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
Re: [asterisk-users] ODBC crashing asterisk
March 24 2016 6:01 PM, "Mike Diehl"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 -- _ -- 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
Re: [asterisk-users] ODBC crashing asterisk
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"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 -- _ -- 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
Re: [asterisk-users] ODBC crashing asterisk
You have an error in your SQL syntax; check the manual that corresponds On Mar 23, 2016 11:38 PM, "Mike Diehl"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 > -- _ -- 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
[asterisk-users] ODBC crashing asterisk
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