[Spce-user] Multiple ATA registrations
Dave Massey
dave at optionsdsl.ca
Sun Nov 18 22:42:03 EST 2012
Just wanted to Add the mysql dump of the table as well.
-------------- 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> |
More information about the Spce-user
mailing list