[Serusers] lookup not finding local users

[Glenn Dalgliesh]

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 at 69.250.205.31 | NULL     | 2005-02-26
03:31:09 | -1.00 | e5201b3819008718 at 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 at 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 at 69.19.88.19>..Contact:
<sip:4103532264 at 69.19.88.16>..Call-ID: 745bcf587074e77d4a8118dc212
  ccba7 at 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 at 69.19.88.16>;tag=as149fbe93..To:
<sip:9901 at 69.19.88.19>..Call-ID:
745bcf587074e77d4a8118dc212ccba7 at 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 at 69.19.88.19 out_uri=sip:9901 at 69.19.88.16:5060
via_cnt==1"....
#
U 69.19.88.19:5060 -> 69.19.88.16:5060
  INVITE sip:9901 at 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 at 69.19.88.16>;tag=as149fbe93..To: <sip:9901 at 69.19.88.19>..Contact:
<sip:4103532264 at 69.19.88.16>..Call-ID: 745bcf587074e77d4a8118d
  c212ccba7 at 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 at 69.19.88.16>;tag=as149fbe93..To:
<sip:9901 at 69.19.88.19>;tag=as149fbe93..Call-ID: 74
  5bcf587074e77d4a8118dc212ccba7 at 69.19.88.16..CSeq: 102 INVITE..User-Agent:
Asterisk PBX..Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER
  ..Contact: <sip:4103532264 at 69.19.88.16>..Content-Length: 0....