<div class="gmail_quote">On Wed, Jun 23, 2010 at 1:57 AM, Tiago Geada <span dir="ltr"><<a href="mailto:tiago.geada@gmail.com">tiago.geada@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<font color="#000066"><font face="courier new,monospace">to re-read peers from realtime db try: sip prune realtime all<br></font></font></blockquote><div><br></div><div>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:</div>
<div><br></div><div><div>| id | membername | queue_name | interface | penalty | paused |</div><div>| 1 | chassoul | in_pruebas | SIP/1336 | 1 | 0 | </div><div><br></div><div>I can see everything is fine on in_pruebas queue with the *CLI></div>
<div><br></div><div><div>*CLI> queue show in_pruebas </div><div>in_pruebas has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime), W:0, C:0, A:0, SL:0.0% within 0s</div><div> Members: </div><div> chassoul (SIP/1336) with penalty 1 (realtime) (Not in use) has taken no calls yet</div>
<div> No Callers</div></div></div><div><br></div><div>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:</div><div>
<br></div><div><div>mysql> update queue_member_table set membername = 'OtherUser' where membername = 'chassoul';</div><div>Query OK, 1 row affected (0.00 sec)</div><div>Rows matched: 1 Changed: 1 Warnings: 0</div>
<div><br></div><div>mysql> select * from queue_member_table where queue_name = 'in_pruebas';</div><div><br></div><div>| id | membername | queue_name | interface | penalty | paused |</div><div>| 1 | OtherUser | in_pruebas | SIP/1336 | 1 | 0 | </div>
<div>+------+------------+------------+-----------+---------+--------+</div><div>1 row in set (0.00 sec)</div></div><div><br></div><div>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. :(</div>
<div><br></div><div><div>*CLI> queue show in_pruebas </div><div>in_pruebas has 0 calls (max unlimited) in 'rrmemory' strategy (0s holdtime), W:0, C:0, A:0, SL:0.0% within 0s</div><div> Members: </div><div> chassoul (SIP/1336) with penalty 1 (realtime) (Not in use) has taken no calls yet</div>
<div> No Callers</div></div><div><br></div><div>Any ideas? </div><div><br></div><div><br></div><div><br></div><div><br></div></div>