Installing Cdr In Pbx Wiki

These labs are part of the training Complete Asterisk Training at www.udemy.com, attend using our discounted coupon

Oct 26, 2019  FreePBX is a web-based open source GUI (graphical user interface) that controls and manages Asterisk (PBX). This tutorial will help you to Install FreePBX 15 on Ubuntu 18.04 / 16.04 & Debian 10/9. A pre-requisite for this setup is Asterisk Server. Install Asterisk on Ubuntu 18.04 / 16.04 / Debian 9 using below guide: How to.

This is not a lab, you are not required to complete it. This lab requires advanced knowledge in Linux and there are many things that can go wrong. A linux geek will complete it easily. However, It took me almost an hour to execute it for the first time. So unless you have the required knowledge and patience let it as just a demo. If you require CDRs sent to ODBC and this lab don't work for you, hire an Linux expert to execute it.

Step 1: Install MySQL Server

apt-get install mysql-server

Provide a password for mysql 'qsasterisk'. You can change the password if you want, but change the lab accordingly.

Step 2: Install MySQL connector for ODBC

wget https://dev.mysql.com/get/Downloads/Connector-ODBC/8.0/mysql-connector-odbc-8.0.11-linux-ubuntu16.04-x86-32bit.tar.gz

tar -xzvf mysql-connector-odbc-8.0.11-linux-ubuntu16.04-x86-32bit.tar.gz
cd mysql-connector-odbc-8.0.11-linux-ubuntu16.04-x86-32bit
cp libmyodbc8a.so /usr/lib/i386-linux-gnu/odbc/

Step 3: Edit odbcinst.init and install the drivers

[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc8a.so
Setup = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so
FileUsage = 1

Step 4: Edit /etc/odbc.ini and create the dsn

[astcdr]
Description = MySQL connection to database
Driver = MySQL
Database = cdr
Server = localhost
User = root
Password = qsasterisk
Port = 3306
Socket = /var/run/mysqld/mysqld.sock

Step 5: Create the database cdr

mysqladmin -uroot -p create cdr

use qsasterisk as the password.

Step 7: Configure res_dbc.conf

Dakshinamurthy stotram pdf. Add to the end of the file

[astcdr]
enabled => yes
dsn => astcdr
username => root
password => qsasterisk
pre-connect => yes

Step 8: Verify in the Asterisk console if you have Adaptive ODBC as an option

After restarting Asterisk,

CLI>cdr show status

qsasteriskCLI> show cdr statusNo such command 'show cdr status' (type 'core show help show cdr' for other possible commands)qsasteriskCLI> cdr show status

Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No

* Registered Backends
-------------------
cdr-custom
csv
cdr_manager (suspended)
**Adaptive ODBC**

Step 9: Verify the ODBC conenction

CLI>odbc show all
ODBC DSN Settings
-----------------

Name: astcdr
DSN: astcdr
Number of active connections: 1 (out of 1)

Step 10 - Create the database schema

root@qsasterisk:/usr/src/asterisk-15.4.1/contrib/realtime/mysql# mysql -u root -p cdr <mysql_cdr.sql

Step 11 - Make some calls and check if the database is filled.

mysql -u root -p cdr