[Asterisk-Users] voicemail system

[harry gaillac]

Hello,

I wish to use asterisk as a voicemail server with ser
.

I want to use asterisk external configuration toHello,

I wish to use asterisk as a voicemail server with ser
.

I want to use asterisk external configuration to
manage users and storing voicemail messages according
to ser database.

Where can i find the schema of the SQL DB for
voicemail accounts .
for example in extconfig ; file.conf =>
driver,database[,table]
;voicemail => odbc,asterisk

where is the schema of "asterisk" database ?

which script retrieve values in db for voicemail.conf
?

Regards 

Harry






///////////////////////////////////////////////////////

A Voicemail table would look more like this:

+----------+---------+----------+----------+-----------+---------------+
| uniqueid | mailbox | context  | password |email     
|   fullname    |
+----------+---------+----------+----------+-----------+---------------+
|        1 |   1234  | default  |  4242    | a at b.com  
| Joe Schmoe    |
+----------+---------+----------+----------+-----------+---------------+

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    | 
     |
| recording    | longblob    | YES  |     | NULL    | 
     |
+--------------+-------------+------+-----+---------+-------+




manage users and storing voicemail messages according
to ser database.

Where can i find the schema of the SQL DB for
voicemail accounts .
for example in extconfig ; file.conf =>
driver,database[,table]
;voicemail => odbc,asterisk

where is the schema of "asterisk" database ?

which script retrieve values in db for voicemail.conf
?

Regards 

Harry






///////////////////////////////////////////////////////

A Voicemail table would look more like this:

+----------+---------+----------+----------+-----------+---------------+
| uniqueid | mailbox | context  | password |email     
|   fullname    |
+----------+---------+----------+----------+-----------+---------------+
|        1 |   1234  | default  |  4242    | a at b.com  
| Joe Schmoe    |
+----------+---------+----------+----------+-----------+---------------+

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    | 
     |
| recording    | longblob    | YES  |     | NULL    | 
     |
+--------------+-------------+------+-----+---------+-------+






	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com