asterisk users - Oct 2005 - From Database, PHP-Webinterface -> TO flatfileconfiguration

Hi.

I've started working on a PHP-project that generates the configuration
files i need based on what's in my MYSQL database. I can add, delete and
edit users from the web. I can set up exactly the dialplan i need by
arranging the users in a firms and groups if needed. I've also set up a
java servlet so that i can get asterisk to reload by pushing a button
from the web-interface. The php-scripts communicates with ip-sockets. 

So what's my question? I'm just wondering if this is a good idea. Any
comments? I've looked into the mysql support in the addons but I find it
hard to do and complicated. For me it's easier to write the config-files
from a php-script. But what about performance? Any big difference here?
What do you think is the pros and cons of a setup like this?

Regards,
Arne Morten

Hey Arne!
My project 'PhoneCALL' http://www.vecsector.com/phonecall does pretty 
much the same thing as you are describing - stores the configs in mysql 
& then submits the changes to flat files & reloads asterisk on 
completion. For me & my clients - there hasn't been any noticeable 
difference, as we used mysql/php for CDR anyway. Also - the flat-files 
are loaded in memory once Asterisk starts, so it's not like it's 
constantly hammering the mysql database for info.

Go for it! :-)

--Dustin


Arne Morten Johansen wrote:
>Hi.
>
>I've started working on a PHP-project that generates the configuration
>files i need based on what's in my MYSQL database. I can add, delete and
>edit users from the web. I can set up exactly the dialplan i need by
>arranging the users in a firms and groups if needed. I've also set up a
>java servlet so that i can get asterisk to reload by pushing a button
>from the web-interface. The php-scripts communicates with ip-sockets. 
>
>So what's my question? I'm just wondering if this is a good idea.
Any
>comments? I've looked into the mysql support in the addons but I find it
>hard to do and complicated. For me it's easier to write the config-files
>from a php-script. But what about performance? Any big difference here?
>What do you think is the pros and cons of a setup like this?
>
>Regards,
>Arne Morten
>
>_______________________________________________
>--Bandwidth and Colocation sponsored by Easynews.com --
>
>Asterisk-Users mailing list
>Asterisk-Users@lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>   http://lists.digium.com/mailman/listinfo/asterisk-users
>  
>

Dear Arne Morten

For me the best solution is to use MySQL. That is the reason we have
developed http://astbill.com. There is no performance issues. AstBill is
Open Source and for each SIP and IAX account you can choose if you want to
use Static confguration from config-files or Asterisk REALTIME from the
MySQL database.

AstBill is a Web Based Billing, Routing and Management Software for Asterisk
and MySQL based on Drupal. AstBill Provides pre and post Paid Billing
Services. AstBill completely automates Asterisk billing and configuration
from start to finish. Key benefits is the Central Web-based installation,
Credit Control on outgoing calls and the User Management and call routing
module. The system is fully themes based.

Are Casilla
Viking Diversified Ltd, London, United Kingdom
http://astartelecom.com - Independent VOIP Telecoms Broker. Consulting in
Asterisk and Drupal
http://astbill.com - Billing, Routing and Management software for Asterisk
and MySQL. Running on Drupal
AstBill DEMO: http://demo.astbill.com


On 10/5/05, Arne Morten Johansen <amj@avio.no>
wrote:
>
> Hi.
>
> I've started working on a PHP-project that generates the configuration
> files i need based on what's in my MYSQL database. I can add, delete
and
> edit users from the web. I can set up exactly the dialplan i need by
> arranging the users in a firms and groups if needed. I've also set up a
> java servlet so that i can get asterisk to reload by pushing a button
> from the web-interface. The php-scripts communicates with ip-sockets.
>
> So what's my question? I'm just wondering if this is a good idea.
Any
> comments? I've looked into the mysql support in the addons but I find
it
> hard to do and complicated. For me it's easier to write the
config-files
> from a php-script. But what about performance? Any big difference here?
> What do you think is the pros and cons of a setup like this?
>
> Regards,
> Arne Morten
>
> _______________________________________________
> --Bandwidth and Colocation sponsored by Easynews.com
<http://Easynews.com>--
>
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> 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/20051005/02babac0/attachment.htm