On 2/11/16 12:36 PM, Joshua Colp wrote:
Carlos Chavez wrote:
I use realtime on my asterisk installation. I have always used mysql for
my realtime connection but as mysql seems to be on the "soon to be
deprecated" list of asterisk features I am trying to move to ODBC (still
using MariaDB/Mysql on backend). I find ODBC support in Asterisk very
unstable. Just today my asterisk server (a test server and a production
server) has crashed often or simply hangs because it says ODBC is
disconnected. I can use the isql tool to query my database without any
interruptions.
Just as a clarification on the res_config_mysql status. It's been
extended support for quite awhile, meaning issues and such are taken
care of by the community and not Digium. It hasn't been deprecated and
won't be removed, we're just not directly fixing issues in it.
Is anyone using res_odbc for realtime in Asterisk 13? Both my test
server and production server are CentOS 7.2 and I followed the procedure
set by the Asterisk Wiki:
https://wiki.asterisk.org/wiki/display/AST/Setting+up+PJSIP+Realtime
<snip>
ODBC is made up of a few parts: res_odbc, the main ODBC library, and
the connector. I know of Postgresql being heavily used and it has not
seen these problems you appear to be having with MySQL. I'm not saying
you need to switch but the problem seems to be with the ODBC MySQL
connector itself, so feedback from people using that combination would
be more valuable to you than everyone using ODBC. It would also be
where you should focus your attention.
Cheers,
Thank you. I will avoid ODBC for the moment and use Mysql for the
realtime engine. Now the problem seems to be that Mysql complains that
some fields (like qualify_timeout and qualify_frequency) are int(11) and
it wants type char instead. Since I am using alembic and the table
definitions that come with Asterisk I wonder why there is a problem.
Why do the ODBC and Mysql engines require different type fields?
--
Telecomunicaciones Abiertas de México S.A. de C.V.
Carlos Chávez
+52 (55)9116-91161
--
_____________________________________________________________________
-- 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
