[Spce-user] Multiple ATA registrations

Dave Massey dave at optionsdsl.ca
Tue Nov 20 10:06:20 EST 2012


On 2012-11-20, at 4:46 AM, Jon Bonilla (Manwe) <jbonilla at sipwise.com> wrote:

> El Mon, 19 Nov 2012 20:39:04 -0500
> Dave Massey <dave at optionsdsl.ca> escribió:
> 
>> I did contact the company, and its not gonna get fixed.  Im gonna guess
>> because its not breaking any RFC, that they don't see the different call-id
>> across reboots as a problem. :(
>> 
>> This doesn't really explain why all the duplicate entries when its not
>> rebooted, but at least I have a final word on one of the issues. But so far
>> since kamailio only has one correct entry in its cache regardless of what the
>> DB says, me deleting out the database every so often has not caused any
>> issues so far.
> 
> Please explain me again something:
> 
> When you see different multiple registrations in the web interface, is the
> content of the database and the content of kamailio cache different?
> 

Yes, the Kamailio cache only shows the correct single entry.

> Because there's another issue here and it's that the number of registered
> devices is limited to 5 by default, so no more than 5 registrations should be
> seen in any case. 

Yea I agree, but it just looks like to me, that its only ever 1 registration to kamailio and its so far purely cosmetic.

Even my device that has a different call-id across reboots expires out of the kamailio cache, but its impossible to delete it from the SPCE interface even with the trash can once its call-id is gone/replaced with a new registration with a new call-id. 

I attached a mysql dump and a kamailio cache dump of 2 subscribers after system ran yesterday and overnight, a few ATA reboots are in there as indicated by different call-ids.  cseqs are updating normally every 60 seconds.

I have no problem registering a device to your system, just say the word :)  
-------------- next part --------------
+-----+-----------+-------------------+----------------------------------+----------+--------------------------+---------------------+-------+-----------------------+-------+---------------------+-------+--------+--------------------------+-----------------------+---------+------------------------+--------+-------------------------------------------------+
| id  | username  | domain            | contact                          | received | path                     | expires             | q     | callid                | cseq  | last_modified       | flags | cflags | user_agent               | socket                | methods | ruid                   | reg_id | instance                                        |
+-----+-----------+-------------------+----------------------------------+----------+--------------------------+---------------------+-------+-----------------------+-------+---------------------+-------+--------+--------------------------+-----------------------+---------+------------------------+--------+-------------------------------------------------+
| 470 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 471 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 475 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 477 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 478 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 479 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 480 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 481 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 482 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 486 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 487 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 488 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 491 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 492 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 496 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 498 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 500 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 502 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 504 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 509 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 510 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 512 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 513 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 518 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 520 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 522 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 524 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 525 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 526 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 527 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 528 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 530 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 531 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 534 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 535 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 536 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 537 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 540 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 542 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 544 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 545 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 546 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 547 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 548 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 549 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 550 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 551 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 552 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
| 553 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 554 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 555 | test2     | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060   | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:35 | -1.00 | 505afc7a at 10.40.36.125 | 33924 | 2012-11-18 22:36:35 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 556 | ddufresne | sip.optionsdsl.ca | sip:ddufresne at 24.102.50.63:49152 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:37:37 | -1.00 | ab3415ea at 10.20.30.166 | 68940 | 2012-11-18 22:36:37 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-1a  |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef1098d8> |
+-----+-----------+-------------------+----------------------------------+----------+--------------------------+---------------------+-------+-----------------------+-------+---------------------+-------+--------+--------------------------+-----------------------+---------+------------------------+--------+-------------------------------------------------+
root at sip:~# mysql -uroot -p -e  "select * from kamailio.location WHERE username='test2'"
Enter password: 
+-----+----------+-------------------+--------------------------------+----------+--------------------------+---------------------+-------+-----------------------+-------+---------------------+-------+--------+--------------------------+-----------------------+---------+------------------------+--------+-------------------------------------------------+
| id  | username | domain            | contact                        | received | path                     | expires             | q     | callid                | cseq  | last_modified       | flags | cflags | user_agent               | socket                | methods | ruid                   | reg_id | instance                                        |
+-----+----------+-------------------+--------------------------------+----------+--------------------------+---------------------+-------+-----------------------+-------+---------------------+-------+--------+--------------------------+-----------------------+---------+------------------------+--------+-------------------------------------------------+
| 545 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 547 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 549 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 550 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 551 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 553 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 554 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |
| 555 | test2    | sip.optionsdsl.ca | sip:test2 at 206.248.139.111:5060 | NULL     | <sip:lb at 172.16.10.55;lr> | 2012-11-18 22:38:05 | -1.00 | 505afc7a at 10.40.36.125 | 33925 | 2012-11-18 22:37:05 |     0 |      0 | OBIHAI/OBi100-1.3.0.2744 | udp:172.16.10.55:5062 |    4767 | uloc-50a695ac-1857-596 |      0 | <urn:uuid:00000000-0000-0000-0000-9cadef10c515> |

-------------- next part --------------

 
Dave


> _______________________________________________
> Spce-user mailing list
> Spce-user at lists.sipwise.com
> http://lists.sipwise.com/listinfo/spce-user





More information about the Spce-user mailing list