Hello,
My missed_calls table :
why serweb don't display missed calls ???????????
Harry
Database changed
mysql> select * from missed_calls;
+------------------------------------------------------+------------------------------------------------------+---------------------+------------+-----------------------------------+----------------------+----------------------+------------------------------+-----------------------------------------+----------+--------+-------------------+-------------------+---------------------+----------------+
| sip_from
| sip_to
| sip_status | sip_method | i_uri
| o_uri | from_uri
| to_uri | sip_callid
| username | domain | fromtag | totag
| time | timestamp |
+------------------------------------------------------+------------------------------------------------------+---------------------+------------+-----------------------------------+----------------------+----------------------+------------------------------+-----------------------------------------+----------+--------+-------------------+-------------------+---------------------+----------------+
| "alice" <sip:alice@nxs.yi.org>;tag=50BB137A-817519BD
| <sip:85@nxs.yi.org;user=phone>
| 408 Request Timeout | INVITE |
sip:85@nxs.yi.org:5060;user=phone |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:85@nxs.yi.org;user=phone |
adb4092e-a342085c-3cc75107(a)192.168.0.20 | n/a |
n/a | 50BB137A-817519BD | n/a |
2005-07-11 19:59:27 | 20050711215927 |
| "alice" <sip:alice@nxs.yi.org>;tag=58B3DFF7-D9F2FCDE
| <sip:bob@nxs.yi.org>
| 408 Request Timeout | INVITE |
sip:bob@nxs.yi.org:5060 |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:bob@nxs.yi.org |
81fb0c1b-22f91c71-913d7ca0(a)192.168.0.20 | n/a |
n/a | 58B3DFF7-D9F2FCDE | n/a |
2005-07-11 20:00:39 | 20050711220039 |
| "alice" <sip:alice@nxs.yi.org>;tag=C64ECD60-736973DB
| <sip:85@nxs.yi.org;user=phone>
| 408 Request Timeout | INVITE |
sip:85@nxs.yi.org:5060;user=phone |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:85@nxs.yi.org;user=phone |
f3aa8034-44a4ec12-263ca735(a)192.168.0.20 | n/a |
n/a | C64ECD60-736973DB | n/a |
2005-07-11 20:14:07 | 20050711221407 |
| "alice" <sip:alice@nxs.yi.org>;tag=1C1BEC5D-3CA00B7C
| <sip:bob@nxs.yi.org>
| 408 Request Timeout | INVITE |
sip:bob@nxs.yi.org:5060 |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:bob@nxs.yi.org |
c660cda1-a8c17ea7-1ccca34e(a)192.168.0.20 | n/a |
n/a | 1C1BEC5D-3CA00B7C | n/a |
2005-07-11 20:22:23 | 20050711222223 |
| "alice" <sip:alice@nxs.yi.org>;tag=270B9E3F-91BEA3C6
| <sip:85@nxs.yi.org;user=phone>;tag=275C18EB-7F246064
| 486 Busy Here | INVITE |
sip:85@nxs.yi.org:5060;user=phone |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:85@nxs.yi.org;user=phone |
c6178fe3-361d479-30c5c848(a)192.168.0.20 | n/a |
n/a | 270B9E3F-91BEA3C6 | 275C18EB-7F246064 |
2005-07-11 21:16:53 | 20050711231653 |
| "alice" <sip:alice@nxs.yi.org>;tag=C9CA532F-3DECF576
| <sip:bob@nxs.yi.org>;tag=3BC100E0-65228A29
| 486 Busy Here | INVITE |
sip:bob@nxs.yi.org:5060 |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:bob@nxs.yi.org |
e6d681d3-cfdf49e9-7f651478(a)192.168.0.20 | n/a |
n/a | C9CA532F-3DECF576 | 3BC100E0-65228A29 |
2005-07-11 21:17:21 | 20050711231721 |
| "alice" <sip:alice@nxs.yi.org>;tag=428D7F3B-FF325EF2
| <sip:bob@nxs.yi.org>;tag=4C783763-93E0625C
| 486 Busy Here | INVITE |
sip:bob@nxs.yi.org:5060 |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:bob@nxs.yi.org |
e29c741f-a6a36795-c372ac14(a)192.168.0.20 | n/a |
n/a | 428D7F3B-FF325EF2 | 4C783763-93E0625C |
2005-07-11 21:18:56 | 20050711231856 |
| "alice" <sip:alice@nxs.yi.org>;tag=2A96F9FF-DBB61286
| <sip:85@nxs.yi.org;user=phone>;tag=4B1A44D8-B81CC9A1
| 486 Busy Here | INVITE |
sip:85@nxs.yi.org:5060;user=phone |
sip:bob@192.168.0.21 | sip:alice@nxs.yi.org |
sip:85@nxs.yi.org;user=phone |
d6955fa3-7faff239-b34be108(a)192.168.0.20 | n/a |
n/a | 2A96F9FF-DBB61286 | 4B1A44D8-B81CC9A1 |
2005-07-11 21:20:16 | 20050711232016 |
+------------------------------------------------------+------------------------------------------------------+---------------------+------------+-----------------------------------+----------------------+----------------------+------------------------------+-----------------------------------------+----------+--------+-------------------+-------------------+---------------------+----------------+
8 rows in set (0.00 sec)
___________________________________________________________________________
Appel audio GRATUIT partout dans le monde avec le nouveau Yahoo! Messenger
Téléchargez cette version sur
http://fr.messenger.yahoo.com