Load queue member from real time


i am using asterisk 13.26.0 and using realtime queue_table & queue_member_table.
i just created queue in queue_table and its working fine but now, how to add member in that same queue using queue_member_table.

Please guide me.


Any guidance ???
as i am still stuck on it.

I have not test it but I think that with these guides and some test, you could do it, note that voip-info site information is outdated

So you’ve got 2 tables, one for queues, and one for queue members. In the queue table, say you want to create a queue called “Queue1”. You would insert an entry into the queue table with name “Queue1”. “name” is the only required field for this. Now you’ve got yourself a queue named “Queue1” in realtime.

Next step, let’s make a queue member that’s associated with the queue “Queue1”. You will need an endpoint set up to take on the queue member role. Let’s call this “PJSIP/101”. Now all you have to do is insert this information into the queue members table. It could look something like “INSERT INTO queue_members (queue_name, interface, uniqueid) VALUES (‘Queue1’, ‘PJSIP/101’, 1);”. These are the required fields for a queue member. That should do it.

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’,

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)

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.

This may seem like a silly question, but just in case: have you added a member to your member table? Does the member identify as one of your endpoints in (pj)sip.conf (via the interface parameter)? Is the endpoint registered and can make calls?

I would also double check your extconfig.conf and make sure everything looks correct. One thing you may want to check is if you are specifying the correct table name in this file. Asterisk will use default values if you do not have the table name specified.

Hi bford,

i am very new for this, but i have already added these below mentioned details also. Anythings else required for this . . .

queue_member_table data : in this panalty is null

36 Agent/1002 monu SIP/1002 0
37 Agent/1001 monu SIP/1001 0

queues => odbc,asterisk,queue_table
queue_member => odbc,asterisk,queue_member_table
queue_log => odbc,asterisk,queue_log

thanks bford, this is resolved as i changed in queues.conf file .

thank-you once again

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.