ODBC Adaptive CDR is not working

nano /etc/asterisk/cdr_adaptive_odbc.conf[adaptive_connection]connection=asteriskcdrdbtable=cdralias start => calldate Modified the /etc/odbc.ini to reflect [MySQL-asteriskcdrdb]Description=MySQL connection to 'asterisk' databasedriver=MySQLserver=localhostdatabase=asteriskcdrdbusername=freepbx (user name and password from /etc/freepbx.conf)password=fpbxPort=3306Socket=/var/lib/mysql/mysql.sockoption=3 module reload res_odbc.so module reload cdr_adaptive_odbc.so restart Asterisk You can run below commands to confirm CDR, MySQL and ODBC connections:cdr show statusmodule show cdrmodule show mysqlodbc s...

Read more »

Troubleshooting ODBC Module in Asterisk

Introduction This article is to introduce troubleshooting steps for ODBC malfunction for Asterisk. Description We are resolving following error for ODBC Connection. $ echo "select 1" | isql -v asterisk-connector [01000][unixODBC][Driver Manager]Can't open lib '/usr/lib64/libmyodbc5.so' : file not found [ISQL]ERROR: Could not SQLConnect Methodology Step # 1 Create a separate directory odbc/ in /usr/lib or /usr/lib64/ (as available): $ mkdir /usr/lib64/odbc/ Step # 2 Download and Install latest MySQL Connector for ODBC with suitable for your OS: $ wget http://mysql.mirrors.crysys.hit.bme.hu/Downloads/Connector-ODBC/5.3/mysql-connector-odbc-5.3.6-linux-el6-x86-64bit.tar.gz $ tar -zxvf mysql-connector-odbc-5.3.4-linux-el6-x86-64bit.tar.gz $ cd mysql-connector-odbc-5.3.4-linux-el6-x86-64bit $...

Read more »

Install Elastix from USB Step by Step Elastix is one of the best Open Source Unified Communications Servers available today, it is very easy to install but the installer is designed to be run from CDROM and we can make the installation in several devices that don´t have an optical drive.  This document will guide you to modify the installer so you can install entirely from an USB Flash drive. Warning: The Server Security is a very important and serious aspect in a VoIP server, this guide will not cover that but there is plenty of information on that topic in the Internet. If you are looking for a professional installation contact me and I'll be glad to help you for a very reasonable price. This guide was created using...

Read more »

Instalando Elastix 4 no CentOS 7 64 bits

Este tutorial tem como objetivo fazer a instalação do Elastix 4 no CentOS 7 64 bits O ambiente utilizado na produção deste tutorial é apresentado a seguir: CentOS 7.2 x86_64 release 1511 Elastix 4.0 RC3 versão 64 bits A instalação do CentOS 7 utilizada para validar esse tutorial foi a Minimal-1511. A ISO dessa versão pode ser baixada através desse link. Todos os comandos executados nesse tutorial foram executados com o usuário root. Preparar o sistema operacional para a instalação do Elastix Antes de iniciar a instalação, precisamos instalar os seguintes pacotes: # yum install epel-release -y # yum install wget vim -y Em seguida, verificamos se existem pacotes a serem atualizados com o comando: # yum update -y Reinicie...

Read more »