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

[Michael Collins]

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/20110323/4d9723c4/attachment.html