[OpenSIPS-Users] Problems migrating from v2.1 to v2.2

[John Quick]

I just wanted to report some snags I hit when migrating. Note: I had the
install prefix set to /

After running make+Install for v2.2, executable files in /usr/local/sbin
were not updated to the v2.2 versions. The new versions were *only* in /sbin
That would be okay, except that when I ran opensipsdbctl, it tried to run
the old version in /usr/local/sbin
When I deleted the old executable files in /usr/local/sbin, I got this
error:
"-bash: /usr/local/sbin/opensipsdbctl: No such file or directory"
...so I copied everything for opensips that was in /sbin to /usr/local/sbin
and that seemed to fix it.

Then I finally was able to run opensipsdbctl migrate <db_v21> <db_v22> and I
got the following errors which I was able to skip:
ERROR: failed to migrate opensips_v21.cc_flows to opensips_v22.cc_agents
(ERROR 1054 (42S22) at line 1: Unknown column
'opensips_v21.cc_flows.agentid' in 'field list')!!!
Skip it and continue (y/n)? y
ERROR: failed to migrate opensips_v21.cc_flows to opensips_v22.cc_cdrs
(ERROR 1054 (42S22) at line 1: Unknown column 'opensips_v21.cc_flows.caller'
in 'field list')!!!

John Quick
Smartvox Limited
Web: www.smartvox.co.uk