← Back to branch summary

~damg/ubuntu/quantal/asterisk/LP1097687

« back to all changes in this revision

Viewing changes to doc/tex/asterisk/node234.html

  • Committer: Bazaar Package Importer
  • Author(s): Lorenzo De Liso
  • Date: 2010-10-15 22:24:34 UTC
  • mfrom: (1.2.8 upstream) (8.3.8 sid)
  • Revision ID: james.westby@ubuntu.com-20101015222434-iy328q8in3lajzlv
Tags: 1:1.6.2.9-2ubuntu1
* Merge from debian unstable, remaining changes:
  - debian/control:
    + Build-depend on hardening-wrapper
    + Change Maintainer
    + Removed Uploaders field.
    + Removed Debian Vcs-Svn entry and replaced with ubuntu-voip Vcs-Bzr,
      to reflect divergence in packages.
  - debian/rules: Make use of hardening-wrapper
  - debian/asterisk.init: chown /dev/dahdi
  - debian/backports/hardy: add file
  - debian/backports/asterisk.init.hardy: add file
 

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/tex/asterisk/node234.html
7
7
  Jens Lippmann, Marek Rouchal, Martin Wilck and others -->
8
8
<HTML>
9
9
<HEAD>
10
 
<TITLE>IMAP Storage</TITLE>
11
 
<META NAME="description" CONTENT="IMAP Storage">
 
10
<TITLE>ODBC Storage</TITLE>
 
11
<META NAME="description" CONTENT="ODBC Storage">
12
12
<META NAME="keywords" CONTENT="asterisk">
13
13
<META NAME="resource-type" CONTENT="document">
14
14
<META NAME="distribution" CONTENT="global">
18
18
 
19
19
<LINK REL="STYLESHEET" HREF="asterisk.css">
20
20
 
 
21
<LINK REL="next" HREF="node235.html">
21
22
<LINK REL="previous" HREF="node233.html">
22
 
<LINK REL="up" HREF="node232.html">
 
23
<LINK REL="up" HREF="node233.html">
23
24
<LINK REL="next" HREF="node235.html">
24
25
</HEAD>
25
26
 
26
27
<BODY >
27
28
 
28
29
<DIV CLASS="navigation"><!--Navigation Panel-->
29
 
<A NAME="tex2html3718"
 
30
<A NAME="tex2html3723"
30
31
  HREF="node235.html">
31
32
<IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next"
32
33
 SRC="/usr/share/latex2html/icons/next.png"></A> 
33
 
<A NAME="tex2html3714"
34
 
  HREF="node232.html">
 
34
<A NAME="tex2html3719"
 
35
  HREF="node233.html">
35
36
<IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up"
36
37
 SRC="/usr/share/latex2html/icons/up.png"></A> 
37
 
<A NAME="tex2html3710"
 
38
<A NAME="tex2html3713"
38
39
  HREF="node233.html">
39
40
<IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous"
40
41
 SRC="/usr/share/latex2html/icons/prev.png"></A> 
41
 
<A NAME="tex2html3716"
 
42
<A NAME="tex2html3721"
42
43
  HREF="node1.html">
43
44
<IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents"
44
45
 SRC="/usr/share/latex2html/icons/contents.png"></A>  
45
46
<BR>
46
 
<B> Next:</B> <A NAME="tex2html3719"
47
 
  HREF="node235.html">Installation Notes</A>
48
 
<B> Up:</B> <A NAME="tex2html3715"
49
 
  HREF="node232.html">Voicemail</A>
50
 
<B> Previous:</B> <A NAME="tex2html3711"
51
 
  HREF="node233.html">ODBC Storage</A>
52
 
 &nbsp; <B>  <A NAME="tex2html3717"
 
47
<B> Next:</B> <A NAME="tex2html3724"
 
48
  HREF="node235.html">IMAP Storage</A>
 
49
<B> Up:</B> <A NAME="tex2html3720"
 
50
  HREF="node233.html">Voicemail</A>
 
51
<B> Previous:</B> <A NAME="tex2html3714"
 
52
  HREF="node233.html">Voicemail</A>
 
53
 &nbsp; <B>  <A NAME="tex2html3722"
53
54
  HREF="node1.html">Contents</A></B> 
54
55
<BR>
55
56
<BR></DIV>
56
57
<!--End of Navigation Panel-->
57
58
 
58
 
<H1><A NAME="SECTION001220000000000000000">
59
 
IMAP Storage</A>
 
59
<H1><A NAME="SECTION001210000000000000000"></A>
 
60
  <A NAME="odbcstorage"></A>
 
61
<BR>
 
62
ODBC Storage
60
63
</H1>
61
 
  By enabling IMAP Storage,  Asterisk will use native IMAP as the storage
62
 
mechanism for voicemail messages instead of using the standard file structure.
63
 
 
64
 
<P>
65
 
Tighter integration of Asterisk voicemail and IMAP email services allows
66
 
additional voicemail functionality, including:
67
 
 
68
 
<P>
69
 
 
70
 
<UL>
71
 
<LI>Listening to a voicemail on the phone will set its state to "read" in
72
 
   a user's mailbox automatically.
73
 
</LI>
74
 
<LI>Deleting a voicemail on the phone will delete it from the user's
75
 
   mailbox automatically.
76
 
</LI>
77
 
<LI>Accessing a voicemail recording email message will turn off the message
78
 
   waiting indicator (MWI) on the user's phone.
79
 
</LI>
80
 
<LI>Deleting a voicemail recording email will also turn off the message
81
 
   waiting indicator, and delete the message from the voicemail system.
82
 
</LI>
83
 
</UL>
84
 
 
85
 
<P>
86
 
<BR><HR>
87
 
<!--Table of Child-Links-->
88
 
<A NAME="CHILD_LINKS"><STRONG>Subsections</STRONG></A>
89
 
 
90
 
<UL CLASS="ChildLinks">
91
 
<LI><A NAME="tex2html3720"
92
 
  HREF="node235.html">Installation Notes</A>
93
 
<UL>
94
 
<LI><A NAME="tex2html3721"
95
 
  HREF="node236.html">University of Washington IMAP C-Client</A>
96
 
<LI><A NAME="tex2html3722"
97
 
  HREF="node237.html">Compiling Asterisk</A>
98
 
</UL>
99
 
<BR>
100
 
<LI><A NAME="tex2html3723"
101
 
  HREF="node238.html">Modify voicemail.conf</A>
102
 
<LI><A NAME="tex2html3724"
103
 
  HREF="node239.html">IMAP Folders</A>
104
 
<LI><A NAME="tex2html3725"
105
 
  HREF="node240.html">Separate vs. Shared Email Accounts</A>
106
 
<LI><A NAME="tex2html3726"
107
 
  HREF="node241.html">IMAP Server Implementations</A>
108
 
<UL>
109
 
<LI><A NAME="tex2html3727"
110
 
  HREF="node242.html">UW IMAP-2005 or earlier</A>
111
 
<LI><A NAME="tex2html3728"
112
 
  HREF="node243.html">UW IMAP-2006</A>
113
 
<LI><A NAME="tex2html3729"
114
 
  HREF="node244.html">UW IMAP-2007</A>
115
 
<LI><A NAME="tex2html3730"
116
 
  HREF="node245.html">Cyrus IMAP</A>
117
 
</UL>
118
 
<BR>
119
 
<LI><A NAME="tex2html3731"
120
 
  HREF="node246.html">Quota Support</A>
121
 
<LI><A NAME="tex2html3732"
122
 
  HREF="node247.html">Application Notes</A>
123
 
</UL>
124
 
<!--End of Table of Child-Links-->
125
 
<BR><HR>
 
64
  
 
65
<P>
 
66
ODBC Storage allows you to store voicemail messages within a database 
 
67
instead of using a file.  This is <SPAN  CLASS="textbf">not</SPAN> a full realtime engine and 
 
68
<SPAN  CLASS="textbf">only</SPAN> supports ODBC.  The table description for the <TT>voicemessages</TT>
 
69
table is as follows:
 
70
 
 
71
<P>
 
72
<BR><P></P>
 
73
<DIV ALIGN="CENTER"><A NAME="4993"></A>
 
74
<TABLE>
 
75
<CAPTION><STRONG>Table 11.1:</STRONG>
 
76
<TT>voicemessages</TT> Table Schema</CAPTION>
 
77
<TR><TD>
 
78
<DIV ALIGN="CENTER">
 
79
<TABLE CELLPADDING=3 BORDER="1" ALIGN="CENTER">
 
80
<TR><TD ALIGN="LEFT">Field</TD>
 
81
<TD ALIGN="LEFT">Type</TD>
 
82
<TD ALIGN="CENTER">Null</TD>
 
83
<TD ALIGN="CENTER">Key</TD>
 
84
<TD ALIGN="LEFT">Default</TD>
 
85
<TD ALIGN="LEFT">Extra</TD>
 
86
</TR>
 
87
<TR><TD ALIGN="LEFT">msgnum</TD>
 
88
<TD ALIGN="LEFT">int(11)</TD>
 
89
<TD ALIGN="CENTER">Yes</TD>
 
90
<TD ALIGN="CENTER">&nbsp;</TD>
 
91
<TD ALIGN="LEFT">NULL</TD>
 
92
<TD ALIGN="LEFT">&nbsp;</TD>
 
93
</TR>
 
94
<TR><TD ALIGN="LEFT">dir</TD>
 
95
<TD ALIGN="LEFT">varchar(80)</TD>
 
96
<TD ALIGN="CENTER">Yes</TD>
 
97
<TD ALIGN="CENTER">MUL</TD>
 
98
<TD ALIGN="LEFT">NULL</TD>
 
99
<TD ALIGN="LEFT">&nbsp;</TD>
 
100
</TR>
 
101
<TR><TD ALIGN="LEFT">context</TD>
 
102
<TD ALIGN="LEFT">varchar(80)</TD>
 
103
<TD ALIGN="CENTER">Yes</TD>
 
104
<TD ALIGN="CENTER">&nbsp;</TD>
 
105
<TD ALIGN="LEFT">NULL</TD>
 
106
<TD ALIGN="LEFT">&nbsp;</TD>
 
107
</TR>
 
108
<TR><TD ALIGN="LEFT">macrocontext</TD>
 
109
<TD ALIGN="LEFT">varchar(80)</TD>
 
110
<TD ALIGN="CENTER">Yes</TD>
 
111
<TD ALIGN="CENTER">&nbsp;</TD>
 
112
<TD ALIGN="LEFT">NULL</TD>
 
113
<TD ALIGN="LEFT">&nbsp;</TD>
 
114
</TR>
 
115
<TR><TD ALIGN="LEFT">callerid</TD>
 
116
<TD ALIGN="LEFT">varchar(40)</TD>
 
117
<TD ALIGN="CENTER">Yes</TD>
 
118
<TD ALIGN="CENTER">&nbsp;</TD>
 
119
<TD ALIGN="LEFT">NULL</TD>
 
120
<TD ALIGN="LEFT">&nbsp;</TD>
 
121
</TR>
 
122
<TR><TD ALIGN="LEFT">origtime</TD>
 
123
<TD ALIGN="LEFT">varchar(40)</TD>
 
124
<TD ALIGN="CENTER">Yes</TD>
 
125
<TD ALIGN="CENTER">&nbsp;</TD>
 
126
<TD ALIGN="LEFT">NULL</TD>
 
127
<TD ALIGN="LEFT">&nbsp;</TD>
 
128
</TR>
 
129
<TR><TD ALIGN="LEFT">duration</TD>
 
130
<TD ALIGN="LEFT">varchar(20)</TD>
 
131
<TD ALIGN="CENTER">Yes</TD>
 
132
<TD ALIGN="CENTER">&nbsp;</TD>
 
133
<TD ALIGN="LEFT">NULL</TD>
 
134
<TD ALIGN="LEFT">&nbsp;</TD>
 
135
</TR>
 
136
<TR><TD ALIGN="LEFT">flag</TD>
 
137
<TD ALIGN="LEFT">varchar(8)</TD>
 
138
<TD ALIGN="CENTER">Yes</TD>
 
139
<TD ALIGN="CENTER">&nbsp;</TD>
 
140
<TD ALIGN="LEFT">NULL</TD>
 
141
<TD ALIGN="LEFT">&nbsp;</TD>
 
142
</TR>
 
143
<TR><TD ALIGN="LEFT">mailboxuser</TD>
 
144
<TD ALIGN="LEFT">varchar(80)</TD>
 
145
<TD ALIGN="CENTER">Yes</TD>
 
146
<TD ALIGN="CENTER">&nbsp;</TD>
 
147
<TD ALIGN="LEFT">NULL</TD>
 
148
<TD ALIGN="LEFT">&nbsp;</TD>
 
149
</TR>
 
150
<TR><TD ALIGN="LEFT">mailboxcontext</TD>
 
151
<TD ALIGN="LEFT">varchar(80)</TD>
 
152
<TD ALIGN="CENTER">Yes</TD>
 
153
<TD ALIGN="CENTER">&nbsp;</TD>
 
154
<TD ALIGN="LEFT">NULL</TD>
 
155
<TD ALIGN="LEFT">&nbsp;</TD>
 
156
</TR>
 
157
<TR><TD ALIGN="LEFT">recording</TD>
 
158
<TD ALIGN="LEFT">longblob</TD>
 
159
<TD ALIGN="CENTER">Yes</TD>
 
160
<TD ALIGN="CENTER">&nbsp;</TD>
 
161
<TD ALIGN="LEFT">NULL</TD>
 
162
<TD ALIGN="LEFT">&nbsp;</TD>
 
163
</TR>
 
164
</TABLE>
 
165
</DIV>
 
166
</TD></TR>
 
167
</TABLE>
 
168
</DIV><P></P>
 
169
<BR>
 
170
 
 
171
<P>
 
172
The database name (from /etc/asterisk/res_odbc.conf) is in the
 
173
<TT>odbcstorage</TT> variable in the general section of voicemail.conf.
 
174
 
 
175
<P>
 
176
You may modify the <TT>voicemessages</TT> table name by using
 
177
<TT>odbctable=<SPAN  CLASS="textit">table_name</SPAN></TT> in voicemail.conf.
 
178
  
 
179
<DIV CLASS="navigation"><HR>
 
180
<!--Navigation Panel-->
 
181
<A NAME="tex2html3723"
 
182
  HREF="node235.html">
 
183
<IMG WIDTH="37" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="next"
 
184
 SRC="/usr/share/latex2html/icons/next.png"></A> 
 
185
<A NAME="tex2html3719"
 
186
  HREF="node233.html">
 
187
<IMG WIDTH="26" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="up"
 
188
 SRC="/usr/share/latex2html/icons/up.png"></A> 
 
189
<A NAME="tex2html3713"
 
190
  HREF="node233.html">
 
191
<IMG WIDTH="63" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="previous"
 
192
 SRC="/usr/share/latex2html/icons/prev.png"></A> 
 
193
<A NAME="tex2html3721"
 
194
  HREF="node1.html">
 
195
<IMG WIDTH="65" HEIGHT="24" ALIGN="BOTTOM" BORDER="0" ALT="contents"
 
196
 SRC="/usr/share/latex2html/icons/contents.png"></A>  
 
197
<BR>
 
198
<B> Next:</B> <A NAME="tex2html3724"
 
199
  HREF="node235.html">IMAP Storage</A>
 
200
<B> Up:</B> <A NAME="tex2html3720"
 
201
  HREF="node233.html">Voicemail</A>
 
202
<B> Previous:</B> <A NAME="tex2html3714"
 
203
  HREF="node233.html">Voicemail</A>
 
204
 &nbsp; <B>  <A NAME="tex2html3722"
 
205
  HREF="node1.html">Contents</A></B> </DIV>
 
206
<!--End of Navigation Panel-->
126
207
<ADDRESS>
127
208
lmadsen
128
 
2010-05-03
 
209
2010-06-17
129
210
</ADDRESS>
130
211
</BODY>
131
212
</HTML>