You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
93 lines
2.2 KiB
93 lines
2.2 KiB
; |
|
; Asterisk Channel Event Logging (CEL) - PostgreSQL Backend |
|
; |
|
|
|
; Sample Asterisk config file for CEL logging to PostgreSQL |
|
; |
|
; CEL field names: |
|
; |
|
; eventtype |
|
; CHANNEL_START = 1 |
|
; CHANNEL_END = 2 |
|
; HANGUP = 3 |
|
; ANSWER = 4 |
|
; APP_START = 5 |
|
; APP_END = 6 |
|
; BRIDGE_START = 7 |
|
; BRIDGE_END = 8 |
|
; CONF_START = 9 |
|
; CONF_END = 10 |
|
; PARK_START = 11 |
|
; PARK_END = 12 |
|
; BLINDTRANSFER = 13 |
|
; ATTENDEDTRANSFER = 14 |
|
; TRANSFER = 15 |
|
; HOOKFLASH = 16 |
|
; 3WAY_START = 17 |
|
; 3WAY_END = 18 |
|
; CONF_ENTER = 19 |
|
; CONF_EXIT = 20 |
|
; USER_DEFINED = 21 |
|
; LINKEDID_END = 22 |
|
; BRIDGE_UPDATE = 23 |
|
; PICKUP = 24 |
|
; FORWARD = 25 |
|
; eventtime (timeval, includes microseconds) |
|
; userdeftype (set only if eventtype == USER_DEFINED) |
|
; cid_name |
|
; cid_num |
|
; cid_ani |
|
; cid_rdnis |
|
; cid_dnid |
|
; exten |
|
; context |
|
; channame |
|
; appname |
|
; appdata |
|
; accountcode |
|
; peeraccount |
|
; uniqueid |
|
; linkedid |
|
; amaflags (an int) |
|
; userfield |
|
; peer |
|
; extra |
|
|
|
;CREATE TABLE pbx_cel ( |
|
; id bigserial , |
|
; eventtype varchar (32) NOT NULL , |
|
; eventtime timestamp NOT NULL , |
|
; userdeftype varchar(256) NOT NULL , |
|
; cid_name varchar (128) NOT NULL , |
|
; cid_num varchar (128) NOT NULL , |
|
; cid_ani varchar (128) NOT NULL , |
|
; cid_rdnis varchar (128) NOT NULL , |
|
; cid_dnid varchar (128) NOT NULL , |
|
; exten varchar (128) NOT NULL , |
|
; context varchar (128) NOT NULL , |
|
; channame varchar (128) NOT NULL , |
|
; appname varchar (128) NOT NULL , |
|
; appdata varchar (128) NOT NULL , |
|
; amaflags int NOT NULL , |
|
; accountcode varchar (32) NOT NULL , |
|
; peeraccount varchar (32) NOT NULL , |
|
; uniqueid varchar (160) NOT NULL , |
|
; linkedid varchar (160) NOT NULL , |
|
; userfield varchar (256) NOT NULL , |
|
; peer varchar (128) NOT NULL |
|
;); |
|
|
|
|
|
[global] |
|
; Use 'show_user_defined' to put "USER_DEFINED" in the eventtype field, |
|
; instead of (by default) just putting the user defined event name there. |
|
; |
|
;show_user_defined=yes |
|
|
|
hostname=127.0.0.1 |
|
port=5432 |
|
dbname=pbx |
|
password=ctepgSQL |
|
user=contacte |
|
table=pbx_cel ;SQL table where CEL's will be inserted |
|
;appname=asterisk ; Postgres application_name support (optional). Whitespace not allowed. |