Hi,
i am using asterisk 18.6.0 and im stuck because realtime queues not working.
i am into this code for extensions.conf
queues => odbc,asterisk-connector,queue_table
queue_member => odbc,asterisk-connector,queue_member_table
and
i am also this code for queues.conf
realtime_family = queues, queue_member
odbc connection is good because running this code to console return sql page
isql -v asterisk-connector
i m also create the queue_table and queue_member_table like bottom sql code
CREATE TABLE IF NOT EXISTS queue_table (
name varchar(128) NOT NULL,
musiconhold varchar(128) DEFAULT NULL,
announce varchar(128) DEFAULT NULL,
context varchar(128) DEFAULT ‘Aria-Agent’,
timeout int(11) DEFAULT NULL,
monitor_join tinyint(1) DEFAULT NULL,
monitor_format varchar(128) DEFAULT NULL,
queue_youarenext varchar(128) DEFAULT NULL,
queue_thereare varchar(128) DEFAULT NULL,
queue_callswaiting varchar(128) DEFAULT NULL,
queue_holdtime varchar(128) DEFAULT NULL,
queue_minutes varchar(128) DEFAULT NULL,
queue_seconds varchar(128) DEFAULT NULL,
queue_lessthan varchar(128) DEFAULT NULL,
queue_thankyou varchar(128) DEFAULT NULL,
queue_reporthold varchar(128) DEFAULT NULL,
announce_frequency int(11) DEFAULT NULL,
announce_round_seconds int(11) DEFAULT NULL,
announce_holdtime varchar(128) DEFAULT NULL,
retry int(11) DEFAULT NULL,
wrapuptime int(11) DEFAULT ‘5’,
maxlen int(11) DEFAULT NULL,
servicelevel int(11) DEFAULT NULL,
strategy varchar(128) DEFAULT ‘rrmemory’,
joinempty varchar(128) DEFAULT NULL,
leavewhenempty varchar(128) DEFAULT NULL,
eventmemberstatus varchar(10) DEFAULT ‘YES’,
eventwhencalled varchar(10) DEFAULT ‘YES’,
reportholdtime tinyint(1) DEFAULT NULL,
memberdelay int(11) DEFAULT NULL,
weight int(11) DEFAULT NULL,
timeoutrestart tinyint(1) DEFAULT NULL,
periodic_announce varchar(50) DEFAULT NULL,
periodic_announce_frequency int(11) DEFAULT NULL,
ringinuse tinyint(1) DEFAULT ‘0’,
setinterfacevar varchar(11) DEFAULT ‘no’
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS queue_member_table (
uniqueid int(10) NOT NULL,
membername varchar(40) DEFAULT NULL,
queue_name varchar(128) DEFAULT NULL,
interface varchar(128) DEFAULT NULL,
penalty int(11) DEFAULT NULL,
paused int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
please help me where is problem