Asterisk odbc Connection Setup

==========================================
          ⭐ 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