[asterisk-users] mysql sip realtime

[Mindaugas Kezys]

"If you change anything in your mysql sip table you do not need to reload 
the modue, what you need to do is
sip prune realtime <peername>
from the CLI"

Without reload prune does not take effect in 1.4.x

And after reload all registrations are lost.

So basically Asterisk Realtime is big mess from our experience and is
totally unusable.

We ended making #exec based script which takes data from DB and forms static
configuration on each reload.

Regards,
Mindaugas Kezys
http://www.kolmisoft.com
VoIP Billing and Routing Solutions




-----Original Message-----
From: asterisk-users-bounces at lists.digium.com
[mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Ishfaq Malik
Sent: 2009 m. rugpjūčio 20 d. 15:56
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] mysql sip realtime

Hi

The column order in your mysql sip table is irrelevant
(Example sip table here 
http://www.voip-info.org/wiki/view/Asterisk+RealTime+Sip)

All generic parameters are still taken from sip.conf and you must set
rtcachefriends=yes

If you change anything in your mysql sip table you do not need to reload 
the modue, what you need to do is
sip prune realtime <peername>
from the CLI

As stated previously, you should never have to reload the sip module 
once realtime is working properly

Hope this all helps

Ish