Tag Archives: asterisk

Asterisk watch active calls && Fix database

watch -n 1 "asterisk -vvvvvrx 'core show channels' | grep call"

WARNING[25801] res_config_mysql.c: Realtime table general@queue_log: column ‘time’ cannot be type ‘int(10) unsigned’ (need char)

Sample queue_log table for MySQL:

Drop table in qstat & asterisk database – table queue_log, and add it again. Then edit extconfig.conf

CREATE TABLE `queue_log` (
`id` varchar(40) NOT NULL default auto_increment,
`time` char(10) unsigned default NULL,
`callid` varchar(32) NOT NULL default '',
`queuename` varchar(32) NOT NULL default '',
`agent` varchar(32) NOT NULL default '',
`event` varchar(32) NOT NULL default '',
`data` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
);