4 thoughts on - Queue_log/cel Sqlite

• 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):

• Which info are you referring to? The table schema?

  Matthew Fredrickson

• Dne 20/10/2016 v 16:32 Matt Fredrickson napsal(a):

  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 ?

• 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.