Re: [Asterisk-Users] Creating conf files from db
Hi Douglas Garstang, Dont go by their requirement list. It is crazy and who knows many of that might be already present in your linux distribution. But I have tried this in a Flash card asterisk dristribution and have come up with a working asterisk+amp+linux in 130 MB. My suggestion is giving a try to AMP is still worth at least you will get an idea on how to make asterisk configurable from mysql. Regards Jithu Douglas Garstang wrote: 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:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 5:57 AM To: [EMAIL PROTECTED]; 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Tel: +44 1296 768003 VoIP: sip:[EMAIL PROTECTED] VoIP: [EMAIL PROTECTED] 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 ___ --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
Re: [Asterisk-Users] Creating conf files from db
On Fri, Dec 23, 2005 at 07:21:54AM +, Peter Bowyer wrote: On 22/12/05, Douglas Garstang [EMAIL PROTECTED] 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. And they are badly written. E.g.: the ammount of code replication between them. -- Tzafrir Cohen | [EMAIL PROTECTED] | VIM is http://tzafrir.org.il | | a Mutt's [EMAIL PROTECTED] | | best ICQ# 16849755 | | friend ___ --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
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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Tel: +44 1296 768003 VoIP: sip:[EMAIL PROTECTED] VoIP: [EMAIL PROTECTED] 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
RE: [Asterisk-Users] Creating conf files from db
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:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 5:57 AM To: [EMAIL PROTECTED]; 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 [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Tel: +44 1296 768003 VoIP: sip:[EMAIL PROTECTED] VoIP: [EMAIL PROTECTED] 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 ___ --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
Re: [Asterisk-Users] Creating conf files from db
On 23/12/05, Tzafrir Cohen [EMAIL PROTECTED] wrote: On Fri, Dec 23, 2005 at 07:21:54AM +, Peter Bowyer wrote: On 22/12/05, Douglas Garstang [EMAIL PROTECTED] 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. And they are badly written. E.g.: the ammount of code replication between them. I guess they're written to be used independently - although I'm sure if you cared to contribute a 'better' version it would be well received -- Peter Bowyer Email: [EMAIL PROTECTED] Tel: +44 1296 768003 VoIP: sip:[EMAIL PROTECTED] VoIP: [EMAIL PROTECTED] 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
[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
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
RE: [Asterisk-Users] Creating conf files from db
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:[EMAIL PROTECTED] 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 ___ --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
RE: [Asterisk-Users] Creating conf files from db
AMP does this. http://coalescentsystems.ca/ Rick From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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. ___ --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
RE: [Asterisk-Users] Creating conf files from db
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:[EMAIL PROTECTED]Sent: Thursday, December 22, 2005 3:42 PMTo: 'Asterisk Users Mailing List - Non-Commercial Discussion'Subject: RE: [Asterisk-Users] Creating conf files from db AMP does this. http://coalescentsystems.ca/ Rick From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Douglas GarstangSent: Thursday, December 22, 2005 3:07 PMTo: Asterisk Users Mailing List - Non-Commercial DiscussionSubject: [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
Re: [Asterisk-Users] Creating conf files from db
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 listTo 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
Re: [Asterisk-Users] Creating conf files from db
On 22/12/05, Douglas Garstang [EMAIL PROTECTED] 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: [EMAIL PROTECTED] Tel: +44 1296 768003 VoIP: sip:[EMAIL PROTECTED] VoIP: [EMAIL PROTECTED] 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
