similar to: Deleting AstDB family at start

While playing with DB function in Dialplan, I have added some garbage in AstDB. These are some family names with space in them. See this, demo*CLI> database show /18-05-2011 00:00:0052011175221575/TESTDATE : 2011-05-14 21:33:46 /18-05-2011 00:00:0052011175221575/TEST1 : 410 /18-05-2011 00:00:0052011175221575/TEST2 : 155 /18-05-2011 00:00:0052011182614252/TEST3 :

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

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

I'm trying to determine the capacity of my host running Asterisk 11.8.1 on CentOS 6.5. The host is an Intel E3-1240v3 with 8GB RAM, an SSD, and gigabit Ethernet. The primary application will be bridging groups of users using meetme(). I'm using 2 boxes -- 1 to initiate calls using call files (box1), and 1 behaving a bit more like a production box -- bridging calls (box2). The call

I?m trying to use the asterisk database but I think there is a limitation in deleting records I need to make my logic work. I understand that I can delete all family members with a specific key and that I can delete an entire family of keys but I would like to be able to delete specific keys which have the same value, is this possible? I have tried moving things around so making the family the

The history of the question is lost (in the mail thread) so I'll jump in based on what I could see in my recent mail and the subject line: - The ASTDB should have no impact on Asterisk service start (which I assume is the problem given the subject line) - If you disabled SElinux then that's not the problem in starting asterisk >From another posting it appears that

Hello. I would like to run asterisk as an user other than root. I have seen some tutorials on the web, but I would like to know if there is some ?official? how-to for this. Is there? I looked at a thread on reviewboard regarding this (https://reviewboard.asterisk.org/r/654/). It was Paul Belangers work trying to make the installation process take care of this. But the conclusion seem to

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.

Hello everyone, We are using an Asterisk server (Ubuntu 10.04 64 bits, Asterisk 1.6.2.7, TDM2400 - 12 FXS/12 FXO), but I noticed the following dmesg alert: asterisk[4687]: segfault at 60 ip ****** sp ****** error 4 in asterisk[400000+187000] The server is running without troubles. I know I should worry, just don't know where to start. Any advices? Alex Saavedra -------------- next part

Hi, Have just been testing asterisk 1.8.0, 1.8.0-rc5 and a trunk version from about half an hour ago. IAX Friends (Zoiper Softphones) don't stay registered for more than a few seconds they start out with status unknown and quickly become unreachable, I am using realtime with postgresql, with tables and configuration that have worked fine for IAX in 1.6 and a trunk release from a few months

Dan - you probably installed the init script (look in /etc/init.d for an 'asterisk' file). Asterisk includes the older init style scripts which are *compatible* with systemd but you don't have as much control compared to creating an Asterisk systemd file. (SystemD service files replace InitD scripts). So that might be part of the solution, but first. If disabling Selinux allows

Hello, I have a problem related to the Asterisk CLI, when I enter "asterisk -rv", it cannot display the Asterisk CLI and instaed, I have this message "Unable to connect to remote asterisk (does /var/run/asterisk.ctl exist?)." When I check with "locate asterisk.ctl", it is indeed in the repertory "/var/run/". So after searching I have found we can enter

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

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

Hi, I am doing an AGI that logs to a database every Agent login/logoff. My idea is to be able to go to this database and check which agents where logged so that I can force their login in case Asterisk goes down for some reason. The problem is that I would need to reload their status from this AGI when Asterisk initializes. Is there a way to do this? One idea I had was to make safe_asterisk to

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