This document describes the Linux upgrade process for configuring a LAMP stack, the Wildfly J2EE server and Level Access’s AMP applications on RedHat Enterprise Linux (RHEL) 8.x.
On this page:
- Required skills
- Prerequisites
- Back up the database
- Upgrade AMP database
- Update AMP master database
- Upgrade AMP
- Upgrade Wildfly
- Contact AMP support
Required skills
Level Access (Level) expects that customers who have elected to self-host their instance of AMP has IT staff with the appropriate level of access, knowledge and ability to perform basic hosting-related IT tasks, including:
Installation and configuration of server, application and database software
Email (specifically SMTP) account setup and configuration
Configuration of DNS and other services
Obtaining or creating signed SSL certificates (https/TLS implementation is mandatory)
In larger enterprises, many different IT teams might participate in configuration and setup. In this case, we recommend assigning a project manager to ensure that all appropriate parties are aware of the upgrade requirements.
You'll need administrator or root access on the target computer to run the commands needed to install AMP and the supporting software. You'll also need to ensure that SELinux is not in "enforcing" mode.
Prerequisites
Before upgrading:
Obtain access to the upgrade file: AMP-9.66.0-UpgradeFiles.zip
-
Ensure that your system still meets the minimum AMP on-premise system requirements. An abbreviated list includes:
PHP 8.2
MySQL 8.x
Java 21
- Log out of your AMP instance via your web browser before you begin the upgrade.
Back up the database
Note: AMP 9.66.x requires that at least MySQL 8.0 is installed. Previous versions of MySQL are not supported and will not allow AMP to run.
We highly recommended that you take a database snapshot before performing the upgrade.
To back up the database:
- Issue the following command from a computer that has access to the AMP database. Substitute the username, database name and host that AMP uses to access the database for
[DB_USER],[DB_NAME],[DB_HOST]. Substitute the current version of AMP for[VERSION].
mysqldump –no-tablespaces --skip-triggers --single-transaction -u [DB_USER] -p [DB_NAME] -h [DB_HOST] -r amp.[VERSION].db.sqlThe following file is generated in the directory that the command is run from: amp.[VERSION].db.sql
Upgrade AMP database
You must update SQL functions and triggers.
To update SQL functions and triggers:
Using the command line, navigate to the
mysql-install/triggersfolderUse the MySQL client to import the functions and triggers by entering the following in the command prompt:
cd mysql-install/triggers
mysql –u root –p –D [AMP_DB_NAME] < triggers_import.sql
mysql –u root –p –D [AMP_DB_NAME] < function_import.sqlUpdate AMP master database
You must first ensure that the AMP master database exist. Then, import the database.
Ensure that the database exists
The AMP master database enables you to import the current Accessibility Standards, Best Practices and Tests during the AMP upgrade process.
Note: During the installation this database might not have been created. Please check that an amp_master database exists in the MySQL instance that AMP is using. If it does not, please create one.
To create the amp_master database:
Log into the MySQL instance as a user that can create and drop tables, as well as create and grant privileges to users.
Create the amp_master database with the following command:
create database amp_master;
Create the amp_master database user and grant this user privileges to manage the data in the amp_master database:
create user 'amp_master'@'%' identified by 'amp_master'; grant all on amp_master.* to 'amp_master'@'%';
4. Grant the AMP database user View only access to the amp_master database. This enables AMP to create and update Accessibility Standards, Best Practices and Tests through the AMP user interface.
grant select on amp_master.* to 'amp'@'%';
Import the database
After you have located or created the database, import it.
To import the database:
Use the command prompt to navigate to the mysql-install folder.
- Run the following command to import the amp_core_tables.sql into the amp_master database:
cd mysql-install/core_tables mysql -u amp_master -p -D amp_master < amp_core_tables.9.66.0.sql
Upgrade AMP
You need to prepare file system, copy and move uploaded assets, update permissions, edit virtual AMP host,
Prepare the file system
Note: AMP 9.66.x requires at least PHP 8.0 is installed. Previous versions of PHP are not supported and will not allow AMP to run.
To prepare the file system:
Unzip amp.zip (located inside the AMP-9.66.0-UpgradeFiles.zip).
Move the resulting amp-install/9.66.0 in to the /opt/amp directory.
tar xzf amp.zip mv amp-install/9.66.0 /opt/amp/
Copy and move uploaded assets
AMP stores documents and images that are uploaded on the file system. You can find them in the following locations:
- /opt/amp/[VERSION]/amp-[VERSION]/amp/uploads/
- /opt/amp/[VERSION]/amp-[VERSION]/amp/exports/
- /opt/amp/[VERSION]/amp-[VERSION]/amp/macro_scripts/
- /opt/amp/[VERSION]/amp-[VERSION]/documents/
- /opt/amp/[VERSION]/amp-[VERSION]/iftb_source/
- /opt/amp/[VERSION]/amp-[VERSION]/private_keys/
Note: If the location of your AMP installation files differs, please adjust the paths appropriately throughout this guide.
To preserve these assets across AMP versions, move these folders from the previous amp-[CURRENT_VERSION] folder to the corresponding folder in the amp-9.66.0 folder.
cd /opt/amp/[CURRENT_VERION]/amp-[CURRENT_VERION]/
mv amp/uploads /opt/amp/9.66.0/amp-9.66.0/amp/
mv amp/exports /opt/amp/9.66.0/amp-9.66.0/amp/
mv amp/macro_scripts /opt/amp/9.66.0/amp-9.66.0/amp/
mv ./documents /opt/amp/9.66.0/amp-9.66.0/amp/
mv ./iftb_source /opt/amp/9.66.0/amp-9.66.0/amp/
mv ./private_keys /opt/amp/9.66.0/amp-9.66.0/amp/Update permissions
You must ensure that each of the folders you copied have the Read/ Write permissions for the user that Apache is running as.
To update the permissions:
Ensure that the EXEC_GROUP value at the top of these scripts is set to a valid group for the Apache user.
From the tools directory, run the update_permissions.sh and hosted_permissions.sh scripts.
cd /opt/amp/9.66.0/amp-9.66.0/tools
sudo sh update_permissions.sh
sudo sh hosted_permissions.sh(Optional) Upgrade SSO configuration
If you use the SimpleSAML installation that Level Access provided with AMP, you can upgrade the SSO SAML service. Learn more about the upgrade process for SSO SAML service.
Edit AMP virtual host
To edit AMP virtual host:
Locate the existing Apache VirtualHost definition for AMP. Typically, it’s located where the appache24-amp.conf file was copied during the initial AMP installation.
- Update the DocumentRoot to use the new version path. For example: /opt/amp/9.66.0/amp-9.66.0/amp.
- Update the php_admin_value include_path to use the new version path. For example: /opt/amp/9.66.0/amp-9.66.0/includes.
- Update the Alias /access-assistant to refer to the /opt/amp/9.66.0/assistant/9.14.0.30 directory.
- Populate ???_MASTER_DATABASE_* environment variables.
- Enter the hostname of the server hosting your master database. Typically, this is the same as the AMP database server. Enter amp_master as USER, PASSWORD and NAME.
Restart Apache
You must restart Apache to update the AMP server with the changes you made.
To restart Apache:
Run configtest to ensure that the changes made to the Apache VirtualHost configuration file do not have any syntax errors.
apachectl configtest
Verify that the Syntax Ok message appears.
Note: If there are problems with the configuration file, an error with a line number is displayed. Review and correct the errors until the Syntax Ok message is received.
Issue the command to gracefully restart Apache.
sudo systemctl restart httpd24-httpdLog in as system admin
To log in as a system administrator:
Navigate to https://YOUR_SERVER_URL/admin/util/data/schema/update.php.
Enter the credentials of the user whose password was updated in the Update System Admin Password section at the AMP Login screen. The AMP Schema Updates page is displayed.
Click the Standard Data Updates link at the bottom of the page. The Reload AMP Data page is displayed.
Click Submit.
Click the AMP logo at the top of the page to return to the new AMP Dashboard.
Upgrade Wildfly
You must prepare the file system, install Chrome drivers, deploy the web app, and complete proxy updates.
Prepare the file system
To prepare the file system:
Move the wildfly.zip file to the Wildfly server and unzip it. The /wildfly-install folder is created, containing the files necessary to configure the JEE system for AMP.
Install Chrome drivers
To install Chrome drivers:
Copy the wildfly-install/chromedrivers folder to the Wildfly root directory:
cp -r wildfly-install/chromedrivers /opt/wildfly/
Deploy web app
To deploy the AMP Services web app:
Copy the AMPJSONServices.war file from the AMP Install files directory in to the Wildfly standalone/deployments directory.
sudo -u wildfly cp wildfly-install/AMPJSONServices.war /opt/wildfly/standalone/deployments/
Proxy updates
Note: The spidering-services.json file in the wildfly-install folder has the section with proxy settings added.
To update the proxy:
Navigate to $JBOSS_HOME/standalone/configuration/spidering-services.json.
Add a section with your organization's proxy setting to the spidering-services.json.
Restart JBoss to pick up the updates to the spider-services.json for deployed web apps.
Contact AMP support
Current licensed AMP users can enter AMP support inquiries online. For general AMP inquiries relating to licensing, pricing or use please e-mail us at ampsupport@levelaccess.com or call us at (800) 889-9659.
Comments
0 comments
Article is closed for comments.