Dne 20/10/2016 v 16:32 Matt Fredrickson napsal(a):
On Thu, Oct 20, 2016 at 4:50 AM, marek cervenka <[email protected]> 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 ?
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
Join the Asterisk Community at the 13th AstriCon, September 27-29, 2016
http://www.asterisk.org/community/astricon-user-conference
New to Asterisk? Start here:
https://wiki.asterisk.org/wiki/display/AST/Getting+Started
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
