odbc

cat /etc/odbcinst.ini
[MySQL]
Description             = MySQL ODBC Driver used for Asterisk configuration
Driver                  = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
Setup                   = /usr/lib/x86_64-linux-gnu/odbc/libodbcmyS.so
UsageCount              = 1
FileUsage               = 3



root@asterisk1:/var/spool/asterisk/voicemail/from-sip/444/INBOX# cat /etc/odbc.ini
[MySQL-Asterisk-sip]
Driver          = MySQL
Database        = yopeso
Server          = localhost
;User            = asterisk
;Password        = RC%70o209zPb$VyYVI._HUkBXvK$R7

[MySQL-Asterisk-voicemail]
Driver          = MySQL
Database        = yopeso
Server          = localhost
User            = asterisk
Password        = RC%70o209zPb$VyYVI._HUkBXvK$R7



root@asterisk1:/var/spool/asterisk/voicemail/from-sip/444/INBOX# cat /etc/asterisk/res_odbc.conf
[asterisk_odbc_sip]
enable => yes
dsn => MySQL-Asterisk-sip
pre-connect => yes
username => asterisk
password => RC%70o209zPb$VyYVI._HUkBXvK$R7


[asterisk_odbc_voicemail]
enable => yes
dsn => MySQL-Asterisk-voicemail
pre-connect => yes
username => asterisk
password => RC%70o209zPb$VyYVI._HUkBXvK$R7


root@asterisk1:/var/spool/asterisk/voicemail/from-sip/444/INBOX# cat /etc/asterisk/extconfig.conf
[settings]
sippeers => odbc,asterisk_odbc_sip,asterisk_sippeers
voicemail => odbc,asterisk_odbc_voicemail,voicemail_users
extensions => odbc,asteriskrealtime,extensions
queues => odbc,asteriskrealtime,queue_table
queue_members => odbc,asteriskrealtime,queue_member_table
meetme => odbc,asteriskrealtime,meetme