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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > >Reply-To: Asterisk Users Mailing List - > Non-Commercial Discussion > ><[email protected]> > >To: [email protected] > >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
README.extconfig
Description: 4218501336-README.extconfig
README.odbcstorage
Description: 1455846133-README.odbcstorage
_______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
