similar to: Multiple queue_log files based on queue - is it possible??

On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com> wrote: > i tested this > > # cat /etc/asterisk/extconfig.conf > [settings] > queue_log => sqlite3,cdrDb > > # cat /etc/asterisk/res_config_sqlite3.conf > [cdrDb] > dbfile = /var/lib/asterisk/realtime.sqlite3 > > sqlite3 /var/lib/asterisk/realtime.sqlite3 > > CREATE TABLE

hi, is it possible log cel/queue_log to sqlite? via odbc? any experience? marek

Hello List - I've been slowing growing my extensions.conf file and have been wondering how everyone manages their systems. I currently have my main extensions.conf where I reference my sub extensions (for tenants or customers) files using the include statements and define my global variables. Today while watching the asterisk console I noticed a call from a voicemail user bounced into

In the example I posted previous, there is an obvious gaping security hole, it would be trivial for someone to read the querystring and exploit it to make free phone calls, spoof caller ID (if you allow the CallerID to be set with a QueryString value), etc. You want to make damn sure that the URL is not publicly accessible or somehow obsfucate the querystring, or use POST. In my case, I

Hi, Surely, I must be overlooking something. If I run the following SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000

I've added lines like this: speeddial = 123,test speeddial = 260,Bob in the [device] section for my 7921, but the speed dials do NOT appear on the menu (click right from the main screen). Am I missing something obvious here? Thanks MD -------------- next part -------------- An HTML attachment was scrubbed... URL:

Wow. My message made it to the list after more than 3 hours. Philipp -- amooma GmbH - Bachstr. 126 - 56566 Neuwied - http://www.amooma.de Let's use IT to solve problems and not to create new ones. Asterisk? -> http://www.das-asterisk-buch.de Gesch?ftsf?hrer: Stefan Wintermeyer Handelsregister: Neuwied B 14998

I have sent a few emails over the past couple of days that simply have not arrived on the list (or so it seems). Is anyone else encountering this ? Julian

Hello all, Could I create a script to delete the first messages on my voice mail? In this script should I update any "messages index file" or there isn't any file to index them? Could you share any script to do that? Thanks in advance. VoipCrazy. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hello! I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues. Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on

Hi, Do you if a DECT-GAP (or DECT-CAP) compliant handset MUST or MAY support roaming and handover and are these functions transparent for handset (then, these functions are implemented in DECT base stations) ? Regards -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20080110/4254f602/attachment.htm

Hi, I am using RT engine to log queue_log to a mysql database. My extconfig is [settings] queue_log => mysql,asterisk16_production Logging to mysql is working fine. But I find that the queue_log file now only has QUEUESTART lines for eg: 1250519094|NONE|NONE|NONE|QUEUESTART| 1250519186|NONE|NONE|NONE|QUEUESTART| How can I have queue_log in both db as well as in a file? thanks and

Hi, I am trying to log queue_log to odbc (MS SQL) I have res_odbc.conf configured and modules.conf have preload => res_odbc.so preload => res_config_odbc.so extconfig.conf has queue_log => odbc,asterisk. When I start asterisk I get the following messages. The important one being: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available

Hi! I want to detect brute-force password hacking attacks - thus if there are too many failed login attempts for a SIP account I want to "lock" this account. Does somebody have any ideas how this could be implemented? thanks klaus

Hello, Iam using queues and agents, thats OK. I have interesting information form Asterisk in txt file format var/log/asterisk/queue_log Today Iam reading these txt files and wrote them in an mySQL databases. I would need this information more realtime. Some information I do writing in the dialplan direct in an mySQL database. Is there any way that Asterisk write this information direct in

Just for some information really : How many of you use multiple sip lines on a phone ?. I'm sitting here looking at my 7960, with it's 6 lines. I've every only used one line, and I was wondering if I was a weirdo ;) The only time I've ever found a use was when I had two systems (production and test) and it caused so much grief (could have been asterisk or cisco) I simply use a

Hi list, I hope someone could help me. I've started using Asterisk 1.6.0.14 to get queue logs in real time with odbc (our databases are all PostgreSQL) but it's not working. However, cdr odbc is working well. When asterisk starts next message appears: WARNING[4217] config.c: Realtime mapping for 'queue_log' found to engine 'odbc', but the engine is not available My

Hi We're using 1.8.23.1 on CentOS 5 and are trying to get accurate stats for queues. For a particular customer, when I run queue show <queue_name> I get the following numbers: <queue_name> has 0 calls (max unlimited) in 'ringall' strategy (17s holdtime, 94s talktime), W:0, C:175, A:44, SL:48.6% within 45s So from that data we look at 17s holdtime And assume that is the

Hello list, as I'm writing a little perl parser for queue_log analysis, I'd like to know *which* telephone answered a specific queue call. Unfortunately app_queue only logs the call id but does not log the call end point. This is okay for SIP endpoints, because their call id is something like SIP/endpointname-1234 so you can reasonably understand who was on answering, but for

Hello, Here is a breakdown of the issue I am experiencing. I have three remote employees, in various states, who have Polycom 501 phones. They are unable to receive incoming calls after a few minutes of the phones being plugged in. They work immediately after being plugged in, but they lose the ability shortly thereafter. They can always make outbound calls, but only to real phone numbers, not