similar to: newbie astdb error, please help

Hello friends, I am getting this error:- Oct 23 15:47:22 WARNING[2124]: db.c:171 ast_db_put: Unable to put value '192.168.1.12:5060:300:15553695861:sip:23@192.168.1.12:5060' for key '23' in family 'SIP/Registry I have no idea what it means. Please tell me what could be the problem. With warm regards. Vivek J. Joshi. vivek@staff.ownmail.com Trikon electronics Pvt. Ltd.

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 friends, I am a newbie to asterisk , please help. I am receiving a phone from a sip server and I want to route it to another sip server. The problem is that the target sip server takes a # in the argument . I am trying to dial as exten => s,5,Dial(12345#123456789@xxx.xxx.xxx.xxx) ;;;; dial the number at the ip address. When this gets executed, I get the following eror:-

I am writing an extension to accept speed dial nos. However, I forgot that these speed dials are the same for all offices and thus would ideally be shared by offices which will host their own Asterisk box. I read from a few postings that this database cannot be replicated to other Asterisk box. I was thinking that if I could just do a simple copy/paste of the speed dial records from the main

Hello friends, I am trying to install asterisk 1.4.0 . I am configuring it as follows:- ./configure --prefix=/home/vivek/downloads/install/asterisk/ But still while running 'make install', it tries to install it in /var/lib/asterisk/ and stops because of failing permissions. I have provided it a prefix, But it doesn't install it there. Can anybody tell me the solution for this. I

Hello, The other day, a 13.14.1 server suddenly stopped working correctly. First, it printed: Oct 23 21:53:40 FOOBAR asterisk[2377]: WARNING[27942]: db.c:332 in ast_db_put: Couldn't execute statment: SQL logic error or missing database This occurred while this server received a lot incoming REGISTER such as: Oct 23 21:53:40 FOOBAR asterisk[2377]: [Oct 23 21:53:40]

Hello friends, I am trying to install asterisk 1.4. I am configuring it as follows:- ./configure --prefix=/home/vivek/downloads/install/asterisk/ But still while running 'make install', it tries to install it in /var/lib/asterisk/ and stops because of failing permissions. I have provided it a prefix, But it doesn't install it there. Can anybody tell me the solution for this. I

Hello friends, Can I run two asterisks running simultaneously on the same machine? I want one to run v1.0.2 for h323 ( which is an old and running production system ) and one for sip implementation. I wonder how it can be done since they will want access to the same ports and ip addresses. Does anyone know to do this or has done this before? Please share your experiences please.

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

I have an ATA-186 in a SIP configuration (following Shawn Djernes how-to), but I get the following error at the asterisk console when I try to call the phone connected to the ATA: ioctl(ZT_LOADZONE) failed: Inappropriate ioctl for device Failed to register zone 'United States / North America': No data available Everything works if I remove indications.conf from /etc/asterisk -

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

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

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

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