Hello Nick,<div><br></div><div>Set your db_mode to 3.</div><div><br></div><div><a href="http://www.opensips.org/html/docs/modules/1.8.x/usrloc.html#id293049">http://www.opensips.org/html/docs/modules/1.8.x/usrloc.html#id293049</a>
</div><div><br></div><div>Regards,</div><div>Ali Pey</div><div><br></div><div><br><div class="gmail_quote">On Tue, Sep 4, 2012 at 10:57 PM, Nick Chang <span dir="ltr"><<a href="mailto:nick.chang@kland.com.tw" target="_blank">nick.chang@kland.com.tw</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="ZH-TW" link="blue" vlink="purple"><div><p class="MsoNormal"><span lang="EN-US">Hello Ali<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Debug is on<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal">
<span lang="EN-US">I saw log <u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialplan:translate: the rule's attrs are usrloc<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialplan:translate: the copied attributes are: usrloc<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialplan:rule_translate: null replacement<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialplan:dp_translate_f: input 0939723377 with dpid 0 => output<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:buf_init: initializing...<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: usrloc<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:comp_scriptvar: str 20 : usrloc<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:registrar:lookup: '<a href="mailto:0939723377@202.55.233.195" target="_blank">0939723377@202.55.233.195</a>' Not found in usrloc<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: -1<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:t_newtran: transaction on entrance=(nil)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:parse_headers: flags=ffffffffffffffff<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:parse_headers: flags=78<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:t_lookup_request: start searching: hash=18019, isACK=0<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:matching_3261: RFC3261 transaction matching failed<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:t_lookup_request: no transaction found<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:run_reqin_callbacks: trans=0x7f5de97b58c0, callback type 1, id 1 entered<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialog:dlg_onreq: t hash_index = 18019, t label = 688903610<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialog:get_dlg_timeout: invalid AVP value, use default timeout<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:run_reqin_callbacks: trans=0x7f5de97b58c0, callback type 1, id 0 entered<u></u><u></u></span></p><p class="MsoNormal">
<span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:parse_headers: flags=78<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:parse_headers: flags=ffffffffffffffff<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:_shm_resize: resize(0) called<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:run_trans_callbacks: trans=0x7f5de97b58c0, callback type 64, id 0 entered<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialog:next_state_dlg: dialog 0x7f5de97b4cd8 changed from state 1 to state 5, due event 4<u></u><u></u></span></p><p class="MsoNormal">
<span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialog:dlg_onreply: dialog 0x7f5de97b4cd8 failed (negative reply)<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialog:unref_dlg: unref dlg 0x7f5de97b4cd8 with 1 -> 2<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:cleanup_uac_timers: RETR/FR timers reset<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:set_timer: relative timeout is 500000<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:insert_timer_unsafe: [4]: 0x7f5de97b5a08 (47200000)<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:set_timer: relative timeout is 5<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:insert_timer_unsafe: [0]: 0x7f5de97b5a38 (51)<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:_reply_light: reply sent out. buf=0x7f5def3ee418: SIP/2.0 4..., shmem=0x7f5de97b8e00: SIP/2.0 4<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:run_trans_callbacks: trans=0x7f5de97b58c0, callback type 128, id 1 entered<u></u><u></u></span></p><p class="MsoNormal">
<span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:_reply_light: finished<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:tm:t_unref: UNREF_UNSAFE: [0x7f5de97b58c0] after is 0<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:dialog:unref_dlg: unref dlg 0x7f5de97b4cd8 with 1 -> 1<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:destroy_avp_list: destroying list (nil)<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17671]: DBG:core:receive_msg: cleaning up<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17672]: DBG:core:parse_msg: SIP Request:<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17672]: DBG:core:parse_msg: method: <ACK><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17672]: DBG:core:parse_msg: uri: <<a href="mailto:sip%3A0939723377@202.55.233.195" target="_blank">sip:0939723377@202.55.233.195</a>><u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Sep 5 10:53:07 Sharesip1 /usr/local/sbin/opensips[17672]: DBG:core:parse_msg: version: <SIP/2.0><u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">It tell me , can’t found this user.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">But In my database.<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US">mysql> select * from location;<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">+------+--------------+----------------+------------------------------------------------------------+--------------------------+------+---------------------+-------+------------+------+---------------------+-------+--------+--------------------------------+---------------------+---------+--------------+<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">| id | username | domain | contact | received | path | expires | q | callid | cseq | last_modified | flags | cflags | user_agent | socket | methods | sip_instance |<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">+------+--------------+----------------+------------------------------------------------------------+--------------------------+------+---------------------+-------+------------+------+---------------------+-------+--------+--------------------------------+---------------------+---------+--------------+<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">| 4237 | 886988000076 | 202.55.233.195 | <a href="mailto:sip%3A886988000076@10.1.1.53" target="_blank">sip:886988000076@10.1.1.53</a>;line=b690308c3bccdc1 | sip:<a href="http://118.163.61.141:40698" target="_blank">118.163.61.141:40698</a> | NULL | 2012-09-05 11:52:39 | -1.00 | 5605 | 2 | 2012-09-05 10:52:39 | 0 | 192 | Linphone/3.5.2 (eXosip2/3.6.0) | udp:<a href="http://10.1.2.150:5060" target="_blank">10.1.2.150:5060</a> | NULL | NULL |<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">| 4238 | 886988000076 | 202.55.233.195 | sip:886988000076@118.163.61.141:40698;line=b690308c3bccdc1 | sip:<a href="http://118.163.61.141:40698" target="_blank">118.163.61.141:40698</a> | NULL | 2012-09-05 11:52:39 | -1.00 | 5605 | 4 | 2012-09-05 10:52:39 | 0 | 192 | Linphone/3.5.2 (eXosip2/3.6.0) | udp:<a href="http://10.1.2.150:5060" target="_blank">10.1.2.150:5060</a> | NULL | NULL |<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">| 4239 | 0939723377 | 202.55.233.195 | sip:0939723377@42.73.55.31:3273;line=76a80b0cc2348e9 | NULL | NULL | 2012-09-05 11:05:32 | -1.00 | 2002148269 | 2 | 2012-09-05 10:55:32 | 0 | 0 | Linphone/3.5.2 (eXosip2/3.6.0) | udp:<a href="http://10.1.2.150:5060" target="_blank">10.1.2.150:5060</a> | NULL | NULL |<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">+------+--------------+----------------+------------------------------------------------------------+--------------------------+------+---------------------+-------+------------+------+---------------------+-------+--------+--------------------------------+---------------------+---------+--------------+<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">3 rows in set (0.00 sec)<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">I can see it.<u></u><u></u></span></p>
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Do you have any suggest??<u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span lang="EN-US">Thanks for your support.<span class="HOEnZb"><font color="#888888"><u></u><u></u></font></span></span></p><span class="HOEnZb"><font color="#888888"><p class="MsoNormal"><span lang="EN-US">Nick<u></u><u></u></span></p>
</font></span></div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>