Sponsor: VoiceMeUp - Corporate & Wholesale VoIP Services

VoIP Mailing List Archives
Mailing list archives for the VoIP community
 SearchSearch 

[asterisk-users] ODBC crashing asterisk


 
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users
View previous topic :: View next topic  
Author Message
mdiehlenator at gmail.com
Guest





PostPosted: Wed Mar 23, 2016 4:38 pm    Post subject: [asterisk-users] ODBC crashing asterisk Reply with quote

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
Back to top
satskiy.a at gmail.com
Guest





PostPosted: Thu Mar 24, 2016 2:55 am    Post subject: [asterisk-users] ODBC crashing asterisk Reply with quote

You have an error in your SQL syntax; check the manual that corresponds On Mar 23, 2016 11:38 PM, "Mike Diehl" <mdiehlenator@gmail.com (mdiehlenator@gmail.com)> wrote:
Quote:
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
Back to top
mdiehlenator at gmail.com
Guest





PostPosted: Thu Mar 24, 2016 4:02 pm    Post subject: [asterisk-users] ODBC crashing asterisk Reply with quote

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:
Quote:
You have an error in your SQL syntax; check the manual that corresponds

On Mar 23, 2016 11:38 PM, "Mike Diehl" <mdiehlenator@gmail.com> wrote:
Quote:
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
Back to top
decipher.hk at gmail.com
Guest





PostPosted: Sun Mar 27, 2016 8:39 pm    Post subject: [asterisk-users] ODBC crashing asterisk Reply with quote

March 24 2016 6:01 PM, "Mike Diehl" <mdiehlenator@gmail.com> wrote:
Quote:
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
Back to top
decipher.hk at gmail.com
Guest





PostPosted: Sun Mar 27, 2016 11:18 pm    Post subject: [asterisk-users] ODBC crashing asterisk Reply with quote

-->



On Mar 24 2016, at 6:01 pm, Mike Diehl <mdiehlenator@gmail.com> wrote:
Quote:

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
Back to top
Display posts from previous:   
Post new topic   Reply to topic    VoIP Mailing List Archives Forum Index -> Asterisk Users All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group

VoiceMeUp - Corporate & Wholesale VoIP Services