[asterisk-users] mysql sip realtime

[Ishfaq Malik]

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

harry R wrote:
> Hi
>
> I have some question about mysql realtime.
> 1) Anyone know exactly if there is a specific order to declare sip 
> table column for realtime ? In which file can I find that order ?
> 2) In my extconfig.conf, [settings] are :
> sipusers => mysql,general,siptable
> sippeers => mysql,general,siptable
>
> so means that I use realtime dynamic exactly ?
> Is it normal if some parameters from sip.conf still used ?
> I notice when I change some values in my mysql database, these new 
> values are not directly updated when I reload chan_sip.so module and 
> tape CLI command "sip show peer <peername>". Is it normal ?
> When I reload chan_sip.so, it seems that connected terminals are no 
> longer detected by Asterisk because when I tape CLI command "sip show 
> peers", there is no results displayed. Any reflexions about that ?
>
> thanks in advance for your answers.
>
> regards.
>
> Harry.
> ------------------------------------------------------------------------
>
> _______________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> AstriCon 2009 - October 13 - 15 Phoenix, Arizona
> Register Now: http://www.astricon.net
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users

-- 
Ishfaq Malik
Software Developer
PackNet Ltd

Office:   0161 660 3062