[Users] missed calls

harry gaillac gaillacharry at yahoo.fr
Tue Jul 12 12:18:09 CEST 2005


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 at nxs.yi.org>;tag=50BB137A-817519BD
| <sip:85 at nxs.yi.org;user=phone>                      
| 408 Request Timeout | INVITE     |
sip:85 at nxs.yi.org:5060;user=phone |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:85 at nxs.yi.org;user=phone |
adb4092e-a342085c-3cc75107 at 192.168.0.20 | n/a      |
n/a    | 50BB137A-817519BD | n/a               |
2005-07-11 19:59:27 | 20050711215927 |
| "alice" <sip:alice at nxs.yi.org>;tag=58B3DFF7-D9F2FCDE
| <sip:bob at nxs.yi.org>                                
| 408 Request Timeout | INVITE     |
sip:bob at nxs.yi.org:5060           |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:bob at nxs.yi.org       |
81fb0c1b-22f91c71-913d7ca0 at 192.168.0.20 | n/a      |
n/a    | 58B3DFF7-D9F2FCDE | n/a               |
2005-07-11 20:00:39 | 20050711220039 |
| "alice" <sip:alice at nxs.yi.org>;tag=C64ECD60-736973DB
| <sip:85 at nxs.yi.org;user=phone>                      
| 408 Request Timeout | INVITE     |
sip:85 at nxs.yi.org:5060;user=phone |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:85 at nxs.yi.org;user=phone |
f3aa8034-44a4ec12-263ca735 at 192.168.0.20 | n/a      |
n/a    | C64ECD60-736973DB | n/a               |
2005-07-11 20:14:07 | 20050711221407 |
| "alice" <sip:alice at nxs.yi.org>;tag=1C1BEC5D-3CA00B7C
| <sip:bob at nxs.yi.org>                                
| 408 Request Timeout | INVITE     |
sip:bob at nxs.yi.org:5060           |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:bob at nxs.yi.org       |
c660cda1-a8c17ea7-1ccca34e at 192.168.0.20 | n/a      |
n/a    | 1C1BEC5D-3CA00B7C | n/a               |
2005-07-11 20:22:23 | 20050711222223 |
| "alice" <sip:alice at nxs.yi.org>;tag=270B9E3F-91BEA3C6
| <sip:85 at nxs.yi.org;user=phone>;tag=275C18EB-7F246064
| 486 Busy Here       | INVITE     |
sip:85 at nxs.yi.org:5060;user=phone |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:85 at nxs.yi.org;user=phone |
c6178fe3-361d479-30c5c848 at 192.168.0.20  | n/a      |
n/a    | 270B9E3F-91BEA3C6 | 275C18EB-7F246064 |
2005-07-11 21:16:53 | 20050711231653 |
| "alice" <sip:alice at nxs.yi.org>;tag=C9CA532F-3DECF576
| <sip:bob at nxs.yi.org>;tag=3BC100E0-65228A29          
| 486 Busy Here       | INVITE     |
sip:bob at nxs.yi.org:5060           |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:bob at nxs.yi.org       |
e6d681d3-cfdf49e9-7f651478 at 192.168.0.20 | n/a      |
n/a    | C9CA532F-3DECF576 | 3BC100E0-65228A29 |
2005-07-11 21:17:21 | 20050711231721 |
| "alice" <sip:alice at nxs.yi.org>;tag=428D7F3B-FF325EF2
| <sip:bob at nxs.yi.org>;tag=4C783763-93E0625C          
| 486 Busy Here       | INVITE     |
sip:bob at nxs.yi.org:5060           |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:bob at nxs.yi.org       |
e29c741f-a6a36795-c372ac14 at 192.168.0.20 | n/a      |
n/a    | 428D7F3B-FF325EF2 | 4C783763-93E0625C |
2005-07-11 21:18:56 | 20050711231856 |
| "alice" <sip:alice at nxs.yi.org>;tag=2A96F9FF-DBB61286
| <sip:85 at nxs.yi.org;user=phone>;tag=4B1A44D8-B81CC9A1
| 486 Busy Here       | INVITE     |
sip:85 at nxs.yi.org:5060;user=phone |
sip:bob at 192.168.0.21 | sip:alice at nxs.yi.org |
sip:85 at nxs.yi.org;user=phone |
d6955fa3-7faff239-b34be108 at 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




More information about the Users mailing list