similar to: Pointers to replace astdb

I've been searching the Internet for information regarding the replacement of astdb with a modern sql engine. There are several reasons one would like to do this. First of all, external applications have a hard time reading/writing to the now-old astdb format. Also (and this is what interests me most), the sql astdb could easily be clustered throughout several servers (I'm looking for a

Does anyone know enough about the implementation of AstDB to know whether the data structure is a Hash function, a Balanced-Tree, a b-Tree, or a Linked List? I'm trying to estimate the lookup 'cost' of a AstDB with around 160,000 keys? Obviously I already know that it WILL WORK, but the question is whether the data structure is optimal in the Berkeley DB AS IMPLEMENTED in Asterisk.

Hi, Asterisk database is made of <family><key> records such as: fam key1 val1 fam key2 val2 ... fam key100 val100 I'm looking for the smartest way to iterate among different keys associated to a given family. One way to do this is to parse "database show fam" response. Is there something smarter ? Something like ${DBKEYS(fam)} which would evaluate to "key1

I'm wondering if there is any command-line interface available for working with values stored in astdb. Of course, I can run "asterisk -rx "database show" " or other commands like that, but I was hoping for a local command that would allow manipulation or output in some other form. Is astdb in a standard db format? JT

Is it possible to delete the keys belonging to a family in AstDB at Asterisk startup? I would like to repopulate it from another source each time Asterisk is restarted. I know there is a DBdeltree(<family>) function. Is there a context that only runs once (automatically) at Asterisk startup (so that I can call this function)? Also is AstDB lookup faster than a func_odbc lookup? Is there a

Hi All, I'm looking for a way to filter the AstDB cidname family to show only those entries with a specified area code in the Asterisk CLI. If this were a SQL database it would be something like: SELECT number, name FROM cidname WHERE number LIKE '1234%' I've tried "database show cidname 1234*" and substituted "%", "$", "-" for the wildcard

Is anyone out there using app_dbodbc (http://www.bkw.org/~brian/app_dbodbc.c)? Any problems with it? I was able to get it all working, but it causes * to segfault every now and then. It does not appear to be related to any specific function (ODBCget,ODBCput,ODBCdel,ODBCdelltree). It is 100% repeatable. If I noload the module, everything works fine, but when its running, after calls to any of the

Works for me.... Thanks, Hristo Benev -----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Alexandru Oniciuc Sent: Monday, May 17, 2010 6:29 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] R: new way of asterisk and kamailio(openser) realtime integration

Hi all, I am planning to implement LCR routing on my already running asterisk server. Uptill now i have found out that asterisk has no support for lcr, i have to do something about it myself, for example using the AGI. Im looking for ideas here. Whats the best way to start implementing lcr in asterisk. Should i use agi and start implementing my own lcr script or is there any plugin available which

This has been on my ToDo list far too long. I have a small call-center setup, with basic time of day/day of week validation before putting callers in the queues. With the holidays upon us, I need to add check to see if 'today' is a holiday so I do not put callers in unmanned queues. Due to how the agents work, I have to allow joinwhenempty. Does anyone have a snippet of dialplan code,

Hello, I put together a new tutorial about asterisk realtime integration with kamailio (openser). This time the database used is the one of asterisk, also call routing logic is controlled by asterisk, here is the link: http://kb.asipto.com/asterisk:realtime:kamailio-3.0.x-asterisk-1.6.2-astdb Practically is an easier way to scale starting from existing asterisk installations. The other

Hi there, I want to add 4000 Callerids and Callernames to my asterisk-db. (/var/lib/asterisk/astdb) I do not want an external database or an sql-database because I do not want asterisk to depend on external processes. However, when I do 4000 "database put number name" via a shellscript and "asterisk -rx" I only have 600 entries later in my asterisk- database. The asterisk

Hello, Here http://www.voip-info.org/wiki/view/Asterisk+database , you can read: "Also, since it's a normal Berkely db1 (version185) file its contents can be viewed/dumped with the standard *db1_dump185* tool. Thus db1_dump185 -p /var/lib/asterisk/astdb will show the complete database tree." Where can this db1_dump185 be found using Debian packages ? Regards -------------- next

Hellow, i need the following requirements with asterisk : 1) Can ACD (Automatic Call Distribution) service work with asterisk, and how to set up ACD in asterisk ? 2) How call barging can set up in asterisk ? 3) How call recording can set up in asterisk? Thanks mahboob System Engr SSL -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi. Is it possible to override the standard DB function in Asterisk? My dialplan contains a lot of calls to "Set(DB(...))" and "${DB(...)} which of course use astdb to store/read data. I would like to stop using astdb and switch to Clustered MySQL (I don't suppose "clustered astdb" exists?). So instead of rewriting extensions.conf and replacing the DB calls with

Hi, On Lenny, I typed "apt-get install db4.5-util " then (as root) : # db4.5_dump /var/lib/asterisk/astdb db4.5_dump: /var/lib/asterisk/astdb: unexpected file type or format db4.5_dump: open: /var/lib/asterisk/astdb: Invalid argument # file /var/lib/asterisk/astdb /var/lib/asterisk/astdb: Berkeley DB 1.85/1.86 (Btree, version 3, native byte-order) Is db4.5_dump appropriate to dump an

Hi, There is any simple way to have external access to the Asterisk database? I want to be able to edit a specific family only, which is a phonebook. Thanks, Dan

Is there any way to get Asterisk to reload the /var/lib/asterisk/astdb file? It seems to only read it on startup. Thanks.

All; I have a question regarding the Astdb. When reading more than a few values, it can take quite a while to grab several values in the astdb using say, asterisk -rx "database show" > output.txt and work with that and then set a new value such as asterisk -rx "database put $key $value". The whole process can take over 1 second for EACH ENTRY which adds up for more than a

Hi I'm trying to use Asterisk running as non-root user and selinux enabled. Asterisk is running ok, but astdb not works. When i try to put in astdb, console shows this message: WARNING[1853]: db.c:350 ast_db_put: Couldn't execute statment: SQL logic error or missing database CentOS 7.5.1804 Asterisk certified/13.21-cert3 [root at sv03 asterisk]# ls -lahZ /var/lib/asterisk/astdb.sqlite3