similar to: Corrupted sqlite3 astdb back end

How do you load the contact list? It's a database? Sqlite3? https://wiki.asterisk.org/wiki/display/AST/SQLite3+astdb+back-end I'm not clear on what this specific database does. If it's not this specific database which has contact information, which database does? thanks, Thufir

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

Hello, I'm using an Asterisk 17 dialplan that currently includes: 1. many "DB gets" calls (ie statements like Set(FOO=${DB(Foo/Bar)}) 2. and a couple of "DB puts" (ie statements like Set(DB(Foo/Bar)=Foo) or DB_DELETE(Foo/bar)) I would like to add an HTTP Provisionning API that would allow an external program to mostly change or sometimes read some ASTDB values. Which

What are you using for the database - SQLite? I am using mysql (mariadb). I am not familiar with SQLlite. Can you access the database from the console - look up the list of tables - display the contents from a table? Anything to see if your SQLite is working and has asterisk data in it. From your Asterisk console, |CLI> core show help database| should give you a list of commands that you

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: # ps aux | grep asterisk asterisk 3389 13.1 3.5

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

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

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

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

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

On Thu, Oct 29, 2020 at 3:05 PM Jeff Pyle <jeff at ugnd.org> wrote: > 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 >

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

Hi all, Could someone please tell me what is the relative "cost" in using conf files oppose to the astdb? Basically I need to match a name to a phone number in order to have all users registered by name and not by number (which I understood is not a good practice). I have 2000 users and a complex dial-plan and server resources become an issue. I could implement this via a context in my

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

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

Greetings: I am using Sqlite3 database with my Rails app. When I try and run "rake tests" for the app it always fails with the error: ** Invoke default (first_time) ** Invoke test (first_time) ** Execute test ** Invoke test:units (first_time) ** Invoke db:test:prepare (first_time) ** Invoke environment (first_time) ** Execute environment ** Execute db:test:prepare ** Invoke

Hello, Are you looking for a general caching solution or you specifically need to use Redis? At Thirdlane we use Memcached which works just fine for our purposes. Regards, Volodya Ivanets From: "Dovid Bender" <dovid at telecurve.com> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users at lists.digium.com> Sent: Wednesday, July 8,