[Asterisk-Users] realtime management for sip with mysql

[Laurent Foulonneau]

It does work fine for me

CVS-HEAD-04/02/05-22

nated clients appears without problem and keep registered as long as i 
restart * or relaod sip.

sip.conf
=======
[general]
recordhistory=yes
port=5060
pedantic=no
context=default
maxexpirey=180
defaultexpirey=160
tos=reliability
rtcachefriends=yes
rtnoupdate=no
rtautoclear=2000
qualify=2000
dtmfmode=rfc2833


SQL Data in sip_clients :
# SELECT *
# FROM `sip_clients`
#
'id','name','accountcode','callgroup','callerid','canreinvite','context','dtmfmode','host','language','mailbox','md5secret','secret','type','username','ipaddr','port','regseconds','allow','qualify','nat'
'5','0870441066','0870441066','[NULL]','0870441066','no','local','rfc2833','dynamic','fr','[NULL]','[NULL]','xxxxxxxxxxxx','peer','xxxxxxxxxxxx','202.171.79.4','19877','1112739637','g729;ilbc;gsm;ulaw;alaw','200','1'


*CLI> sip show peers
Name/username              Host            Dyn Nat ACL 
Mask             Port     Status
0870441066/0870441066      202.171.79.4     D   N      255.255.255.255 
19877    OK (39 ms)
5 sip peers [4 online , 1 offline]
*CLI>


Hope this will help


Laurent








At 17:47 05/04/2005 -0400, you wrote:
>Yes, but I have all the RT Cacheing options turned on so they should 
>appear in sip show peers.  The bug that I am experiencing is that they 
>disappear from the sip show peers list with the Realtime Cacheing turned on.
>
>Bill
>
>
>----------
>
>I believe if you read the wiki, assuming you are successful in locating
>the correct entry, there is a statement indicating sip show peers will
>not reveal sip users.
>g
>
>William M. Sandiford wrote:
> >Hi Bioz:
> >
> >I'm having the same problem with Realtime and CVS-HEAD from 4/4/2005.
> >
> >I haven't found a solution yet, but I have also posted this to the list 
> in the last 24 hours and hopefully someone will help out soon. There was 
> a similar thread from about a month ago that seemed to solve the problems 
> of someone else with a similar problem, but it didn't help me, so you may 
> want to look for it. I believe it was called "Realtime is not working"
> >
> >Regards,
> >Bill
> >
> >PS, if you get it working, be sure to let me (and the list know)
> >
> >--------------
> >
> >Hi
> >I use realtime management for sip with mysql and it works correctly.
> >After 1 or 2 hours having started, I look at "sip show peers" and I have
> >no more sip customers registered.
> >I must do a restart for sip working.
> >Someone have an idea of what goes wrong ?
> >Thanks by advance for your answer.
> >Bioz
> >
> >
> >
>
>--
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.308 / Virus Database: 266.9.2 - Release Date: 4/5/2005
>
>_______________________________________________
>Asterisk-Users mailing list
>Asterisk-Users at lists.digium.com
>http://lists.digium.com/mailman/listinfo/asterisk-users
>To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users