<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16722">
<STYLE>@font-face {
font-family: 宋体;
}
@font-face {
font-family: Verdana;
}
@font-face {
font-family: @宋体;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; layout-grid: 15.6pt; }
P.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; TEXT-ALIGN: justify; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt
}
LI.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; TEXT-ALIGN: justify; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt
}
DIV.MsoNormal {
TEXT-JUSTIFY: inter-ideograph; TEXT-ALIGN: justify; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
FONT-STYLE: normal; FONT-FAMILY: Verdana; COLOR: windowtext; FONT-WEIGHT: normal; TEXT-DECORATION: none; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
UNKNOWN {
FONT-SIZE: 10pt
}
BLOCKQUOTE {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px; MARGIN-LEFT: 2em
}
OL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
UL {
MARGIN-TOP: 0px; MARGIN-BOTTOM: 0px
}
</STYLE>
</HEAD>
<BODY style="MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt">
<DIV><FONT color=#000080 size=2 face=Verdana>Hi Peter,</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV><FONT color=#000080>Thanks for reminding, i've submit it to
Jira.</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV>
<DIV class=item-header>
<UL class=breadcrumbs>
<LI><A id=project-name-val
href="http://jira.freeswitch.org/browse/FS">FreeSWITCH</A> </LI>
<LI class=section><A id=key-val
href="http://jira.freeswitch.org/browse/FS-3190">FS-3190</A></LI></UL>
<H2 id=issue_header_summary class=item-summary><A
href="http://jira.freeswitch.org/browse/FS-3190">Table 'sip_authentication' was
not cleared after nonce expired -caused sofia_reg_internal.db grow bigger and
bigger along with time</A></H2></DIV></DIV>
<DIV><FONT color=#000080 size=2 face=Verdana></FONT> </DIV>
<DIV><FONT color=#000080 size=2 face=Verdana></FONT> </DIV>
<DIV><FONT color=#c0c0c0 size=2 face=Verdana>2011-03-26 </FONT></DIV><FONT
color=#000080 size=2 face=Verdana>
<HR style="WIDTH: 100px" align=left color=#b5c4df SIZE=1>
</FONT>
<DIV><FONT color=#c0c0c0 size=2 face=Verdana><SPAN>Charles</SPAN> </FONT></DIV>
<HR color=#b5c4df SIZE=1>
<DIV><FONT size=2 face=Verdana><STRONG>发件人：</STRONG> Peter Olsson </FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>发送时间：</STRONG> 2011-03-26 16:14:02
</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>收件人：</STRONG> FreeSWITCH Users Help
</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>抄送：</STRONG> </FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>主题：</STRONG> Re:
[Freeswitch-users]sofia_reg_internal.db growbiggerandbiggeralong with time
</FONT></DIV>
<DIV><FONT size=2 face=Verdana></FONT> </DIV>
<DIV><FONT size=2 face=Verdana>
<DIV>If you've found a bug - please submit it to Jira. Also, make sure to attach your sip profile config to it.</DIV>
<DIV></DIV>
<DIV>/Peter</DIV>
<DIV>________________________________________</DIV>
<DIV>Från: freeswitch-users-bounces@lists.freeswitch.org [freeswitch-users-bounces@lists.freeswitch.org] f&#246;r Charles [fieldpeak@gmail.com]</DIV>
<DIV>Skickat: den 26 mars 2011 04:06</DIV>
<DIV>Till: FreeSWITCH Users Help; FreeSWITCH Users Help; anthony.minessale</DIV>
<DIV>Ämne: Re: [Freeswitch-users] sofia_reg_internal.db growbiggerandbiggeralong with time</DIV>
<DIV></DIV>
<DIV>Hi Anthony,</DIV>
<DIV></DIV>
<DIV>I tried to delete the db files sofia_reg_* db files, it is the same.</DIV>
<DIV></DIV>
<DIV>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),</DIV>
<DIV>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.</DIV>
<DIV></DIV>
<DIV>Please FOCUS here.</DIV>
<DIV></DIV>
<DIV>the mail below shows the details,</DIV>
<DIV>thanks!</DIV>
<DIV></DIV>
<DIV>sender： Charles</DIV>
<DIV>sent time： 2011-03-25 12:22:57</DIV>
<DIV>receiver： FreeSWITCH Users Help; msc; jeff</DIV>
<DIV>cc： jonas.gauffin</DIV>
<DIV>subject： Re: Re: [Freeswitch-users] sofia_reg_internal.db grow bigger and biggeralong with time</DIV>
<DIV></DIV>
<DIV>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).</DIV>
<DIV>however, i did not find anything wrong regarding the code itselft, so failed to fix it...</DIV>
<DIV>could you please help focus here to fix it, thanks.</DIV>
<DIV></DIV>
<DIV>P.S. i manually insert the correct record into this talbe, after a while (tens of seconds), it automatically deteleted by FS.</DIV>
<DIV></DIV>
<DIV>btw, i found there is a bug report like this http://jira.freeswitch.org/browse/FS-498# and it is marked</DIV>
<DIV></DIV>
<DIV>Resolved:14/Sep/10 12:32 PM, however, my version is Nov, 30, 2010, there is still exsit.</DIV>
<DIV></DIV>
<DIV></DIV>
<DIV>[cid:__0@Foxmail.net]</DIV>
<DIV></DIV>
<DIV></DIV>
<DIV> line#801 of sofia_reg.c:</DIV>
<DIV>sql = switch_mprintf("insert into sip_authentication (nonce,expires,profile_name,hostname, last_nc) "</DIV>
<DIV> "values('%q', %ld, '%q', '%q', 0)", uuid_str,</DIV>
<DIV> switch_epoch_time_now(NULL) + (profile->nonce_ttl ? profile->nonce_ttl : DEFAULT_NONCE_TTL),</DIV>
<DIV> profile->name, mod_sofia_globals.hostname);</DIV>
<DIV>switch_assert(sql != NULL);</DIV>
<DIV>sofia_glue_actually_execute_sql(profile, sql, profile->ireg_mutex);</DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV>2011-03-26</DIV>
<DIV>________________________________</DIV>
<DIV>Charles</DIV>
<DIV>________________________________</DIV>
<DIV>发件人： Anthony Minessale</DIV>
<DIV>发送时间： 2011-03-26 00:12:12</DIV>
<DIV>收件人： FreeSWITCH Users Help</DIV>
<DIV>抄送：</DIV>
<DIV>主题： Re: [Freeswitch-users] sofia_reg_internal.db growbiggerandbiggeralong with time</DIV>
<DIV>can you try deleting the db files sofia_reg_* db files? Maybe they</DIV>
<DIV>have become corrupt?</DIV>
<DIV>2011/3/25 fieldpeak <fieldpeak@gmail.com>:</DIV>
<DIV>> Hi Jonas,</DIV>
<DIV>> i also think so. can you please update was the bug fixed?</DIV>
<DIV>></DIV>
<DIV>> 在 2011-3-25 下午5:14，"Jonas Gauffin" <jonas.gauffin@gmail.com>编写：</DIV>
<DIV>></DIV>
<DIV>> might be the same bug as I reported here:</DIV>
<DIV>> http://jira.freeswitch.org/browse/FS-498</DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>> On Fri, Mar 25, 2011 at 8:13 AM, Charles <fieldpeak@gmail.com> wrote:</DIV>
<DIV>>></DIV>
<DIV>>> no, this is not the c...</DIV>
<DIV>></DIV>
<DIV>> _______________________________________________</DIV>
<DIV>> FreeSWITCH-users mailing list</DIV>
<DIV>> FreeSWITCH-users@lists.freeswitch.org</DIV>
<DIV>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</DIV>
<DIV>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users</DIV>
<DIV>> http://www.freeswitch.org</DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>> _______________________________________________</DIV>
<DIV>> FreeSWITCH-users mailing list</DIV>
<DIV>> FreeSWITCH-users@lists.freeswitch.org</DIV>
<DIV>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</DIV>
<DIV>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users</DIV>
<DIV>> http://www.freeswitch.org</DIV>
<DIV>></DIV>
<DIV>></DIV>
<DIV>--</DIV>
<DIV>Anthony Minessale II</DIV>
<DIV>FreeSWITCH http://www.freeswitch.org/</DIV>
<DIV>ClueCon http://www.cluecon.com/</DIV>
<DIV>Twitter: http://twitter.com/FreeSWITCH_wire</DIV>
<DIV>AIM: anthm</DIV>
<DIV>MSN:anthony_minessale@hotmail.com</DIV>
<DIV>GTALK/JABBER/PAYPAL:anthony.minessale@gmail.com</DIV>
<DIV>IRC: irc.freenode.net #freeswitch</DIV>
<DIV>FreeSWITCH Developer Conference</DIV>
<DIV>sip:888@conference.freeswitch.org</DIV>
<DIV>googletalk:conf+888@conference.freeswitch.org</DIV>
<DIV>pstn:+19193869900</DIV>
<DIV>_______________________________________________</DIV>
<DIV>FreeSWITCH-users mailing list</DIV>
<DIV>FreeSWITCH-users@lists.freeswitch.org</DIV>
<DIV>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</DIV>
<DIV>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users</DIV>
<DIV>http://www.freeswitch.org</DIV>
<DIV>!DSPAM:4d8d70e832765221816297!</DIV>
<DIV>_______________________________________________</DIV>
<DIV>FreeSWITCH-users mailing list</DIV>
<DIV>FreeSWITCH-users@lists.freeswitch.org</DIV>
<DIV>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</DIV>
<DIV>UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users</DIV>
<DIV>http://www.freeswitch.org</DIV></FONT></DIV></BODY></HTML>