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

[Bogdan-Andrei Iancu]

Hi John,

Thank you for your report.

I found a typo (c'n'p error) in the DB migration code - this is fixed 
now, so you can update from GIT and re-test.

We will follow up on the issue related to the CTL scripts.

Regards,

Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
http://www.opensips-solutions.com

On 08.06.2016 17:51, John Quick wrote:
> 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
>
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>