cel_odbc.conf.sample 3.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108
  1. ;
  2. ; Asterisk Channel Event Logging (CEL) - Adaptive ODBC Backend
  3. ;
  4. ; General module options category.
  5. [general]
  6. ; Use 'show_user_defined' to put "USER_DEFINED" in the eventtype field,
  7. ; instead of (by default) just putting the user defined event name there.
  8. ;
  9. ;show_user_defined=yes
  10. ; This configuration defines the connections and tables for which CEL records
  11. ; may be populated. Each context specifies a different CEL table to be used.
  12. ;
  13. ; The columns in the tables should match up word-for-word (case-insensitive) to
  14. ; the CEL variables set in the dialplan. The natural advantage to this system
  15. ; is that beyond setting up the configuration file to tell you what tables to
  16. ; look at, there isn't anything more to do beyond creating the columns for the
  17. ; fields that you want, and populating the corresponding CEL variables in the
  18. ; dialplan.
  19. ;
  20. ; Please note that after adding columns to the database, it is necessary to
  21. ; reload this module to get the new column names and types read.
  22. ;
  23. ; Warning: if you specify two contexts with exactly the same connection and
  24. ; table names, you will get duplicate records in that table. So be careful.
  25. ;
  26. ; CEL FIELDS:
  27. ; eventtype
  28. ; CHANNEL_START = 1
  29. ; CHANNEL_END = 2
  30. ; HANGUP = 3
  31. ; ANSWER = 4
  32. ; APP_START = 5
  33. ; APP_END = 6
  34. ; BRIDGE_START = 7
  35. ; BRIDGE_END = 8
  36. ; CONF_START = 9
  37. ; CONF_END = 10
  38. ; PARK_START = 11
  39. ; PARK_END = 12
  40. ; BLINDTRANSFER = 13
  41. ; ATTENDEDTRANSFER = 14
  42. ; TRANSFER = 15
  43. ; HOOKFLASH = 16
  44. ; 3WAY_START = 17
  45. ; 3WAY_END = 18
  46. ; CONF_ENTER = 19
  47. ; CONF_EXIT = 20
  48. ; USER_DEFINED = 21
  49. ; LINKEDID_END = 22
  50. ; BRIDGE_UPDATE = 23
  51. ; PICKUP = 24
  52. ; FORWARD = 25
  53. ; eventtime (timeval, includes microseconds)
  54. ; userdeftype (set only if eventtype == USER_DEFINED)
  55. ; cid_name
  56. ; cid_num
  57. ; cid_ani
  58. ; cid_rdnis
  59. ; cid_dnid
  60. ; exten
  61. ; context
  62. ; channame
  63. ; appname
  64. ; appdata
  65. ; accountcode
  66. ; peeraccount
  67. ; uniqueid
  68. ; linkedid
  69. ; amaflags (an int)
  70. ; userfield
  71. ; peer
  72. ; extra
  73. ; The point of this module is to allow you log whatever you like in terms of the
  74. ; CEL variables. Do you want to log uniqueid? Then simply ensure that your
  75. ; table has that column. If you don't want the column, ensure that it does not
  76. ; exist in the table structure. If you'd like to call uniqueid something else
  77. ; in your table, simply provide an alias in this file that maps the standard CEL
  78. ; field name (uniqueid) to whatever column name you like.
  79. ;[first]
  80. ;connection=mysql1
  81. ;table=cel
  82. ;[second]
  83. ;connection=mysql1
  84. ;table=extracel
  85. ;[third]
  86. ;connection=sqlserver
  87. ;table=AsteriskCEL
  88. ;usegmtime=yes ; defaults to no
  89. ;allowleapsecond=no ; allow leap second in SQL column for eventtime, default yes.
  90. ;alias src => source
  91. ;alias channel => source_channel
  92. ;alias dst => dest
  93. ;alias dstchannel => dest_channel
  94. ; Any filter specified MUST match exactly or the event will be discarded
  95. ;filter accountcode => somename
  96. ;filter src => 123
  97. ; Additionally, we now support setting static values per column. Reason
  98. ; for this is to allow different sections to specify different values for
  99. ; a certain named column, presumably separated by filters.
  100. ;static "Some Special Value" => identifier_code