allI get this warning in the Asterisk CLI about once every ten minutes or so:[Nov 23 14:47:36] WARNING: res_odbc.c:647ast_odbc_prepare_and_execute: SQL Execute returned an error -1: HY000:[MySQL][ODBC 5.1 Driver][mysqld-5.1.73]Deadlock found w..
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 O..
guysIm running 126.96.36.199 with CEL logging over ODBC to MariaDB 5.5.41 on the same CentOS 7 machine.Ive noticed that the CDR entries made are all in-time, e. g. the call will take place and the CDR entry is immediately written into the CDR table in ..
I have a huge problem with a 188.8.131.52 Asterisk instance not logging CEL events with the correct eventtimes.Im logging via ODBC to MariaDB 15.1 Distrib 10.0.20-MariaDBIm logging into a MyISAM table.If I start the Asterisk instance, logged times are corre..
allI have a strange issue with 184.108.40.206 on a production Asterisk machine at our head office, and the same issue with a production machine at a branch office.Every now and then, on the head office machine, ODBC CEL and CDR logging will stop working…
Is there any reason why ODBC voicemail storage requires varchar for most fields? For example, is there anything stopping me using a BIGINT or similar for origtime or INT for duration?Kind re..
I am not running ODBC Storage for Voicemail.Just running Real-time time static for configurations.John===============================;Do you have compiled asterisk by yourself? In the Voicemail Build Option, what option have you selected? I think ..
allasterisk 1.8.23I have odbc all setup to mysql but cant figure out why the dialplan wont write to the odbc functionfubc_odbc.conf[D..
, Im trying to put my voicemail on asterisk realtime with 11.XX, generate tables in a couple of files in the folder realtime / mysql , voicemail_messages.sql and voicemail.sqlthe connection with mysql and ODBC works wellisql asterisk useradmin xxx+————————————–..