[Asterisk-Users] Problems with app_realtime

[Brian Wilkins]

I was going to, but then just took a look at the code in chan_sip.c on line 
1044 (realtime_update_peer) and the regseconds is in unix time. So, if 
converted to human time it translates into the correct readable date and 
time.

So if someone has a regseconds of 1103262922, the registration time is  
17-12-2004 05:55:22. 



On Friday 17 December 2004 03:57 pm, Matthew Boehm wrote:
> Post this as a bug Brian.
>
> -Matthew
>
> ----- Original Message -----
> From: "Brian Wilkins" <brian at hcc.net>
> To: "Asterisk-users" <asterisk-users at lists.digium.com>
> Sent: Tuesday, December 14, 2004 3:51 AM
> Subject: [Asterisk-Users] Problems with app_realtime
>
> > It seems that when setting qualify = 200 or qualify = yes in the database
>
> for
>
> > a sip friend/peer, RealTime does not update the registration status like
>
> it
>
> > should.
> >
> > I also have several peers which have been offline and Asterisk still
>
> reports
>
> > them as registered, even though the registration seconds are only 200.
> >
> >
> > Asterisk Ver: CVS HEAD 12/1/2004
> >
> > Layout of sip_buddies:
> >
> >
> > mysql> describe sip_buddies;
> > +----------------+---------------+------+-----+---------+----------------
> >+
> >
> > | Field          | Type          | Null | Key | Default | Extra         
> > | |
> >
> > +----------------+---------------+------+-----+---------+----------------
> >+
> >
> > | uniqueid       | int(11)       |      | PRI | NULL    | auto_increment
> > | | name           | varchar(30)   |      | UNI |         |              
> > |  | accountcode    | varchar(30)   | YES  |     | NULL    |             
> > |   | amaflags       | char(1)       | YES  |     | NULL    |            
> > |    | callgroup      | varchar(30)   | YES  |     | NULL    |           
> > |     | callerid       | varchar(50)   | YES  |     | NULL    |          
> > |      | canreinvite    | char(1)       | YES  |     | NULL    |         
> > |       | context        | varchar(30)   | YES  |     | NULL    |        
> > |        | defaultip      | varchar(15)   | YES  |     | NULL    |       
> > |         | dtmfmode       | varchar(7)    | YES  |     | NULL    |      
> > |          | fromuser       | varchar(50)   | YES  |     | NULL    |     
> > |           | fromdomain     | varchar(31)   | YES  |     | NULL    |    
> > |            | host           | varchar(31)   |      |     |         |   
> > |             | incominglimit  | char(2)       | YES  |     | NULL    |  
> > |              | outgoinglimit  | char(2)       | YES  |     | NULL    | 
> > |               | insecure       | char(1)       | YES  |     | NULL    |
> > |                | language       | char(2)       | YES  |     | NULL   
> > | |                | mailbox        | varchar(50)   | YES  |     | NULL  
> > |  |                | md5secret      | varchar(32)   | YES  |     | NULL 
> > |   |                | nat            | varchar(5)    | YES  |     | NULL
> > |    |                | permit         | varchar(95)   | YES  |     |
> > | NULL    |                | deny           | varchar(95)   | YES  |    
> > | | NULL    |                | pickupgroup    | varchar(10)   | YES  |   
> > |  | NULL    |                | port           | varchar(5)    |      |  
> > |   |         |                | qualify        | varchar(4)    | YES  | 
> > |    | NULL    |                | restrictcid    | char(1)       | YES  |
> > |     | NULL    |                | rtptimeout     | char(3)       | YES 
> > | |     | NULL    |                | rtpholdtimeout | char(3)       | YES
> > |  |     | NULL    |                | secret         | varchar(30)   |
> > | YES  |     | NULL    |                | type           | varchar(6)   
> > | |      |     |         |                | username       | varchar(30) 
> > |  |      |     |         |                | allow          |
> > | varchar(100)  | YES  |     | NULL    |                | disallow      
> > | | varchar(100)  | YES  |     | NULL    |                | regseconds   
> > |  | int(11)       |      |     | 0       |                | ipaddr      
> > |   | varchar(15)   |      |     |         |                | ts         
> > |    | timestamp(14) | YES  |     | NULL    |                |
> >
> > +----------------+---------------+------+-----+---------+----------------
> >+ 36 rows in set (0.01 sec)
> >
> >
> >
> >
> >
> > --
> > Brian Wilkins
> > Software Engineer
> > brian at hcc.net
> >
> > Heritage Communications Corporation
> >   Melbourne, FL     USA     32935
> > 321.308.4000 x33
> > http://www.hcc.net
> >
> > _______________________________________________
> > Asterisk-Users mailing list
> > Asterisk-Users at lists.digium.com
> > http://lists.digium.com/mailman/listinfo/asterisk-users
> > To UNSUBSCRIBE or update options visit:
> >    http://lists.digium.com/mailman/listinfo/asterisk-users
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
Brian Wilkins
Software Engineer
brian at hcc.net

Heritage Communications Corporation
  Melbourne, FL     USA     32935
321.308.4000 x33
http://www.hcc.net