Tag : odbc
Home » Posts tagged odbc"
allI get this warning in the Asterisk CLI about once every ten minutes or so:[Nov 23 14:47:36] WARNING[2544]: 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 1.8.32.3 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 1.8.11.0 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 1.8.11.0 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..
On a previous opportunity we configured our Asterisk installation to connect with MariaDB (or MySQL) database through ODBC, using unixODBC. Well, this is a sample of the res_odbc.conf and cdr_odbc.conf files that would work just out of the box with t..