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

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

Hi Michael, It looks that I found the root cause, at the line#801 of sofia_reg.c, when excute the SQL statement ('INSERT') to the table 'sip_authentication', it wrongly insert as screenshot below, profile_name should be 'internal' and hostname should be 'mypc' (name of my computer). however, i did not find anything wrong regarding the code itselft, so failed to fix it... could you please help focus here to fix it, thanks. P.S. i manually insert the correct record into this talbe, after a while (tens of seconds), it automatically deteleted by FS. btw, i found there is a bug report like this http://jira.freeswitch.org/browse/FS-498# and it is marked Resolved:14/Sep/10 12:32 PM, however, my version is Nov, 30, 2010, there is still exsit. line#801 of sofia_reg.c: sql = switch_mprintf("insert into sip_authentication (nonce,expires,profile_name,hostname, last_nc) " "values('%q', %ld, '%q', '%q', 0)", uuid_str, switch_epoch_time_now(NULL) + (profile->nonce_ttl ? profile->nonce_ttl : DEFAULT_NONCE_TTL), profile->name, mod_sofia_globals.hostname); switch_assert(sql != NULL); sofia_glue_actually_execute_sql(profile, sql, profile->ireg_mutex); 2011-03-25 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

The fs version is git-head on Noveber,30,2010 在 2011-3-24 下午6:48，"mazilo" <Nabble@slickdeals.endjunk.com>编写： I am just curious what version of FreeSWITCH are you using that gives you this problem. ----- FreeSWITCH hosted on a Seagate DockStar with OpenWRT. -- View this message in context: http://freeswitch-users.2379917.n2.nabble.com/sofia-reg-internal-db-grow-big... Sent from the freeswitch-users mailing list archive at Nabble.com. _______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@list...