[Asterisk-Dev] (no subject)

[Steve Downs]

I noticed that there was some support for managing the configuration of
Asterisk in a database.  It seems that it is somewhat incomplete and I was
wondering if there was anyone working on it right now--or if there are any
serious caveats working in this area.

I am potentially looking to implement a rather large menu/voice mail
system and was thinking asterisk would be able to give me a lot of the
functionality I want.  The project requires that everything be rather
dynamic (prompts and routing can be changed on a whim).  I think I would
rather implement large portions of the config in a database to make it
easier for the user management interface (ie. a web interface) manipulate
the data.

I spent the weekend going through the code and added Postgresql support to
the MySQL support that was already there in chan_sip.c and chan_iax2.c. 
Additionally I made changes to allow the commands "sip show users" and
"sip show peers" show the data that it gets in the database (whether mysql
or postgres)--it is highly inefficient as implemented, but as a proof of
concept it works.

Many of the questions that I have concerning this have to do with the
database schema.  Has anyone spent the time to come up with a complete
schema that would encompass the extensions.conf file as well as sip and
iax2 (and any others)?

Steve