Hi all, I'd like to keep track of on what switch and sofia profile_name a UA is registered. By default, FS automatically creates a table sip_registrations without these fields, so I started looking in mod_sofia to see whether the fields could be added, and to my surprise, I saw they should already be inserted (along with presence_hosts) !
sofia_reg.c in function sofia_reg_handle_register at line 774: sql = switch_mprintf("insert into sip_registrations " "(call_id ,sip_user ,sip_host ,presence_hosts ,contact ,status ,rpid ,expires,user_agent,server_user,server_host,profile_name,hostname) " "values ('%q','%q', '%q','%q','%q','%q', '%q', %ld, '%q', '%q', '%q', '%q', '%q')", call_id, to_user, reg_host, profile->presence_hosts ? profile->presence_hosts : reg_host, contact_str, reg_desc, rpid, (long) switch_timestamp(NULL) + (long) exptime * 2, agent, from_user, guess_ip4, profile->name, mod_sofia_globals.hostname); (Is that the right spot ?) So I tried just adding the fields as VARCHAR(255)'s to the table, and restarted the switch. It coredumped (for the first time btw), so I guessed the NULL values for the already present registrations were to blame, so I emptied the sip_registrations table and restarted. It started alright, but then gave errors on registrations this: 2008-09-23 17:57:26 [ERR] sofia_glue.c:2880 sofia_glue_actually_execute_sql() ERR: [insert into sip_registrations values ('[EMAIL PROTECTED]', '00A0C5D4C03A-1','scarlet.nl','"user" <sip: [EMAIL PROTECTED]:63747;fs_nat=yes>','Registered(UDP- NAT)', 'unknown', 1222192646, 'dunno', '00A0C5D4C03A-1', '213.204.232.18')] [STATE: HY000 CODE 1136 ERROR: [unixODBC][MySQL][ODBC 3.51 Driver] [mysqld-5.0.51a-3ubuntu5.1]Column count doesn't match value count at row 1 ] How can this be ? This query is very different from the one before... Is it already possible to save the hostname and sip_registrations (and presence_hosts) somehow ? thanks, Leon de Rooij [EMAIL PROTECTED] _______________________________________________ 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