login | register
Wed 01 of Aug, 2007 [09:14 UTC]

voip-info.org

Navigation
Today's Deals
Recently Visited Pages
Search with Google
Search this site with Google. Results may not include recent changes.

Web www.voip-info.org
Last Changes
Shoutbox
  • Aykut, Wed 01 of Aug, 2007 [07:53 UTC]: Hi all, does anybody know about Thomson ST2030 SIP phone. I have upgraded it to latest version (1.56) but "Hold" and "Conf" features are not working after the upgrade ?? Do you know any solution or do you have Ver. 1.52 ?? Where can I find it?
  • Edward J Brown, Tue 31 of Jul, 2007 [23:33 UTC]: Has anybody experienced Choppy voice quality when using a Linksys SPA942 in an Asterisk Conference bridge? It works fine with my polycom and Cisco, but sucks with my Linksys.
  • www.astawerks.com, Fri 27 of Jul, 2007 [18:00 UTC]: does anyone use asterisk on top of clark connect? does it work good?
  • simon, Fri 27 of Jul, 2007 [14:16 UTC]: Hi All, Has anyone here managed to get the Cisco79x1 to successfully fail over to the backup proxy. I have 2 asterisk servers , handsets all register and function, except that backup proxy function doesn't work. Any working example would be very apprecia
  • Matthew Richmond, Thu 26 of Jul, 2007 [03:40 UTC]: using the page() application to page across our building...often the meetme conferences don't disconnect after the caller hangs up. Anyone else having this problem. (using Polycom phones)
  • Matthew Richmond, Wed 25 of Jul, 2007 [02:58 UTC]: thanks Nicholas Blasgen! I haven't worked with AGI before, but there's always a first! Thanks again!
  • Nicholas Blasgen, Tue 24 of Jul, 2007 [19:18 UTC]: Matthew Richmond, AGI will handle all that for you.
  • sam, Mon 23 of Jul, 2007 [16:39 UTC]: need help - certain voicemail extension will stop working and recording voicemail on asterisk - anyone know why and how to fix it? Thanks
  • john haji, Mon 23 of Jul, 2007 [14:55 UTC]: free calls to pakistan
  • bong, Sat 21 of Jul, 2007 [19:09 UTC]: hi good day to all can anyone help me how to configured the nortel sip to the signaling server and how to activate in mobile w/ sip compatible without mcs
Server Stats
  • Execution time: 0.38s
  • Memory usage: 2.21MB
  • Database queries: 32
  • GZIP: Disabled
  • Server load: 3.42

Asterisk configuration from database

Configuration from database

Asterisk configurations can be stored in a database. This is useful since it allows easy creation of web-based UIs. There are different approaches to storing users in a database.

1. Asterisk RealTime (Asterisk v1.2)

Asterisk RealTime
The Asterisk external configuration engine is the result of work by Anthony Minessale II, Mark Spencer, and Constantine Filin. It is designed to provide a flexible, seamless integration between Asterisk's internal configuration structure and external SQL databases (maybe even LDAP one day).

External configuration is configured in /etc/asterisk/extconfig.conf allowing you to map any configuration file (static mappings) to be pulled from the database, or to map special runtime entries which permit the dynamic creation of objects, entities, peers, etc. without the necessity of a reload.

Generally speaking, the columns in your tables should line up with the fields you would specify in the given entity declaration. If an entry would appear more than once, in the column it should be separated by a semicolon.

A Tutorial on how to install and configure Asterisk Realtime can be found here:

2. Dynamic 'friends' (Asterisk v1.0.*)

The user details are read directly from the database. This is used for SIP & IAX friends:
Voicemail:
and also for MeetMe:

However the number of options supported by this 'MySQL_Friends' system is currently very limited: You can't specify nat= or host=dynamic nor accountcode= and the like. It appears that these restrictions made ast_data appear (see above and bug 1086).
Question: Does this entirely replace the peer entries in sip.conf, or does this add to manual entries in sip.conf?

3. Load configuration from database on startup (Asterisk v1.0.*)

Obviously, the disadvantage of such systems is that Asterisk needs to be reloaded to see these changes. This can be done from a shell script using

  asterisk -r -x reload

or by using the Manager interface.
An example of this approach is: Asterisk GUI phpMyEdit

3a: res_config

All the details are stored in the database. When changes are made, asterisk has to be reloaded to load the new configuration in memory. This is the approach taken by:

3b: contrib scripts

This can be used to write a file to be #included in sip.conf or extensions.conf, which means you can nicely mix database-based setup with .conf file setup:

4. Templates & MySQL_AUTH

This is available in Olle's chan_sip2:

Templates can be used to store the different user options and peers can be 'autocreated' when they register. Only the passwords are stored in the MySQL database.

Option 4 can also benefit from the use of Templates.

See also


Created by flavour, Last modification by chrissnell on Wed 03 of May, 2006 [05:10 UTC]

Comments

Comments Filter

ASTERISK +CVS HEAD

by agarcia on Thursday 26 of May, 2005 [14:47:45 UTC]
Hi all.

I have installed the 1.0.5 asterisk release with xorcom, why we cannot have the realtime with the normal install of asterisk?

How can y install CVS-HEAD on my asterisk ?

Thanks for your response


ast_data?

by axelm on Tuesday 27 of July, 2004 [16:25:19 UTC]
It seems to me that "ast_data" should be mentioned in the "dynamic" section - unfortunately i do not know enough about it's current status.

Please update this page with new information, just login and click on the "Edit" or "Add Comment" button above. Get a free login here: Register Thanks! - support@voip-info.org

Page Changes | Comments

Sponsored by:
Terms of Service Privacy Policy
© 2003-2007 Arte Marketing, Inc.

Powered by bitweaver