similar to: conf files vs astdb

Hi all, Can the Asterisk do ?things? not during a call? For example I would like to change my dial plan during certain hours\dates or I would like to check some information in the astdb (e.g. counters of al sort) and handle it as required and so on. All of this is not call-related therefore I don?t know if I can somehow do it using the dial-plan applications\functions. I know I can do chron jobs

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

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 All, I would like to separate the media traffic from the signalling. Can Asterisk send and receive media (rtp) traffic from a secondary network interface? Thanks, Harel ________________________________ This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the named

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

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

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

Hi All, I would like to implement a call-back option when called user is busy. Consider this scenario: 1. A caller is calling a number which is busy on another call. 2. The system will prompt the caller ("press 3 to be called back" etc.) to be called back when called user is available. 3. Caller hangs up. >>problem: how to monitor called user status after calling user has

I set up a call forwarding script in extensions.conf which uses the AstDB but I'm wondering if I reboot the server, will the entry in AstDB still reside? What the script does is when a call comes in, it check to see if there is a null value or a call forward number. If null, it will call the local office connections. If there is a number, it calls that. Now I just need to know if I reboot

I need clarification on couple of issues of Realtime Queue. It seems that when Agents(Memebers) are added using AddQueueMember, Asterisk puts this Queue-Member relationship information into AstDB, So that on asterisk restart this can be preserved. My question is, why does asterisk not store call information for Queue (holdtime, talktime, W, C, A, SL%) in AstDB, So that it can also be retained

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

Using svn trunk, I was trying to see what the astdb entry in the sip.conf file does. Nothing :) I presume that it's meant to create an entry in the astdb. so, I have astdb=chan2ext/SIP/grandstream1=1234 in sip.conf But database show only gives *CLI> database show /SIP/Registry/706 : 192.168.0.200:5060:3600:706:sip:706@192.168.0.200:5060

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 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

Hello, I'm trying to fill CID data into the astdb using AsteriskWin32's asterisk.exe, to no avail: The batch file stops after the first line, and just waits: ---------------------------------------- rem c:\cygroot\mystuff>import.bat rem rem c:\cygroot\mystuff>C:\cygroot\bin\asterisk.exe -rx 'database put cidname 123 "My cellphone"' rem rem Asterisk module

Hi listers, We want to implement one call center with asterisk. The idea is it should be scalable, with openser as an dispatcher and bunch of asterisk servers to do ACD, Queues, Agents things... Easy to say :( Look closely to the current asterisk, we do see some problem: - SIP registrations was stored in astdb. - And queue members also was stored in astdb. - ... asterisk was built as

Hi All, I?m trying to do ?things? after my Dial application terminates (e.g. play IVR to called party, calling party, etc.). I?m trying to use the local channel for this purpose but so far with no success. I?m using 1.6.1.18 and this is my extensions.conf: [Internal] exten => _22,1,Dial(Local/${EXTEN}@CW/n) ; 22 is test number exten => _22,2,Noop(After Hangup) [CW] exten =>

Hi, all What is the use of astdb? Is it used to store realtime values like sip etc. Regards, Bhrugu Mehta -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100127/b13d6a62/attachment.htm

Is anyone aware of a way to replicate parts of the AstDB to another Asterisk install? For example, to export all CF entries on a FreePBX based system to another system running FreePBX, I might do: asterisk -rx 'database show' | grep CF This gives me a list of data, which I can rsync to another host to reimport using 'database put'. BUT, the problem comes in when I want to sync

Hello everybody, I am not using astdb (no func_db and app_db) so I am wondering why asterisk is always updating it. The interval of the update is not constant. Using lsof, I noted the intervals are somewhere between 1 minute to 12 minutes. The output of lsof says that asterisk, atd and crond processes were just active, just after the hard disk changed the state from standby to active/idle. I