VoIP Mailing List Archives
Mailing list archives for the VoIP community |
|
View previous topic :: View next topic |
Author |
Message |
mdiehlenator at gmail.com Guest
|
Posted: Wed Mar 23, 2016 4:38 pm Post subject: [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 |
|
Back to top |
|
|
satskiy.a at gmail.com Guest
|
Posted: Thu Mar 24, 2016 2:55 am Post subject: [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" <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
|
Posted: Thu Mar 24, 2016 4:02 pm Post subject: [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:
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
|
|
Back to top |
|
|
decipher.hk at gmail.com Guest
|
Posted: Sun Mar 27, 2016 11:18 pm Post subject: [asterisk-users] ODBC crashing asterisk |
|
|
-->
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 |
|
|
|
|
|
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
|