[asterisk-users] realtime queues "membername" problem

[Rob Coward]

I'm just about to start experimenting with realtime queues, so can't
offer anything from my own experience, but what happens if instead of
updating the existing row, you delete it and insert a new one for the new
user ? 

ie. DELETE FROM queue_member_table WHERE id=1; 

INSERT INTO
queue_member_table (membername,queue_name,interface,penalty,paused) VALUES
('OtherUser','in_pruebas','SIP/1336','1','0'); 

Rob 

On Wed, 23 Jun 2010
12:37:47 -0600, Jean Chassoul  wrote:  On Wed, Jun 23, 2010 at 1:57 AM,
Tiago Geada  wrote:
 to re-read peers from realtime db try: sip prune
realtime all
  Hi, I don't have a problem with peers or realtime sip! the
problem is with realtime queues I obviously have a queue_member_table for
INSERT/UPDATE/DELETE users to any queue on my callcenter system, I have for
example this row in queue members:   | id | membername | queue_name |
interface | penalty | paused | | 1 | chassoul | in_pruebas | SIP/1336 | 1 |
0 |   I can see everything is fine on in_pruebas queue with the *CLI>  
*CLI> queue show in_pruebas  in_pruebas has 0 calls (max unlimited) in
'rrmemory' strategy (0s holdtime), W:0, C:0, A:0, SL:0.0% within 0s 
Members:   chassoul (SIP/1336) with penalty 1 (realtime) (Not in use) has
taken no calls yet  No Callers    The problem is when i need to disconect a
user and connect another one with the same interface or simple update the
membername field on any row, for example:   mysql> update
queue_member_table set membername = 'OtherUser' where membername =
'chassoul'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1
Warnings: 0  mysql> select * from queue_member_table where queue_name =
'in_pruebas';  | id | membername | queue_name | interface | penalty |
paused | | 1 | OtherUser | in_pruebas | SIP/1336 | 1 | 0 | 
+------+------------+------------+-----------+---------+--------+ 1 row in
set (0.00 sec)   Asterisk don't read this change and don't update the new
information on the queue, I still got the old member instead of "OtherUser"
member. :(   *CLI> queue show in_pruebas  in_pruebas has 0 calls (max
unlimited) in 'rrmemory' strategy (0s holdtime), W:0, C:0, A:0, SL:0.0%
within 0s  Members:   chassoul (SIP/1336) with penalty 1 (realtime) (Not in
use) has taken no calls yet  No Callers   Any ideas?        




Links:
------
[1] mailto:tiago.geada at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100624/78507f46/attachment.htm