[Asterisk-Users] MySQL Dynamic Extensions

[Tony Wasson]

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> 
> 
>  
> 
>