[asterisk-users] queue_log/cel sqlite
creslin at digium.com
Fri Oct 21 09:16:29 CDT 2016
On Thu, Oct 20, 2016 at 9:45 AM, marek cervenka <cervajs2 at gmail.com> wrote:
> Dne 20/10/2016 v 16:32 Matt Fredrickson napsal(a):
>> On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <cervajs2 at gmail.com>
>>> i tested this
>>> # cat /etc/asterisk/extconfig.conf
>>> queue_log => sqlite3,cdrDb
>>> # cat /etc/asterisk/res_config_sqlite3.conf
>>> dbfile = /var/lib/asterisk/realtime.sqlite3
>>> sqlite3 /var/lib/asterisk/realtime.sqlite3
>>> CREATE TABLE "queue_log" ("time" TEXT, "data1" TEXT, "data2" TEXT,
>>> TEXT, "data4" TEXT, "data5" TEXT, "event" TEXT, "agent" TEXT, "queuename"
>>> TEXT, "callid" TEXT);
>>> and it works
>>> sqlite> select * from queue_log;
>>> 2016-10-20 11:40:36.628804||||||QUEUESTART|NONE|NONE|NONE
>>> 2016-10-20 11:40:36.690313||||||CONFIGRELOAD|NONE|NONE|NONE
>>> column types needs modification to something more appropriate
>>> can someone with confluence access ad info to
>>> https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration ?
>> Which info are you referring to? The table schema?
> ideally add "correct" sql schema for sqlite to asterisk repo and link it to
> it was hard for me to find if queue_log can be logged with sqlite. imho it
> will be usefull document the example configuration for others
> but i'm not sure where is the best place
> maybe https://wiki.asterisk.org/wiki/display/AST/Queue+Logs ?
My suggestion would be to add a comment to the page with your proposed
changes. That would be the best place to start, for the next time
someone works on that page.
Digium, Inc. | Engineering Manager
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA
More information about the asterisk-users