[asterisk-users] Asterisk and Dabatase

[Mike]

Bilal,

I've explored two ways of working with the database, as far as dialplan
goes.  The first was using realtime, as described in the wiki, to store the
dialplan.  This became very messy very quickly, as an SQL database isn't a
great support for the dialplan. It's (relatively) hard to modify, and if
your goal is to build your own Web portal (which was my goal) you're stuck
making the portal code very complexe to accommodate the messy dialplan.

What I went with was the complete opposite.  I build the dialplan in the
conf files, but everytime I refered to something dynamic, I called an SQL
function (see MYSQL cmd for Asterisk).  This made the dialplan more complexe
(lot's of call to MYSQL) but it's more easily changed (since it's still
text) and the Web portal is much readable since everything relies a
well-designed relational DB instead of the dialplan realtime database.

But there are donwsides to that too: MYSQL down means my VoIP server is also
down (which never actually happened, but it could).  And, as I said, the
.conf file is a lot more complexe

As for the other parts of Asterisk (SIP accounts, queue data, etc) I did use
Asterisk realtime DB for that.  Be aware that, as of 1.4.22, there are
limitations with using SIP accounts in a realtime DB (for example, the
SIPPEER func doesn't seem to work, which is a darn shame, and hints don't
quite work too unless they are in a conf file.  That last issue seems to be
fixed in the latest 1.6, but I haven't tried it)...

Mike



-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of bilal ghayyad
Sent: Sunday, December 21, 2008 7:40
To: Asterisk Users Mailing List - Non-Commercial Discussion; Grey Man
Subject: Re: [asterisk-users] Asterisk and Dabatase

I am interested in the inner working and I would like to go deep, so how can
I start with letting asterisk work based on the database and work realtime?

About AsteriskNow, it is licensed as I know.

Regards
Bilal


--- On Sun, 12/21/08, Grey Man <greymanvoip at gmail.com> wrote:

> From: Grey Man <greymanvoip at gmail.com>
> Subject: Re: [asterisk-users] Asterisk and Dabatase
> To: bilmar_gh at yahoo.com, "Asterisk Users Mailing List - Non-Commercial
Discussion" <asterisk-users at lists.digium.com>
> Date: Sunday, December 21, 2008, 7:33 AM
> On Sun, Dec 21, 2008 at 11:57 AM, bilal ghayyad
> <bilmar_gh at yahoo.com> wrote:
> > Where this link? Did not see or receive any?
> >
> > In case of using database, how can I determine that my
> configuration be taken from DB or from .conf files? Where
> this can be setted? And is it possible to take confiruation
> from both?
> >
> > If any recorded added for DB, then I need to do a
> reload to become effected?
> 
> Getting Asterisk up and running with a database
> configuration
> (realtime) is not something that you will be able to do
> quickly or
> easily. If you are new to Asterisk I'd highly recommend
> getting a grip
> on running Asterisk with the configuration files before
> moving onto
> realtime.
> 
> If you're not too interested in the inner workings and
> do just want to
> get something up and running pronto take a look at the
> AsteriskNow or
> TrixBox products. They tend to provide a higher level
> abstraction to
> running Asterisk and have a web page based configuration
> approach.
> 
> Regards,
> 
> Greyman.


      

_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users