[Asterisk-Users] voicemail system

[harry gaillac]

Hello,

In fact i wish to add users table in ser DB. 
What's "voicemessages" table?

How can i configure voicemail conf according to
extconf
and voicemail messages stored in db.

readme.extconfig say voicemail conf is stored in db.
readme.odbcstorage say voicemail message are stored in
other table

What about ast_data ?

regards

Harry

--- Orlando Guitián <oguitian at msn.com> a écrit :

> 4. Configure database
> Create a database (e.g. 'asterisk_vm') & a user
> which can access it (needs 
> to have write access for password changes from
> inside VM).
> 
> For mysql table has to be called 'users' (hardcoded
> in .h file)
> 
> CREATE TABLE users (
>    context char(79) DEFAULT '' NOT NULL,
>    mailbox char(79) DEFAULT '' NOT NULL,
>    password char(79) DEFAULT '' NOT NULL,
>    fullname char(79) DEFAULT '' NOT NULL,
>    email char(79) DEFAULT '' NOT NULL,
>    pager char(79) DEFAULT '' NOT NULL,
>    options char(159) DEFAULT '' NOT NULL,
>    stamp timestamp,
>    PRIMARY KEY (context,mailbox)
> );
> 
> For postgres table has to be called 'voicemail'
> 
> CREATE TABLE voicemail (
>    context varchar(79) DEFAULT '' NOT NULL,
>    mailbox varchar(79) DEFAULT '' NOT NULL,
>    password varchar(79) DEFAULT '' NOT NULL,
>    fullname varchar(79) DEFAULT '' NOT NULL,
>    email varchar(79) DEFAULT '' NOT NULL,
>    pager varchar(79) DEFAULT '' NOT NULL,
>    options varchar(159) DEFAULT '' NOT NULL,
>    stamp timestamp,
>    PRIMARY KEY (context,mailbox)
> );
> 
> Note that context refers to the Mailbox context, not
> extension context)
> Note that the password is stored in plain text
> 
> 
> >From: harry gaillac <gaillacharry at yahoo.fr>
> >Reply-To: Asterisk Users Mailing List -
> Non-Commercial Discussion 
> ><asterisk-users at lists.digium.com>
> >To: Asterisk-Users at lists.digium.com
> >Subject: [Asterisk-Users] voicemail system
> >Date: Tue, 21 Jun 2005 00:51:48 +0200 (CEST)
> >
> >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


	

	
		
___________________________________________________________________________ 
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger 
Téléchargez cette version sur http://fr.messenger.yahoo.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: README.extconfig
Type: application/octet-stream
Size: 3047 bytes
Desc: 4218501336-README.extconfig
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20050621/5bc1c281/README.obj
-------------- next part --------------
A non-text attachment was scrubbed...
Name: README.odbcstorage
Type: application/octet-stream
Size: 1140 bytes
Desc: 1455846133-README.odbcstorage
Url : http://lists.digium.com/pipermail/asterisk-users/attachments/20050621/5bc1c281/README-0001.obj