[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