[Asterisk-Users] Problems with app_realtime

[Matthew Boehm]

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