-> cat /etc/odbc.ini

[asterisk-kamailio]
Description	= MySQL Asterisk Dbase
Driver		= MySQL
Server		= localhost
User		= asterisk
Password	= pass
Port		= 3306
Database	= asterisk
Socket		= /var/lib/mysql/mysql.sock
option		= 3

-> cat /etc/odbcinst.ini

# Driver from the mysql-connector-odbc package
# Setup from the unixODBC package
[MySQL]
Description	= ODBC for MySQL
Driver		= /usr/lib/libmyodbc5.so
Setup		= /usr/lib/libodbcmyS.so
Driver64	= /usr/lib64/libmyodbc5.so
Setup64		= /usr/lib64/libodbcmyS.so
FileUsage	= 1

-> echo "select 1" | isql -v asterisk-kamailio
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select 1
+---------------------+
| 1                   |
+---------------------+
| 1                   |
+---------------------+
SQLRowCount returns 1
1 rows fetched

-> cat res_odbc.conf

[asterisk-kamailio]
enabled => yes
dns => asterisk-kamailio
username => asterisk
password => 4st3r1sk_p4SS
pooling => no
limit => 1
pre-connect => yes

-> cat cdr_adaptive_odbc.conf

[first]
connection=asterisk
loguniqueid=yes
table=test
alias start=>calldate

-> cat extconfig.conf
[default]
sipusers => odbc,asterisk,sipusers
sippeers => odbc,asterisk,sipusers
sipregs  => odbc,asterisk,sipregs
voicemail => odbc,asterisk,voicemail

-> cat extensions.conf
[default]

exten => _1XXX,1,Dial(SIP/${EXTEN})
exten => _1XXX,n,Voicemail(${EXTEN},u)
exten => _1XXX,n,Hangup()
exten => _1XXX,101,Voicemail(${EXTEN},b)
exten => _1XXX,102,Hangup()


asterisk CLi ::

odbc show :

ODBC DSN Settings
-----------------


sip show peers :
Name/username             Host                                    Dyn Forcerport Comedia    ACL Port     Status      Description                      Realtime
0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]