[Asterisk-Users] RE: Realtime SIP Lookups

[Douglas Garstang]

Actually this is completely screwy. I have rtcachefriends=no and Asterisk is still populating the astdb file. Why the hell is it doing this?

mysql> select * from ast_config;
+----+------------+------------+-----------+----------+----------+----------------+---------+
| id | cat_metric | var_metric | commented | filename | category | var_name       | var_val |
+----+------------+------------+-----------+----------+----------+----------------+---------+
|  1 |          0 |          0 |         0 | sip.conf | general  | context        | default |
|  2 |          0 |          0 |         0 | sip.conf | general  | rtcachefriends | no      |
|  3 |          0 |          0 |         0 | sip.conf | general  | rtupdate       | yes     |
|  4 |          0 |          0 |         0 | sip.conf | general  | rtautoclear    | no      |

-----Original Message-----
From: Douglas Garstang 
Sent: Tuesday, December 06, 2005 8:37 AM
To: asterisk-users at lists.digium.com
Subject: RE: Realtime SIP Lookups


Thanks for the reply Anish. 

I turned off the caching with rtcachefriends=no, verified the registrations where not stored in astdb, and saw select queries being performed to the database, and it still failed. Did you ever try that?

Douglas.

-----Original Message-----
From: Anish Basu [mailto:anish at softelinc.com]
Sent: Tuesday, December 06, 2005 8:33 AM
To: asterisk-users at lists.digium.com
Cc: Douglas Garstang
Subject: Realtime SIP Lookups


Doug,

When you use Realtime SIP Peers, registration information is stored in the
mysql database, the astdb database, as well as being cached in memory.  When
a SIP lookup is done, and registration information is stored in cache, that
information will be used rather than querying sip_buddies.  We tried similar
experiments of sharing registration information using a single mysql
database or using mysql replication across all of the asterisk servers
without any success.  It seems like a patch to the Realtime architecture
needs to be developed such that sip_buddies is always queried first before
looking in cache or astdb.

Anish Basu
Field Systems Engineer
Softel, Inc.
Phone: (732) 705-9202
Cell: (732) 312-6634