<div dir="ltr">Hi Razvan,<div><br></div><div>I truncate the cc_tables to avoid the duplicate error.</div><div>I made the call and here below are the outputs of the commands you asked me to run:</div><div><br></div><div><div>
bash-4.2# opensipsctl fifo cc_list_queue</div><div>Call:: 0 Waiting for=1189 ETW=0</div><div> Flow:: support Priority=256 Skill=custcare</div><div>Call:: 1 Waiting for=1079 ETW=0</div><div> Flow:: support Priority=256 Skill=custcare</div>
<div>Call:: 2 Waiting for=593 ETW=0</div><div> Flow:: support Priority=256 Skill=custcare</div><div>Call:: 3 Waiting for=140 ETW=0</div><div> Flow:: support Priority=256 Skill=custcare</div><div>Call:: 4 Waiting for=24 ETW=0</div>
<div> Flow:: support Priority=256 Skill=custcare</div><div><br></div><div><br></div><div>bash-4.2# opensipsctl fifo cc_list_flows</div><div>Flow:: support Avg Call Duration=0 Processed Calls=0 Logged Agents=1 Ongoing Calls=5 Ref=5</div>
<div><br></div><div><br></div><div>bash-4.2# opensipsctl fifo cc_list_agents<br></div><div>Agent:: 1000 Ref=1 Loged in=YES State=incall</div><div><br></div><div><br></div><div>bash-4.2# opensipsctl fifo cc_list_calls<br></div>
<div>Call:: 943.0 Ref=2 State=queued Call Time=39 Flow=support</div><div>Call:: 943.0 Ref=2 State=queued Call Time=155 Flow=support</div><div>Call:: 943.0 Ref=2 State=queued Call Time=608 Flow=support</div><div>Call:: 943.0 Ref=2 State=queued Call Time=1094 Flow=support</div>
<div>Call:: 943.0 Ref=2 State=queued Call Time=1204 Flow=support</div></div><div><br></div><div><br></div><div>I'll send the debug log to your email address.</div><div><br></div><div><br></div><div>Thanks for your support</div>
<div><br></div><div>Best Regards,</div><div><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Wed, May 14, 2014 at 2:25 PM, Răzvan Crainea <span dir="ltr"><<a href="mailto:razvan@opensips.org" target="_blank">razvan@opensips.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi, Garmin!<br>
<br>
First of all, please truncate the cc_calls table. This should prevent the mysql duplicate error.<br>
Next make the call. According to your previous mail, you are hearing the queue message provided by the Asterisk box, right? If so, please run the following opensipsctl commands:<br>
<br>
opensipsctl fifo cc_list_queue<br>
opensipsctl fifo cc_list_flows<br>
opensipsctl fifo cc_list_agents<br>
opensipsctl fifo cc_list_calls<br>
<br>
If possible, please provide (via pastebin) the debug log of the call (privately if you want).<br>
<br>
Best regards,<br>
<br>
Razvan Crainea<br>
OpenSIPS Core Developer<br>
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.<u></u>com</a><div class=""><br>
<br>
On 05/14/2014 12:16 PM, Garmin Sag wrote:<br>
</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">
Hello All,<br>
<br>
I'm new to Opensips (and especially all the B2B stuff), so please<br>
forgive my ignorance. It's my first post to the list, so if it's not the<br>
right place to ask for help, then please forgive me.<br>
<br>
I want to try the new call center module, but I have problems. I'm using<br>
Opensips 1.11.1 (from<br>
<a href="http://opensips.org/pub/opensips/1.11.1/src/opensips-1.11.1-0f26cc5_src.tar.gz" target="_blank">http://opensips.org/pub/<u></u>opensips/1.11.1/src/opensips-<u></u>1.11.1-0f26cc5_src.tar.gz</a>).<br>
<br>
I think I've missed something.<br>
<br>
Here is what I expect from the test:<br>
1001@dark.sip calls 321 (the customer care number) and when the Agent<br>
(1000@dark.sip) is logged in, 1000 should receive the call, and 1001<br>
should hear the<br>
music on hold played from a remote Asterisk box (<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.57.3</a><br></div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>) until 1000 accepts the call.<div class=""><br>
<br>
Here is UL output:<br>
bash-4.2# opensipsctl ul show<br>
Domain:: location table=512 records=2<br>
AOR:: 1000@dark.sip<br>
Contact:: sip:1000@192.168.57.2:5060;ob Q=<br>
Expires:: 6<br>
Callid:: d8238fca92d546a4a02dacd49945ce<u></u>09<br>
Cseq:: 28989<br>
User-agent:: MicroSIP/3.5.2<br>
Received:: sip:<a href="http://192.168.57.2:5060" target="_blank">192.168.57.2:5060</a><br></div>
<<a href="http://192.168.57.2:5060" target="_blank">http://192.168.57.2:5060</a>><div class=""><br>
State:: CS_SYNC<br>
Flags:: 0<br>
Cflags:: NAT<br>
Socket:: udp:<a href="http://192.168.57.1:5060" target="_blank">192.168.57.1:5060</a><br></div>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>><div class=""><br>
Methods:: 8063<br>
AOR:: 1001@dark.sip<br>
Contact::<br>
<a href="http://sip:1001@192.168.57.1:5062" target="_blank">sip:1001@192.168.57.1:5062</a>;<u></u>line=440bf1c1659e8f5 Q=<br>
Expires:: 3419<br>
Callid:: 1327377519<br>
Cseq:: 12<br>
User-agent:: Linphone/3.6.1 (eXosip2/3.6.0)<br>
Received:: sip:<a href="http://192.168.57.1:5062" target="_blank">192.168.57.1:5062</a><br></div>
<<a href="http://192.168.57.1:5062" target="_blank">http://192.168.57.1:5062</a>><div class=""><br>
State:: CS_SYNC<br>
Flags:: 0<br>
Cflags:: NAT<br>
Socket:: udp:<a href="http://192.168.57.1:5060" target="_blank">192.168.57.1:5060</a><br></div>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>><div><div class="h5"><br>
Methods:: 4294967295<br>
<br>
<br>
<br>
When 1001 dial 321, it's connected to the music on hold on the remote<br>
asterisk box (192.168.57.3), but the Agent (1000@dark.sip) doesn't ring<br>
When I log off the agent using "opensipsctl fifo cc_agent_login 1000 0",<br>
then 1001 cannot call 321 ("Cannot handle call") and that's normal I think.<br>
When I log the Agent in using "opensipsctl fifo cc_agent_login 1000 1",<br>
then 1001 can call 321 and stay in queue while connected to the music on<br>
hold,<br>
but still the call is not delivered to the Agent<br>
<br>
Here is the code:<br>
.....<br>
loadmodule "b2b_entities.so"<br>
modparam("b2b_entities", "db_mode", 1)<br>
modparam("b2b_entities", "db_url",<br>
"mysql://opensips:opensipsrw@<u></u>localhost/opensips_1_11")<br>
<br>
loadmodule "b2b_logic.so"<br>
modparam("b2b_logic", "db_mode", 1)<br>
modparam("b2b_logic", "db_url",<br>
"mysql://opensips:opensipsrw@<u></u>localhost/opensips_1_11")<br>
modparam("b2b_logic", "script_scenario",<br>
"/etc/opensips/scenario_<u></u>callcenter.xml")<br>
<br>
loadmodule "call_center.so"<br>
modparam("call_center", "db_url",<br>
"mysql://opensips:opensipsrw@<u></u>localhost/opensips_1_11")<br>
modparam("call_center", "acc_db_url",<br>
"mysql://opensips:opensipsrw@<u></u>localhost/opensips_1_11")<br>
modparam("call_center", "b2b_scenario", "call center")<br>
.....<br>
<br>
route{<br>
......<br>
<br>
$var(flowid)="support";<br>
if($rU=="321") {<br>
if (is_method("INVITE") and !has_totag()) {<br>
if (!cc_handle_call("$var(flowid)<u></u>")) {<br>
send_reply("403","Cannot handle call");<br>
exit;<br>
}<br>
exit;<br>
}<br>
}<br>
<br>
.....<br>
<br>
<br>
<br>
<br>
And below are the database contents:<br>
<br>
MariaDB [opensips_1_11]> select * from cc_agents;<br>
+----+---------+--------------<u></u>--------------+----------+----<u></u>------+---------------+<br>
| id | agentid | location | logstate | skills |<br>
last_call_end |<br>
+----+---------+--------------<u></u>--------------+----------+----<u></u>------+---------------+<br>
| 1 | 1000 | <a href="http://sip:1000@192.168.57.2:5060" target="_blank">sip:1000@192.168.57.2:5060</a><br></div></div>
<<a href="http://sip:1000@192.168.57.2:5060" target="_blank">http://sip:1000@192.168.57.2:<u></u>5060</a>> | 1 | custcare | 0 |<div class=""><br>
+----+---------+--------------<u></u>--------------+----------+----<u></u>------+---------------+<br>
1 row in set (0.00 sec)<br>
<br>
MariaDB [opensips_1_11]> select * from cc_flows;<br>
+----+---------+----------+---<u></u>-------+------------+---------<u></u>--------+---------------------<u></u>-+<br>
| id | flowid | priority | skill | prependcid | message_welcome |<br>
message_queue |<br>
+----+---------+----------+---<u></u>-------+------------+---------<u></u>--------+---------------------<u></u>-+<br>
| 2 | support | 256 | custcare | | NULL |<br>
</div><a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.57.3</a> <mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>> |<div><div class="h5"><br>
+----+---------+----------+---<u></u>-------+------------+---------<u></u>--------+---------------------<u></u>-+<br>
1 row in set (0.00 sec)<br>
<br>
MariaDB [opensips_1_11]> select * from cc_calls;<br>
+----+-------+----------+-----<u></u>---+------------+-----+-------<u></u>-----+-----------+-----------+<u></u>-----------+---------+--------<u></u>-+-------+<br>
| id | state | ig_cback | no_rej | setup_time | eta | last_start |<br>
recv_time | caller_dn | caller_un | b2buaid | flow | agent |<br>
+----+-------+----------+-----<u></u>---+------------+-----+-------<u></u>-----+-----------+-----------+<u></u>-----------+---------+--------<u></u>-+-------+<br>
| 37 | 3 | 0 | 0 | -1 | 0 | 99 |<br>
99 | 1001 | 1001 | 943.0 | support | 1000 |<br>
+----+-------+----------+-----<u></u>---+------------+-----+-------<u></u>-----+-----------+-----------+<u></u>-----------+---------+--------<u></u>-+-------+<br>
1 row in set (0.00 sec)<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Every time 1001 calls 321, I get the following log<br>
<br>
May 14 09:33:12 darkstar /sbin/opensips[7494]:<br>
CRITICAL:db_mysql:wrapper_<u></u>single_mysql_real_query: driver error (1062):<br>
Duplicate entry '943.0' for key 'PRIMARY'<br>
May 14 09:33:12 darkstar /sbin/opensips[7494]: ERROR:core:db_do_insert:<br>
error while submitting query<br>
May 14 09:33:12 darkstar /sbin/opensips[7494]:<br>
ERROR:call_center:cc_db_<u></u>insert_call: inserting new record in database<br>
May 14 09:33:12 darkstar /sbin/opensips[7494]:<br>
ERROR:call_center:w_handle_<u></u>call: Failed to insert call record in db<br>
<br>
<br>
<br>
<br>
I checked my MySQL log, and I see something like the following<br>
<br>
<br>
Query insert into b2b_entities<br>
(type,tag0,tag1,callid,ruri,<u></u>from_uri,from_dname,to_uri,to_<u></u>dname,route0,route1,sockinfo_<u></u>srv,param,state,cseq0,cseq1,<u></u>lm,lrc,lic,contact0,contact1<br>
) values<br>
(0,'265302590','B2B.15.62','<u></u>1805953653','sip:321@dark.sip'<u></u>,'sip:1001@dark.sip','','sip:<u></u>321@dark.sip','','','','udp:<a href="http://192.168.57.1:5060" target="_blank">19<u></u>2.168.57.1:5060</a><br>
</div></div>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>','<u></u>943.0',1,21,1,0,0,21,'<a href="http://sip:1001@192.168.57.1:5062" target="_blank">sip:<u></u>1001@192.168.57.1:5062</a><br>
<<a href="http://sip:1001@192.168.57.1:5062" target="_blank">http://sip:1001@192.168.57.1:<u></u>5062</a>>','sip:<a href="http://192.168.57.1:5060" target="_blank">192.168.57.1:5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>')<div class=""><br>
Query insert into b2b_logic<br>
(si_key,scenario,sparam0,<u></u>sparam1,sparam2,sparam3,<u></u>sparam4,sdp,sstate,next_<u></u>sstate,lifetime,e1_type,e1_<u></u>sid,e1_to,e1_from,e1_key,e2_<u></u>type,e2_sid,e2_to,e2_from,e2_<u></u>key<br>
) values ('943.0','call center','<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.57.3</a><br></div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>','','','','','',1,1,<u></u>1400057835,0,'server1','sip:<u></u>321@dark.sip','sip:1001@dark.<u></u>sip','B2B.15.62',1,'client1','<a href="mailto:sip%3A789@192.168.57.3" target="_blank"><u></u>sip:789@192.168.57.3</a><br>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>','sip:1001@dark.sip','B2B.<a href="tel:252.8053748" value="+12528053748" target="_blank">252.8053748</a>')<div class="">
<br>
Query insert into cc_calls<br>
(state,ig_cback,no_rej,setup_<u></u>time,eta,last_start,recv_time,<u></u>caller_dn,caller_un,b2buaid,<u></u>flow,agent<br>
) values (2,0,0,-1,0,1623,1623,'1001','<u></u>1001','943.0','support','')<br>
Query insert into b2b_entities<br>
(type,tag0,tag1,callid,ruri,<u></u>from_uri,from_dname,to_uri,to_<u></u>dname,route0,route1,sockinfo_<u></u>srv,param,state,cseq0,cseq1,<u></u>lm,lrc,lic,contact0,contact1,<u></u>leg_tag,leg_cseq,leg_contact,<u></u>leg_route<br>
) values<br>
(1,'<u></u>e86fcb40bafe3c72250681c6aca3fa<u></u>92-c0ef','as79f2b584','B2B.<u></u><a href="tel:252.8053748" value="+12528053748" target="_blank">252.8053748</a>','','sip:1001@<u></u>dark.sip','','<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.<u></u>57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>','','','','udp:<a href="http://192.168.57.1:5060" target="_blank">192.168.57.1:<u></u>5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>','<u></u>943.0',4,22,1,1,0,22,'sip:<a href="http://192.168.57.1:5060" target="_blank">192.<u></u>168.57.1:5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>','<a href="http://sip:789@192.168.57.3:5060" target="_blank">s<u></u>ip:789@192.168.57.3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>','as79f2b584',22,'<a href="http://sip:789@192.168.57.3:5060" target="_blank">sip:<u></u>789@192.168.57.3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>','')<div class=""><br>
Query update b2b_logic set<br>
sstate=1,next_sstate=1,<u></u>lifetime=1400100975,e1_type=0,<u></u>e1_sid='server1',e1_to='sip:<u></u>321@dark.sip',e1_from='sip:<u></u>1001@dark.sip',e1_key='B2B.15.<u></u>62',e2_type=1,e2_sid='client1'<u></u>,e2_to='<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>',e2_from='sip:1001@dark.sip'<u></u>,e2_key='B2B.<a href="tel:252.8053748" value="+12528053748" target="_blank">252.8053748</a>'<div class="">
<br>
where si_key='943.0'<br>
Query update b2b_entities set<br>
state=5,cseq0=22,cseq1=1,lm=4,<u></u>lrc=0,lic=22,contact0='sip:<a href="http://192.168.57.1:5060" target="_blank">192<u></u>.168.57.1:5060</a><br></div>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>',<u></u>contact1='<a href="http://sip:789@192.168.57.3:5060" target="_blank">sip:789@192.168.57.<u></u>3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>',leg_tag='as79f2b584',<u></u>leg_cseq=22,leg_contact='<a href="http://sip:789@192.168.57.3:5060" target="_blank">sip:<u></u>789@192.168.57.3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>',leg_route='' where type=1 AND<div class=""><br>
tag0='<u></u>e86fcb40bafe3c72250681c6aca3fa<u></u>92-c0ef' AND tag1='as79f2b584' AND<br>
callid='B2B.<a href="tel:252.8053748" value="+12528053748" target="_blank">252.8053748</a>'<br>
Query update b2b_logic set<br>
sstate=1,next_sstate=1,<u></u>lifetime=1400100975,e1_type=0,<u></u>e1_sid='server1',e1_to='sip:<u></u>321@dark.sip',e1_from='sip:<u></u>1001@dark.sip',e1_key='B2B.15.<u></u>62',e2_type=1,e2_sid='client1'<u></u>,e2_to='<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>',e2_from='sip:1001@dark.sip'<u></u>,e2_key='B2B.<a href="tel:252.8053748" value="+12528053748" target="_blank">252.8053748</a>'<div class="">
<br>
where si_key='943.0'<br>
Query update b2b_entities set<br>
state=5,cseq0=21,cseq1=1,lm=0,<u></u>lrc=200,lic=21,contact0='<a href="http://sip:1001@192.168.57.1:5062" target="_blank">sip:<u></u>1001@192.168.57.1:5062</a><br></div>
<<a href="http://sip:1001@192.168.57.1:5062" target="_blank">http://sip:1001@192.168.57.1:<u></u>5062</a>>',contact1='sip:<a href="http://192.168.57.1:5060" target="_blank">192.168.<u></u>57.1:5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>' where type=0 AND tag0='265302590' AND<div class=""><br>
tag1='B2B.15.62' AND callid='1805953653'<br>
Query delete from b2b_entities where type=1 AND<br>
tag0='<u></u>e86fcb40bafe3c72250681c6aca3fa<u></u>92-c0ef' AND tag1='as79f2b584' AND<br>
callid='B2B.<a href="tel:252.8053748" value="+12528053748" target="_blank">252.8053748</a>'<br>
Query update b2b_logic set<br>
sstate=-2,next_sstate=1,<u></u>lifetime=1400057814,e1_type=0,<u></u>e1_sid='server1',e1_to='sip:<u></u>321@dark.sip',e1_from='sip:<u></u>1001@dark.sip',e1_key='B2B.15.<u></u>62',e2_type=1,e2_sid='client1'<u></u>,e2_to='<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>',e2_from='sip:1001@dark.sip'<u></u>,e2_key='B2B.<a href="tel:252.8053748" value="+12528053748" target="_blank">252.8053748</a>'<div class="">
<br>
where si_key='943.0'<br>
Query delete from b2b_entities where type=0 AND tag0='265302590' AND<br>
tag1='B2B.15.62' AND callid='1805953653'<br>
Query delete from b2b_entities where type=0 AND tag0='265302590' AND<br>
tag1='B2B.15.62' AND callid='1805953653'<br>
Query delete from b2b_logic where si_key='943.0'<br>
Query delete from b2b_entities where param='943.0'<br>
<br>
<br>
Query insert into b2b_entities<br>
(type,tag0,tag1,callid,ruri,<u></u>from_uri,from_dname,to_uri,to_<u></u>dname,route0,route1,sockinfo_<u></u>srv,param,state,cseq0,cseq1,<u></u>lm,lrc,lic,contact0,contact1<br>
) values<br>
(0,'1426943035','B2B.406.2','<u></u>271697631','sip:321@dark.sip',<u></u>'sip:1001@dark.sip','','sip:<u></u>321@dark.sip','','','','udp:<a href="http://192.168.57.1:5060" target="_blank">19<u></u>2.168.57.1:5060</a><br>
</div>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>','<u></u>943.0',1,21,1,0,0,21,'<a href="http://sip:1001@192.168.57.1:5062" target="_blank">sip:<u></u>1001@192.168.57.1:5062</a><br>
<<a href="http://sip:1001@192.168.57.1:5062" target="_blank">http://sip:1001@192.168.57.1:<u></u>5062</a>>','sip:<a href="http://192.168.57.1:5060" target="_blank">192.168.57.1:5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>')<div class=""><br>
Query insert into b2b_logic<br>
(si_key,scenario,sparam0,<u></u>sparam1,sparam2,sparam3,<u></u>sparam4,sdp,sstate,next_<u></u>sstate,lifetime,e1_type,e1_<u></u>sid,e1_to,e1_from,e1_key,e2_<u></u>type,e2_sid,e2_to,e2_from,e2_<u></u>key<br>
) values ('943.0','call center','<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.57.3</a><br></div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>','','','','','',1,1,<u></u>1400057866,0,'server1','sip:<u></u>321@dark.sip','sip:1001@dark.<u></u>sip','B2B.406.2',1,'client1','<a href="mailto:sip%3A789@192.168.57.3" target="_blank"><u></u>sip:789@192.168.57.3</a><br>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>','sip:1001@dark.sip','B2B.<a href="tel:252.3775340" value="+12523775340" target="_blank">252.3775340</a>')<div class="">
<br>
Query insert into cc_calls<br>
(state,ig_cback,no_rej,setup_<u></u>time,eta,last_start,recv_time,<u></u>caller_dn,caller_un,b2buaid,<u></u>flow,agent<br>
) values (2,0,0,-1,0,1655,1655,'1001','<u></u>1001','943.0','support','')<br>
Query insert into b2b_entities<br>
(type,tag0,tag1,callid,ruri,<u></u>from_uri,from_dname,to_uri,to_<u></u>dname,route0,route1,sockinfo_<u></u>srv,param,state,cseq0,cseq1,<u></u>lm,lrc,lic,contact0,contact1,<u></u>leg_tag,leg_cseq,leg_contact,<u></u>leg_route<br>
) values<br>
(1,'<u></u>e86fcb40bafe3c72250681c6aca3fa<u></u>92-c0ef','as7277702c','B2B.<u></u><a href="tel:252.3775340" value="+12523775340" target="_blank">252.3775340</a>','','sip:1001@<u></u>dark.sip','','<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.168.<u></u>57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>','','','','udp:<a href="http://192.168.57.1:5060" target="_blank">192.168.57.1:<u></u>5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>','<u></u>943.0',4,22,1,1,0,22,'sip:<a href="http://192.168.57.1:5060" target="_blank">192.<u></u>168.57.1:5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>','<a href="http://sip:789@192.168.57.3:5060" target="_blank">s<u></u>ip:789@192.168.57.3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>','as7277702c',22,'<a href="http://sip:789@192.168.57.3:5060" target="_blank">sip:<u></u>789@192.168.57.3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>','')<div class=""><br>
Query update b2b_logic set<br>
sstate=1,next_sstate=1,<u></u>lifetime=1400101006,e1_type=0,<u></u>e1_sid='server1',e1_to='sip:<u></u>321@dark.sip',e1_from='sip:<u></u>1001@dark.sip',e1_key='B2B.<u></u>406.2',e2_type=1,e2_sid='<u></u>client1',e2_to='<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.<u></u>168.57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>',e2_from='sip:1001@dark.sip'<u></u>,e2_key='B2B.<a href="tel:252.3775340" value="+12523775340" target="_blank">252.3775340</a>'<div class="">
<br>
where si_key='943.0'<br>
Query update b2b_entities set<br>
state=5,cseq0=22,cseq1=1,lm=4,<u></u>lrc=0,lic=22,contact0='sip:<a href="http://192.168.57.1:5060" target="_blank">192<u></u>.168.57.1:5060</a><br></div>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>',<u></u>contact1='<a href="http://sip:789@192.168.57.3:5060" target="_blank">sip:789@192.168.57.<u></u>3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>',leg_tag='as7277702c',<u></u>leg_cseq=22,leg_contact='<a href="http://sip:789@192.168.57.3:5060" target="_blank">sip:<u></u>789@192.168.57.3:5060</a><br>
<<a href="http://sip:789@192.168.57.3:5060" target="_blank">http://sip:789@192.168.57.3:<u></u>5060</a>>',leg_route='' where type=1 AND<div class=""><br>
tag0='<u></u>e86fcb40bafe3c72250681c6aca3fa<u></u>92-c0ef' AND tag1='as7277702c' AND<br>
callid='B2B.<a href="tel:252.3775340" value="+12523775340" target="_blank">252.3775340</a>'<br>
Query update b2b_logic set<br>
sstate=1,next_sstate=1,<u></u>lifetime=1400101006,e1_type=0,<u></u>e1_sid='server1',e1_to='sip:<u></u>321@dark.sip',e1_from='sip:<u></u>1001@dark.sip',e1_key='B2B.<u></u>406.2',e2_type=1,e2_sid='<u></u>client1',e2_to='<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.<u></u>168.57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>',e2_from='sip:1001@dark.sip'<u></u>,e2_key='B2B.<a href="tel:252.3775340" value="+12523775340" target="_blank">252.3775340</a>'<div class="">
<br>
where si_key='943.0'<br>
Query update b2b_entities set<br>
state=5,cseq0=21,cseq1=1,lm=0,<u></u>lrc=200,lic=21,contact0='<a href="http://sip:1001@192.168.57.1:5062" target="_blank">sip:<u></u>1001@192.168.57.1:5062</a><br></div>
<<a href="http://sip:1001@192.168.57.1:5062" target="_blank">http://sip:1001@192.168.57.1:<u></u>5062</a>>',contact1='sip:<a href="http://192.168.57.1:5060" target="_blank">192.168.<u></u>57.1:5060</a><br>
<<a href="http://192.168.57.1:5060" target="_blank">http://192.168.57.1:5060</a>>' where type=0 AND tag0='1426943035' AND<div class=""><br>
tag1='B2B.406.2' AND callid='271697631'<br>
Query delete from b2b_entities where type=1 AND<br>
tag0='<u></u>e86fcb40bafe3c72250681c6aca3fa<u></u>92-c0ef' AND tag1='as7277702c' AND<br>
callid='B2B.<a href="tel:252.3775340" value="+12523775340" target="_blank">252.3775340</a>'<br>
Query update b2b_logic set<br>
sstate=-2,next_sstate=1,<u></u>lifetime=1400057840,e1_type=0,<u></u>e1_sid='server1',e1_to='sip:<u></u>321@dark.sip',e1_from='sip:<u></u>1001@dark.sip',e1_key='B2B.<u></u>406.2',e2_type=1,e2_sid='<u></u>client1',e2_to='<a href="mailto:sip%3A789@192.168.57.3" target="_blank">sip:789@192.<u></u>168.57.3</a><br>
</div>
<mailto:<a href="mailto:sip%253A789@192.168.57.3" target="_blank">sip%3A789@192.168.57.3</a><u></u>>',e2_from='sip:1001@dark.sip'<u></u>,e2_key='B2B.<a href="tel:252.3775340" value="+12523775340" target="_blank">252.3775340</a>'<div class="">
<br>
where si_key='943.0'<br>
Query delete from b2b_entities where type=0 AND tag0='1426943035'<br>
AND tag1='B2B.406.2' AND callid='271697631'<br>
Query delete from b2b_entities where type=0 AND tag0='1426943035'<br>
AND tag1='B2B.406.2' AND callid='271697631'<br>
Query delete from b2b_logic where si_key='943.0'<br>
Query delete from b2b_entities where param='943.0'<br>
<br>
<br>
<br>
Your help is really appreciated. And sorry for my poor english<br>
<br>
Best Regards,<br>
<br>
Garmin<br>
<br>
<br></div>
______________________________<u></u>_________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<u></u>bin/mailman/listinfo/users</a><br>
<br>
</blockquote>
<br>
______________________________<u></u>_________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-<u></u>bin/mailman/listinfo/users</a><br>
</blockquote></div><br></div>