nano /etc/asterisk/extconfig.conf
sippeers => odbc,asterisk,sip_buddies
sipusers => odbc,asterisk,sip_buddies
extensions => odbc,asterisk,extensions
voicemail => odbc,asterisk,voicemail_users
queues => odbc,asterisk,queue_table
queue_members => odbc,asterisk,queue_member_table
queue_log => odbc,asterisk,queue_log
meetme => odbc,asterisk,meetme
musiconhold => odbc,asterisk,musiconhold
sip.conf => odbc,asterisk,sip_reg
nano /etc/asterisk/extentions.conf
[general]
[globals]
;
[from-sip]
switch =>Realtime/CONTEXT1@
nano /etc/asterisk/res_odbc.conf
[asterisk]
dsn => asterisk-connector
username => root
password => paasword
pre-connect => yes
nano /etc/odbc.ini
[asterisk-connector]
Description = MySQL ODBC
Driver = MySQL
Socket = /var/lib/mysql/mysql.sock
Server = localhost
User = root
Password = mysqlpassword
Database = DBname
Option = 3
DONE!!