<!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>Hi <FONT color=#000000>Michael,
</FONT></FONT></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><FONT color=#000080 size=2></FONT> </DIV>
<DIV><FONT color=#c0c0c0 size=2>2011-03-25 </FONT></DIV><FONT color=#000080
size=2>
<HR style="WIDTH: 100px" align=left color=#b5c4df SIZE=1>
</FONT>
<DIV><FONT color=#c0c0c0 size=2><SPAN>Charles</SPAN> </FONT></DIV>
<HR color=#b5c4df SIZE=1>
<DIV><FONT size=2><STRONG>发件人：</STRONG> Michael Collins </FONT></DIV>
<DIV><FONT size=2><STRONG>发送时间：</STRONG> 2011-03-24 10:56:52 </FONT></DIV>
<DIV><FONT size=2><STRONG>收件人：</STRONG> FreeSWITCH Users Help </FONT></DIV>
<DIV><FONT size=2><STRONG>抄送：</STRONG> </FONT></DIV>
<DIV><FONT size=2><STRONG>主题：</STRONG> Re: [Freeswitch-users]
sofia_reg_internal.db grow bigger and biggeralong with time </FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>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...
<DIV><BR></DIV>
<DIV>-MC<BR><BR>
<DIV class=gmail_quote>On Wed, Mar 23, 2011 at 7:42 PM, fieldpeak <SPAN
dir=ltr><<A
href="mailto:fieldpeak@gmail.com">fieldpeak@gmail.com</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Hi Anthony,<BR><BR>Thanks for your reply.<BR>i tried to
understand how long it is the expire time and where to cnofigure it.<BR>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...<BR><BR>thanks for your help!<BR><BR>
<DIV class=gmail_quote>2011/3/24 Anthony Minessale <SPAN dir=ltr><<A
href="mailto:anthony.minessale@gmail.com"
target=_blank>anthony.minessale@gmail.com</A>></SPAN><BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>they expire so they will be deleted when the expire time
happens.<BR>If you have a lot you were probably attacked by a sip worm.<BR>
<DIV>
<DIV></DIV>
<DIV><BR><BR>On Wed, Mar 23, 2011 at 9:38 AM, fieldpeak <<A
href="mailto:fieldpeak@gmail.com" target=_blank>fieldpeak@gmail.com</A>>
wrote:<BR>> i found sofia_reg_internal.db grow bigger and bigger after
FreeSwitch for<BR>> some time.<BR>> the change comes from the
sip-authentication table inside this db, it always<BR>> create new record
for nonce for the new challenge ('407 Proxy Authentication<BR>>
Required') for the call from registered users.<BR>> any one can help how
to avoid the db grow, i'm afaid the hard disk will be<BR>> full along
with time...<BR>><BR>> Thanks!<BR>><BR></DIV></DIV>>
_______________________________________________<BR>> FreeSWITCH-users
mailing list<BR>> <A href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR>> <A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>>
UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR>>
<A href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR>><BR>><BR><BR><BR><BR>--<BR>Anthony
Minessale II<BR><BR>FreeSWITCH <A href="http://www.freeswitch.org/"
target=_blank>http://www.freeswitch.org/</A><BR>ClueCon <A
href="http://www.cluecon.com/"
target=_blank>http://www.cluecon.com/</A><BR>Twitter: <A
href="http://twitter.com/FreeSWITCH_wire"
target=_blank>http://twitter.com/FreeSWITCH_wire</A><BR><BR>AIM: anthm<BR><A
href="mailto:MSN%3Aanthony_minessale@hotmail.com"
target=_blank>MSN:anthony_minessale@hotmail.com</A><BR>GTALK/JABBER/<A
href="mailto:PAYPAL%3Aanthony.minessale@gmail.com"
target=_blank>PAYPAL:anthony.minessale@gmail.com</A><BR>IRC: <A
href="http://irc.freenode.net" target=_blank>irc.freenode.net</A>
#freeswitch<BR><BR>FreeSWITCH Developer Conference<BR><A
href="mailto:sip%3A888@conference.freeswitch.org"
target=_blank>sip:888@conference.freeswitch.org</A><BR><A
href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org"
target=_blank>googletalk:conf+888@conference.freeswitch.org</A><BR>pstn:+19193869900<BR><BR>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A href="mailto:FreeSWITCH-users@lists.freeswitch.org"
target=_blank>FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR></BLOCKQUOTE></DIV><BR><BR>_______________________________________________<BR>FreeSWITCH-users
mailing list<BR><A
href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</A><BR><A
href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</A><BR>UNSUBSCRIBE:<A
href="http://lists.freeswitch.org/mailman/options/freeswitch-users"
target=_blank>http://lists.freeswitch.org/mailman/options/freeswitch-users</A><BR><A
href="http://www.freeswitch.org"
target=_blank>http://www.freeswitch.org</A><BR><BR></BLOCKQUOTE></DIV><BR></DIV></FONT></DIV></BODY></HTML>