[Asterisk-Users] MySQL Dynamic Extensions

[Andy Powell]

You could take a look at 

http://andreasotto.net/asterisk/

and modify that to suit....

Andy

*********** REPLY SEPARATOR  ***********

On 15/03/2004 at 16:46 Tony Wasson wrote:

>Darren Nay wrote:
>> Hello All,
>> 
>>  
>> 
>> I am just looking into Asterisk as a viable voicemail solution for our
>phone
>> service.  In order to use it though I will need to make extensions.conf
>> dynamic (ie. Via MySQL).  Is this possible?
>> 
>
>Sure..
>
>Set up the database as you see documented. You can schedule this up to 
>once a minutes using crontab.
>
>Setting something like this in your /etc/crontab should do it nicely....
>
>*/5 * * * * root /usr/local/sbin/update-voicemail 2>&1 > /var/log/vm.log
>
>NOTE: You can increase the frequency by using */3 or */1. */5 means 
>every 5 minutes. */3 means every 3 minutes.
>
>Then make /usr/local/sbin/update-voicemail look like:
>
>   #!/bin/bash
>   /path/to/retrieve_extensions_from_mysql.pl
>   /usr/sbin/asterisk -rx "extensions reload"
>
>Next, make the script executable
>#chmod +x /usr/local/sbin/update-voicemail
>
>This is not totally dynamic, but it ought to be close enough. You could 
>make this completely dynamic using a trigger.
>
>Tony Wasson
>
>
>> 
>> I've found the following information on this subject:
>> 
>> http://www.voip-info.org/wiki-Asterisk+extensions+from+mysql
>> <http://www.voip-info.org/wiki-Asterisk+extensions+from+mysql> 
>> 
>>  
>> 
>> However, this is not a fully dynamic function.  It requires me to pull
>the
>> mysql database every so often (presumably via cron) and then restart
>> asterisk after updating extensions.conf.
>> 
>>  
>> 
>> Is it possible to setup asterisks so that extensions.conf is fully
>dynamic
>> via a MySQL database?
>> 
>>  
>> 
>> Thanks for the help!! 
>> 
>>  
>> 
>> Regards,
>> 
>>  
>> 
>> Darren Nay
>> 
>> dnay at ionosphere.net <mailto:dnay at ionosphere.net> 
>> 
>>  
>> 
>> 
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users