[Freeswitch-users] sofia_reg_internal.db grow bigger and biggeralong with time

[Charles]

Hi Michael,

unstood it's a unix epoch time now.
how, it always stay in the table even the call finshied which will lead the database get bigger and bigger till disk reach full, especially we set db on RAM disk which is limited by the physical RAM size, can you help advise how to avoid this happen.
thanks!


2011-03-24 



Charles 



发件人： Michael Collins 
发送时间： 2011-03-24  10:56:52 
收件人： FreeSWITCH Users Help 
抄送： 
主题： Re: [Freeswitch-users] sofia_reg_internal.db grow bigger and biggeralong with time 
 
1300933453 is a unix epoch time in seconds. You can get the exact time from the fs_cli by issuing the strepoch command. Anyway, the size of that number is not the issue. I'll defer to Tony on the database record remaining in the table for longer than expected...


-MC


On Wed, Mar 23, 2011 at 7:42 PM, fieldpeak <fieldpeak at gmail.com> wrote:

Hi Anthony,

Thanks for your reply.
i tried to understand how long it is the expire time and where to cnofigure it.
so i made a test, see the attached screen shot, in the profile internal.xml, the nonce-ttl = 60, when i make a call from a registerred user, a new record was added in the 'sip_authentication' table with a very big value (1300933453, i don't know what the unit is, s or ms?) , after 60 seconds (actually i wait for more than 15 minutes), even the call finished, the new record still stay their, it was not deleted. want to know when it will be deleted...

thanks for your help!


2011/3/24 Anthony Minessale <anthony.minessale at gmail.com>

they expire so they will be deleted when the expire time happens.
If you have a lot you were probably attacked by a sip worm.



On Wed, Mar 23, 2011 at 9:38 AM, fieldpeak <fieldpeak at gmail.com> wrote:
> i found sofia_reg_internal.db grow bigger and bigger after FreeSwitch for
> some time.
> the change comes from the sip-authentication table inside this db, it always
> create new record for nonce for the new challenge ('407 Proxy Authentication
> Required') for the call from registered users.
> any one can help how to avoid the db grow, i'm afaid the hard disk will be
> full along with time...
>
> Thanks!
>

> _______________________________________________
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
>



--
Anthony Minessale II

FreeSWITCH http://www.freeswitch.org/
ClueCon http://www.cluecon.com/
Twitter: http://twitter.com/FreeSWITCH_wire

AIM: anthm
MSN:anthony_minessale at hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
IRC: irc.freenode.net #freeswitch

FreeSWITCH Developer Conference
sip:888 at conference.freeswitch.org
googletalk:conf+888 at conference.freeswitch.org
pstn:+19193869900

_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org



_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users at lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110324/7389b5c7/attachment-0001.html