[Asterisk-Users] RE: Realtime SIP Lookups

[Douglas Garstang]

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