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.
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);