==========================================
          ⭐ For cdr table ⭐
==========================================

------------------------------------------
👉 /etc/odbc.ini
------------------------------------------
[odbcAsterisk]
Driver = MySQL ODBC 5.3 Unicode Driver
Description = MySQL connection to ‘asterisk’ database
Server = localhost
Port = 3306
Database = asterisk
UserName = root
Password = Root@pr1sonl1nk
Socket = /var/lib/mysql/mysql.sock


------------------------------------------
👉 /etc/asterisk/cdr_odbc.conf
------------------------------------------
[global]
dsn=odbcAsterisk
loguniqueid=yes
table=cdr
dispositionstring=yes
usegmtime=no
hrtime=yes


------------------------------------------
👉 /etc/asterisk/res_odbc.conf
------------------------------------------
[odbcasterisk]
enabled => yes
dsn => odbcAsterisk
username => root
password => Root@pr1sonl1nk
pre-connect => yes
limit=1
share_connections=yes
sanitysql=select 1
isolation=repeatable_read


------------------------------------------
👉 /etc/asterisk/cdr_manager.conf
------------------------------------------
[general]
enabled = yes


------------------------------------------
👉 /etc/asterisk/cdr_adaptive_odbc.conf
------------------------------------------
[adaptive_connection]
connection=odbcasterisk
table=cdr
alias start => calldate
alias channel => source_channel



==========================================
           ⭐ For cel table ⭐
==========================================

------------------------------------------
👉 /etc/asterisk/cel.conf
------------------------------------------
#uncomment these lines
enable=yes
dateformat = %F %T


------------------------------------------
👉 /etc/asterisk/cel_odbc.conf
------------------------------------------
[cel]
connection=odbcasterisk
table=cel
username= root
password= Root@pr1sonl1nk
loguniqueid=yes



==========================================
       ⭐ For realtime sip peers ⭐
==========================================

------------------------------------------
👉 /etc/asterisk/extconfig.conf
------------------------------------------
#uncomment these lines
sippeers => odbc,odbcasterisk


------------------------------------------
👉 /etc/asterisk/sip.conf
------------------------------------------
#uncomment these lines
rtcachefriends=yes
rtupdate=yes
rtautoclear=yes