[Spce-user] Permanent Contacts after upgrade from 2.8 to 3.8.6

[Alex Lutay]

Dear Robert,

On 05/18/2016 02:45 PM, Alex Lutay wrote:
> Sure, the fix is already on review. There is one place left with root
> user there for 3 years, while all the code uses sipwise user.

I have two good and one bad news.

Good news #1:

The situation is clear here. And the issue with root user
is really the problem + one more unsafe state handling due to missing
"set -e". The fix will be prepared and released without rush.

The issue happens here ONLY:
 - if root user has a password
 - if some subscriber has more the one permanent registrations.

Bad news:

The permanent registrations is lost due to command:
> echo "DROP TABLE IF EXISTS location_perm;"
which is executed earlier the schedule due to wrong user 'root' in use.

Good news #2:

We are doing backups! :-)

You can find it on your server:
zless /var/backup/ngcp-mr3.8.6/db_backup.sql.gz
(please make a copy first).

There is content of location before the upgrade,
and there is permanent registrations you have
(with expires="1970-01-01 01:00:00").

So you have to recover them manually
extracting values "username domain contact path"
and insert in new kamailio using:

> ngcp-sercmd proxy ul.add location "${username}@${domain}" "${contact}" 0 1.00 "${path}" 0 0 4294967295

Feel free to ask if you need further assistance here.
We are sorry for inconvenience here.
Thank you for the bugreport.

-- 
Alex Lutay