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

[fieldpeak]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110324/abedeecc/attachment.html