[asterisk-users] queue_log/cel sqlite

[marek cervenka]

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 ?


is there somebody using it in production?
thanks

Dne 20/10/2016 v 10:16 marek cervenka napsal(a):
> hi,
>
> is it possible log cel/queue_log to sqlite?
>
> via odbc?
>
> any experience?
>
> marek
>
>
>