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@hcc.net Heritage Communications Corporation Melbourne, FL USA 32935 321.308.4000 x33 http://www.hcc.net
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@hcc.net> > To: "Asterisk-users" <asterisk-users@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@hcc.net > > > > Heritage Communications Corporation > > Melbourne, FL USA 32935 > > 321.308.4000 x33 > > http://www.hcc.net > > > > _______________________________________________ > > Asterisk-Users mailing list > > Asterisk-Users@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@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@hcc.net Heritage Communications Corporation Melbourne, FL USA 32935 321.308.4000 x33 http://www.hcc.net
Post this as a bug Brian. -Matthew ----- Original Message ----- From: "Brian Wilkins" <brian@hcc.net> To: "Asterisk-users" <asterisk-users@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 databasefor> a sip friend/peer, RealTime does not update the registration status likeit> should. > > I also have several peers which have been offline and Asterisk stillreports> 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@hcc.net > > Heritage Communications Corporation > Melbourne, FL USA 32935 > 321.308.4000 x33 > http://www.hcc.net > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@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
Don't use Qualify. bkw> -----Original Message----- > From: asterisk-users-bounces@lists.digium.com [mailto:asterisk-users- > bounces@lists.digium.com] On Behalf Of Brian Wilkins > Sent: Tuesday, December 14, 2004 3:52 AM > To: Asterisk-users > 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@hcc.net > > Heritage Communications Corporation > Melbourne, FL USA 32935 > 321.308.4000 x33 > http://www.hcc.net > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@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