Version 2 (modified by ibaldin, 5 years ago)

--

Notes on ORCA Eastsound 5.0

Migration Notes

VERY IMPORTANT - you need to modify MySQL configuration on the VM. First you have to change the /etc/my.cnf file:

Under the [mysqld] section add this line:

max_allowed_packet=32M

Also, you need to change the schemas for both mysql databases (for both containers) to change shirakoproperties column type from 'text' to 'largetext'. Save this as a script script.sql:

alter table Actors modify shirakoproperties longtext; alter table Clients modify shirakoproperties longtext; alter table ConfigMappings? modify shirakoproperties longtext; alter table Inventory modify shirakoproperties longtext; alter table ManagerObjects? modify shirakoproperties longtext; alter table Miscellaneous modify shirakoproperties longtext; alter table Packages modify shirakoproperties longtext; alter table Plugins modify shirakoproperties longtext; alter table Proxies modify shirakoproperties longtext; alter table Reservations modify shirakoproperties longtext; alter table Slices modify shirakoproperties longtext; alter table Units modify shirakoproperties longtext; alter table Users modify shirakoproperties longtext;

And then run it like this (for the two databases):

mysql -u orca -p orca12080 < script.sql mysql -u orca -o orca14080 < script.sql