similar to: AstDB wildard searches

Hi All, I need to use partial matches on the CIDNAME family I have stored in AstDB. For example, an organisation might have several numbers with the same area code and the same first few digits: 1234 567890 1234 567889 1234 567824 ... I'd like to store these (e.g.) as CIDNAME/12345678* (where "*" is a wildcard) so that I can retrieve the organisation name from

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. currently i am running the phonebook in astdb with *database put cidname 0123456789 "name_surname"* and i retrive it with *exten =>9876543210,1,Set(CALLERID(name)=${DB(cidname/${CALLERID(num)})})* Now, my system has mysql and i got all my contacts in there in a database is called *asterisk *and a table called *addressbook**. *password of the mysql is *whateverpasswd* how do i

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

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

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.

My setup : Trixbox 2.6.1 & TE410P running well .: 1. I need to store the CallerId of the PSTN caller with his language preference so that next time he is played the prompt in his language that he chose the first time.What would be better - storing his number in the Asterisk DB and using Dbput and DBget ? or storing it in MySQL from the dial plan and quering it everytime to see the callers

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

Thanks a lot for the reply. I did follow that already, but i do have a problem. Here is my extensions.conf part for that particular number exten => 6912345678,1,Answer() exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd asterisk) exten => 6912345678,n,MYSQL(Query resultid ${connid} SET NAMES utf8) exten => 6912345678,n,GotoIf($["${connid}" =

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

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, Asterisk 1.4.12 on CentOS 5 I'm trying to increment an AstDB key with the length of the last outgoing call. Here's what I've got for "01" UK geographical numbers: exten => _01.,1,Dial(${UKGeographical}/${EXTEN},,g) exten => _01.,n,Log(NOTICE,Call to ${EXTEN} lasted ${DIALEDTIME}) exten => _01.,n,Set(CALLTIME=${DIALEDTIME}) exten =>

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

unix-odbc with Asterisk Realtime is one good way to use a different backend DB than MySQL. I haven't heard of "bit rot" problems running it over long times, but I'd like to if there are any. I'm particularly interested in seeing reports of Asterisk Realtime backed by Postgres. The problem with pointing dialplan DB functions like Set(DB) at unix-odbc (or any relational

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

Hi Most of our customers have generic names like "Hospital", so I need to rewrite their caller ID name by looking up the number in a database on the Asterisk server, and rewriting the name such as "Reading Hospital" so that we know who's calling. Any idea if this can be done with Asterisk, and how to do it? Thank you.