[Asterisk-Users] Problems with app_realtime

[Brian Wilkins]

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