[Freeswitch-users] sofia_reg_internal.db growbiggerandbiggeralong with time

Madovsky infos at madovsky.org
Sat Mar 26 17:59:54 MSK 2011


seems that even the text of your email becomes bigger and bigger :)

  ----- Original Message ----- 
  From: Charles 
  To: FreeSWITCH Users Help ; FreeSWITCH Users Help 
  Sent: Saturday, March 26, 2011 6:33 AM
  Subject: Re: [Freeswitch-users]sofia_reg_internal.db growbiggerandbiggeralong with time


  Hi Peter,

  Thanks for reminding, i've submit it to Jira.

    a.. FreeSWITCH 
    b.. 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 at lists.freeswitch.org [freeswitch-users-bounces at lists.freeswitch.org] för Charles [fieldpeak at 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 at 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 at 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 at 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 at gmail.com> wrote:
  >>
  >> no, this is not the c...
  >
  > _______________________________________________
  > FreeSWITCH-users mailing list
  > FreeSWITCH-users at 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 at 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 at hotmail.com
  GTALK/JABBER/PAYPAL:anthony.minessale at gmail.com
  IRC: irc.freenode.net #freeswitch
  FreeSWITCH Developer Conference
  sip:888 at conference.freeswitch.org
  googletalk:conf+888 at conference.freeswitch.org
  pstn:+19193869900
  _______________________________________________
  FreeSWITCH-users mailing list
  FreeSWITCH-users at 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 at 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 at lists.freeswitch.org
  http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
  UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
  http://www.freeswitch.org
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20110326/e596111d/attachment.html 


More information about the FreeSWITCH-users mailing list