Hi Peter, Thanks for reminding, i've submit it to Jira. FreeSWITCH FS-3190 Table 'sip_authentication' was not cleared after nonce expired -caused sofia_reg_internal.db grow bigger and bigger along with time 2011-03-26 Charles 发件人： Peter Olsson 发送时间： 2011-03-26 16:14:02 收件人： FreeSWITCH Users Help 抄送： 主题： Re: [Freeswitch-users]sofia_reg_internal.db growbiggerandbiggeralong with time If you've found a bug - please submit it to Jira. Also, make sure to attach your sip profile config to it. /Peter ________________________________________ Från: freeswitch-users-bounces@lists.freeswitch.org [freeswitch-users-bounces@lists.freeswitch.org] för Charles [fieldpeak@gmail.com] Skickat: den 26 mars 2011 04:06 Till: FreeSWITCH Users Help; FreeSWITCH Users Help; anthony.minessale Ämne: Re: [Freeswitch-users] sofia_reg_internal.db growbiggerandbiggeralong with time Hi Anthony, I tried to delete the db files sofia_reg_* db files, it is the same. Actually i've located the bug where the source code, when INSERTing the new record to the table sip_authentication(line#801 of sofia_reg.c), It compose a wrong SQL statement which caused insert the wrong values ('NULL' at 'profile' column, and 'internal' at hostname column) to columns, consequetnly, failed to delete when expires time arrive. Please FOCUS here. the mail below shows the details, thanks! sender： Charles sent time： 2011-03-25 12:22:57 receiver： FreeSWITCH Users Help; msc; jeff cc： jonas.gauffin subject： Re: Re: [Freeswitch-users] sofia_reg_internal.db grow bigger and biggeralong with time 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. [cid:__0@Foxmail.net] 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-26 ________________________________ Charles ________________________________ 发件人： Anthony Minessale 发送时间： 2011-03-26 00:12:12 收件人： FreeSWITCH Users Help 抄送： 主题： Re: [Freeswitch-users] sofia_reg_internal.db growbiggerandbiggeralong with time can you try deleting the db files sofia_reg_* db files? Maybe they have become corrupt? 2011/3/25 fieldpeak <fieldpeak@gmail.com>:
Hi Jonas, i also think so. can you please update was the bug fixed?
在 2011-3-25 下午5:14，"Jonas Gauffin" <jonas.gauffin@gmail.com>编写：
might be the same bug as I reported here: http://jira.freeswitch.org/browse/FS-498
On Fri, Mar 25, 2011 at 8:13 AM, Charles <fieldpeak@gmail.com> wrote:
no, this is not the c...
_______________________________________________ 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
-- 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 !DSPAM:4d8d70e832765221816297! _______________________________________________ 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