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.
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!
_______________________________________________
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