Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread Mindaugas Kezys
...@lists.digium.com [mailto:asterisk-users-boun...@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

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread Ishfaq Malik
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

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread Mindaugas Kezys
-Original Message- From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Ishfaq Malik Sent: 2009 m. rugpjūčio 21 d. 12:50 To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] mysql sip realtime I have

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread harry R
2009/8/21 Ishfaq Malik i...@pack-net.co.uk I have to disagree with you there, we use 1.4.17 and sip prune realtime works fine After a few test, I notice these events when I use asterisk+mysql+realtime+sip 1) after a sip prune realtime peername, peername will not be reachable by another

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread Ishfaq Malik
Have you set the qualify column in the sip table? harry R wrote: 2009/8/21 Ishfaq Malik i...@pack-net.co.uk mailto:i...@pack-net.co.uk I have to disagree with you there, we use 1.4.17 and sip prune realtime works fine After a few test, I notice these events when I use

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread harry R
Have you set the qualify column in the sip table? yes and default set to yes ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread Jonathan Thurman
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 ? They won't be found in the CLI command until Asterisk receives another packet from that

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread Tilghman Lesher
On Friday 21 August 2009 20:20:14 Jonathan Thurman wrote: 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 ? They won't be found in the

Re: [asterisk-users] mysql sip realtime

2009-08-21 Thread Jonathan Thurman
Ideally, the way realtime works, it shouldn't matter at all whether the record exists in memory or in the database.  In reality, there's a few cases where the data needs to exist in memory for a particular event to occur correctly (such as device state notifications).  I think a better goal

[asterisk-users] mysql sip realtime

2009-08-20 Thread harry R
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

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread 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

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread Tilghman Lesher
On Thursday 20 August 2009 06:54:12 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 ? There is no specific order, but columns are processed in the

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread harry R
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 ? They won't be found in the CLI command until Asterisk receives another packet from

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread harry R
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

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread Ishfaq Malik
harry R wrote: 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

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread Ishfaq Malik
Once set up properly you should really hardly ever be doing sip reloads harry R wrote: 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

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread harry R
I try CLI command sip prune realtime peer name and my peer infos was perfectly updated when I do sip show peer name but have you any idea of how I can do that automatically ? How are you updating your sip table? Are you doing it manually or have you built an interface for it? If you have

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread Ishfaq Malik
harry R wrote: I try CLI command sip prune realtime peer name and my peer infos was perfectly updated when I do sip show peer name but have you any idea of how I can do that automatically ? How are you updating your sip table? Are you doing it manually or have

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread harry R
Well, it shouldn't. The Contact header should identify how to contact the peer, and that is currently saved into the database on register (unless you have updates turned off). Which column are concerned by ? my update is on because some column are dynamically updated each time a terminal

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread Tilghman Lesher
On Thursday 20 August 2009 08:25:29 harry R wrote: 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 ? They won't be found in

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread harry R
Unfortunately not, I built ours myself. ok thank for all these advices and sol ___ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- AstriCon 2009 - October 13 - 15 Phoenix, Arizona Register Now: http://www.astricon.net

Re: [asterisk-users] mysql sip realtime

2009-08-20 Thread Tilghman Lesher
On Thursday 20 August 2009 10:20:55 harry R wrote: Well, it shouldn't. The Contact header should identify how to contact the peer, and that is currently saved into the database on register (unless you have updates turned off). Which column are concerned by ? my update is on because some