<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=gb2312" 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 Anthony,</FONT></DIV>
<DIV><FONT color=#000080></FONT> </DIV>
<DIV><FONT color=#000080>I tried to delete </FONT><FONT
color=#000000>the db files sofia_reg_* db files, it is
the same.</FONT></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><FONT style="BACKGROUND-COLOR: #ffff00" color=#ff0000>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.</FONT></DIV>
<DIV><FONT color=#ff0000><FONT
style="BACKGROUND-COLOR: #ffff00"></FONT></FONT> </DIV>
<DIV><FONT color=#ff0000><FONT
style="BACKGROUND-COLOR: #ffff00">Please FOCUS here.<FONT
color=#ff0000><FONT
color=#ff0000><STRONG></FONT></DIV></STRONG></FONT></FONT></FONT>
<DIV> </DIV>
<DIV>the mail below shows the details, </DIV>
<DIV>thanks!</DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT size=2 face=Verdana><STRONG>sender：</STRONG> Charles</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>sent time：</STRONG>
2011-03-25 12:22:57</FONT></DIV>
<DIV>receiver<FONT size=2 face=Verdana><STRONG>：</STRONG> FreeSWITCH Users Help;
msc; jeff</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>cc：</STRONG> jonas.gauffin</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>subject：</STRONG> Re: Re:
[Freeswitch-users] sofia_reg_internal.db grow bigger and biggeralong with
time</FONT></DIV></DIV>
<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 <A
href="http://jira.freeswitch.org/browse/FS-498">http://jira.freeswitch.org/browse/FS-498</A>#
and it is marked
<DL class=dates>
<DT>Resolved:14/Sep/10 12:32 PM, however, my version is Nov, 30, 2010, there
is still exsit.</DT></DL></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><IMG src="cid:__0@Foxmail.net"></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><U><STRONG> line#801 of sofia_reg.c:</STRONG></U></DIV>
<DIV>
<DIV><EM><FONT
color=#0000ff>sql = switch_mprintf("insert into sip_authentication (nonce,expires,profile_name,hostname, last_nc) "</FONT></EM></DIV>
<DIV><EM><FONT
color=#0000ff> "values('%q', %ld, '%q', '%q', 0)", uuid_str,</FONT></EM></DIV>
<DIV><EM><FONT
color=#0000ff> switch_epoch_time_now(NULL) + (profile->nonce_ttl ? profile->nonce_ttl : DEFAULT_NONCE_TTL),</FONT></EM></DIV>
<DIV><EM><FONT
color=#0000ff> profile->name, mod_sofia_globals.hostname);</FONT></EM></DIV>
<DIV><EM><FONT
color=#0000ff>switch_assert(sql != NULL);</FONT></EM></DIV>
<DIV><EM><FONT
color=#0000ff>sofia_glue_actually_execute_sql(profile, sql, profile->ireg_mutex);</FONT></EM></DIV></DIV>
<DIV><FONT color=#000080 size=2></FONT> </DIV></DIV>
<DIV> </DIV>
<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> Anthony Minessale
</FONT></DIV>
<DIV><FONT size=2 face=Verdana><STRONG>发送时间：</STRONG> 2011-03-26 00:12:12
</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>can you try deleting the db files sofia_reg_* db files? Maybe they</DIV>
<DIV>have become corrupt?</DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></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></DIV>
<DIV></DIV>
<DIV>-- </DIV>
<DIV>Anthony Minessale II</DIV>
<DIV></DIV>
<DIV>FreeSWITCH http://www.freeswitch.org/</DIV>
<DIV>ClueCon http://www.cluecon.com/</DIV>
<DIV>Twitter: http://twitter.com/FreeSWITCH_wire</DIV>
<DIV></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></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>_______________________________________________</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>