search for: 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 lo...

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

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 Asterisk databas...

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

...s, 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 standalone PBX, so it's understandable. Is it time to replace astdb with something like MySQL, so all asterisk boxes in cluster can have identical access to all the informations, devstates, etc...? Our first thought i...

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

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 -rw-r-----. a...

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

Hello, On Asterisk 13.19 I'm trying to set astdbdir in /etc/asterisk.conf, but it's not having any effect. For example: # grep astdbdir /etc/asterisk/asterisk.conf astdbdir => /tmp/asterisk /tmp/asterisk exists and is owned by asterisk:asterisk, as the asterisk processing is running as asterisk:asterisk with the config file forced: # p...

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

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

...rious info that can help such a project, if people are really working on it. On Sat, 2008-03-08 at 20:08 -0600, asterisk-users-request at lists.digium.com wrote: > Date: Sat, 8 Mar 2008 10:01:28 -0800 (PST) > From: Vieri <rentorbuy at yahoo.com> > Subject: [asterisk-users] replace astdb with a cluster-capable sql > database engine > To: asterisk-users at lists.digium.com > Message-ID: <955964.50841.qm at web32608.mail.mud.yahoo.com> > Content-Type: text/plain; charset=iso-8859-1 > > I've been searching the Internet for information > r...

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

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 on restart? Though Queue-Member relationship information is stored in AstDB, it still forgets num...

...e enabled, a 'sip show peers' yields none. As each peer (phone) registers, or a call is made to the peer, Asterisk adds them to the list returned by 'sip show peers'. Correct? Apparently Asterisk doesn't refer to thie list however, when deciding where a peer is located. It uses astdb instead (I have rtcachefriends=yes). I cleared the fullcontact field in the database, and placed a call. The only place that Asterisk could get the peer's IP address from was astdb, as the peer wasn't in 'sip show peers' as I purposefully cleared the fullcontact field for all peers...

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 "%",...

...but it seems an easy way to test your database connection. Do you have webmin installed on your Centos7 box. I find that this is a handy web/graphical interface to Centos7. On 15/03/2017 10:55 AM, Dan Cropp wrote: > Here is the audit.log. > Does this indicate a problem with accessing the astdb.sqlite3 file? > > Permissions for this file are... > [root at localhost ~]# ls -l /var/lib/asterisk/astdb.sqlite3 > -rw-r--r--. 1 root root 5120 Mar 15 09:39 /var/lib/asterisk/astdb.sqlite3 > > > [root at localhost ~]# tail -f /var/log/audit/audit.log > type=AVC msg=audit(1...

I'd like to be able to generate a Manager Event from the dialplan but can't seem to find a way to do it. Alternatively, trigger and Event when a record in AstDB gets changed. Can anyone point me in the right direction? Thanks. By way of explanation, I've a app that connects to astmanproxy and I'd like it to know when a call group gets put into Nightservice. Putting the call group into Nightservice is done in the dialplan and sets a record in A...

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

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