search for: queue_member_t

hi, all i try to confiture realtime queue, but not work, details as below: Insert into queue_table(name)value('95040654321'); INSERT INTO queue_member_table VALUES ('', 'Zhang Shukun', '95040654321', 'SIP/1001', 2, 1); INSERT INTO queue_member_table VALUES ('', 'Li Aiwei', '95040654321', 'SIP/1002', 2, 1); INSERT INTO queue_member_table VALUES ('', 'Zhang Jianming', ...

...l] realtime_family=queue_members persistentmembers = yes autofill = yes monitor-type = MixMonitor [queue2280] music = default strategy = roundrobin timeout = 15 wrapuptime=10 announce-frequency = 30 announce-holdtime = no joinempty = yes extconfig.conf: [settings] queue_members=>mysql,ASTERISK,queue_member_table MYSQL: root at dell860:/etc/asterisk# mysql -u myuser -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 5.0.24a-Debian_9ubuntu2-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer...

...ogin app). I think this has something to do with how I setup the datatypes for my queus and queue member tables as I have no problems having asterisk save my CDR through unixODBC with firebird nor does my iax peers/users table have any problems either. Below is how I set up my queues_table and queue_member_table: CREATE TABLE queue_table ( name VARCHAR(128) NOT NULL PRIMARY KEY, musiconhold VARCHAR(128), announce VARCHAR(128), context VARCHAR(128), timeout NUMERIC(11,0), monitor_join SMALLINT, monitor_format VARCHAR(128), queue_youarenext VARCHAR(128), queue_thereare VARCHAR(128), queue_callswaiting VA...

...m already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html ? I have a database called asterisk which contains 2 main tables: Queues and queue_member_table, both tables have sample data. ? mysql> select * from queue_member_table; +----------+------------+------------+-----------+---------+--------+ | uniqueid | membername | queue_name | interface | penalty | paused | +----------+------------+------------+-----------+---------+--------+ |???????...

.../realtime/postgresql/realtime.sql:CREATE TABLE sip_conf ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE voicemail_users ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_table ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_member_table asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE "queue_log" ( Any help is appreciated. -Stephen More -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20140509/fcbc9b5...

...events via a websocket to a CRM. Basically what I want to do is notice when things happen (i.e. new channel, new bridge etc) without sending the channels to the Stasis app. The channels I'm interested in are agents who are in a queue only because they are in a realtime MySQL database for the queue_member_table. There doesn't appear to be a way to monitor general Asterisk events like you can in the Asterisk manager without polling for channel statuses or sending the channels to the Stasis app and recreating the logic of the Queue application. Is this a correct assumption? -- Cheers, Matt Ridde...

...p_buddies == Binding sippeers to mysql/general/sip_buddies == Binding iaxusers to mysql/general/iax_buddies == Binding iaxpeers to mysql/general/iax_buddies == Binding meetme to mysql/general/meetme == Binding queues to mysql/general/queue_table == Binding queue_members to mysql/general/queue_member_table Only extensions.conf and agents.conf are static, all other configs use the regular realtime engine and they all work fine. This is the table structure I have been using since 1.2: CREATE TABLE `ast_config` ( `id` int(11) NOT NULL auto_increment, `cat_metric` int(11) NOT NULL default ...

...and vmusers works just fine. extconfig.conf ; Primary Database Connection sipusers => odbc,proxy01,sipusers,1 sippeers => odbc,proxy01,sipusers,1 voicemail => odbc,proxy01,vmusers,1 meetme => odbc,proxy01,meetme,1 queues => odbc,proxy01,queue_table,1 queue_members => odbc,proxy01,queue_member_table,1 extensions => odbc,proxy01,extensions,1 -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20101226/aad633ff/attachment.htm>

...kefile) PGSQL application to let me do this: macro queue-addremove(queuename,penalty) { switch(${MACRO_EXTEN:0:1}) { case I: // Login PGSQL(Connect connid host=XXX user=XXX password=XXX dbname=XXX); PGSQL(Query resultid ${connid} INSERT INTO queue_member_table VALUES (\'${queuename}\'\,\'Local/${MACRO_EXTEN:1}@agents\'\,${penalty})); PGSQL(Clear ${resultid}); PGSQL(Disconnect ${connid}); break; I do this because AddQueueMember does not INSERT the new agent into the table defined in extc...

...nt to use realtime queues and agents and after following the instructions I can get the queue to show up on the system but no agents. I am using Asterisk 1.4.4 on a CentOS 5 machine. I have this in extconfig.conf: queues => mysql,asteriskcdrdb,queue_table queue_members => mysql,asteriskcdrdb,queue_member_table I put this into queues.conf: [general] realtime_family = queues,queue_members Here is what I get from queue show: pbxinsol*CLI> queue show henkel has 0 calls (max unlimited) in 'ringall' strategy (0s holdtime), W:0, C:0, A:0, SL:0.0% within 0s Members: Agent/1 (Inv...

Hi, Sorry to resend the same question. This mail is just to add a few bits of details: When I tried to join the "support" queue, I get L RealTime: Retrieve SQL: SELECT * FROM queue_member_table WHERE interface LIKE '%' AND queue_name = 'Support' ORDER BY interface [Mar 29 10:01:52] WARNING[6203]: app_queue.c:3939 queue_exec: Unable to join queue 'Support' In "show queue". it looks like the queue is set up fine: *CLI> show queue Support has 0...

hi,all i have just upgrade from 1.4.28 to 1.6.2.1. all works fine now except realtime queue. it seems queue_table works fine, but queue_member_queue not work, the two tables works fine when in 1.4.28. is that something changed related to realtime queue configuration? more detail about two table definition and data stored in , please see: http://pastebin.com/m33f9539e the extconfig.conf file,

...eue? I see AgentCallBack was something I would use, but it's been deprecated? I am guessing (bark if I'm wrong) I will need to do mealtime queue members, and create my own login/logoff scripts to add member to the mysql table? (I am already using realtime for sip, so adding a queue_member_table should not be difficult.) -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100226/3041af98/attachment.htm

...-------------------------------------+ | QueueDialplanParameters?????????????????????????????????????????????????? | | Queues?????????????????????????????????????????????????????????????????????????????????| | queue_log???????????????????????????????????????????????????????????????????????????? | | queue_member_table?????????????????????????????????????????????????????????? | +-----------------------------------------------------------------+ SQLRowCount returns 4 4 rows fetched Each table has?all of the required fields, some people suggested that queue_name is missing but it's not. I am getting the f...

...#39;/etc/asterisk/asterisk.conf': Found == Parsing '/etc/asterisk/extconfig.conf': Found == Binding iaxusers to mysql/asterisk/iaxfriends == Binding iaxpeers to mysql/asterisk/iaxfriends == Binding queues to mysql/asterisk/queue_table == Binding queue_members to mysql/asterisk/queue_member_table Asterisk 1.2.16, Copyright (C) 1999 - 2006 Digium, Inc. and others. Created by Mark Spencer <markster@digium.com> Asterisk comes with ABSOLUTELY NO WARRANTY; type 'show warranty' for details. This is free software, with components licensed under the GNU General Public License vers...

Could someone provide some steps for troubleshooting Realtime? I can't see any signs that it's working. I followed and double-checked a few different guides around the net, but haven't been able to figure it out. -------------- next part -------------- An HTML attachment was scrubbed... URL: