我想通过odbc将语音消息存储到mysql数据库中。app_voicemail是否使用odbc存储支持编译?
这个问题导致设置在:
-"FreePBX 2.11"要求我启用文件存储或odbc存储'
-"FreePBX 2.10"没有提出同样的问题
可能导致仅支持"文件存储"?
当我在vocalmail中留言时,日志中没有"sql insert"的痕迹。
在我看到的所有示例中,要在表中插入voicemessage行的sql语句在哪里?
ODBC DSN Settings
-----------------
Name: asterisk
DSN: asterisk-connector
Last connection attempt: 1970-01-01 01:00:00
Pooled: No
Connected: Yes
-----------------
root@pbx:~ $ isql asterisk root passw0rd
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>
-----------------
/etc/asterisk/func_odbc.conf
[SQL]
dsn=asterisk-connector
readsql=${ARG1}
-----------------
/etc/asterisk/res_odbc.conf
[asterisk]
enabled => yes
dsn => asterisk-connector
username => root
password => passw0rd
pooling => no
limit => 1
pre-connect => yes
-----------------
/etc/odbc.ini
[asterisk-connector]
Driver = MySQL
Description = MySQL connection to .asterisk. database
Server = localhost
Port = 3306
User = root
Password = --------
Database = asterisk
Option = 3
Socket = /var/lib/mysql/mysql.sock
-----------------
/etc/asterisk/voicemail.conf
odbcstorage=asterisk
odbctable=voicemessages
-----------------
ODBC存储依赖于星号模块。Asterisk已使用启用了odbc的语音邮件进行编译
它与freepbx网站的关系很小。如果模块存在并配置,它应该可以工作。