This page explain how to upgrade from a previous version of the Project Web Manager to a new one.

Of course, you need to have working PWM in place before upgrading to a new version.

 Installation

The 1.2.5x introduce a new options a some changes in the data base regarding attached files.

This migration applies only if your PWM version is 1.2.1x

• Download the last version of PWM binary release
• Unzip the files
• Prepare the database (commands are the same for MySQL and MariaDB):
  • It is recommended to make a backup of your data base BEFORE applying the patches that follow.
  • Connect to the data base, in a console type:
    mysql -u pwmroot -p
    press enter and give the password for the pwmroot user.
  • Run the following commands that will updates all tables and index used by Project Web Manager (execute as pwmroot user in a mysql session):
    source path/mysql-upgrade-04.sql
    where path is the path to the script (ex: c:/toto/titi), press enter to execute.
    Note It may be necessary before loading the script to set the variable thread_stack=512K into your data base configuration file, section [mysqld]
    CAUTION whatever your platform is use '/' (and NOT '\'), and do not use spaces in the path, move the file if needed.
  • Exit the connexion:
    exit
    press enter to execute.

Read the installation documentation in order to configure all files (services, data base access, ...).

DO NOT copy/paste your old configuration files into the new pwm.war.

Simply deploy the war on your J2EE server.

The 1.2.1 introduce a new license option.

This migration applies only if your PWM version is 1.2.0x

• Download the last version of PWM binary release
• Unzip the files
• Prepare the database (commands are the same for MySQL and MariaDB):
  • It is recommended to make a backup of your data base BEFORE applying the patches that follow.
  • Connect to the data base, in a console type:
    mysql -u pwmroot -p
    press enter and give the password for the pwmroot user.
  • Run the following commands that will updates all tables and index used by Project Web Manager (execute as pwmroot user in a mysql session):
    source path/mysql-upgrade-03.sql
    where path is the path to the script (ex: c:/toto/titi), press enter to execute.
    Note It may be necessary before loading the script to set the variable thread_stack=512K into your data base configuration file, section [mysqld]
    CAUTION whatever your platform is use '/' (and NOT '\'), and do not use spaces in the path, move the file if needed.
  • Exit the connexion:
    exit
    press enter to execute.

Read the installation documentation in order to configure all files (services, data base access, ...).

DO NOT copy/paste your old configuration files into the new pwm.war.

Simply deploy the war on your J2EE server.

The 1.2.00 introduce the final cost value, so some changes on the data base must be done.

This migration applies only if your PWM version is 1.1.02 or 1.1.03 or 1.1.04

• Download the last version of PWM binary release
• Unzip the files
• Prepare the database (commands are the same for MySQL and MariaDB):
  • It is recommended to make a backup of your data base BEFORE applying the patches that follow.
  • Connect to the data base, in a console type:
    mysql -u pwmroot -p
    press enter and give the password for the pwmroot user.
  • Run the following commands that will updates all tables and index used by Project Web Manager (execute as pwmroot user in a mysql session):
    source path/mysql-upgrade-02.sql
    where path is the path to the script (ex: c:/toto/titi), press enter to execute.
    Note It may be necessary before loading the script to set the variable thread_stack=512K into your data base configuration file, section [mysqld]
    CAUTION whatever your platform is use '/' (and NOT '\'), and do not use spaces in the path, move the file if needed.
  • Exit the connexion:
    exit
    press enter to execute.

Read the installation documentation in order to configure all files (services, data base access, ...).

DO NOT copy/paste your old configuration files into the new pwm.war.

Simply deploy the war on your J2EE server.

The 1.2.00 introduce the final cost value, so some changes on the data base must be done.

This migration applies only if your PWM version is 1.1.02 or 1.1.03 or 1.1.04

• Download the last version of PWM binary release
• Unzip the files
• Prepare the database (commands are the same for MySQL and MariaDB):
  • It is recommended to make a backup of your data base BEFORE applying the patches that follow.
  • Connect to the data base, in a console type:
    mysql -u pwmroot -p
    press enter and give the password for the pwmroot user.
  • Run the following commands that will updates all tables and index used by Project Web Manager (execute as pwmroot user in a mysql session):
    source path/mysql-upgrade-02.sql
    where path is the path to the script (ex: c:/toto/titi), press enter to execute.
    Note It may be necessary before loading the script to set the variable thread_stack=512K into your data base configuration file, section [mysqld]
    CAUTION whatever your platform is use '/' (and NOT '\'), and do not use spaces in the path, move the file if needed.
  • Exit the connexion:
    exit
    press enter to execute.

Read the installation documentation in order to configure all files (services, data base access, ...).

DO NOT copy/paste your old configuration files into the new pwm.war.

Simply deploy the war on your J2EE server.

The 1.1.02 introduce the cost/h value, so some changes on the data base must be done.

• Download the last version of PWM binary release
• Unzip the files
• Prepare the database (commands are the same for MySQL and MariaDB):
  • It is recommended to make a backup of your data base BEFORE applying the patches that follow.
  • Connect to the data base, in a console type:
    mysql -u pwmroot -p
    press enter and give the password for the pwmroot user.
  • Run the following commands that will updates all tables and index used by Project Web Manager (execute as pwmroot user in a mysql session):
    source path/mysql-upgrade-01.sql
    where path is the path to the script (ex: c:/toto/titi), press enter to execute.
    Note It may be necessary before loading the script to set the variable thread_stack=512K into your data base configuration file, section [mysqld]
    CAUTION whatever your platform is use '/' (and NOT '\'), and do not use spaces in the path, move the file if needed.
  • Exit the connexion:
    exit
    press enter to execute.

Read the installation documentation in order to configure all files (services, data base access, ...).

DO NOT copy/paste your old configuration files into the new pwm.war.

Simply deploy the war on your J2EE server.