Asterisk Documentation 1.4 odbcstorage.txt

-=NOTE: These pages are automatically updated once per
day from the Asterisk subversion repository when the repository changes revisions. Any
changes made to this page will be automatically overwritten with the
latest version from http://svn.digium.com/view/asterisk/branches/.

ODBC Voicemail Storage
======================

ODBC Storage allows you to store voicemail messages within a database 
instead of using a file.  This is *not* a full realtime engine and 
*only* supports ODBC.  The table description for the "voicemessages" 
table is as follows:

+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| msgnum         | int(11)     | YES  |     | NULL    |       |
| dir            | varchar(80) | YES  | MUL | NULL    |       |
| context        | varchar(80) | YES  |     | NULL    |       |
| macrocontext   | varchar(80) | YES  |     | NULL    |       |
| callerid       | varchar(40) | YES  |     | NULL    |       |
| origtime       | varchar(40) | YES  |     | NULL    |       |
| duration       | varchar(20) | YES  |     | NULL    |       |
| mailboxuser    | varchar(80) | YES  |     | NULL    |       |
| mailboxcontext | varchar(80) | YES  |     | NULL    |       |
| recording      | longblob    | YES  |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+

The database name (from /etc/asterisk/res_odbc.conf) is in the 
"odbcstorage" variable in the general section of voicemail.conf.

You may modify the voicemessages table name by using 
odbctable=??? in voicemail.conf




-=NOTE: These pages are automatically updated once per
day from the Asterisk subversion repository when the repository changes revisions. Any
changes made to this page will be automatically overwritten with the
latest version from http://svn.digium.com/view/asterisk/branches/.

ODBC Voicemail Storage
======================

ODBC Storage allows you to store voicemail messages within a database 
instead of using a file.  This is *not* a full realtime engine and 
*only* supports ODBC.  The table description for the "voicemessages" 
table is as follows:

+----------------+-------------+------+-----+---------+-------+
| Field          | Type        | Null | Key | Default | Extra |
+----------------+-------------+------+-----+---------+-------+
| msgnum         | int(11)     | YES  |     | NULL    |       |
| dir            | varchar(80) | YES  | MUL | NULL    |       |
| context        | varchar(80) | YES  |     | NULL    |       |
| macrocontext   | varchar(80) | YES  |     | NULL    |       |
| callerid       | varchar(40) | YES  |     | NULL    |       |
| origtime       | varchar(40) | YES  |     | NULL    |       |
| duration       | varchar(20) | YES  |     | NULL    |       |
| mailboxuser    | varchar(80) | YES  |     | NULL    |       |
| mailboxcontext | varchar(80) | YES  |     | NULL    |       |
| recording      | longblob    | YES  |     | NULL    |       |
+----------------+-------------+------+-----+---------+-------+

The database name (from /etc/asterisk/res_odbc.conf) is in the 
"odbcstorage" variable in the general section of voicemail.conf.

You may modify the voicemessages table name by using 
odbctable=??? in voicemail.conf




Created by: josiahbryan, Last modification: Sun 25 of Jul, 2010 (08:43 UTC)
Please update this page with new information, just login and click on the "Edit" or "Discussion" tab. Get a free login here: Register Thanks! - Find us on Google+