Versions Compared

Old Version 11

changes.mady.by.user Gary Parden

Saved on

compared with

New Version Current

changes.mady.by.user Ian Fitzgerald (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If necessary, upgrade to supported versions of Java, Tomcat and Oracle, SQL Server or MySQL / MariaDB.

See above for details.

Remember, if you are upgrading tomcat, to restore any JDBC drivers needed for datasources that use database technologies or versions not supported for PhixFlow's own connections. See Install Tomcat for details, but in brief, make sure that any additional JDBC drivers you use are placed in:

...

Warning

Some MariaDB PhixFlow migration scripts create or use privileged functions and/or procedures, and must have privileges not required by the regular PhixFlow user.

Specifically, one of the following must be true:

  • the migration user must have has SUPER privilege, or
  • the mysql global variable 'log_bin_trust_function_creators' must be is set to true

If neither are true, the migration script may fail and would require manual recovery.

...

Code Block
titleE.g. for MariaDB users
cd $RELEASE/schema/sqlserver/migration/X.Y
mysql -h myServer -u myUsername -p -D myDatabase
source migrate_schema_from_x_y_z_to_X_Y_Z.sql


Re-start Tomcat

Import new Templates package

...


Complete

The upgrade is now complete.