[SR-Users] upgrade question to Kamailio 4, how to handle ruid in location/aliases

[Daniel-Constantin Mierla]

Hello,

On 23/09/14 15:57, Klaus Darilion wrote:
> Hi!
>
> I have to upgrade a production server from 3.x to 4.x.
> 4.x added a unique constraint on ruid.
>
> I have plenty of entries in aliases and usrloc table. How do I update
> these entries to get the ruid field populated?
>
> Can I do an upgrade reusing the entries stored in the usrloc table or do
> I have to truncate the table and then wait until every client reREGISTERs?
it should just work with putting an unique value for each record -- 
maybe you can generate some kind of random string via an sql query. I 
assume you don't have GRUU contacts anyhow, having an old version not 
supporting it, so the ruid is used only internally.

Cheers,
Daniel

-- 
Daniel-Constantin Mierla
http://twitter.com/#!/miconda - http://www.linkedin.com/in/miconda
Next Kamailio Advanced Trainings 2014 - http://www.asipto.com
Sep 22-25, Berlin, Germany