Please rate how useful you found this document: 
Average: 1 (1 vote)

Overview

According to the Upgrade Road Map, this document explains the standard procedure to upgrade to ProcessMaker versions 3.4.x from the following ProcessMaker versions:

  • 3.2.2 or 3.2.3
  • 3.3.x Minor Release
  • 3.4.x Point Release

Refer to the following sections to upgrade from ProcessMaker versions 3.2.2, 3.2.3, 3.3.x or 3.4.x to ProcessMaker 3.4.x:

Before Upgrading to ProcessMaker 3.4.x

Before upgrading from ProcessMaker 3.2.2, 3.2.3, 3.3.x or 3.4.x to the latest ProcessMaker 3.4.x in point release in either Linux or Windows platforms, take into account the following considerations:

  • A ProcessMaker Point Release means an upgrade from a version to another one in the ProcessMaker 3.4.x range.
  • ProcessMaker upgrade makes changes in the source code. ProcessMaker services and tasks must be stopped, so this action should be planned and done when ProcessMaker is not being used.

  • JOBS_PENDING and JOBS_FAILED tables must not contain any task. To clean all pending tasks in this tables, use this guide.

  • Before the upgrading, update values in the CONTENT table by following the next steps:
  1. Log on to MySQL as the "root" user (or as the user listed in the shared/sites/workspace/db.php file):

    mysql -u root -p
  2. Switch to workspace's database (which is named wf_workflow by default):

    USE database;

    Note: To see a list of the available databases, use: SHOW DATABASES;

  3. Issue the following two commands to update values in the CONTENT table:

    UPDATE CONTENT SET CON_VALUE = 'none' WHERE CON_CATEGORY = 'WEE_DESCRIPTION' AND CON_LANG = 'en' AND CON_VALUE = '';
    UPDATE CONTENT SET CON_VALUE = 'untitled'
    WHERE CON_CATEGORY IN ('WEE_DESCRIPTION', 'WEE_TITLE', 'DYN_TITLE', 'OUT_DOC_TITLE', 'REP_TAB_TITLE', 'TRI_TITLE')
    AND CON_VALUE = '' AND CON_LANG = 'en';

    If more workspaces were created, then issue these same commands for each workspace database.

  4. Exit MySQL:

    EXIT;

Steps to Upgrade to ProcessMaker 3.4.x

Steps to upgrade from ProcessMaker 3.2.2, 3.2.3, 3.3.x or 3.4.x to the latest ProcessMaker 3.4.x point release based on these supported operating systems:

Linux

Follow these steps to upgrade to ProcessMaker 3.4.x in Linux platforms, which involves the Apache and NGINX web servers:

  1. In the terminal, log on as root or with the root privileges:

    su or: sudo su -
  2. Copy the processmaker-3.4.x.tar.gz file to the /opt directory:

    cp processmaker-3.4.x.tar.gz /opt/
  3. Overwrite any existing files in the /opt directory:

    cd /opt tar -xzvf processmaker-3.4.x.tar.gz
  4. Configure the permissions for the processmaker directory:

    chmod -R 770 processmaker/
  5. Give permission to access the following files in the /processmaker directory:

    cd processmaker chmod -R 775 bootstrap bootstrap/cache config framework cd thirdparty/html2ps_pdf/ chmod -R 775 cache/ out/ temp/
  6. Depending on the supported stacks, set the Apache or NGINX user as the owner of the files within the processmaker directory:

    chown -R apache:apache processmaker

    or nginx:

    chown -R nginx:nginx processmaker
  7. Upgrade ProcessMaker files, the ProcessMaker database, and the translation files as described at ProcessMaker Command:

    ./processmaker upgrade [workspace]

    Warning: In case of a Point Release upgrade, to avoid downtime, DO NOT use this command if the ProcessMaker version to upgrade does not contain database upgrades. Review our current Release Notes in the front page (previous versions are in the same document) to know if the ProcessMaker version has changes in its database.

  8. Run the flush-cache command:

    ./processmaker flush-cache

    Note: In case of a Point Release upgrade that does not contain a solution that requires to run the flush-cache command, the upgrading process does not requires to run the command. In the front page (previous versions are in the same document), review the requirements of the Release Notes to know if the ProcessMaker version requires to run the flush-cache command.

  9. As of ProcessMaker 3.4.6, to update the PM_DELETECASE permission, run the following MySQL query:

    UPDATE RBAC_PERMISSIONS SET PER_STATUS = 1 WHERE PER_UID = '00000000000000000000000000000013';
  10. As of ProcessMaker 3.4.7, to update the PM_FOLDERS_ALL permission, run the following MySQL query:

    UPDATE RBAC_PERMISSIONS SET PER_CODE = 'PM_FOLDERS_ALL' WHERE PER_UID = '00000000000000000000000000000015';
  11. In a ProcessMaker point release, consider the following:

    Note: After every command execution, verify if there are error or warning messages. This may be due to wrong file permissions.

    • Check if ProcessMaker files have the correct owner and permissions.
    • Enable the Supervisor service with this commands:
    • $ sudo supervisorctl reread
      $ sudo supervisorctl update
      $ sudo supervisorctl stop all
      $ sudo supervisorctl start all
      $ sudo supervisorctl status all
    • Restart the Supervisor service:
    • $ sudo systemctl stop supervisord.service
      $ sudo systemctl start supervisord.service
      $ sudo systemctl status supervisord.service

Windows

Follow these steps to upgrade to ProcessMaker 3.4.x in Windows platforms:

  1. Copy the processmaker-3.4.x.tar.gz file to the C:\opt directory.

  2. Use a program like WinRAR or 7-Zip to extract processmaker-3.4.x.tar.gz to the C:\opt directory.

  3. Start the command prompt as the administrator, and then issue the commands in the next steps.

  4. Go to the C:\opt\processmaker directory:

    cd C:\opt\processmaker
  5. Upgrade ProcessMaker files, the ProcessMaker database, and the translation files as described at ProcessMaker Command:

    php -f processmaker upgrade [workspace]

    Warning: In case of a Point Release upgrade, to avoid downtime, DO NOT use this command if the ProcessMaker version to upgrade does not contain database upgrades. Review our current Release Notes in the front page (previous versions are in the same document) to know if the ProcessMaker version has changes in its database.

  6. Run the flush-cache command:

    php -f processmaker flush-cache

    Note: In case of a Point Release upgrade that does not contain a solution that requires to run the flush-cache command, the upgrading process does not requires to run the command. In the front page (previous versions are in the same document), review the requirements of the Release Notes to know if the ProcessMaker version requires to run the flush-cache command.

  7. As of ProcessMaker 3.4.6, to update the PM_DELETECASE permission, run the following MySQL query:

    UPDATE RBAC_PERMISSIONS SET PER_STATUS = 1 WHERE PER_UID = '00000000000000000000000000000013';
  8. As of ProcessMaker 3.4.7, to update the PM_FOLDERS_ALL permission, run the following MySQL query:

    UPDATE RBAC_PERMISSIONS SET PER_CODE = 'PM_FOLDERS_ALL' WHERE PER_UID = '00000000000000000000000000000015';
  9. In a ProcessMaker point release, consider the following:

    • Check if ProcessMaker files have the correct owner and permissions.

    • The Supervisor service must be configured as a Windows service. Use the NSSM software.

    • Stop and restart the service from the local Windows Services in the Control Panel.