Just wondering if anyone here has tried the approach, where all config files are stored in a database, maybe using the ast_static table structure. Rather than using realtime to access the database live, you have scripts that read the contents of the db, and generate the .conf files from that., and then do a 'reload'. Anyone tried that? How'd it work for you? Doug. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051222/ae4d61a7/attachment.htm
Douglas Garstang a ?crit :> Just wondering if anyone here has tried the approach, where all config > files are stored in a database, maybe using the ast_static table > structure. Rather than using realtime to access the database live, you > have scripts that read the contents of the db, and generate the .conf > files from that., and then do a 'reload'.I did do that when I was doing a prototype which used FireFly as a client + the IAX2 protocol. I used Perl's Template Toolkit to generate the configuration files from the DB every 15 minutes or so and then do an asterisk -rx 'restart when convenient'.> Anyone tried that? How'd it work for you?Works just fine. But it was just a prototype which never had more than 20 users. Pretty cool stuff though - I even had the program generate a custom downloadable firefly installer (using NullSoft installer + Wine and a bit of Perl scripting) for each user so it would be a zero config setup. I never really went ahead with the project because the Firefly people are unreacheable. Their mailserver is pretty much broken, they don't answer the phone, and they never shipped those Fancy IAX adapter that are on display on their site... Cheers, Jean-Michel.
Hi Jean-Michel. Awesome! Although.... I just spent an hour writing the perl code from scratch. Didn't know about the template toolkit. D'oh. Oh well, it seems to be working fine. I've written some scripts to RE-populate the db from the config files too. Thanks. -----Original Message----- From: Jean-Michel Hiver [mailto:jhiver@ykoz.net] Sent: Thursday, December 22, 2005 3:25 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] Creating conf files from db Douglas Garstang a ?crit :> Just wondering if anyone here has tried the approach, where all config > files are stored in a database, maybe using the ast_static table > structure. Rather than using realtime to access the database live, you > have scripts that read the contents of the db, and generate the .conf > files from that., and then do a 'reload'.I did do that when I was doing a prototype which used FireFly as a client + the IAX2 protocol. I used Perl's Template Toolkit to generate the configuration files from the DB every 15 minutes or so and then do an asterisk -rx 'restart when convenient'.> Anyone tried that? How'd it work for you?Works just fine. But it was just a prototype which never had more than 20 users. Pretty cool stuff though - I even had the program generate a custom downloadable firefly installer (using NullSoft installer + Wine and a bit of Perl scripting) for each user so it would be a zero config setup. I never really went ahead with the project because the Firefly people are unreacheable. Their mailserver is pretty much broken, they don't answer the phone, and they never shipped those Fancy IAX adapter that are on display on their site... Cheers, Jean-Michel. _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- Asterisk-Users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
AMP does this. http://coalescentsystems.ca/ Rick _____ From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Douglas Garstang Sent: Thursday, December 22, 2005 3:07 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [Asterisk-Users] Creating conf files from db Just wondering if anyone here has tried the approach, where all config files are stored in a database, maybe using the ast_static table structure. Rather than using realtime to access the database live, you have scripts that read the contents of the db, and generate the .conf files from that., and then do a 'reload'. Anyone tried that? How'd it work for you? Doug. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051222/34fb09fe/attachment.htm
I guess I do too now. Really, it wasn't hard to write. It still needs some work, but for 2 hours work, I'm nearly all the way there. -----Original Message----- From: Azfhasterisk [mailto:azfhasterisk@qwest.net] Sent: Thursday, December 22, 2005 3:42 PM To: 'Asterisk Users Mailing List - Non-Commercial Discussion' Subject: RE: [Asterisk-Users] Creating conf files from db AMP does this. http://coalescentsystems.ca/ Rick _____ From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Douglas Garstang Sent: Thursday, December 22, 2005 3:07 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [Asterisk-Users] Creating conf files from db Just wondering if anyone here has tried the approach, where all config files are stored in a database, maybe using the ast_static table structure. Rather than using realtime to access the database live, you have scripts that read the contents of the db, and generate the .conf files from that., and then do a 'reload'. Anyone tried that? How'd it work for you? Doug. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20051222/6f428f93/attachment.htm
Yes that is how AMP works. It's a very nice setup.
----- Original Message -----
From: Douglas Garstang
To: Asterisk Users Mailing List - Non-Commercial Discussion
Sent: Thursday, December 22, 2005 5:07 PM
Subject: [Asterisk-Users] Creating conf files from db
Just wondering if anyone here has tried the approach, where all config files
are stored in a database, maybe using the ast_static table structure. Rather
than using realtime to access the database live, you have scripts that read the
contents of the db, and generate the .conf files from that., and then do a
'reload'.
Anyone tried that? How'd it work for you?
Doug.
------------------------------------------------------------------------------
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20051222/39a5aca8/attachment.htm
On 22/12/05, Douglas Garstang <dgarstang@oneeighty.com> wrote:> Just wondering if anyone here has tried the approach, where all config files > are stored in a database, maybe using the ast_static table structure. Rather > than using realtime to access the database live, you have scripts that read > the contents of the db, and generate the .conf files from that., and then do > a 'reload'. > > Anyone tried that? How'd it work for you?http://www.voip-info.org/wiki/view/Asterisk+configuration+from+database Specifically, option 4b. You have scripts to do the bulk of this in your /contrib directory. -- Peter Bowyer Email: peter@bowyer.org Tel: +44 1296 768003 VoIP: sip:peter@bowyer.org VoIP: *5048707000@sipbroker.com FWD: **275*5048707000 VoipTalk: **473*5048707000
I took a look at it last night. It has a HUGE long list of requirements.
It's not worth the effort. I'll just write it myself.
-----Original Message-----
From: Jithendra [mailto:jithendra@cem-solutions.net]
Sent: Friday, December 23, 2005 5:57 AM
To: peter@bowyer.org; Asterisk Users Mailing List - Non-Commercial
Discussion
Subject: Re: [Asterisk-Users] Creating conf files from db
Hi Douglas Garstang,
Check out the functionality of AMP (Asterisk Management Portal). It
does what you want. It stores the configuration in the DB, then runs
some perl scripts to generate configuration files from the DN and then
reloads asterisk.
HTH.
Regards,
Jithu
Peter Bowyer wrote:
>On 22/12/05, Douglas Garstang <dgarstang@oneeighty.com> wrote:
>
>
>>Just wondering if anyone here has tried the approach, where all config
files
>>are stored in a database, maybe using the ast_static table structure.
Rather
>>than using realtime to access the database live, you have scripts that
read
>>the contents of the db, and generate the .conf files from that., and
then do
>>a 'reload'.
>>
>>Anyone tried that? How'd it work for you?
>>
>>
>
>http://www.voip-info.org/wiki/view/Asterisk+configuration+from+database
>
>Specifically, option 4b. You have scripts to do the bulk of this in
>your /contrib directory.
>
>--
>Peter Bowyer
>Email: peter@bowyer.org
>Tel: +44 1296 768003
>VoIP: sip:peter@bowyer.org
>VoIP: *5048707000@sipbroker.com
>FWD: **275*5048707000
>VoipTalk: **473*5048707000
>_______________________________________________
>--Bandwidth and Colocation provided by Easynews.com --
>
>Asterisk-Users mailing list
>To UNSUBSCRIBE or update options visit:
> http://lists.digium.com/mailman/listinfo/asterisk-users
>
>
>
>
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
Asterisk-Users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users