Re: [Asterisk-Users] MySQL Dynamic Extensions
On Monday 15 March 2004 17:28, Darren Nay wrote: 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? Not yet, although you can do something similar by using the Eval and Exec applications. Eval has been committed to CVS; Exec is still being pondered on the bugtracker. You should be able to use these two applications to produce a static dialplan, which pulls applications and arguments from a database in real time, then executes them. -Tilghman ___ 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
[Asterisk-Users] MySQL Dynamic Extensions
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? I've found the following information on this subject: 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 [EMAIL PROTECTED]
Re: [Asterisk-Users] MySQL Dynamic Extensions
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 21 /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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ___ 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
Re: [Asterisk-Users] MySQL Dynamic Extensions
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 21 /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 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ___ 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 ___ 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