[asterisk-users] queue_log/cel sqlite

[marek cervenka]

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> 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 "queue_log" ("time" TEXT, "data1" TEXT, "data2" TEXT, "data3"
>> 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

https://wiki.asterisk.org/wiki/display/AST/Realtime+Database+Configuration


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 ?