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
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