Hi

i dont think the DB is queried, I think the location in the memory is though

try using serctl to display what is in memory

Iqbal

Glenn Dalgliesh wrote:

I don’t seem to be able to get a match when I send a call from my gw to ser registered user. Debug indicates that user Not found in usrloc even though the database shows the users registered. I am able to make out bound calls the gw just fine. If anyone can shed some light in it it would be great.

Part 1 of 2 Part to follow with ser.cfg

Thanks

============================================================================

mysql> select * from location; +----------+--------+------------------------+----------+------------------- --+-------+----------------------------------+------+----------------+------ -----+-------+-------+----------------------------+ | username | domain | contact | received | expires | q | callid | cseq | last_modified | replicate | state | flags | user_agent | +----------+--------+------------------------+----------+------------------- --+-------+----------------------------------+------+----------------+------ -----+-------+-------+----------------------------+ | 9901 | | sip:9901@69.250.205.31 | NULL | 2005-02-26 03:31:09 | -1.00 | e5201b3819008718@192.168.199.102 | 107 | 20050226033016 | 0 | 0 | 0 | Grandstream BT100 1.0.5.11 | +----------+--------+------------------------+----------+------------------- --+-------+----------------------------------+------+----------------+------ -----+-------+-------+----------------------------+ 1 row in set (0.01 sec)

====debugt output====================================================================== =========================

20(18672) parse_headers: flags=256 20(18672) find_first_route: No Route headers found 20(18672) loose_route: There is no Route HF 20(18672) lookup(): '9901' Not found in usrloc

============================================================================

U 69.19.88.16:5060 -> 69.19.88.19:5060 INVITE sip:9901@69.19.88.19 SIP/2.0..Via: SIP/2.0/UDP 69.19.88.16:5060;branch=z9hG4bK2fb13d17..From: "Cell Phone MD" <sip:4103532264 @69.19.88.16>;tag=as149fbe93..To: sip:9901@69.19.88.19..Contact: sip:4103532264@69.19.88.16..Call-ID: 745bcf587074e77d4a8118dc212 ccba7@69.19.88.16..CSeq: 102 INVITE..User-Agent: Asterisk PBX..Date: Sat, 26 Feb 2005 08:41:01 GMT..Allow: INVITE, ACK, CANCEL, OPTIONS , BYE, REFER..Content-Type: application/sdp..Content-Length: 240....v=0..o=root 11581 11581 IN IP4 69.19.88.16..s=session..c=IN IP4 66. 159.88.16..t=0 0..m=audio 14934 RTP/AVP 0 8 101..a=rtpmap:0 PCMU/8000..a=rtpmap:8 PCMA/8000..a=rtpmap:101 telephone-event/8000..a=fmtp:1 01 0-16..a=silenceSupp:off - - - -.. # U 69.19.88.19:5060 -> 69.19.88.16:5060 SIP/2.0 100 trying -- your call is important to us..Via: SIP/2.0/UDP 69.19.88.16:5060;branch=z9hG4bK2fb13d17..From: "Cell Phone MD" < sip:4103532264@69.19.88.16>;tag=as149fbe93..To: sip:9901@69.19.88.19..Call-ID: 745bcf587074e77d4a8118dc212ccba7@69.19.88.16..CSeq: 102 INVITE..Server: Sip EXpress router (0.9.0 (i386/linux))..Content-Length: 0..Warning: 392 69.19.88.19:5060 "Noisy feedback tells: p id=18682 req_src_ip=69.19.88.16 req_src_port=5060 in_uri=sip:9901@69.19.88.19 out_uri=sip:9901@69.19.88.16:5060 via_cnt==1".... # U 69.19.88.19:5060 -> 69.19.88.16:5060 INVITE sip:9901@69.19.88.16:5060 SIP/2.0..Max-Forwards: 10..Record-Route: sip:69.19.88.19;ftag=as149fbe93;lr=on..Via: SIP/2.0/UDP 66 .159.88.19;branch=z9hG4bK96c9.80b8ddd7.0..Via: SIP/2.0/UDP 69.19.88.16:5060;branch=z9hG4bK2fb13d17..From: "Cell Phone MD" <sip:410353 2264@69.19.88.16>;tag=as149fbe93..To: sip:9901@69.19.88.19..Contact: sip:4103532264@69.19.88.16..Call-ID: 745bcf587074e77d4a8118d c212ccba7@69.19.88.16..CSeq: 102 INVITE..User-Agent: Asterisk PBX..Date: Sat, 26 Feb 2005 08:41:01 GMT..Allow: INVITE, ACK, CANCEL, OPT IONS, BYE, REFER..Content-Type: application/sdp..Content-Length: 240..P-hint: GATEWAY....v=0..o=root 11581 11581 IN IP4 69.19.88.16..s= session..c=IN IP4 69.19.88.16..t=0 0..m=audio 14934 RTP/AVP 0 8 101..a=rtpmap:0 PCMU/8000..a=rtpmap:8 PCMA/8000..a=rtpmap:101 telephone -event/8000..a=fmtp:101 0-16..a=silenceSupp:off - - - -.. # U 69.19.88.16:5060 -> 69.19.88.19:5060 SIP/2.0 482 Loop Detected..Via: SIP/2.0/UDP 69.19.88.19;branch=z9hG4bK96c9.80b8ddd7.0..Via: SIP/2.0/UDP 69.19.88.16:5060;branch=z9hG4b K2fb13d17..From: "Cell Phone MD" sip:4103532264@69.19.88.16;tag=as149fbe93..To: sip:9901@69.19.88.19;tag=as149fbe93..Call-ID: 74 5bcf587074e77d4a8118dc212ccba7@69.19.88.16..CSeq: 102 INVITE..User-Agent: Asterisk PBX..Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER ..Contact: sip:4103532264@69.19.88.16..Content-Length: 0....

---

Serusers mailing list serusers@lists.iptel.org http://lists.iptel.org/mailman/listinfo/serusers

.