Hi,
I've been trying to migrate from DevTest 10.3 to 10.6, and I've encountered a problem when I start up the Identity and Access Manager (IAM) component.
What I do in Docker is the following:
- I install DevTest 10.3 on (all the databases use utf8mb4 charset and collation):
- container A with the Enterprise Dashboard (ED) + a separate container with a mysql 5.7.27 database for the ED.
- container B with the Registry, Portal, and VSE + a separate container with a mysql 5.7.27 database for the Registry.
- one additional machine with a mysql 5.7.27 database for the future IAM.
- I start up ED, then the Registry, Portal, and finally the VSE. I wait until they populate the databases. The dradis.properties on container A is configured for the ED DB, and the site.properties on container B is configured for the Registry DB.
- I stop all the 10.3 services.
- I install DevTest 10.6 without ED on container B in a different directory than the 10.3 installation, migrating the required files from the 10.3 installation directory into the 10.6 installation directory. I configure IdentityAccessManager/iam.properties on container B for the IAM DB.
- I start the IAM, I wait, then it stops.
As I check the IdentityAccessManager/standalone/log/server.log, I see that there are problems with some alter table statements. I've tried setting innodb_strict_mode=off, and also innodb_log_file_size=256M without any luck. Maybe there is some other problem that I cannot spot - sorry, I'm not an expert with DevTest. I've attached the logs from the server.log file.
Would you be so kind to help me resolving this problem? Thank you in advance for your response.
Sincerely,
Gábor Román