****************************************************************** * Fired up Asterisk and sipfriends showing starting point/last state * At this point the sipfriends table has an entry for defaultip * from when I was just trying to update it to a new DHCP'd IP last week (192.168.1.103) * I fired up the Windows and Xten client which was assigned a new IP of * 192.168.1.107 and I then proceeded to update sipfriends extension * 2101 with this new IP address. ****************************************************************** mysql> select * from sipfriends; +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ | uniqueid | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | defaultip | dtmfmode | fromuser | fromdomain | host | incominglimit | outgoinglimit | insecure | language | mailbox | md5secret | nat | permit | deny | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | allow | disallow | regseconds | ipaddr | +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ | 3 | 2101 | NULL | NULL | NULL | NULL | NULL | default | 192.168.1.103 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | 2101 | NULL | NULL | NULL | NULL | NULL | 5060 | NULL | NULL | NULL | NULL | 1234 | friend | 2101 | NULL | NULL | 1108765479 | 192.168.1.106 | | 4 | 2102 | NULL | NULL | NULL | NULL | NULL | default | 192.168.1.103 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | 2102 | NULL | NULL | NULL | NULL | NULL | 5060 | NULL | NULL | NULL | NULL | 1234 | friend | 2102 | NULL | NULL | 1108774704 | 192.168.1.106 | +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ 2 rows in set (0.01 sec) mysql> *CLI> database show /SIP/Registry/2101 : 192.168.1.106:5060:1800:2101:sip:2101@192.168.1.106:5060 /SIP/Registry/2102 : 192.168.1.106:5060:1800:2102:sip:2102@192.168.1.106:5060 /dundi/secret : HRRcaUdXkwNqhi4Z+cGSGg /dundi/secretexpiry : 1109097682 *CLI> *********************************************************************** * Now just brought up new xten client with 192.168.1.107 *********************************************************************** mysql> update sipfriends set defaultip='192.168.1.107'; Query OK, 2 rows affected (0.00 sec) Rows matched: 2 Changed: 2 Warnings: 0 mysql> select * from sipfriends; +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ | uniqueid | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | defaultip | dtmfmode | fromuser | fromdomain | host | incominglimit | outgoinglimit | insecure | language | mailbox | md5secret | nat | permit | deny | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | allow | disallow | regseconds | ipaddr | +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ | 3 | 2101 | NULL | NULL | NULL | NULL | NULL | default | 192.168.1.107 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | 2101 | NULL | NULL | NULL | NULL | NULL | 5060 | NULL | NULL | NULL | NULL | 1234 | friend | 2101 | NULL | NULL | 1108765479 | 192.168.1.106 | | 4 | 2102 | NULL | NULL | NULL | NULL | NULL | default | 192.168.1.107 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | 2102 | NULL | NULL | NULL | NULL | NULL | 5060 | NULL | NULL | NULL | NULL | 1234 | friend | 2102 | NULL | NULL | 1108774704 | 192.168.1.106 | +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ 2 rows in set (0.00 sec) mysql> ************************************************************************************* * My Xten SIP client repeated tries to register with no luck (no IP in db) * BELOW IS A CALL FROM 100 (ZAP PHONE) TO 2101 ************************************************************************************* *CLI> -- Starting simple switch on 'Zap/1-1' -- Executing Dial("Zap/1-1", "SIP/2101|20") in new stack -- SIP Seeding '2101' at 2101@192.168.1.106:5060 for 1800 We're at 192.168.1.104 port 12048 Answering with capability 0x2 (gsm) Answering with capability 0x4 (ulaw) Answering with capability 0x8 (alaw) Answering with non-codec capability 0x1 (telephone-event) 12 headers, 12 lines Reliably Transmitting: INVITE sip:2101@192.168.1.106:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK609e3bcc From: "Ron Anderson" ;tag=as4f3ee087 To: Contact: Call-ID: 62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104 CSeq: 102 INVITE User-Agent: Asterisk PBX Date: Tue, 22 Feb 2005 18:03:59 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Content-Type: application/sdp Content-Length: 263 v=0 o=root 5169 5169 IN IP4 192.168.1.104 s=session c=IN IP4 192.168.1.104 t=0 0 m=audio 12048 RTP/AVP 3 0 8 101 a=rtpmap:3 GSM/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=silenceSupp:off - - - - (no NAT) to 192.168.1.106:5060 -- Called 2101 Retransmitting #1 (no NAT): INVITE sip:2101@192.168.1.106:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK609e3bcc From: "Ron Anderson" ;tag=as4f3ee087 To: Contact: Call-ID: 62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104 CSeq: 102 INVITE User-Agent: Asterisk PBX Date: Tue, 22 Feb 2005 18:03:59 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Content-Type: application/sdp Content-Length: 263 v=0 o=root 5169 5169 IN IP4 192.168.1.104 s=session c=IN IP4 192.168.1.104 t=0 0 m=audio 12048 RTP/AVP 3 0 8 101 a=rtpmap:3 GSM/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=silenceSupp:off - - - - to 192.168.1.106:5060 Retransmitting #2 (no NAT): INVITE sip:2101@192.168.1.106:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK609e3bcc From: "Ron Anderson" ;tag=as4f3ee087 To: Contact: Call-ID: 62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104 CSeq: 102 INVITE User-Agent: Asterisk PBX Date: Tue, 22 Feb 2005 18:03:59 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Content-Type: application/sdp Content-Length: 263 v=0 o=root 5169 5169 IN IP4 192.168.1.104 s=session c=IN IP4 192.168.1.104 t=0 0 m=audio 12048 RTP/AVP 3 0 8 101 a=rtpmap:3 GSM/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=silenceSupp:off - - - - to 192.168.1.106:5060 Retransmitting #3 (no NAT): INVITE sip:2101@192.168.1.106:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK609e3bcc From: "Ron Anderson" ;tag=as4f3ee087 To: Contact: Call-ID: 62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104 CSeq: 102 INVITE User-Agent: Asterisk PBX Date: Tue, 22 Feb 2005 18:03:59 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Content-Type: application/sdp Content-Length: 263 v=0 o=root 5169 5169 IN IP4 192.168.1.104 s=session c=IN IP4 192.168.1.104 t=0 0 m=audio 12048 RTP/AVP 3 0 8 101 a=rtpmap:3 GSM/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=silenceSupp:off - - - - to 192.168.1.106:5060 Retransmitting #4 (no NAT): INVITE sip:2101@192.168.1.106:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK609e3bcc From: "Ron Anderson" ;tag=as4f3ee087 To: Contact: Call-ID: 62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104 CSeq: 102 INVITE User-Agent: Asterisk PBX Date: Tue, 22 Feb 2005 18:03:59 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Content-Type: application/sdp Content-Length: 263 v=0 o=root 5169 5169 IN IP4 192.168.1.104 s=session c=IN IP4 192.168.1.104 t=0 0 m=audio 12048 RTP/AVP 3 0 8 101 a=rtpmap:3 GSM/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=silenceSupp:off - - - - to 192.168.1.106:5060 Retransmitting #5 (no NAT): INVITE sip:2101@192.168.1.106:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK609e3bcc From: "Ron Anderson" ;tag=as4f3ee087 To: Contact: Call-ID: 62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104 CSeq: 102 INVITE User-Agent: Asterisk PBX Date: Tue, 22 Feb 2005 18:03:59 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Content-Type: application/sdp Content-Length: 263 v=0 o=root 5169 5169 IN IP4 192.168.1.104 s=session c=IN IP4 192.168.1.104 t=0 0 m=audio 12048 RTP/AVP 3 0 8 101 a=rtpmap:3 GSM/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=silenceSupp:off - - - - to 192.168.1.106:5060 Feb 22 10:04:05 WARNING[5169]: chan_sip.c:730 retrans_pkt: Maximum retries exceeded on call 62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104 for seqno 102 (Critical Request) Destroying call '62b653243f8f053b4b3b5e5f61dc6475@192.168.1.104' -- SIP Seeding '2101' at 2101@192.168.1.106:5060 for 1800 == No one is available to answer at this time (1:0/0/0) -- Executing VoiceMail("Zap/1-1", "u2101") in new stack uniqueid => 2 customer_id => 2101 context => default mailbox => 2101 password => 1234 fullname => Ron SipPhone email => ron@advancedprovisioning.com stamp => 2005-02-17 17:05:29 -- Playing 'vm-theperson' (language 'en') -- Playing 'digits/2' (language 'en') -- Playing 'digits/1' (language 'en') -- Playing 'digits/0' (language 'en') -- Playing 'digits/1' (language 'en') == Spawn extension (default, 2101, 2) exited non-zero on 'Zap/1-1' -- Executing Hangup("Zap/1-1", "") in new stack == Spawn extension (default, h, 1) exited non-zero on 'Zap/1-1' -- Hungup 'Zap/1-1' ********************************************************************************* * DELETED 2101 FROM ASTERISK DATABASE ********************************************************************************* localhost*CLI> database del SIP Registry/2101 Database entry removed. localhost*CLI> database show /SIP/Registry/2102 : 192.168.1.106:5060:1800:2102:sip:2102@192.168.1.106:5060 /dundi/secret : HRRcaUdXkwNqhi4Z+cGSGg /dundi/secretexpiry : 1109097682 localhost*CLI> ************************************************************************************* * RESTARTED SIP CLIENT BUT UNABLE TO CONNECT AS 2101 (SEE XTEN LOG) ************************************************************************************* * THEN MADE CALL FROM ZAP PHONE 100 (SIP DEBUG FOLLOWS) ************************************************************************************* localhost*CLI> sip debug SIP Debugging Enabled We're at 192.168.1.104 port 18654 Answering with capability 0x2 (gsm) Answering with capability 0x4 (ulaw) Answering with capability 0x8 (alaw) Answering with non-codec capability 0x1 (telephone-event) 12 headers, 12 lines Reliably Transmitting: INVITE sip:2101@192.168.1.107 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK72e1154f From: "Ron Anderson" ;tag=as6e1581e5 To: Contact: Call-ID: 657945eb5214f13f536544ac0b7c05e4@192.168.1.104 CSeq: 102 INVITE User-Agent: Asterisk PBX Date: Tue, 22 Feb 2005 18:38:27 GMT Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Content-Type: application/sdp Content-Length: 265 v=0 o=root 29599 29599 IN IP4 192.168.1.104 s=session c=IN IP4 192.168.1.104 t=0 0 m=audio 18654 RTP/AVP 3 0 8 101 a=rtpmap:3 GSM/8000 a=rtpmap:0 PCMU/8000 a=rtpmap:8 PCMA/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-16 a=silenceSupp:off - - - - (no NAT) to 192.168.1.107:5060 localhost*CLI> Sip read: SIP/2.0 100 Trying Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK72e1154f From: "Ron Anderson" ;tag=as6e1581e5 To: ;tag=3080971507 Contact: Call-ID: 657945eb5214f13f536544ac0b7c05e4@192.168.1.104 CSeq: 102 INVITE Server: X-Lite release 1103m Content-Length: 0 9 headers, 0 lines Sip read: SIP/2.0 180 Ringing Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK72e1154f From: "Ron Anderson" ;tag=as6e1581e5 To: ;tag=3080971507 Contact: Call-ID: 657945eb5214f13f536544ac0b7c05e4@192.168.1.104 CSeq: 102 INVITE Server: X-Lite release 1103m Content-Length: 0 9 headers, 0 lines localhost*CLI> Sip read: REGISTER sip:192.168.1.104 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.107:5060;rport;branch=z9hG4bKB923E7481E4C4586951696AF7B83D0FD From: Ron Anderson ;tag=3356140252 To: Ron Anderson Contact: "Ron Anderson" Call-ID: DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104 CSeq: 9522 REGISTER Expires: 1800 Max-Forwards: 70 User-Agent: X-Lite release 1103m Content-Length: 0 11 headers, 0 lines Using latest request as basis request Sending to 192.168.1.107 : 5060 (non-NAT) Transmitting (no NAT): SIP/2.0 100 Trying Via: SIP/2.0/UDP 192.168.1.107:5060;branch=z9hG4bKB923E7481E4C4586951696AF7B83D0FD From: Ron Anderson ;tag=3356140252 To: Ron Anderson ;tag=as3af9b7d2 Call-ID: DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104 CSeq: 9522 REGISTER User-Agent: Asterisk PBX Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Contact: Content-Length: 0 to 192.168.1.107:5060 Transmitting (no NAT): SIP/2.0 401 Unauthorized Via: SIP/2.0/UDP 192.168.1.107:5060;branch=z9hG4bKB923E7481E4C4586951696AF7B83D0FD From: Ron Anderson ;tag=3356140252 To: Ron Anderson ;tag=as3af9b7d2 Call-ID: DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104 CSeq: 9522 REGISTER User-Agent: Asterisk PBX Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Contact: WWW-Authenticate: Digest realm="asterisk", nonce="7d0ea2f3" Content-Length: 0 to 192.168.1.107:5060 Scheduling destruction of call 'DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104' in 15000 ms localhost*CLI> Sip read: REGISTER sip:192.168.1.104 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.107:5060;rport;branch=z9hG4bK667A605F73C04DEBAE340422A5FAB9C2 From: Ron Anderson ;tag=3356140252 To: Ron Anderson Contact: "Ron Anderson" Call-ID: DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104 CSeq: 9523 REGISTER Expires: 1800 Authorization: Digest username="2101",realm="asterisk",nonce="7d0ea2f3",response="a44aaee09928ca9f0daacb814e368c7e",uri="sip:192.168.1.104" Max-Forwards: 70 User-Agent: X-Lite release 1103m Content-Length: 0 12 headers, 0 lines Using latest request as basis request Sending to 192.168.1.107 : 5060 (non-NAT) Transmitting (no NAT): SIP/2.0 100 Trying Via: SIP/2.0/UDP 192.168.1.107:5060;branch=z9hG4bK667A605F73C04DEBAE340422A5FAB9C2 From: Ron Anderson ;tag=3356140252 To: Ron Anderson ;tag=as3af9b7d2 Call-ID: DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104 CSeq: 9523 REGISTER User-Agent: Asterisk PBX Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Contact: Content-Length: 0 to 192.168.1.107:5060 Transmitting (no NAT): SIP/2.0 200 OK Via: SIP/2.0/UDP 192.168.1.107:5060;branch=z9hG4bK667A605F73C04DEBAE340422A5FAB9C2 From: Ron Anderson ;tag=3356140252 To: Ron Anderson ;tag=as3af9b7d2 Call-ID: DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104 CSeq: 9523 REGISTER User-Agent: Asterisk PBX Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Expires: 1800 Contact: ;expires=1800 Date: Tue, 22 Feb 2005 18:38:31 GMT Content-Length: 0 to 192.168.1.107:5060 Scheduling destruction of call 'DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104' in 15000 ms localhost*CLI> Sip read: 0 headers, 0 lines localhost*CLI> Sip read: SIP/2.0 200 Ok Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK72e1154f From: "Ron Anderson" ;tag=as6e1581e5 To: ;tag=3080971507 Contact: Call-ID: 657945eb5214f13f536544ac0b7c05e4@192.168.1.104 CSeq: 102 INVITE Content-Type: application/sdp Server: X-Lite release 1103m Content-Length: 293 v=0 o=2101 6280890 6295062 IN IP4 192.168.1.107 s=X-Lite c=IN IP4 192.168.1.107 t=0 0 m=audio 8000 RTP/AVP 3 0 8 98 97 101 a=rtpmap:0 pcmu/8000 a=rtpmap:8 pcma/8000 a=rtpmap:3 gsm/8000 a=rtpmap:98 iLBC/8000 a=rtpmap:97 speex/8000 a=rtpmap:101 telephone-event/8000 a=fmtp:101 0-15 10 headers, 13 lines Found RTP audio format 3 Found RTP audio format 0 Found RTP audio format 8 Found RTP audio format 98 Found RTP audio format 97 Found RTP audio format 101 Peer audio RTP is at port 192.168.1.107:8000 Found description format pcmu Found description format pcma Found description format gsm Found description format iLBC Found description format speex Found description format telephone-event Capabilities: us - 0x8000e (gsm|ulaw|alaw|h263), peer - audio=0x60e (gsm|ulaw|alaw|speex|ilbc)/video=0x0 (nothing), combined - 0xe (gsm|ulaw|alaw) Non-codec capabilities: us - 0x1 (g723), peer - 0x1 (g723), combined - 0x1 (g723) list_route: hop: set_destination: Parsing for address/port to send to set_destination: set destination to 192.168.1.107, port 5060 Transmitting: ACK sip:2101@192.168.1.107:5060 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.104:5060;branch=z9hG4bK7dde1c26 From: "Ron Anderson" ;tag=as6e1581e5 To: ;tag=3080971507 Contact: Call-ID: 657945eb5214f13f536544ac0b7c05e4@192.168.1.104 CSeq: 102 ACK User-Agent: Asterisk PBX Content-Length: 0 (no NAT) to 192.168.1.107:5060 Destroying call 'DC47D88BBEAC474B94C672BD9F676CBE@192.168.1.104' Feb 22 10:38:56 NOTICE[29599]: rtp.c:317 process_rfc3389: RFC3389 support incomplete. Turn off on client if possible localhost*CLI> Sip read: BYE sip:6502922409@192.168.1.104 SIP/2.0 Via: SIP/2.0/UDP 192.168.1.107:5060;rport;branch=z9hG4bK516653C0FF36463B94A2C70A2986D7B6 From: ;tag=3080971507 To: "Ron Anderson" ;tag=as6e1581e5 Contact: Call-ID: 657945eb5214f13f536544ac0b7c05e4@192.168.1.104 CSeq: 31512 BYE Max-Forwards: 70 User-Agent: X-Lite release 1103m Content-Length: 0 10 headers, 0 lines Sending to 192.168.1.107 : 5060 (non-NAT) Transmitting (no NAT): SIP/2.0 200 OK Via: SIP/2.0/UDP 192.168.1.107:5060;branch=z9hG4bK516653C0FF36463B94A2C70A2986D7B6 From: ;tag=3080971507 To: "Ron Anderson" ;tag=as6e1581e5 Call-ID: 657945eb5214f13f536544ac0b7c05e4@192.168.1.104 CSeq: 31512 BYE User-Agent: Asterisk PBX Allow: INVITE, ACK, CANCEL, OPTIONS, BYE, REFER Contact: Content-Length: 0 to 192.168.1.107:5060 Destroying call '657945eb5214f13f536544ac0b7c05e4@192.168.1.104' localhost*CLI> Sip read: 0 headers, 0 lines localhost*CLI> *********************************************************************** * SIPFRIENDS TABLE NOW UPDATED WITH .107 IP *********************************************************************** localhost*CLI> database show /SIP/Registry/2101 : 192.168.1.107:5060:1800:2101:sip:2101@192.168.1.107:5060 /SIP/Registry/2102 : 192.168.1.106:5060:1800:2102:sip:2102@192.168.1.106:5060 /dundi/secret : HRRcaUdXkwNqhi4Z+cGSGg;3cJ0VrP+NE6n3vYS3vtMDA /dundi/secretexpiry : 1109101282 localhost*CLI> mysql> select * from sipfriends; +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ | uniqueid | name | accountcode | amaflags | callgroup | callerid | canreinvite | context | defaultip | dtmfmode | fromuser | fromdomain | host | incominglimit | outgoinglimit | insecure | language | mailbox | md5secret | nat | permit | deny | pickupgroup | port | qualify | restrictcid | rtptimeout | rtpholdtimeout | secret | type | username | allow | disallow | regseconds | ipaddr | +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ | 3 | 2101 | NULL | NULL | NULL | NULL | NULL | default | 192.168.1.107 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | 2101 | NULL | NULL | NULL | NULL | NULL | 5060 | NULL | NULL | NULL | NULL | 1234 | friend | 2101 | NULL | NULL | 1109099311 | 192.168.1.107 | | 4 | 2102 | NULL | NULL | NULL | NULL | NULL | default | 192.168.1.107 | NULL | NULL | NULL | dynamic | NULL | NULL | NULL | NULL | 2102 | NULL | NULL | NULL | NULL | NULL | 5060 | NULL | NULL | NULL | NULL | 1234 | friend | 2102 | NULL | NULL | 1108774704 | 192.168.1.106 | +----------+------+-------------+----------+-----------+----------+-------------+---------+---------------+----------+----------+------------+---------+---------------+---------------+----------+----------+---------+-----------+------+--------+------+-------------+------+---------+-------------+------------+----------------+--------+--------+----------+-------+----------+------------+---------------+ 2 rows in set (0.02 sec) mysql>