queue_table:
CREATE TABLE QueueTable (
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’,
PRIMARY KEY (name)
) ENGINE=MyISAM DEFAULT CHARSET=latin1
queue_member_table:
CREATE TABLE queue_member_table (
uniqueid int(10) unsigned NOT NULL AUTO_INCREMENT,
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,
PRIMARY KEY (uniqueid),
UNIQUE KEY queue_interface (queue_name,interface)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1
and
i also did the setting in extconfig.conf
but still not able to read member from member table.
when i show log from cli>
localhost*CLI> queue show
monu has 0 calls (max unlimited) in ‘rrmemory’ strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 0s
No Members
No Callers
sonu has 0 calls (max unlimited) in ‘rrmemory’ strategy (0s holdtime, 0s talktime), W:0, C:0, A:0, SL:0.0% within 0s
No Members
No Callers
As i had already added member for both queue.
Please guide me further.