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

[Klaus Darilion]

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?

Thanks
Klaus

[Daniel-Constantin Mierla]

Hello,

Post by Klaus Darilion
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