On Thu, Mar 02, 2006 at 04:14:34PM -0700, Douglas Garstang wrote: > The best way to achieve maximum manageability is to design a MySQL database > and develop AGI scripts (in your language of choice) that work to that > design. I've found that it has been far easier to develop complex routing > logic in python than it is in the horrible assembler-like Asterisk > extensions.conf language. In a perfect world, there would be _ONE_ line in > your extensions.conf, and it would be: > > exten => _.,1,AGI(routing_script) agreed. I'm building a system for a few hundred users and this is the method I'm using basically. > > You'd also replicate your databases and put logic into your application such > that upon failure to connect to the primary database, the application can > seamlessly start performing reads from the secondary, replicated server. > > Doug. > > -----Original Message----- > From: Cosmin Prund [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 02, 2006 1:26 PM > To: 'Asterisk Users Mailing List - Non-Commercial Discussion' > Subject: RE: [Asterisk-Users] Re: Asterisk at large > > > I'm no Asterisk genie but if you're running on one server you're probably > not dealing with lots of users (for what I'm trying to say 100 users are not > a lot of users). Factoring in the VERY simple format of both sip.conf and > extensions.conf, isn't it possible to create an php "page" that would > generate those two files from the database? You'll next need to run a basic > script that would call the php's + asterisk -rx "reload" and you'd be done! > > If you're trying to skip the reload step (ie: make the changes available > immediately / transparently) I don't think it can be done, and this has > nothing to do with Asterisk and a lot more to do with databases. Asterisk is > something outside the database, using the database as nothing more but a > source for data. Asterisk will not know the data in the database has > changed, it needs to be told! > > On the other hand I am a newbie to Asterisk and I don't really like/know > mySql so I might be very wrong and far from the truth. > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:asterisk-users- > > [EMAIL PROTECTED] On Behalf Of C F > > Sent: Thursday, March 02, 2006 9:19 PM > > To: Asterisk Users Mailing List - Non-Commercial Discussion > > Subject: Re: [Asterisk-Users] Re: Asterisk at large > > > > Douglas, a lot easier? If it's like you say with multiple servers. But > > the OP did not indicate this in his/her question, in fact s/he sounded > > clueless. > > Also, what is the purpose of NOT having *any* configs from > > /etc/asterisk/???????? > > > > On 3/2/06, Douglas Garstang <[EMAIL PROTECTED]> wrote: > > > Yikes. Managability! It's a lot easier to manage multiple Asterisk > > systems configuration from a single MySQL database then it is to manage > > .conf files on several redundant Asterisk boxes. I can't believe you asked > > that question. I'll apologise in advance because I must be missing part of > > this thread. > > > > > > -----Original Message----- > > > From: C F [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, March 02, 2006 10:16 AM > > > To: Asterisk Users Mailing List - Non-Commercial Discussion > > > Subject: Re: [Asterisk-Users] Re: Asterisk at large > > > > > > > > > Can you explain why you would want asterisk only thru realtime? and > > > not thru the /etc/asterisk/ ? > > > > > > The wiki is located at: > > > http://www.voip-info.org/ > > > the archives for this list is located at: > > > http://lists.digium.com/ > > > The asterisk irc channel is at: > > > irc://irc.freenode.net/#asterisk > > > Google is located at: > > > http://www.google.com/ > > > The asterisk docs project is located at: > > > http://www.asteriskdocs.org/ > > > > > > > > > > > > > > > On 3/2/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > Hi Group, > > > > > > > > Please read my previous message below, I want to configure Asterisk > > with Mysql > > > > and make Asterisk dynamic so that Asterisk will read everything from > > Mysql and > > > > we can make changes to mysql data directly. Please tell how can we do > > this and > > > > point me to related documentation. > > > > > > > > Thanks for your help and time, > > > > Manoj. > > > > > > > > Quoting [EMAIL PROTECTED]: > > > > > > > > > Hi Group, > > > > > > > > > > I was able to install Asterisk and its addons successfully. Now I > > want to > > > > > eliminate sip.conf and extensions.conf and use everything from Mysql > > DB, Is > > > > > this possible? I have seen this page > > > > > > > > > > http://www.voip- > > info.org/wiki/index.php?page=Asterisk%20extensions%20from%20mysql > > > > > > > > > > and learnt that we still get the data from Mysql DB and write it as > > > > > sub file to > > > > > actual sip or extensions.conf before starting Asterisk. Can we > > > > > eliminate config > > > > > files completely? If it is possible then please point me to the > > links > > > > > explaing > > > > > how can we do this? I also found very less information on using > > Asterisk with > > > > > Mysql, if there are any articles discussing this please send me > > those links. > > > > > > > > > > Thanks for your help all the time, > > > > > Manoj. > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > > --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 > > _______________________________________________ > --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
-- Kristian Larsson, Net At Once AB Email: [EMAIL PROTECTED] Phone: +46 470 592717 Cell: +46 704 910401 _______________________________________________ --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
