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" <[EMAIL PROTECTED]> > To: "Asterisk-users" <[EMAIL PROTECTED]> > 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 > > [EMAIL PROTECTED] > > > > Heritage Communications Corporation > > Melbourne, FL USA 32935 > > 321.308.4000 x33 > > http://www.hcc.net > > > > _______________________________________________ > > Asterisk-Users mailing list > > [EMAIL PROTECTED] > > 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 > [EMAIL PROTECTED] > 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 [EMAIL PROTECTED] Heritage Communications Corporation Melbourne, FL USA 32935 321.308.4000 x33 http://www.hcc.net _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
