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@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@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@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@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@hotmail.com
GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com
IRC: irc.freenode.net #freeswitch

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

_______________________________________________
FreeSWITCH-users mailing list
FreeSWITCH-users@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@lists.freeswitch.org
http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
http://www.freeswitch.org