Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -Editar o arquivo /etc/odbcinst.ini:
- #CentOS x86_64
- [MySQL]
- Description = MySQL ODBC MyODBC Driver
- Driver = /usr/lib64/libmyodbc5.so
- #Driver = /usr/lib64/libodbcmyS.so
- FileUsage = 1
- -Editar o arquivo /etc/odbc.ini:
- [asterisk-connector]
- Description = MySQL connection to asterisk database
- Driver = MySQL
- Database = asterisk
- Server = localhost
- UserName = root
- Password = root
- Port = 3306
- Socket =/var/lib/mysql/mysql.sock
- -Para testar a conexão ao banco de dados utilizar o comando:
- echo "SELECT 1" | isql -v asterisk-connector
- -Editar o arquivo /etc/asterisk/res_odbc.conf
- [asterisk]
- enabled => yes
- dsn => asterisk-connector
- pre-connect => yes
- username => root
- password => root
- -Editar o arquivo /etc/asterisk/func_odbc.conf
- [nome_funcao]
- dsn=asterisk
- readsql=SELECT …
- -A partir do Asterisk, chamar a função ODBC_nome_funcao()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement