asterisk - FreePBX 2.10 odbc storage -
i store voicemessages on odbc mysql database. app_voicemail compiled odbc storage support?
this question cause setup in:
- "freepbx 2.11" ask me enable file-storage or odbc-storage'
- "freepbx 2.10" same question not asked.
maybe cause support 'file-storage'?
when leave message in vocalmail, in log there no trace of 'sql insert'.
in examples i've seen, sql statement insert in table row of voicemessage?
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 | | [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 .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 storage depend asterisk module. asterisk have compiled voicemail-odbc enabled
it have small relation freepbx web. should work if module present , configured.
Comments
Post a Comment