[Freeswitch-users] store sofia profile_name and hostname in sip_registrations

[Leon de Rooij]

I rebuilt everything from latest SVN and now it works alright !
I still had an older version intalled, but was looking in newer  
source :)

kind regards,

Leon


On Sep 23, 2008, at 6:14 PM, Leon de Rooij wrote:

> 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 ('446BD213B8D1111 at 172.16.42.124',
> '00A0C5D4C03A-1','scarlet.nl','"user" <sip:
> 00A0C5D4C03A-1 at 213.204.223.35: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
> leon at scarlet-internet.nl
>
> _______________________________________________
> 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