[Asterisk-Users] Re: Asterisk at large

[Douglas Garstang]

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)

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:cosmin at adicomsoft.ro]
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: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-
> bounces at lists.digium.com] 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 <dgarstang at oneeighty.com> 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:shmaltz at gmail.com]
> > 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, mkumar at mantragroup.com <mkumar at mantragroup.com> 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 mkumar at mantragroup.com:
> > >
> > > > 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