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.
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
I keep getting errors like this one:
asterisk:
/builddir/build/BUILD/mysql-connector-odbc-5.2.5-src/driver/desc.c:110:
desc_free_paramdata: Assertion `aprec' failed.
[Feb 9 16:28:48] WARNING[3781]: res_odbc.c:1405 _ast_odbc_request_obj2:
SetConnectAttr (Txn isolation) returned an error: HY000: [MySQL][ODBC
5.2(w) Driver]Lost connection to MySQL server during query
[Feb 9 16:28:48] WARNING[3781]: res_config_odbc.c:117 custom_prepare:
SQL Prepare failed![SELECT * FROM ps_domain_aliases WHERE id = ?]
[Feb 9 16:28:48] WARNING[3781]: res_odbc.c:765 ast_odbc_sanity_check:
Connection is down attempting to reconnect...
Aborted (core dumped)
Any pointers on working with ODBC and Asterisk?
--
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
