Asterisk – New System

!!!Important!!!

When you set up new phone system, dont forget to check Audio Codec on the SIP and IAX trunks. If this shit is not configured properly, it cause busy signal when you pick up.

Asterisk watch active calls && Fix database

``

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

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