This section contains guides to help you with installing a new copy of Drupal.  Information on updating and upgrading existing Drupal sites can be found elsewhere in the handbook.

services:  
  appserver:
    build_as_root:
      - apt-get update -y
      - apt-get install libxslt1-dev -y
      - docker-php-ext-install xsl
      - docker-php-ext-enable xsl

lando rebuild -y

composer create-project drupal-composer/drupal-project:9.x-dev SITENAME --no-interaction

cd SITENAME
lando init

lando start

lando drupal moi module_name

lando drupal cc all

$databases = array (
  'default' => 
  array (
    'default' => 
    array (
      'database' => 'myd7sitedb',
      'username' => 'database',
      'password' => 'database',
      'host' => 'database',
      'port' => '3306',
      'driver' => 'mysql',
      'prefix' => '',
    ),
  ),
);

name: myd7site
recipe: drupal7
config:
  php: '7.3'
  composer_version: 2
  via: 'apache:2.4'
  webroot: .
  database: 'mysql:5.7'
  # note this is just for lando/docker as 'global' install--drush is installed via drupal composer for local site use
  drush: ^8
  xdebug: false
services:
  database:
    creds:
      user: database
      password: database
      database: myd7sitedb
  appserver:
    overrides:
      environment:
        DRUSH_OPTIONS_URI: "https://local.myd7site.gatech.edu"
tooling:
  'lint:php:themes':
    service: appserver
    cmd: /app/vendor/bin/phpcs --standard=phpcs-themes.xml
    description: 'Runs php linter against your custom code. Ex: lando lint:php'
proxy:
  appserver:
    - myd7site.lndo.site
    - local.myd7site.gatech.edu //set in local hosts file

$databases = array (
  'default' =>
    array (
      'default' =>
        array (
          'database' => 'database',
          'username' => 'mysql',
          'password' => 'mysql',
          'host' => 'ic',
          'port' => '3306',
          'driver' => 'mysql',
          'prefix' => '',
        ),
    ),
);

name: multid7
recipe: drupal7
config:
  php: '7.3'
  composer_version: 2
  via: 'apache:2.4'
  webroot: .
  database: 'mysql:5.7'
  # note this is just for lando/docker as 'global' install--drush is installed via drupal composer for local site use
  drush: ^8
  xdebug: false
proxy:
  appserver:
    - cse.lndo.site
    - local.cse.gatech.edu //set in local hosts file
    - ic.lndo.site
    - local.ic.gatech.edu //set in local hosts file
    - scs.lndo.site
    - local.scs.gatech.edu //set in local hosts file
services:
  cse:
    type: mysql:5.7
    appserver:
      overrides:
        environment:
          DRUSH_OPTIONS_URI: "https://local.cse.gatech.edu"
  ic:
    type: mysql:5.7
    appserver:
      overrides:
        environment:
          DRUSH_OPTIONS_URI: "https://local.ic.gatech.edu"
  scs:
    type: mysql:5.7
    appserver:
      overrides:
        environment:
          DRUSH_OPTIONS_URI: "https://local.scs.gatech.edu"

$databases['default']['default'] = array (
  'database' => 'myd9db',
  'username' => 'database',
  'password' => 'database',
  'prefix' => '',
  'host' => 'database',
  'port' => '3306',
  'namespace' => 'Drupal\\Core\\Database\\Driver\\mysql',
  'driver' => 'mysql',
);

name: myd9
recipe: drupal9
config:
  php: '7.3'
  composer_version: 2
  via: 'apache:2.4'
  webroot: .
  database: 'mysql:5.7'
  drush: true
  xdebug: false
tooling:
  'lint:php:themes':
    service: appserver
    cmd: /app/vendor/bin/phpcs --standard=phpcs-themes.xml
    description: 'Runs php linter against your custom code. Ex: lando lint:php'
  drush:
    service: appserver
    env:
     DRUSH_OPTIONS_URI: "https://local.myd9.gatech.edu"
proxy:
  appserver:
    - myd9.lndo.site
    - local.myd9.gatech.edu // set in local hosts file
services:
  database:
    creds:
      user: database
      password: database
      database: myd9db

name: samplesymfony4app
recipe: symfony
config:
  symfony: '4'
  php: '7.3'
  via: 'apache:2.4'
  webroot: public
  database: mysql:5.7
  services:
    database:
        creds:
            user: database
            password: database
            database: gradcc

name: samplesymfony5app
recipe: symfony
config:
  php: '7.3'
  via: 'apache:2.4'
  webroot: public
  database: mysql:5.7
  services:
    database:
        creds:
            user: database
            password: database
            database: symfony5db

name: myphp
recipe: lamp
config:
  php: '7.4'
  via: 'apache:2.4'
  composer_version: '2'
  webroot: public
  database: mysql:5.7
  services:
    database:
        creds:
            user: database
            password: database
            database: myphpdb
  proxy:
    appserver:
      - myphp.lndo.site
      - local.myphp.gatech.edu // set in local hosts file

The specified file temporary://fileX could not be copied, 
because the destination directory is not properly configured. 
This may be caused by a problem with file or directory permissions. 
More information is available in the system log.

  http://your-site-host-name/admin/config/media/file-system

$ ./install.sh

Enter the full path to your project directory: /c/path/to/your/installation-folder

Enter your database username: database_username

Enter your database password: database_password

Enter your database host (probably localhost): localhost

Enter the database port: 3306

Enter the name of the database: database_name

Enter the site name: Site Name

Enter the site email: email@gatech.edu

Moving an existing Drupal site (either a production site or one built on a development server) to an OIT Web Hosting account is not terribly difficult, but it is important to make sure you follow all of the right steps.

Skills Required for Migrating a Drupal Site

• You will need to know how to access the Plesk control panel for your account in order to complete the rest of these steps you may also wish to set an SSH password or SSH key so that you can SSH into your web hosting space.

• You should have a basic understanding of filesystems and mySQL databases, as well as phpMyAdmin

• If you need assistance with some of these steps, check with your local unit's IT support staff 

Before You Begin

If you haven't done so already, you'll need to request a hosting account from OIT.  If you are moving a live site, you should ask for the account to be set up as the hostname of your live site, but ask that DNS not be updated yet, since that would disrupt your existing site.  Once the account is set up, you can do one of two things to access it while you are working on migrating your existing site:

1. You can edit your local computer's hosts list (on Linux and Macintosh computers, this is /etc/hosts) to locally map your live site's hostname to your OIT hosting account.  This is the quickest method, but while you have this mapping in place you won't be able access your existing live site from that computer.

2. You can create a DNS alias for your new site.  You or someone in your IT staff will have to create the alias in DNS, and then you'll have to go into the Plesk control panel for your new OIT Web Hosting site and add the alias there (via the Add New Domain Alias button on the main page) so that the Plesk server knows that your DNS alias goes with your OIT Web Hosting account.  This method takes a little more effort to set up, but with it you can access your new site from anywhere while you are testing it, and you can access your existing live site from the same computer at the same time.

3. You could actually mix these two methods for perhaps the most versatile option:  you can define an alias for your new site in your local computer's host file, and then add that alias to your Web Hosting account via the Plesk control panel, but without adding the alias to DNS.  This will let you access both the old and new sites from your local computer, but you still won't be able to access your new site from anywhere else.

When your new site is ready to go live and replace your existing live site, you can have DNS updated (see below) and remove any unneeded aliases that you have created.

Moving Any Drupal Site to an OIT Web Hosting Account

1. You will need to create an archive of the filesystem of your existing site, and an archive (often called an SQL dump) of your existing site's database.  How you do this will depend on where your existing site is located.  Please note that if you are comfortable with using SSH, you can archive your site's filesystem as either a GZipped Tar archive (.tar.gz extension) or a Windows style ZIP archive (.zip extension).  If you are not comofrtable with SSH and prefer to upload your archive to your Web Hosting account via the Plesk control panel, your archive must be in Windows style ZIP format.

2. Upload the archive file to your OIT Web Hosting Account and unpack it where you want your Drupal installation to live.  From within the Plesk control panel, you can upload the archive file via the File Manager.  Once the file is uploaded, just select it in the File Manager to unpack it.  After the archive file has been unpacked, move it to your hosting account's "/private/" folder.

3. In the Plesk control panel, go to the Databases manager and create a new database.  Copy down the database name, the database user name, and the password, as you will need them later.

4. While still in the Databases manager, on its main page select the phpMyAdmin link for the database you just created.  This will open phpMyAdmin for this database in a new browser window or tab.  On the Import tab of phpMyAdmin, import the SQL dump of your existing site's database.

5. Either via SSH or the Plesk control panel's File Manager, modify your Drupal site's sites/default/settings.php file and update the database information in it to match what you copied down in step three above.

6. Navigate to your Web Hosting account's main URL, and you should hopefully see the front page of your Drupal site.  Try logging into it and check the Drupal status page and error logs to see if there are any problems with the site.

Updating DNS When Moving a Live Site

If your site is already live in another location, then you will need to update DNS to point your site's hostname to your new OIT Web Hosting account.  You will need to know your hosting account's server name - to get this, just look in your browser's address bar while logged into your Web Hosting account's Plesk control panel.  The server will be web-plesk##.oit.gatech.edu, where # is a number.  Either update your existing site's hostname to point to this Plesk server, or if you don't have that kind of access, ask your local IT support staff to make the change for you.  If you don't have anyone in your unit who can update DNS, you can always open a support request with OIT.

A Word on Migrating a Development Site to Live Production

If you are developing your site somewhere else and then moving it to an OIT Web Hosting account (or any other server where the DNS hostname for the site will be different from what it was in development), then you need to take special care to make sure that your internal links do not break.

When setting the URL paths for page links, inline images, attachment files, etc., make sure to enter those URLs as relative paths.  A regular (called 'absolute') URL looks like this:

  http://your-site-host-name/path/to/my/file.xyz

The relative version of that path looks like this:

  /path/to/my/file.xyz

Relative paths will continue to work even after you change the hostname of the website.  Absolute paths will cause the user's web browser to try to follow the link back to the development site.  This can cause all kinds of problems, ranging from links not working and images not showing as soon as the new site goes live, to problems that aren't detected until someone shuts down the development site months after the production site went live.

The command line savvy developer may want to search through his/her SQL database dump for the hostname of the development server before uploading that dump file to the new OIT Web Hosting account.  This is a great way of catching any absolute URL links that are still lingering about somewhere in the site.

Importing a Migrated Site into Installatron

Installatron is a service available in OIT Web Hosting that (among other things) can keep the core of your Drupal site automatically updated with security patches. To import a migrated Drupal site into Installatron, please refer to the Installatron documentation provided by OIT's Web Hosting team and watch the video tutorial on this page.

Please note that by default, Installatron does not enable automatic updating of Drupal core when importing a Drupal website into Installatron. To turn on automatic update:

1. From the front page of the Plesk control panel, look for the Installatron Applications Installer link on the right-hand side of the page.
2. In the section that gives details about your Drupal installation, select the blue wrench icon button.
3. Under Automatic Update, select 'Create a backup and update to new minor versions and security releases. (Recommended)'.
4. Select Save All. 

Before you take a Georgia Tech Drupal site live, it is a good idea to go through the following checklist of best practices to make sure your site is secure and streamlined for production use. This checklist is designed for Drupal 7 sites on OIT's Web Hosting, but will generally apply to other environments and later versions of Drupal as well.

---

Within the Drupal Application

Helpful Tip: The admin interface can be accessed via the black admin toolbar at the top of any page when logged in with administrator rights.

Make Sure Core, Module, and Theme Updates Get Applied When Needed

Enable the Update manager using the following settings so that you and your team will be notified of important available updates.  Then, make sure those updates get applied in a timely fashion (but be sure to back up your site before doing so: more information on backup is below, in case anything goes wrong).

If you are using Drupal 8 or higher (considered modern Drupal), the site now needs the Composer CLI tool to manage installation and updates for Drupal core and any modules, due to more complex project dependencies.

Recommended "Available updates" Settings

Located at: Reports -> Available Updates -> Settings (admin/reports/updates/settings)

• Check for updates: Weekly
• Check for updates of disabled modules and themes: Yes (unless on a multi-site, where only 1 site should check this)
• E-mail addresses to notify when updates are available: At least TWO (2) email addresses (preferably some office-wide emails).
• E-mail notification threshold: Only security updates

Limit Access to Your Site

Avoid giving out any more access than necessary

• Make sure you have a suitable user account role for content managers that does not let them install modules, change themes, adjust low-level Drupal settings, etc.

• Ideally, only trained IT and/or web development staff should have administrator or super administrator privileges

Review your User Account List Regularly

Remove (or block) accounts of users no longer working in your unit; blocking is often the better option, as that maintains tracking of what those users did. Removing the account will require all content changes to be attributed to the "anonymous" user.

Review your Role Permissions Regularly

Roles are what map Drupal access permissions to individual users.  Review the list (found at People -> Permissions) to make sure roles do not have unnecessary permissions that put your site at risk.

Recommended "Account settings" Settings

Located at: Configuration -> People -> Account settings (admin/config/people/accounts)

• Anonymous users - Name: Visitor
• Administrator role: Super Administrator (for Drupal Express sites only; for all other sites: Administrator)
• Who can register accounts?: Administrators only
• Require e-mail verification when a visitor creates an account: Yes.
• When cancelling a user account: Disable the account and keep its content.
• Personalization
  • Enable signatures: No
  • Enable user pictures: No

Enable GT Account Authentication

• Most Georgia Tech Sites should use GT Account Authentication, which is provided by the CAS (cas) module
• Drupal Express has the CAS module already installed
• For all other sites, see the Installing CAS section for installation and configuration instructions

Recommended "Text formats" Settings

Located at: Configuration -> Content authoring -> Text formats (admin/config/content/formats)

• Order matters: place "basic text editor" at the top/first, then "minimal HTML", etc.
• "Plain text" is the only format to which Anonymous users should have access.
• If "PHP code" is present, DO NOT allow anyone to use it!

Configure Error Logging Securely

Drupal and PHP error messages shown to regular users could reveal sensitive details about your site, and just look unprofessional as well.  Use the following settings to hide error and warning messages from site visitors and keep them from overflowing your site's database.

Note: Do not enable the core syslog module if you are using OIT Web Hosting. According to the syslog module documentation, it is not appropriate for shared hosting. You should be able to find most useful debugging information by going to the Logs section in the OIT Web Hosting Control Panel and looking at the error logs.

Recommended "Logging and errors" Settings

Located at: Configuration -> Development -> Logging and errors (admin/config/development/logging)

• Error messages to display: None. 
• Database log messages to keep: 100

Enable Caching to Improve Site Performance

Recommended "Performance " Settings

Located at: Configuration -> Development -> Performance (admin/config/development/performance)

• Caching
  • Cache pages for anonymous users: Yes.
  • Cache blocks: (Depends on how often your blocks change)
  • Minimum cache lifetime: (Depends on how much dynamic content you have)

  • Expiration of cached pages: (Only matters if you are using an external cache like Varnish)

• Bandwidth optimization
  • Aggregate and compress CSS files: Yes
  • Aggregate JavaScript files: Yes

Protect Web Forms and Collected Data

Note: You should try using non-Drupal solutions for forms, such as Qualtrics, whenever possible. Keeping forms and general data out of Drupal is more secure and makes it easier to manage and later upgrade your Drupal site.

In general, do not use Drupal to store sensitive data of any kind: FERPA protected, HIPAA protected, DoD protected, or personal identity information (SSNs, birthdates, etc.)!  The exception to this rule is if your Drupal site is for internal use only and is firewalled properly to prevent access from off-campus.  Even then, you should apply all possible security protections to prevent internal hacking of your sensitive data.

If you still need to have a form on a Drupal site, use the latest version of WebForm, and install some type of anti-spam / anti-bot protection, as forms get hit by bots quickly and regularly once they are made public.

• Look at modules like Honeypot, Spamicide and BOTCHA to fend off bots
• Avoid CAPTCHA (especially the early versions) if at all possible, as it will greatly irritate your users; the latest version is more acceptable, as it does not "quiz" the site visitor as strongly as the earlier versions
• If you're resorting to CAPTCHA, consider whether or not the form can instead be locked down to just the Georgia Tech Campus only

Recommended "Site information" Settings

Located at: Configuration ->  System -> Site information

"E-mail address" is the address from which emails are sent by the site, so it should be generic, rather than the address of a real person.  Note: this must be an @gatech.edu email address for the campus email servers to accept messages from your website!

Note that the Georgia Tech web theme does not display the "Site name" set here, but rather has it's own site title fields on the theme configuration page.  However, "Site name" is used for the name shown in a web browser tab and any page bookmarks in a browser, so it needs to be set to something meaningful, and ideally identical to what you set on the theme configuration page.

Module and Library Safety Tips

• Where possible, sign up for alerts about updates to libraries being used (such as CKEditor, phpCAS, Flexslider, etc), especially security vulnerability alerts.  Drupal does not give any notifications about out-of-date libraries!
• Always turn off the following (unless you really need them):
  • PHP filter
  • Tracker
  • Comments
• Review your modules regularly and disable any that are not being used
  • Disabled modules should be uninstalled and then removed from the Drupal filesystem (move them to the /private folder if you are on OIT Web Hosting)
  • If Drupal reports that a module has been removed from its repository on the Drupal.org website, there's usually a good reason.  Remove any such modules from your site ASAP!
• Avoid keeping development-only modules on live sites. If you really need any, keep them turned off when not in use.
• Avoid alpha/beta release modules and anything that is poorly supported or not supported at all.
  • When evaluating new modules, look at the last date of a release (be wary if more than a year ago), number of sites reporting usage of the module, reputation of the module's maintainer(s), and the number of open issues in the development queue.

Check Your Site's Health

• Check the Status report (found at Reports -> Status report) and correct any problems listed
• Use the Security Review module to scan your installation for common security problems

Custom Code and the Drupal Filesystem

General Rules of Thumb

• Always write secure code!
• Never hack the core Drupal code or any third party modules!
  • Hacks will likely get overwritten when updates are applied later on.
  • Instead, look for ways to extend or adjust the code through a custom module.
• Avoid using unsupported modules, libraries or themes.
• Test anything new or uncertain in a separate instance of Drupal.  Never develop on your live site!
• Don't bother trying to hide the fact that you're running Drupal - it's really not worth the time and effort.

Drupal Filesystem Maintenance

• Avoid putting anything but Drupal related code in or under the main Drupal directory
  • Adding other files or applications complicates the upgrade process, which can result in those other files or applications disappearing unexpectedly.
    • Drupal version 8 and beyond does not support running any other applications from within or under the main Drupal directory.
  • If you manually install modules or themes, don't leave their archive files within the Drupal directory tree.  Move them to the /private directory if you want to keep them around.

OIT Plesk Web Hosting Control Panel

General Hosting Account Configuration

Owner/Administrator

• Avoid giving out hosting account access unless it is absolutely needed; only those who need to perform Drupal code upgrades should have hosting account access - content managers should never be given access to the hosting account.
• Regularly check that the administrators of a site are correct (and remove any former maintainers).

Notification Email Address for Website

Only one email address is allowed, so set to the address of a mailing list or alias that forwards to all of your site administrators.

Installatron Applications Installer

• If you are using Drupal 8 or higher (considered modern Drupal), the site now needs the Composer CLI tool to manage installation and updates for Drupal core and any modules, due to more complex project dependencies.

• The Installatron tool on Plesk does not support Composer-managed updates, and is not recommended for managing a modern Drupal site. Installatron will update Drupal core without checking dependencies, and there is a high risk of updates eventually breaking any site that includes additional modules, as most Drupal sites do.

  Plesk now offers the PHP Composer UI tool to provide limited Composer support via a site's control panel. However, updates have to be manually prompted, and the tool is limited use.

• How do I get started with Drupal on Plesk?
• Is Drupal the right choice of CMS for my site?

PHP Composer UI Tool

• While it's strongly recommended to use Composer CLI to develop and manage your site projects locally, the PHP Composer tool on Plesk provides some helpful options for managing Composer applications from your site control panel.

• How do I use the Plesk PHP Composer extension? 

SSL Configuration

Follow the guide to SSL configuration to run your site with SSL encryption (via an https:// URL).

Plesk Backup / Restoration Manager

• Before any major update or smaller update, it is recommended that you create a full backup of your site following the instructions before performing any changes/upgrade on your site.
• In case that you need to restore the site back from unsuccessful change/upgrade:
  Please note that Drupal upgrade process tends to add new files to the system.  
  
  Restoring from backup will not delete files that were added after the backup was created. Therefore, it is suggested to do a "clean" restore to avoid new files created during the unsuccessful upgrade interfering the configuration of your site before the backup.  
  
  How to do a "clean" restore with Plesk Backup Manager (under About Restoration Behavior section)

Scheduled Tasks (cron)

• Follow the guide to setting up cron so that your Drupal site will refresh content and check for security updates.

Directory structure (multi-site vs. solo site, single system per virtual host, etc.)

• This will vary depending on your site setup, but we no longer recommend using "contrib" and "custom" subfolders in the sites/all/modules folder.

URL Redirects

• These are usually created in your .htaccess file (always keep a copy of the latest in your /private directory).
• Check that your redirects did not get overwritten when your site's Core code was late updated.

---

Additional ideas can be found in the recording of the How Not to Build and Maintain a Drupal Site session at DrupalCon Amsterdam 2014, and in the following:

• Securing Your Drupal Site (Last updated in 2016)
• List of security-related contrib modules (Last updated in 2016)
• Supporting Drupal Over the Long Run (BadCamp 2012)
• Performance for Site Builders (2012)

Updates patch Drupal to add new features and protect against discovered vulnerabilities, keeping your sites working optimally. Always test new updates on a development site before applying them to your live, production site.

Drupal 9 has a different method of doing updates.  Please see the soon-to-be-added pages for Drupal 9 update instructions.

---

Drupal Updates Sub-Topics

Notes, tips, and tricks for upgrading a Drupal 8 site to Drupal 9

Moving to Drupal 9 from Drupal 8 does not involve near as much planning and preparation work as previous major version upgrades thanks to changes the Drupal organization has made to the development process.  Instead of Drupal 9 introducing a new batch of features, new features have been added gradually over the major point releases of Drupal 8.  The key changes with the first release of Drupal 9 will be to remove deprecated (old and no longer used) code, and to upgrade the underlying Symfony framework.  On the surface, though, you should not see any notable differences between Drupal 8.9 and Drupal 9.0, assuming you have prepared your site properly.

Preparation

Basic Requirements

• Drupal 9 requires PHP 7.3 or higher (7.4 is preferred). If you are on OIT Web Hosting, you should be able to set your PHP version now via your site's Plesk Control Panel.

• Drupal 9 requires a settings.php change:
  • The line beginning with "$config_directories['sync'] =" has to be changed to "$settings['config_sync_directory'] ="

  • Note: You can do this before upgrading, as Drupal 8.9 will work with either version of the setting.

• To upgrade to Drupal 9, you must be on Drupal 8.9.0 or higher.
  • If you are already on 8.9, make sure you have the latest patch release to get the smoothest transition

  • If you are on anything earlier, upgrade to the latest patch release of 8.9 first, then upgrade to the latest 9.0 release.

• Drupal 9 requires all active themes and modules to declare Drupal 9 compatibility:
  • Compatibility is indicated by a line in the theme or module's .info.yml file that starts with "core_version_requirement:"
  • Check and update all custom and contrib modules.
• Drupal 9 (as did Drupal 8.9) uses CKEditor 4.14.0, but Drupal 9 seems to be stricter about CKEditor plugins. If you are using any add-on CKEditor plugins, check each one to see if there's a 4.14 specific version and upgrade as needed. Composer should maintain the compatible plugin version with a Drupal 9-compatible release.
  
  As an example, Balloon Panel, used by Accessibility Checker, was one that needs to be up-to-date to work in Drupal 9.

Checking Module / Theme Compatibility

There are several tools available that are supposed to check your site's modules and themes for Drupal 9 compatibility. The present options either require the ability to run PHP at the command line or require your site to be managed through Composer (such as Drupal Express websites).

Upgrade Status Module

The Upgrade Status module can perform a website audit to determine which modules, themes, and add-ons are Drupal 9 compatible.

Command Line

If you are comfortable with running simple commands at the Linux command line, you can get a quick overview of your modules declared compatibility by going to the main modules directory and running the following command:

  grep "core" */*info*

For any module where you do not see a line with "^9" near the end, you'll need to do some testing and research to see if the module will work with Drupal 9.  Check first for a new major version release, and if there is none, you could try the instructions given below for testing a previously Untested Release to see if it causes any problems.

Process

Once you've completed all of the preparatory steps, upgrading is the same as if you were upgrading to another point release of Drupal 8. 

As with any major update, make a full backup (filesystem and database) before you begin, just to be safe.

Afterward, test major website capabilities thoroughly, since a lot of old code has been removed and the underlying Symfony engine has received a major upgrade.

Institute Communications update process

Refer to Institute Communications' gt_installer Drupal 8 to Drupal 9 update process to update GT Theme, GT Tools, and GT Profile to their latest versions.

Issues

Semantic Numbering - New Major Releases

As more time goes by, more module developers will move to the new semantic numbering system that is not tied to a Drupal version number (e.g. 7.x-1.0). Typically, if a module was at say version "8.x-3.5" then the next major release done under the new numbering system would be "4.0.0". You'll have to check carefully for this change, as Drupal alerts major version releases (8.x-3.5 to 4.0, for example) as "Other versions available".

However, in the case of modules like Webform, you may find you are expected to upgrade to the next major version when you upgrade your site to Drupal 9. Module version updates to the next major version can be done easily if you manage your site with Composer. Otherwise, you'll have to do this by hand at the filesystem level (Drupal won't upgrade to a new major version via the GUI).

As with most major version upgrades, manually run schema updates (go to update.php after updating).

Known Problem Modules

• Devel has a new 4.0.0 release just for Drupal 9, but the popular Kint debugger sub-module is gone from 4.0.x. To get that functionality you have to use composer to install a Kint plugin for Devel 4.0.x or use the devel_kint_extras module. That's a big complication if your site is not set up to be managed by composer. As a workaround, you can download the PHAR version of Kint and manually include it in your site to get its functionality. Please note that the manual library process is not as streamlined an install as a prepackaged module.

• Webform 8.x-5 is not compatible with Drupal 9 at all and will actually break the update.php process. If you use Webform, do not attempt to upgrade to Drupal 9 until you have upgraded Webform to its new 6.0 release.

composer require drupal/upgrade_status
drush en upgrade_status
drush cr

composer remove drupal/PROJECTNAME

composer require drupal/imageapi_optimize:^4.0

composer require drupal/core-recommended:^9.0.0 drupal/core-composer-scaffold:^9.0.0 drupal/core-project-message:^9.0.0 --update-with-dependencies --no-update

We use --no-update to avoid a chicken-and-egg problem with mutual dependencies.

--no-update

composer update

composer install

Migration, not upgrade

Drupal 8, released in November of 2015, was a major rewrite of the underlying Drupal code (Drupal's core engine and APIs). Because of the multitude of changes, there is no direct in-place upgrade path to go from any earlier version of Drupal to Drupal 8 or later. Instead, Drupal 7 and earlier sites must be migrated to Drupal 8 or later, which involves setting up a whole new Drupal 8 website and copying into it (manually or automatically) the content of the older website.

As Drupal 8 reached it's end of life on November 2nd, 2021, all remaining migrations from Drupal 7 should be done directly to Drupal 9.  All of the information below applies to Drupal 9.

Requirements and Web Hosting Support

Drupal 9 requires a hosting environment running at least PHP 7.4 or later, which is available on OIT Web Hosting. OIT does not currently support is use of Drush or command line access to Composer. However, the Plesk control panel GUI allows for composer set up and management.

The easiest way to get started with the Georgia Tech branded version of Drupal 9 is to request an installation from OIT. You can select this option when requesting a new OIT Web Hosting account, which is usually the best way to go.  In short, you would set up a new site in a new hosting account using a temporary domain name, and then once you have copied over all of your existing content, you would shut down your old site and repoint your real domain name to the new hosting account. 

Note

If this sounds a little too technical for you, you should consult with your local IT support staff, who should be able to help you through anything concerning domain names and repointing them.

Georgia Tech Migration Roadmap

Beyond PHP support, each Georgia Tech unit website will need several extra components to be fully usable. The following table is an attempt to start tracking the status of the components needed for Georgia Tech Drupal 9 sites, and it will be updated as releases and additional information come available.

Status of common Drupal 7 components in Drupal 8
(Last Updated April 21st, 2021)

Component Name	Available for Drupal 9?	Comments?
Georgia Tech Web Theme	Yes	An official Institute Communications Drupal 9 theme is available. Please see the Georgia Tech Web Theme section for more information on the status of Drupal 9 theme development.
GT Account Authentication	Yes	CAS module v1.0 is fully usable and CAS configuration instructions are available.
Mercury News and Events	Yes	An official port of the official Hg Mercury is available.  It uses a feeds approach (creating nodes for each news or event item) that is different from the Drupal 7 module approach.  Testing in a development environment is recommended to gain familiarity with how to configure and manage the Drupal 9 module.
GT Content Types	No	Vertical, Horizontal, and Multipurpose page types are not going to be ported to Drupal 8. Such pages will have to be rebuilt in Drupal 8+. Alternative page layout systems include: Layout Builder (used in the official Drupal 9 Georgia Tech theme) Paragraphs Panels and Panelizer
GT Drupal Express (DX)	No	A Drupal 9 installation is available for Drupal 9 websites installed through OIT Web Hosting - GT Drupal Express (DX) for Drupal 9. Please note that this is not be a direct replacement (or direct upgrade path) for existing Drupal 7 DX sites. Drupal 7 DX developers should plan for a manual content migration to Drupal 9, as it is unlikely that a script will be developed to aid DX migrations to Drupal 9. A Drupal Express migration strategy guide is under development.
Web Forms	Yes	The traditional Webform module was been completely rewritten for Drupal 8 and is much more capable (and more complex) than the old version. Existing users should treat it like a new product and go through all available getting started and training guides and videos before trying to build a form with Drupal 9. Drupal 9 itself comes with a limited Contact Form functionality and a handful of contrib modules (such as Contact Storage) are available to extend that functionality, though not to the level found in the traditional Webform module. Contact forms are recommended for simple RSVP and feedback forms.

Complete Migration Process

Kevin Pittman has posted a guide to migrating from Drupal 7 to Drupal 9 that includes a lot of planning tips and technical details.

The following information is currently targeted to those site admins who have a site built on a custom theme implementation or have written custom modules for Drupal 9.

If you are using the standard Drupal 9 Drupal Express provided by Institute Communications, you should wait until they release a new version of the Georgia Tech theme package before trying to upgrade to Drupal 10.

A list of things to be watchful for when upgrading to Drupal 10 (to be expanded in the near future):

• There's a new 2.x version CAS module and 2.x version External Auth module that must be installed before upgrading.

• For that matter, use the Available Updates report to scrutinize all of your modules, even the ones that show up in green.  A module with a major version update can still render in green if you have the last release of the previous major version.

• If you are running a Composer manged site, install the Upgrade Status module to check your site for upgrade issues that need to be corrected.

• If you have your own custom modules, you'll need to go through all of them and check for Drupal 10 compatibility issues:

  • drupal_get_path() and drupal_get_filename() are removed from Drupal 10

  • \Drupal::entityQuery now requires an accessCheck() parameter to work

  • Seven, Classy and Stable have been removed from Drupal 10 and need to be disabled before upgrading, unless you plan to use the contrib versions, in which case you must install those versions before upgrading.

    • The administration theme of choice is now 'Claro' - you should switch to Claro and uninstall Seven before trying to do an upgrade to Drupal 10.

    • NOTE: If a theme you are using has enabled Classy or Stable, you must use a hack to disable them, as they are hidden in the admin GUI by default.  See Drupal Issue #3328016 for more details.

      • Short summary: If a theme uses another theme as a base theme, the other theme gets enabled at install time.  However, Classy and Stable are hidden themes, so they don't show up in the admin GUI, thus you can't uninstall them through the GUI.  Unfortunately, Drupal 10's update.php script expects them to be uninstalled.  The hack involves modifying both theme's .info.yaml files to unhide them, allowing you to uninstall them.  Take note that even after unhiding a theme, you still won't be able to uninstall it if an active theme refers to it as a base theme.  Deal with those active themes first (uninstall them or update them to not rely on Classy or Stable), then flush caches and you should be able to uninstall Classy and Stable after unhiding them.

    • If you are using a theme based on Classy, you have two choices: install the contrib version of Classy, or merge everything from Classy into your theme.  Do note that Classy uses Stable as a base, and Stable has also been removed from Drupal 10, replaced with Stable9.  Stable9 does exist in Drupal 9.5.0, so you can port your theme over while still running under Drupal 9.  However, you'll have to use the hack in the previous bullet point to enable Stable9 before you can get another theme to use it as a base theme.  This is because Stable9 is also hidden, like Stable and Classy

  • Last but certainly not least, update the core_version_requirement setting in each custom theme and module's .info.yml file to include ^10

• Deprecated Modules: The following need to be fully uninstalled before upgrading, unless you are choosing to use the new contrib versions, in which case you need to install the corresponding contrib version before upgrading:

  • CKEditor 4 (if you're removing it, don't forget to remove all CKEditor 4 add-on modules as well)
  • Color
  • Quickedit
  • RDF
  • Aggregator
  • Hal

Installing the Georgia Tech Theme

You will need to download both the current Georgia Tech Drupal Theme package, and the GT Tools module.

1. Install the GT Tools module into your sites/all/modules directory, and the Georgia Tech Drupal Theme package into your sites/all/themes directory.
2. Log into your site with administrative privileges and enable the GT Tools module.  Please note that you do not have to enable the GT Content Types or GT Directory sub modules that come with GT Tools.
3. Go to the Appearance administration page and enable the "Georgia Tech - Drupal 7 Theme" and make it the default theme.
4. After enabling the new theme, follow the Settings link shown below its name to configure the theme's settings, using our GT Theme Settings Guide as a reference as needed.

Extending the Georgia Tech Theme

The recommended way of extending the Georgia Tech Theme to meet your unit's special needs is to create a sub-theme instead of modifying any of the files in the Georgia Tech Theme.  This way, when new versions of the official theme are released, you can just drop them into place and not have to figure out all the different things that you customized.

As a way to get started quickly, there is an unofficial GT Sub-theme package that you can use as a base for your own custom sub-theme.

An important hint for those new to sub-themes:  on your Appearance administration page, you set your sub-theme to be your enabled and default theme.  It will then include everything that it needs from your base theme (the official Georgia Tech Drupal Theme).  For this reason, you must leave the Georgia Tech Drupal Theme installed on your site, and it's a good idea to leave it enabled as well.

For advanced developers, there is also a Sass based version of the official Georgia Tech Drupal Theme.

Upgrading the Georgia Tech Theme

It is highly recommended that you first test any new version of the official Georgia Tech Drupal Theme against a copy of your website to make sure you fully understand the effect it will have on your pages and content.

If you have done all of your customizations in a sub-theme, then upgrading the official Georgia Tech Drupal Theme is very easy:

1. Download the latest version of the Georgia Tech Drupal Theme
2. Backup the existing files in your sites/all/themes/gt directory and then remove the directory.
3. Remove the sites/all/themes/gt directory.
4. Install the Georgia Tech Drupal Theme package into your sites/all/themes directory.
5. Log into your site with administrative privileges and flush all of the caches.  This can be done on the Configuration -> Development -> Performance administration page, or via the 'Home' menu if you have the Admin Menu third-party module installed.
6. Go to the Georgia Tech Drupal Theme settings page and verify that all of the available settings are correct.  Note: it has been observed that sometimes after upgrading the theme, you will find all of the settings fields blank the first time you visit the settings page.  If this happens, simply switch to the global theme settings page and the go back to the GT theme settings page, and your old settings should be restored.

Please note that a new version of the Georgia Tech Drupal Theme could cause conflicts with custom CSS and template code in a sub-theme, so you'll have to watch for these issues and update any custom CSS/template files accordingly.

The GT theme version 2.x offers a variety of settings options.

How to Manage Theme Settings

To manage these options:

• Go to: yoursite.gatech.edu/admin/appearance/settings/gt_subtheme
• Use the Appearance link if using the Administration Menu module

Description of Theme Settings

These include:

Georgia Tech Logo Options

Select the default GT logo, or go with one of the college logos. You can also upload a file to use, but it must be a transparent .png, and be within the specified dimensions -- plus be an official logo approved by Institute Communications! Contact Institute Communications if you need assistance getting a logo generated in the proper format.

Styling Version

This setting (only available in versions 2.5 through 2.7) configures which CSS/styling is applied to the GT website.  It allows you to switch to the new layout/style treatment (2.5) or stay backwards-compatible with previous styling. This is to help avoid "breaking" any styling folks may have done via a custom subtheme. The version 2.5 styling option also includes support for a couple of block classes that are added through the GT Tools module (/admin/config/system/gt):

New CSS styles for adding icons to block titles:

• icon-institution (displays: http://fontawesome.io/icon/university/)
• icon-mortar-board (http://fontawesome.io/icon/graduation-cap/)

New CSS styles for adding colored backgrounds to block titles:

• block-title-bg-gt-blue - GT Navy blue background w/ white text
• block-title-bg-gt-gold - GT "Buzz" gold background w/ white text
• block-title-bg-gray - "Dark" gray background (#646464) w/ white text

Site Header

These settings configure site header actions.

1. Site Header Title: Same as the previous theme. The text provided here will appear in the site header, to the right of the main logo. The text will be set in "Buzz" Gold.
2. Hide Home Page Title: Check this box if you want the default page title text to NOT appear on your home page. Note that this is NOT the Site Header Title (as mentioned above,) but the node title of your home page for your site.
3. Search Options: (Removed in version 2.7) Select to have your search be the built-in Drupal search, the campus Google appliance, or user choice.
4. Breadcrumb Options: By default the breadcrumb will list a link back to the main Georgia Tech site homepage first. If you'd like to have another default link always appear after the Georgia Tech link use these fields.

​Super Footer

These settings relate to the superfooter at the bottom of each page.

1. Remove Superfooter: (Added in version 2.7): completely hide the superfooter
2. Super Footer Menus Setup: The Full Georgia Tech Default option will give you the exact same set of super footer menus that appear on the home page of www.gatech.edu. The Georgia Tech Minimum option will give you just the menu from the left column in the super footer of the home page at www.gatech.edu, but the menu will be broken up into two shorter menus. The Configurable option allows you to have three fully configurable menus in your site's super footer.
3. Collapsed Super Footer: Check this option if you would like to have the super footer collapsed by default. If this option is checked a "Resources" tab will appear above the lower footer, which serves as an open/close trigger for the super footer.
4. Campus Map Image and Custom Street Address: By default the site super footer area will show an image of the campus map plus link to the map site, and the official GT mailing address. You can opt to upload your own map image, and have it link to where ever you'd like, plus enter your address.

Footer Login

These settings configure site footer login actions.

1. Show a login link in the footer.
2. Redirect to current page: (Added in version 2.7) instead of being redirected to homepage after you log in.
3. Alternate Login URL: (Added in version 2.7): If you use a different URL to log in to your site, provide that full URL (i.e., http://editor.mysite.gatech.edu).

The GT Tools module is required when using the GT Theme and should be installed before the theme on your Drupal 7 site.  It provides some additional functionality that Drupal doesn't support directly in a theme package, so this functionality had to be provided in a separate module.

GT Tools includes a sub-module called GT Content Types, which provides three new page layouts via custom content types: "Horizontal Landing Page", "Vertical Landing Page", and "Multipurpose Page".  If you want to use this sub-module, you must install the 2.2 version (or newer) of the blockreference module (older versions 2.0 and 2.1 don't work).

The topics below are for troubleshooting specific problems and doing advanced implementations of the Georgia Tech Drupal theme. Implementing some of these features will require knowledge of advanced Drupal development techniques and/or PHP coding skills.

---

Advanced Topics Pages

Please see the introduction to contrib (third-party) modules before installing anything listed on this page.

The following information is provided as-is with no warranty or guarantees of any kind!  While members of the campus community have recommended the following modules for their listed purposes, it's perfectly possible you could blow up your Drupal website if you don't know what you're doing and install them incorrectly or alongside other modules that are incompatible.

Most descriptions are borrowed from the module's home page on the Drupal.org website.

Please see the introduction to contrib (third-party) modules before installing anything listed on this page.

The following information is provided as-is with no warranty or guarantees of any kind!  While members of the campus community have recommended the following modules for their listed purposes, it's perfectly possible you could blow up your Drupal website if you don't know what you're doing and install them incorrectly or alongside other modules that are incompatible.

Most descriptions are borrowed from the module's home page on the Drupal.org website.

Editor's Note: With Drupal 9 having been out since 2020 and Drupal 10 coming out in mid-2022, virtually all development work has ceased on Drupal 7 modules, and in many cases modules have been abandoned for one reason or another, meaning that no one is supporting those modules.  Before adding a module to your Drupal 7 site, check the status of it carefully!  If it has not been updated in more than three years, you could run into problems with it, especially if you have to keep your site going beyond the end of 2022 when you will be required to upgrade to PHP 8.0.  [We recommend that everyone try to get their Drupal 7 sites migrated to Drupal 9 or another content management system before the end of 2022.]

APIs

These are only needed if required by another module.  The ones listed below are some of the most commonly used API modules.

• Libraries - Introduces a common repository for libraries in sites/all/libraries and sites/<domain>/libraries
• Chaos Tools (CTools) - A set of APIs and tools to improve the developer experience
• Entity API - Extends the entity API of Drupal core in order to provide a unified way to deal with entities and their properties
• FlexSlider - Integrates the Flex Slider library with Drupal, which allows you to build responsive, resizable slideshows 
• Advanced Help - Provides support for advanced help documentation in modules provided in standard HTML format
• JQuery Update - Upgrades the version of jQuery in Drupal core to a newer version of jQuery

Administrative Tools

• Administration Menu - Administrative links are displayed in a CSS/JS-based menu at the top on all pages of your site, including links to common tasks and actions
• Module Filter - Lets you more easily see installed modules grouped by type and quickly search through them
• Filter Permissions - Provides filters at the top of the Permissions page for easier management.
• Node Convert - Node Convert adds a menu tab "Convert" on the node view page that gives the ability to convert the node from its current content type to another content type.
  • Local Guide to Using Node Convert

User Authentication

• CAS - Provides single sign-on capability for your Drupal site by implementing the CAS protocol.
  • Local CAS Resources
• LDAP - Provides integration with LDAP (Lightweight Directory Access Protocol) for authentication, user provisioning, authorization, etc.
  • Local LDAP Resources

Security

• SpamSpan - Obfuscates email addresses to help prevent spambots from collecting them
• Honeypot - Uses both the honeypot and timestamp methods of deterring spam bots from completing forms on your Drupal site
• CAPTCHA - Provides CAPTCHA ("Are you a human?") challenge-response tests to virtually any user facing web form on a Drupal site.
  • reCAPTCHA - Uses the Google reCAPTCHA web service to improve the CAPTCHA system and protect email addresses [Requires CAPTCHA module]
• Spamicide - Spamicide adds an input field to each form then hides it with css, when spam bots fill in the field the form is discarded
• BOTCHA - In BOTCHA, we don't abuse our human users - protection is completely transparent to them and non-intrusive. BOTCHA lets spambots to prove they are bots, and lets real users zip by
• Mollom - Connects your site with the Mollom network to help determine if posts or comments are spam.
• Security Review - Automates testing for many of the easy-to-make mistakes that can make your site insecure

User Interface

• CK Editor - Allows Drupal to replace textarea fields with the CKEditor - a visual HTML editor, usually called a WYSIWYG editor
• IMCE - An image/file uploader and browser that supports personal directories and quota
• Image Resize Filter - Just insert an image and set it's height and width properties in HTML (done automatically by WYSIWYG editors) and the image is resized on output to match the HTML
• Adaptive Image Styles - Allows any image to be adaptive simply by setting it to be rendered with the 'adaptive' image style.  Adaptive images are sized down based on the user's detected screen size, reducing bandwidth and load times.  [Requires .htaccess modifications]

Navigation / URL Paths

• 404 Navigation - Causes Drupal to render the primary/main menu on 404 (page not found) error pages
• Pathauto - Automatically generates URL/path aliases for various kinds of content (nodes, taxonomy terms, users) without requiring the user to manually specify the path alias
• Pathologic - An input filter that can correct paths in links and images in your Drupal content in situations which would otherwise cause them to “break;” for example, if the URL of the site changes, or the content was moved to a different server
• Redirect - Work in progress for a Drupal 7 integration and collaboration between redirection-type modules: Path Redirect and Global Redirect
• Global Redirect - Makes sure that all ways to access a page redirect with 301 errors to a single URL path, which optimizes a site for search engines

Design / Layout

• Paragraphs - Allows you — Site Builders — to make things cleaner so that you can give more editing power to your end-users
• Node Block - Allows you to have nodes of specific content type(s) be provided as blocks, combining the editing flexibility of node fields with the placement flexibility of Drupal blocks
• Panels - Allows a site administrator to create customized layouts for multiple uses
  • Menu Mini-Panels - A system for building "megamenu" -style (explanation) dropdown menus using Mini Panels, which provides tremendous flexibility in what can be displayed.
• Menu Block - Provides configurable blocks of menu trees starting with any level of any menu

Flow and Logic

• Workflow - Allows you to create arbitrary Workflows, and assign them to Entities
• Revisioning - Allows for the configuration of workflows to create, moderate and publish content revisions
• Rules - Allows site administrators to define conditionally executed actions based on occurring events (known as reactive or ECA rules)
• Override Node Options - Allows permissions to be set to each field within the Authoring information and Publishing options field sets on the node form

Data Integration / Migration

• Views - Provides a GUI for processing, sorting, and displaying data
  • Views Data Export - Provides a way to export large amounts of data from views [Requires Views module]
  • Views Bulk Operations - Augments Views by allowing bulk operations to be executed on the displayed rows [Requires Views module]
• Feeds - Import or aggregate data as nodes, users, taxonomy terms or simple database records
  • Feeds Extebsible Parser - A set of extensible parsers for Feeds [Requires Feeds module]
  • Feeds Tamper - Provides a small plugin architecture for Feeds to modify data before it gets saved [Requires Feeds module]
• Bundle Copy - This module has export/import support for: Node types, Taxonomy, User, Field API fields, and Field groups

Fields and Forms

• Link - Provides a standard custom content field for links
• Date - This package contains both a flexible date/time field type Date field and a Date API that other modules can use
• Location - Allows real-world geographic locations to be associated with Drupal nodes, including people, places, and other content
  • GMap - Provides an interface to the Google Maps API within Drupal [Requires the Location module]
  • Local Location and GMap Resources
• Entity Reference - Provides a field type that can reference arbitrary entities
• Block Reference - Defines a field type that creates a relationship to a block and allows the block to be displayed as the content of the field
• File (Field) Paths - Allows you to automatically sort and rename your uploaded files using token based replacement patterns to maintain a nice clean filesystem
• Transliteration - Provides one-way string transliteration (romanization) and cleans file names during upload by replacing unwanted characters
• Conditional Fields - User interface to the new States API, plus the ability to modify fields appearance and behavior on certain conditions when viewing content
• Field Permissions - Allows site administrators to set field-level permissions to edit, view and create fields on any entity
• Field Group - All fieldable entities will have the possibility to add groups to wrap their fields together. Fieldgroup comes with default HTML wrappers like vertical tabs, horizontal tabs, accordions, fieldsets or div wrappers
• Webform - Allows for the creation of user friendly forms and surveys in Drupal complete with email receipts and data export
  • Local Webform Resources

Drupal 8+ includes the popular What You See is What You Get (WYSIWYG) editor CKEditor, but out of the box it only provides the 'minimal' configuration, which is missing a lot of the features you may have come to enjoy when implementing CKEditor in Drupal 7 using the CKEditor module and the full version of CKEditor.

Fortunately, there are a few easy ways to make CKEditor much more useful.  To start, the Drupal core team has assembled a list of add-on modules that implement popular CKEditor plugins, which makes it very easy to add official CKEditor features to your site:

  CK Editor Modules and Plugins | Drupal.org

Important:  Most if not all of these modules do not include the actual plugin.  You will need to go to ckeditor.com and download the matching plugin, then create a 'libraries' directory at the root of your Drupal installation and unpack the plugin into that directory.  For example, for the 'font' plugin, you should end up with a 'libraries/font' directory, which would have a file named 'plugin.js' in it, along with any other supporting files for the plugin.

When downloading a plugin, you will need the version that works with CKEditor 4.17.1, as that is what comes with Drupal 9.3.  For future versions of Drupal, to determine what version of CKEditor you have, go to a page with the CKEditor editor visible, then open your browser's developer console and type:

alert(CKEDITOR.version);

In addition to the plugin based modules referenced above, the following special purpose Drupal 9 / CK Editor modules may also be of interest:

• Editor Advanced Link - Adds additional properties (title, class, id, target, rel) to the Link properties box
• Editor File - Adds the ability to upload files directly into CKEditor (just like you can now do with Images)

Here are a few more tips and tricks for enhancing CKEditor:

Where Did Image Properties Go?

One thing you won't find in any of the lists above is a means of bringing back the extensive set of image properties available in CKEditor under Drupal 7, and there's a reason for this.  The designers of Drupal 8+ want you to upload properly sized images and let Drupal handle their placement, so that they can be as responsive as possible.  This is actually a good thing in retrospect, as it's going to minimize the situations where a content editor uploads a giant 3000+ pixel image and then uses the size properties to make it fit on the screen.

That said, you're probably going to want a way to float images left and right.  That ability still exists and is enabled via Configuation -> Content authoring -> Text formats and editors.  Modify one of your text formats and look for the "Align images" checkbox under "Enabled Filters".  The explanation for the option isn't very informative, but enabling it will enable options on the CKEditor image placement pop-up to left or right align (float) the image.

You'll also want to enable "Caption images" directly below "Align images", as it provides a very useful feature for entering automatically positioned and formatted visible image captions.

Expanding CKEditor's Default Window Height

Editor's Note: All current versions of Drupal 8+ now support CKEditor's dynamic height feature, which automatically grows the height of the editor box based on the number of lines of text it contains.  So, the following is no longer needed, but has been left here in case someone should still want to force the default height to be larger.

One feature lost in Drupal 8 is the ability to set the number of rows on a textarea field and have CKEditor expand to fill that space.  However, you can still manually set the height of CKEditor, but you have to do it by creating a simple module.  We won't go into how to write a module here, as there are plenty of tutorials out there covering this basic topic.  Once you have the skeleton of a bare bones module in place, add this function to it, replacing 'xxxxxx' with the machine name of your module:

function xxxxxx_editor_js_settings_alter(array &$settings) {
  foreach (array_keys($settings['editor']['formats']) as $text_format_id) {
    if ($settings['editor']['formats'][$text_format_id]['editor'] === 'ckeditor') {
      $settings['editor']['formats'][$text_format_id]['editorSettings']['height'] = '600px';
    }
  }
}

This will set your CKEditor window height to 600px tall.  Just change 600 to another value if you prefer the window to he taller or shorter.

Adding a Font Size Drop-Down

While it is not recommendable to add a font selection drop down on Georgia Tech sites, many content editors want to be able to make lines of text bigger, and if you don't give them a way to do it correctly, they'll make those lines headings, which creates accessibility problems.

The easiest way to fix this is to add the CKEditor Font plugin using the CKEditor Font module. Once installed you can edit any of your text formats and add the 'S' button (for font 'S'ize) to the button bar.  However, if you want to be fully accessibility compliant, you should also change the available size list from point sizes to percentages.  That can be done by creating another bare bones module (see the Window Height section above) and putting the following code into it:

function xxxxxx_editor_js_settings_alter(array &$settings) {
  foreach (array_keys($settings['editor']['formats']) as $text_format_id) {
    if ($settings['editor']['formats'][$text_format_id]['editor'] === 'ckeditor') {
      $settings['editor']['formats'][$text_format_id]['editorSettings']['fontSize_sizes'] ='80%/80%;90%/90%;Normal/100%;110%/110%;120%/120%;130%/130%;140%/140%;150%/150%';
   }
  }
}

Note: if you want to change both the font size menu and the window height, you can (and should) combine the code into a single function in a single module.  Just add the innermost assignment line from one of the code snippets to the other snippet.

Getting CKEditor to Use Your Theme CSS

By default CKEditor uses a very basic set of CSS, so the text you create and edit won't look exactly like it will when displayed by your Drupal site's theme.  However, you can tell CKEditor to use your site's CSS so that the editing experience better reflects reality.

To do this, you will need to be using a custom sub-theme.  In your sub-theme's .info.yaml file, add the following lines:

ckeditor_stylesheets:
  - css/fonts.css
  - css/general.css

YAML is very picky about spacing, so take care to get it right:  it's two blank spaces (no tabs allowed), then a dash, then one more space.  Of course, replace fonts.css and general.css with whichever CSS files are needed to implement your theme's special text formatting.  You can have any number of CSS lines underneath the 'ckeditor_stylesheets:' heading.

If you add this to a theme that is already active, be sure to flush all of your caches to get the change to take effect.

The Drupal community on campus has found a number of modules which help with using CKEditor:

IMCE

Versions: Drupal 9, 7

​IMCE can be used for managing images, and you might even use imce for files, as well.

Installation instructions for IMCE:

1. Download, install, and configure IMCE.
2. Remove the default Image button.
3. Add the IMCE button.
4. Enable the option "Plugin for inserting files from imce without image dialog".
5. Enable the option "Plugin for inserting Drupal embeded media".

LinkIt

Versions: Drupal 9, 7

LinkIt can be used for managing URL links to pages on the site and outside of the site.

Installation instructions for LinkIt:

1. Download, install, and configure LinkIt
2. Remove the default URL button.
3. Add the LinkIt button.
4. Check "Support for Linkit module".

Image Resize Filter

Versions: Drupal 9, 7

From the Drupal.org site:  Image Resize Filter makes it easy to resize images, especially when combined with a WYSIWYG editor such as tinyMCE, CKeditor etc. Users never have to worry about scaling image sizes again, just insert an image and set it's height and width properties in HTML (this is done automatically by WYSIWYG editors) and the image is resized on output to match the HTML.

Embedding Georgia Tech MediaSpace Repository Content

A good solution for the Georgia Tech MediaSpace (Kaltura) repository has not been developed yet.  In the meantime, an experimental MediaSpace embed module is available for Drupal 7 and Drupal 8+ from the developer who created the embed module for the now retired OIT Digital Media Repository.  Use at your own risk!

• IAC Support for oEmbed Formats for Drupal 9 (oEmbed support for MediaSpace, YouTube, Vimeo, and Google Maps)

• GT Kaltura Module for Drupal 7

After installing either module, you will have to add the new input filter to your preferred text formats.  Make sure to set the ordering so that the filter comes last after all other filters.  This ensures that the filter's Javascript code does not get filtered out by any of your other text filters.

There is also a method now for enabling MediaSpace as an oEmbed provider in the Drupal Media library system.  The Media Library works outside of CKEditor and would be used in conjunction with custom blocks that contain Media fields (typically used with Layout Builder based page.)

Embedding YouTube and Vimeo Videos

Option #1 - Video Embed Field (Drupal 7 or 9)

1. Download, install, and enable the Video Embed Field module.
2. Add the new video field type to one or more of your Drupal Content Types.
3. Content editors can now add videos to nodes of those content types by inserting the right linking details into the video field.
4. WebWash provides a tutorial about video styles you can create with the Video Embed Field module.

Option #2 - Video Filter (Drupal 7)

1. Download, install, and enable the Video Filter module.
2. In the administrative configuration area of Drupal under Content authoring -> Text formats, configure each text format that you want to be able to use embedded videos.
   1. Enable the video filter.
   2. In the Filter processing order section, move the video filter down to the bottom of the list so that it is applied after all other filters.
   3. Don't forget to save your changes.
3. On pages that use one of these configured text formats, you can now insert a video shortcode to create an embed of a supported video type.  See the download page at the link above for the full list of supported video services and formats.
4. Example shortcode for embedding a video:

---

[ VIDEO::http://www.youtube.com/watch?v=98nNpzE6gIs::aVideoStyle ]

---

Option #3 - Ivan Allen College oEmbed Support Module (Drupal 9)

1. Install the IAC Support for oEmbed Formats for Drupal 9 module
2. Add the new "Embed remote content with oEmbed links" input filter to your preferred text formats
3. Where you want to place a YouTube video, just paste in the video's oEmbed URL (see the oEmbed module's instructions for full details)

Option #4 - Drupal Media Library and oEmbed

You can use the standard instructions for adding an oEmbed provider to Drupal's Media Library to enable the use of YouTube, Vimeo, and some other video services.  In most cases YouTube will be enabled out-of-the-box.  The Media Library works outside of CKEditor and would be used in conjunction with custom blocks that contain Media fields (typically used with Layout Builder based page.)

The Easy Way for IFRAME and JavaScript Embeds

The "Full HTML" format in an out-of-the-box installation of Drupal 9, or in Drupal 7 with CKEditor installed without the WYSIWYG plugin should already allow for IFRAME embeds and JavaScript embeds.  If you haven't added any tools to restrict this, then you're all set.

For more restrictive CKEditor configurations, such as the GT Editor version of CKEditor for Drupal 7, you'll need to add a new text format (Configuration -> Content authoring -> Text formats and editors) that at a minimum allows IFRAME embeds.  If the service you want to embed from also requires you to include a snippet of JavaScript, then you'll need to enable that for your new text format as well.  You'll then want to restrict this format to site administrators (which should hopefully be a separate role from that of your site's day-to-date content creators and editors).  You can then add blocks where needed and use this new text format so that you can add your embed code to the block.

The Preferred Way for PHP Code

By far, the recommended way of adding custom PHP Code to a page of a Drupal site is by creating a custom module, which is a type of plugin that adds extra functionality to your Drupal site.  This does require a reasonable amount of PHP coding experience and time to get familiar with how to code for Drupal.  The Drupal organization has made some tutorials available to help get you started:

• Drupal 9/8 custom module tutorial

• Drupal 7 custom module tutorial

For a lot of cases, the right approach is to create a module that implements its own dynamic block(s).  These will act like a custom block that you create in the Block Layout interface, only the content will be generated by your module instead of being entered through the Drupal user interface.  Thus, you could implement a block that has your external embed code or custom PHP code output as its content, then place that block on whichever page you want the output to show.

The Absolutely Wrong Way for PHP Code

Do not try to use the PHP Code Filter module under any circumstances! This module used to let you put PHP Code directly into CKEditor and have it get processed when the page is displayed. It is very unsafe and can't even be turned on in Drupal 7 unless you upgraded to Drupal 7 from an earlier version that had it turned on. In addition, the module has been completely removed from Drupal 8. If you are already using this method for custom PHP, you should look into switching to one of the following methods as soon as possible.

There are two parts to installing CKEditor for Drupal 7 (Drupal 8 comes with it already installed):

1. The CKEditor Drupal module, which is placed in the sites/all/modules folder.
2. The CKEditor library, which is placed INSIDE the sites/all/libraries folder.

After installing the module and library, enable the module and it should take effect immediately.

If you want to customize your CKEditor settings, look in the administrative configuration area under Content Authoring -> CKEditor.

---

Additional Resources for Using CKEditor in Drupal 7

The Georgia Tech GT Editor module for Drupal 7 is built around CKEditor, but provides a great deal more control over what content editors can create, preventing them from doing things that might be dangerous (embedding JavaScript, for example.)

This is a community supported project, meaning it is not officially supported by OIT or Institute Communications.

---

GT Editor Guides and Tutorials

        div.form-item-log,
	.preview h3,
	.preview .node-teaser,
	body.page-admin-structure-block-add .form-item-regions-seven,
	body.page-admin-structure-block-manage-block .form-item-regions-seven,
	fieldset#edit-body-und-0-format,
	fieldset#edit-field-body-1-und-0-format,
	fieldset#edit-field-body-2-und-0-format,
	fieldset#edit-field-body-3-und-0-format
	{
	   display: none;
	}

If not properly secured, forms can easily be used by hackers and automated "bot" programs to gain access to information within our sites, deface a site, or or even gain access to all the sites on a shared server.  The following is a non-exhaustive list of tips for making any web-based form more secure.

Form Safety Tips

• Never ask for sensitive information or information you don't need. Examples include birth date, credit card number, student data (including GTID), and other sensitive data.
• Protect your form with CAS login (for campus) or with CAPTCHA (for people without GT accounts).
• Remove old data and forms.
• Regularly archive and then delete old submissions and forms
  • Go in every month or semester and download the old submissions to a spreadsheet, and then delete those submissions from the website.
  • Close or remove web forms when they are no longer in use.
• Use SSL / HTTPS for your site.

A bug exists in Webform 3.x that can prevent you from changing the "From" address in an automated email template.  There is an existing Drupal.org discussion about this issue: https://www.drupal.org/node/1804214#comment-9661515

Drupal 7 Fix

1. Visit Configuration -> Content -> Webform (admin/config/content/webform).
2. Uncheck the Use Reply-To header option
3. Save your changes.

Twig stubs and code-samples to aid your Twig template development.

External Resources

• Twig data stubs (from the Ivan Allen College's web development resources website)

Per Georgia Tech's accessibility requirements, certain fields likely need additional explanatory text accompanying them:

Video Fields (e.g. YouTube)

Any publicly available video must be captioned for end-users. MediaSpace and YouTube automatic captions are not enough to meet full guidance: any automatic captions must be manually reviewed and corrected.

Please see the Video Captioning and Audio Transcripts page of the Resources for Webmasters website for more information.

Image Field

Any non-decorative image must have alternative text describing the visual component of the text.

Please see the Ivan Allen College's Web Accessibility Primer for additional information on alternative text for images.

You can find Georgia Tech's license for Font Awesome 5 on Github.

Recommended Usage

We strongly recommend utilizing the SVG icons for usage in your Drupal website, due to accessibility and compatibility concerns.

Here's how to whitelist HTML tags in your module output that are normally stripped out by the XSS filter:

    $tagList = array('input');
  
    return array(
      '#markup' => $buffer,
      '#allowed_tags' => array_merge(\Drupal\Component\Utility\Xss::getAdminTagList(), $tagList),
    );

And here's how to allow data URLs in your module output for displaying images with data that you've already pulled in from a data source (code updated 2017-12-11 to a better format that avoids whitescreening in certain use cases):

  $allowedProtocols = \Drupal\Component\Utility\URLHelper::getAllowedProtocols();
  $allowedProtocols[] = 'data';
  \Drupal\Component\Utility\URLHelper::setAllowedProtocols($allowedProtocols);

Useful modules

List of potentially useful Layout Builder Extensions within the Layout Builder Ecosystem:

• Layout Builder Restrictions - 8.x-2.4 as of 12/11/2019
  Lets you restrict which block types appear in Layout Builder's Add Block panel - very useful

• Layout Builder Modal - 8.x-1.0-alpha2 as of 7/31/2019
  This module lets you add and configure existing blocks in a modal in the Layout Builder UI.

• Layout Builder Styles - 8.x-1.0-beta1 as of 7/19/2019
  This module allow site builders to select from a list of styles to apply to layout builder blocks and layout builder sections.

• Layout Builder Kit - 8.x-1.0-beta1 as of 10/21/2019
  An assortment of pre-built block types for use with Layout Builder

• Layout builder library - 8.x-1.0-beta1 as of 6/17/2019
  Provides a layout library allowing content editors to pick from a list of pre-defined layouts.

Please see the Drupal 8 documentation for a complete list of contributed modules compatible with Layout Builder.

Local modules

Locally written modules:

• Layout Builder Operation Link
      Add a 'Layout' link to content entities in the Content listing view

Media Library in Drupal 9 offers a lot of great functionality for managing and reusing images (and other media types), but out-of-the-box it has a notable accessibility issue.

If you try to configure an image media type so that the user can select the thumbnail image and get the full-size version, the option for this (setting "Link image to" to "File") gives you only a link around the image, with no way to include the media item's built-in Name field.  Worse, the link will be presented to screen readers with the image's alternate text, which may not be appropriate for link text, and training content managers on how to handle this special usage of the alternate text field would be an uphill battle.

Correcting this problem requires both changing your media type configuration and adding a custom template:

Media Type Configuration

1. Edit your Media type and switch to the Manage display tab
2. Move the Thumbnail and Name fields up above the "Disabled" separator, but leave Image enabled as well.
3. Configure the Thumbnail settings as desired, then configure Image with the "URL to image" format pointing to the "original image".
4. Save your changes.

Custom Template Configuration

First, create a template file named "media--XXXXX--default.html.twig" where "XXXXX" is the machine name of your Media Type.  Place the following inside it:

{%
  set classes = [
    'media-library-item',
    'media-library-item--grid',
  ]
%}

<div{{ attributes.addClass(classes) }}>
  <a href="{{ content.field_media_image.0['#markup'] }}">
    {{ content.thumbnail }}
    <span class='visually-hidden'>Full Size Version of Image "</span> {{ content.name }} <span class='visually-hidden'>"</span>
  </a>
</div>

If you put your template into a sub-theme, then just flush your caches and it should take effect.  If you put your template into a module, then add the following to your .module file:

function YYYYY_theme($existing, $type, $theme, $path) {
  return [
    'media__XXXXX__default' => [
      'base hook' => 'media',
    ],
  ];
}

Replace "XXXXX" with the machine name of your media type, and replace "YYYYY" with the machine name of your module.  Flush your caches, and the template should take effect.

Scott Jacobson, Desmond Gardfrey, and Eric Sembrat were able to get Georgia Tech's MediaSpace working as an oembed provider for Drupal media.  Below is the method they developed.

1. Add the OEmbed Providers module

2. Add a custom provider (/admin/config/media/oembed-providers/custom-providers). The provider name must be entered as MediaSpace @ Georgia Tech with the '@' symbol in the middle.
   
   Provider Name: MediaSpace @ Georgia Tech
   Provider URL: https://mediaspace.gatech.edu
   Endpoint #1 - Endpoint schemes: https://mediaspace.gatech.edu/id/*
   Endpoint #1 - Endpoint URL: https://mediaspace.gatech.edu/oembed
   Endpoint #1 - Discovery: (Select this checkbox)
   Endpoint #1 - Available formats: JSON (Select this checkbox)

   

3. Add a provider bucket (/admin/config/media/oembed-providers/buckets)

   • Check the option Allowed Providers "MediaSpace @ Georgia Tech"

4. Add a media type of MediaSpace @ Georgia Tech (/admin/structure/media/add)

   • Select Media source MediaSpace @ Georgia Tech and select the Save button.  The field mapping is unnecessary unless you want to override something.

5. Add your oEmbed media link to a Media type (/media/add/)

6. To add Media within CKEditor:

   • Add the "insert from media library" button to one of the CKEditor toolbar text formats (/admin/config/content/formats)

     • Make sure that the embed code is wrapped in CSS like <div class="video-container"></div> when entered via CKEditor.

   • Add the following CSS via your custom theme or a custom module:

     .video-container { position: relative; overflow: hidden; width: 100%; }
     .video-container::after {​​​​​​​ display: block; content: ""; padding-top: 56.25%; }​​​​​​​
     .video-container iframe {​​​​​​​ position: absolute; top: 0; left: 0; width: 100%; height: 100%; }​​​​​​​

7. You could also make a custom block type with a TWIG file, wrapping the embed in <div class="video-container"></div> and adding the above CSS to your custom theme or a custom module.

8. To Be Determined:  How to add the MediaSpace @ Georgia Tech provider to the custom block types Call to Action and Video Embed.  (Editor's note: This should be doable by modifying the existing media types used by those blocks and adding the provider as an Allowed Provider.)

 

Editor's Note: Node Convert has not been ported to Drupal 8, but a replacement module called Convert Bundles is under development.  At the time of writing, Convert Bundles was still in alpha testing, so it isn't ready for prime time yet, but is worth watching for future developments.

The Node Convert module can be used to switch between different page layouts without losing existing content.  One example is changing a Basic page so that it uses a Horizontal Landing Page layout.

Overview of Process

1. After backing everything up, install the Node Convert module in the usual way.
2. Go to People -> Permissions and set permissions for your different user roles.
3. Optionally, if you have a LOT of content to convert, or are just feeling super fancy, you can also create "node convert templates".

Set Permissions for Users, Based on Their Role

In your site's Administration interface, go to the page where you manage which features people can use on your site. In Drupal 7, this can be found at People -> Permissions (admin/people/permissions). The main roles usually needing permissions for converting layouts are Editor and Super Administrator.

Editor Permissions

Give the "Editor" role permission to convert To AND From each of the four (4) main page layouts, by checking the boxes next to these specific permissions:

• convert from page
• convert to page
• convert from horizontal_landing_page
• convert to horizontal_landing_page
• convert from multipurpose_page
• convert to multipurpose_page
• convert from vertical_landing_page 
• convert to vertical_landing_page

Super Administrator Permissions

Give the "Super Administrator" role all of the same permissions as an Editor, but then also check the "administer conversion" box.

(Optional) Make Templates for converting content in large batches

If you need to convert a LARGE amount of content, you can make this easier by creating "Node Convert templates" (under "admin/structure/node_convert_templates" in Drupal 7).

Read documentation and examples of how to create and use these templates at:

• Node Convert's official Drupal.org Documentation
• How to Video by the University of Virginia (possibly in Drupal 6)

Here's a quick reference guide to working with the new configuration management system. You'll need this if you want to build a module that adds its own configuration to Drupal during its installation process:

Simple Configuration API | Drupal.org

Editor's Note: Information on Obtaining and SSL Certificate and Setting Up SSL on OIT Web Hosting with an External Domain Name has been moved to the Georgia Tech Resources for Webmasters website.

Additional details about enabling SSL for Drupal can be found in Jimmy Kriigel's posting in GitHub about SSL and Drupal sites.

Part I: SSL Certificate

See if you need an SSL Certificate, and if so, obtain your SSL Certificate. In short, if your site is a top-level site on OIT Web Hosting, you can use the existing SSL certificate available on your hosting server - no special configuration on the Plesk control panel side is needed - just follow the steps in Part II below.  If your site's hostname is a subdomain of a department domain (e.g. something.yourdepartment.gatech.edu), then you will have to see if the Plesk certificate includes your "yourdepartment.gateh.edu" domain name - if so, then you should be good to go - if not, then you'll need to obtain a certificate (see "obtain your SSL Certificate" above).

Part II: Configure Your Drupal Instance

Edit Your Site's .htaccess File

Add the following directly after "RewriteEngine On" in your site's .htaccess file:

RewriteCond %{HTTP_HOST} ^www\.(.+)$ [NC]
RewriteRule ^ https://%1%{REQUEST_URI} [L,R=301]
RewriteCond %{HTTPS} !=on
RewriteRule ^/?(.*) https://%{SERVER_NAME}/$1 [R,L]

What this will do is catch any requests that have "www." before your site's hostname and redirect the user to the non-"www." version of the URL.  Then, if the user is not using HTTPS, it will redirect the user to the HTTPS version of the URL to ensure that HTTPS / SSL security is always used.

Edit Your Site's settings.php File (Drupal 7 only)

Find the line for "$base_url" (or add one if this setting is not defined), and set it to the the fully qualified domain name of your site, like so:

$base_url = "https://foobar.gatech.edu/";

Important Note:  The settings.php file is usually protected from editing, so you may have to modify its access permissions before you can modify it.  Try editing it from the File Manager in your hosting account's Plesk Control Panel, as this may make it easier to override those protections.

You can restrict your site so that only people who are on-campus (or using the VPN) can access it. This is a great idea for internal-use-only sites and also for all of your development/test websites if you are not using a local stack.

Using .htaccess Configuration

Here's the code to put into the .htaccess file in the root directory of your site (on OIT Web Hosting, this goes under httpdocs or httpsdocs usually):

RewriteEngine On
RewriteCond %{REMOTE_ADDR} !^130.207.
RewriteCond %{REMOTE_ADDR} !^128.61.
RewriteCond %{REMOTE_ADDR} !^143.215.
RewriteCond %{REMOTE_ADDR} !^192.93.8.
RewriteCond %{REMOTE_ADDR} !^10.
RewriteCond expr "! -R '172.16.0.0/12'"
RewriteCond expr "! -R '100.64.0.0/10'"
RewriteCond %{REQUEST_URI} !/vpn-message.html
RewriteRule ^.* /vpn-message.html [R=303,L]

The first three lines cover the main Atlanta campus, while the fourth line (192.93.8.) covers GT Lorraine in France, and the last 3 private campus IP space.  The last RewriteCond line is needed to whitelist your message to off-campus users - otherwise they'll end up in an infinite redirect loop.  Also note the 303 redirect status on the last line: this tells the browser to check back with the server and not cache the redirect.  If you use 301 instead, then a user who connects from off-campus and gets your message file will continue to get it even if they then connect to the VPN.  Using 303 ensures that they'll actually get to your site once they've logged into the VPN.

The method above will direct all outside users to /message.html on your site, where you can post a message about the site being for on-campus use only. An alternate method (shown below) will just give users a 403 Forbidden error, which might be good enough in many cases.

Alternate Method with Basic Apache HTTPD Configuration

The following may be a little easier to maintain than the as the campus network expands and evolves than the version above, but this version will simply give the off-campus user a standard 403 Access Denied error message without any further explanation.

For Apache 2.4 .htaccess

Require all denied
## All Atlanta Campus & VPNs
Require ip 130.207.0.0/16
Require ip 128.61.0.0/16
Require ip 143.215.0.0/16
Require ip 10.0.0.0/8
Require ip 172.16.0.0/12
Require ip 100.64.0.0/10
## GT Lorraine
Require ip 192.93.8.0/24

Using a Firewall

If your website is not on OIT Web Hosting, then you can also limit access through firewalls:

Software Firewall

This kind of firewall you have to set up and maintain yourself, so you need to have some basic networking knowledge to get it configured correctly.  On the other hand, you can reconfigure it yourself whenever necessary.  On UNIX style systems (Linux, Mac OS X, etc.), you can use either  ipfilters or ipfw.  On Windows servers, Microsoft provides its own firewalling tools - check your Windows server documentation for more information.

Hardware Firewall

This kind of configuration has to be done via the GT Networking Firewall web application by someone authorized to make changes to the subnet that your server lives on.  The upside to this option is that you don't have to know anything about networking, and you don't have to worry about your firewall breaking when you run upgrades on your server's operating system.  The downside is that if you don't have access to mange the firewall for your subnet then you'll have to send your requests for changes up to whomever manages your subnet.

Central Authentication Service (CAS) based single sign-on is the main method of doing authentication via GT Account Usernames for Drupal website logins.  Once users have logged into the GT CAS system, the can access any Georgia Tech website that utilizes CAS without having to enter their GT Account Username again, as long as they don't completely close their browser or clear their browser's cookie cache.

---

CAS Guides and Resources

Lightweight Directory Access Protocol (LDAP) is an open protocol for sharing directory information and can be used as an alternative to CAS to allow users to log in to a web application using their GT Account Username and password.  Unless your application doesn't support CAS, it's best to use it instead of LDAP, since LDAP requires obtaining a special GTED LDAP user account for your application.

If you just want basic directory information for users without the ability to do user authentication, there is a public GT LDAP server called 'Whitepages' that can be queried from any server or workstation on-campus.

---

LDAP Guides and Resources

All Georgia Tech users who have been enabled for two factor authentication (2FA) are required to log into CAS with their two-factor token via the Duo 2FA service.  As of summer 2017, this includes virtually all campus employees, and will soon include all students.

So, long story short, there is no reason to add your own two-factor authentication to your Drupal websites - you would, in effect, just be creating three-factor authentication, which would likely create more headaches than benefits.

More information on the campus program can be found on the OIT Two-Factor Authentication website.

The GT Account Username is the standard computer account for everyone at Georgia Tech.  It is used to access a variety of systems including TechWorks, BuzzPort, and Mercury, and can be used to access your Drupal site by installing the CAS module.   

You may often find that need to add someone to a group in Mercury or to your Drupal site, and you need to know the person's GT Account Username.  Here are several ways that you can look up that information:

Using Office 365

[Instructions courtesy of Noel Moreno]

• Go to the "People" area (click on the "waffle" in the upper left, then select "People").  
• In the left column, check the radio button for "Directory".  
• Enter the person's name, email address, partial name, etc. in the search box.  
• Results are returned on the right.  Select the person of interest.  
• In the data returned, the GT Account Username will in the person's "IM" value.  It will be "sip:[gt account]@gatech.edu".

Using Command Line tools

Note: Any command line tools to query data via the Georgia Tech "White Pages" (which both the Georgia Tech Directory Tools and the 'ldapsearch' examples use) will only work from on-campus or over the campus VPN.

• Georgia Tech Directory Tools [Tip from Shawn Carnley]
• UNIX 'ldapsearch' Command Line Query [Code Included]

If you have enabled CAS authentication to help keep your site secure, but have a limited number of non-GT users who need access to certain protected features of your Drupal site, you can create guest GT Account Usernames for them.

Creating a New Guest User Account

1. Log into PASSPORT (https://passport.gatech.edu)
2. Under Sponsored Guests, choose Manage guests.
3. Select the Create a new guest button and follow the instructions to create your guest user.
   • Only grant LAWN wireless or T-Square access if necessary.
   • Only grant permissions for the length of time the guest will need access (1-365 days).
4. Write down the Guest's new GT Account Username and Password, so you can communicate it to them over the phone or in person (since it's not very safe to send passwords electronically).

If you are unable to log in with CAS after migrating a site, make sure you copied the .htaccess file in the root of your site (httpdocs on OIT Web Hosting). 

Please note that this file may be hidden to some file browsers. If so, configure your file browser to show hidden files.

Technical Details

CAS requires that Clean URLs be enabled. When Clean URLs is enabled, Drupal edits the .htaccess file to properly handle normal-looking URLs. 

When a Drupal website is migrated without the .htaccess file, Drupal reverts to the ugly URL schema (i.e. http://drupal.gatech.edu?q=user/login). This has the side-effect of also disallowing CAS from working properly.

To use the CAS PEM certificate installed on websites hosted on OIT webhosting, please use the following path:

 /etc/pki/tls/certs/ca-bundle.crt

Applying fix to resolve CAS redirect loop

1. Login to Plesk via https://hosting.gatech.edu
2. Click “Databases” in the side menu
3. Click “phpMyAdmin” to edit your database
4. Go to the “variable” table
5. Look for a variable named “cas_cert”
6. Click the “BLOB” link next to the variable name in the value column to download the “variable-value.bin” file
7. When you open the file in Notepad++ (or your text editor of choice), you’ll see a line similar to this:                                               s:33:" /etc/pki/tls/certs/ca-bundle.crt";
8. Delete the PEM path (DO NOT DELETE THE QUOTES!) and save the file
9. Click the “Edit” link next to the “cas_cert” variable
10. In the “value” row item, click the “Browse” button to upload the edited file
11. You can now login to your website (if you still see the CAS authentication error message, click the “reload” button on your browser)

A number of performance settings are recommended to cache Drupal data objects and speed up your site.

Enable Caching and Aggragation Settings

These settings can be enabled in Drupal 7 via the administrative control panel under Configuration -> Development -> Performance

• Cache pages for anonymous users
• Cache blocks
• Compress cached pages
• Aggregate and compress CSS files
• Aggregate JavaScript files
• Set Minimum cache lifetime = 15 minutes

Disable and Remove Unnecessary Modules

---

Additional Optimization Techniques

There are also quite a few modules that attempt to cache resource-heavy actions on Drupal.

Getting Started with Performance Module

For most websites, core Drupal caching should be sufficient to keep CPU/memory usage down and keep your website running smoothly. However, for larger and more complex websites, additional caching and optimization will be needed.

For your specific website (and its use cases, structure, and workflows), please browse through the modules below and see which module(s) may work for your website. 

For questions, please contact the Georgia Tech Drupal mailing list and someone will be glad to help!

Advanced CSS/JS Aggregation

Availability: Drupal 7, Drupal 9

From the module's Drupal.org page:  AdvAgg allows you to improve the frontend performance of your site. The performance benefits are achieved by using some of the features found in AdvAgg and its sub modules. Out of the box AdvAgg's frontend performance will be similar to cores.

Boost

Availability: Drupal 7

Boost provides static page caching for Drupal enabling a very significant performance and scalability boost for sites that receive mostly anonymous traffic.  For shared hosting this is your best option in terms of improving performance.

• Boost is not recommended for large websites (nodes >= 1000), as the caching process will take up the websites' allotment of CPU cycles. This will slow down the website to be unusable for end-users.
• Boost can be used alongside Memcache API and Integration
• No configuration for Boost is necessary beyond installing and enabling the module. 
• Core caching in Drupal must be disabled for Boost to work properly

CDN

Availability: Drupal 7, Drupal 9

CDN provides easy Content Delivery Network integration for Drupal sites. It alters file URLs, so that files are downloaded from a CDN instead of your web server.

Before you begin, you will need to select a CDN provider. CDN have different costs and features depending on your needs. 

• These CDNs are currently used on campus:
  • Keycdn.com - Used by the Office of International Education (Jimmy Kriigel)
    • http://oie.gatech.edu
    • http://pacific.gatech.edu
    • http://oxford.gatech.edu
• This module is best used for websites with lots of traffic and lots of images and/or locally hosted videos.
• KeyCDN has made a CDN Drupal Integration Tutorial available.
• The CDN module has TEST Mode.  If you don't want to use the CDN to serve files to your visitors yet, but you do want to see if it's working well for your site, then enable testing mode.  Users will only get the files from the CDN if they have the permission to "Access files on CDN when in testing mode".
• The "Far Future expiration" option doesn't work with the IMCE module.
  • Update: IMCE has a patch in their dev branch for this issue.
• You can manually flush a CDN cache file by having the Display statistics Shows enabled and scrolling down to the bottom of the page and selecting "Touch" to purge the file.

Entity Cache

Availability: Drupal 7

From the module's Drupal.org page:  Entity cache puts core entities into Drupal's cache API.  Due to the entity loading changes in Drupal 7, no core patches are required.

Don't bother using this module if you're not also going to use Memcache API and Integration or Redis – the purpose of Entity Cache is to allow queries to be offloaded from the database onto alternative storage, and there are minimal, if any, gains from using it with the default database cache.

Memcache API and Integration

Availability: Drupal 7

This module provides integration between Drupal and Memcached with the following features:

• An API for using Memcached and the PECL Memcache or Memcached libraries with Drupal.
• Memcache backends for the following systems (all drop-in):
  • Caching (memcache.inc)
  • Locking (memcache-lock.inc)
  • Sessions (memcache-session.inc) (D6 only)
• A module that provides a comprehensive administrative overview of Drupal's interaction with Memcached and stats.
• A set of tests that can be run to test your memcache setup.

Memcache is ideal when there are lots of database reads and writes, as it is a cache for the data layer (this is also why it can so easily whitescreen your site when things go wrong). This article does a decent job of explaining the "whens" and "whys" of APC, Varnish and Memcached.

Recommended Settings

After enabling the memcache module, add this text to the bottom of your settings.php:

$conf['cache_backends'][] = 'sites/all/modules/memcache/memcache.inc';
$conf['lock_inc'] = 'sites/all/modules/memcache/memcache-lock.inc';
$conf['memcache_stampede_protection'] = TRUE;
$conf['cache_default_class'] = 'MemCacheDrupal';
$conf['cache_class_cache_form'] = 'DrupalDatabaseCache';
$conf['page_cache_without_database'] = TRUE;
$conf['page_cache_invoke_hooks'] = FALSE;
$conf['memcache_servers'] = array('localhost:11211' => 'default');

You will need to adjust the module directories if your module is installed in a different directory.

Troubleshooting

In some cases, Drupal will white-screen after settings.php is edited to reflect the new memcache settings. If this occurs, please check your error log on Web Hosting.  If you see a 'Fatal Error', follow the directions below (taken from this Drupal.org thread):

1. Backup your website.
2. Download registry_rebuild and upload to sites/all/modules.
3. Run registry_rebuild by navigating your browser to: [yourdomain]/sites/all/modules/registry_rebuild/registry_rebuild.php
4. If no errors show up, your registry has been rebuilt.
5. Delete the module from the sites/all/modules directory.

Varnish HTTP Accelerator

Availability: Drupal 7

Varnish HTTP Accelerator provides integration between your Drupal site and the Varnish Cache, an advanced and very fast reverse-proxy system.  Basically, Varnish handles serving static files and anonymous page-views for your site much faster and at higher volumes than Apache, in the neighborhood of 3000 requests per second.

Besides performance modules, there are several other methods for increasing the performance of your Drupal site.

Disable Modules Only Needed During Development

Only enable these modules while actively developing, and then turn them off the rest of the time.

• Field UI (in core)
• Rules UI/Admin
• Views UI
• Module Filter
• Advanced Help
• Fast Permissions Administration
• Devel

Track Your Site's Performance Baselines

• Drupal's Devel module
  • Execution time and memory usage
  • Query logging
• Web optimization
  • SpriteMe
• Web testing
  • webpagetest.org
  • Google's PageSpeed Online
• Browser-based
  • Firebug or Web Inspector
  • YSlow!
• Saas products
  • New Relic
  • Yottaa

Locate and Fix PHP Errors/Warnings

• Turn on verbose error reporting to find errors and warnings (check Apache error logs as well)
• Perform performance testing of any custom coding.

Optimize Javascript and Other Front-End Features

• Example modules using JavaScript:  Views Slideshow and Conditional Fields.

Unless you manually configure Drupal cron to be run by your web hosting server, it will be automatically run when someone visits a page on your Drupal site after a certain amount of time has passed.  This method works perfectly fine, but can slow down the display of the page the user requested since the cron run will block page generation until it has finished.  This becomes more noticeable on site visited less frequently as more tasks can accumulate that need to be executed during a cron run.

To keep this from happening, you can schedule Drupal cron to run automatically in the background.  On a web server that you fully control, you can use UNIX style cron to run the Drupal cron job.  You can also do this on OIT Web Hosting, but you have to configure the job via the Plesk Control Panel.

Step by Step Instructions

1. Log into your hosting account's Plesk control panel.
2. On the main control panel page, navigate to Schedule Tasks, found in the right-hand sidebar menu.
3. On the Scheduled Tasks page, select the Add button
4. Fill out the form as follows (the example here will set up Drupal cron to run every eight hours):
   • Minute: 0
   • Hour: 0,8,16
   • Day of the Month / Month / Day of the Week: * (insert an asterisk)
   • In the text field, Command, enter the following:

     curl --silent --compressed http://YOURDRUPALSITE.gatech.edu/cron.php?KEY-FROM-ADMIN-REPORTS-STATUS-PAGE

     You can find the link to put at the end of this command (KEY-FROM-ADMIN-REPORTS-STATUS-PAGE) on your Drupal site's status report page at Reports -> Status report (admin/reports/status)

Video Tutorial

Logging details about your site's usage can be very valuable, but if not configured properly, can also be a huge resource drain.  The following articles provide useful best practices for managing your Drupal site's logging functions.

---

Logs and Logging Guides and Resources

[Mon Jun 15 03:01:53 2014] [warn] RSA server certificate CommonName (CN) `hosting.gatech.edu' does NOT match server name!? 
[Mon Jun 15 08:52:25 2014] [error] [client 130.207.000.00] File does not exist: /var/www/vhosts/mysite.gatech.edu/httpdocs/favicon.ico, referer: http://mysite.gatech.edu/node/77 
[Mon Jun 15 09:03:20 2014] [warn] [client 130.207.000.00] mod_fcgid: stderr: PHP Warning:  chdir(): open_basedir restriction in effect. File() is not within the allowed path(s): (/var/www/vhosts/mysite.gatech.edu/:/tmp/:/usr/share/pear:/var/cache/hg:/opt/atomic/atomic-php55/root/usr/share/pear) in /var/www/vhosts/mysite.gatech.edu/httpdocs/custom-file.php on line 88

Georgia Tech staff, students, and faculty can now use a Georgia Tech instance of GitHub, a version/revision control system.  This service is available thanks to the College of Engineering's brilliant proof of concept with GitHub Enterprise, and the ensuing excited buy-in from the Office of Information Technology.

What is GitHub and Why Should I Use Revision Control?

GitHub is a proprietary hosted extension of the open-source Git version/revision control system commonly used for open-source software projects.  It is very useful for multi-developer projects, as it allows coordinating and tracking code changes and the orderly acceptance and integration of those changes into the master project.  Version control also makes it much easier to revert back to an earlier version of the software if it is discovered that accepted changes have caused unexpected problems.

Or, to put it short, it'll save your bacon.  Figuratively, not literally.

Support Policy

OIT does not offer technical support or training for Git or GitHub usage.  If you want to learn how to use git, see below for many educational resources.

Accessing Georgia Tech GitHub Enterprise

Just go to https://github.gatech.edu and log in with your GT Account Username and password.

GitHub User Software

You can access repositories in GitHub using git from the command line of most Unix based operating systems (see GitHub's KB), but you can also use a variety of GUI (graphical user interface) applications, such as:

• For beginners, GitHub's Desktop (for Mac OS X or Windows).
• For something that works on both Windows and Mac, try SourceTree.
• There are also lots more graphical clients to use with git.

Drupal List

We have a Drupal community group in GitHub that allows users to share and collaborate on projects. Please add collaborative projects to the GT Drupal group on GitHub at Georgia Tech.

Learn to Use git with GitHub Resources

You can learn how to use git (and GitHub) with these tools from GitHub Enterprise, such as:

• Guides: Tutorials, tips, and workflows to help you and your team learn about GitHub.
• Reference Sheets: Quick reference guides and manuals for GitHub 

Learn to Use git with General Internet Resources

The internet has lots of other great places to teach you about git. Here are a few:

• Lynda.com - GitHub for Web Designers
• Lynda.com - Fundamentals of Software Revision Control 
• Learn Git Branching - A good interactive visual guide to Git's concept of version control.

---

Local GitHub Guides and Resources

git clone https://github.gatech.edu/ORG_NAME/Repo-Name

[submodule "gt_tools"]
path = web/modules/contrib/gt_tools
url = https://github.gatech.edu/ICWebTeam/gt_tools-8.x.git
update = checkout
branch = master
ignore = dirty
shallow = TRUE

[submodule "gt_theme"]
path = web/themes/contrib/gt_theme
url = https://github.gatech.edu/ICWebTeam/gt_theme-8.x.git
update = checkout
branch = master
ignore = dirty
shallow = TRUE

[submodule "hg_reader"]
path = web/modules/contrib/hg_reader
url = https://github.gatech.edu/ICWebTeam/hg_reader-8.x.git
update = checkout
branch = master
ignore = dirty
shallow = TRUE

[submodule "gt_profile_curie"]
path = web/profiles/contrib/gt_profile_curie
url = https://github.gatech.edu/ICWebTeam/gt_profile_curie.git
update = checkout
branch = master
ignore = dirty
shallow = TRUE

Drush (Drupal Shell) is a great Drupal "module" to accomplish many administrative tasks via the command-line. It is not a module in the normal sense, because it's not enabled/disabled from the Drupal admin. Instead, it actually lives anywhere on your local system and is run like any other local executable. Here are some of its key features from the Drush Drupal.org page:

---

A few core drush features:

• The Drush Package Manager allows you to download, enable, disable, uninstall, update modules/themes/profiles/translations from the command line in a very simple way (apt-get style) - just type e.g. drush dl views and drush enable views in a Drupal directory to install the Views project!
• Additionally, the Drush Package Manager also allows you to update all your modules with just one command - drush update.
• Drush Core: several useful utilities for site administrators and developers (e.g. drush cron or drush cache clear)
• Drupal SQL Commands help you issue queries to any of your databases (i.e. is multi-site aware) and even helps you migrate databases between your environments.
• Drush simpletest commands make it easy to run unit tests from the command line and email results to your dev team.
• Drush now supports aliases which let's you perform actions on separate Drupal installations.  This is very useful for multi-site configurations.

---

Drush Guides and Resources

Creating a new MySQL database for a site hosted on OIT Web Hosting can be a little confusing.  Below are the steps for getting a database set up and configured properly via the Web Hosting Plesk control panel, as well as generic steps for creating a new database on any MySQL instance that has phpMyAdmin installed.

MySQL Database Creation on OIT Web Hosting

1. Visit OIT Web Hosting [https://hosting.gatech.edu/] and select the website you want to work with from the list of sites that you manage.
2. Select the Databases management link.
3. On the Databases management page, select the Add New Database link.
4. Fill in the fields on the Add New Database form, and be sure to copy down everything for future reference.  Use the password generate to generate a secure password (select the 'Show' button to see the generated value so that you can copy it down.)
5. Select the OK button to create your new database.
6. Back on the Databases management page, you should see a listing in the table for your new database.  The Webadmin link on that row will let you access your database via phpMyAdmin.

Video Tutorial (1:13)

MySQL Database Creation on a Standard Apache HTTPD Server Via phpMyAdmin

1. Log into phpMyAdmin on your server with the master (root) user account for your mySQL instance.
2. Select the Databases tab.
3. In the box under Create database, enter the name for your new database and select the Create button.
4. Select the Users tab and create a new user with a unique name and password.  Be sure to write down the name of the database you create, as well as the username and password you make for it. (As always, try to choose a fairly-secure database username and password and do NOT use your GTaccount - jdoe3).
5. Once the account is created, grant it access to the database that you created.  You'll probably want to give the account all privileges for the database except "grant", as you usually don't want the account to be able to give out access to other accounts.

Video Tutorial (0:39)

You can view any MySQL database on an OIT Web Hosting website using many different GUI based applications. Below are a few implementations that have been used by members of our community:

General Instructions

OIT has an FAQ entry explaining how to connect to your hosting database, which also discusses using phpMyAdmin to view your database(s) from your hosting control panel (which doesn't require any additional software).

Rochester University has a nice tutorial on using phpMyAdmin with MySQL.

Elsewhere in this handbook is a  more in-depth post on SSH tunneling.

The general information you'll need, if you choose to connect with a more graphical software application, is:

• the domain name of the site your database uses (example: mydepartment.gatech.edu)
• the SSH or FTP Login account name and password for this site
• the host your database lives on: for OIT Web Hosting, use "mysql.localhost" instead of plain "localhost".
• the database account's username and password (this will be different from the SSH/FTP login account and password)
• the port for your database: 3306

MySQL Workbench

Andrew Dugenskei (a member of the GT Drupal community) has a preference for MySQL Workbench.

Fortunately, MySQL Workbench (available for Mac OSX and Windows) makes it very easy to communicate with OIT web hosted databases and it is free. If you're on campus, no other software is needed. If you're off campus, you just need to first make sure you are connected to the VPN.

Below is a screen capture from the Workbench connection manager with some pseudo values. Once the correct values are entered, connecting to an OIT databases is a just a click away.

From the above screen capture and based on the Workbench Installation Guide, you can use these settings.

Under the Connection Tab, Choose "Standard TCP/IP over SSH" and then enter these parameters for your site:

• SSH Hostname: mydepartment.gatech.edu (port name ":22" at end is optional)
• SSH Username: myFTPaccount (for your SSH or "Local FTP" account on Web Hosting)
• SSH Password: myFTPpassword (for your SSH or "Local FTP" account on Web Hosting)
• MySQL Hostname: mysql.localhost (for web hosting, just use this instead of worrying about which server you're on)
• MySQL Server Port (leave same): 3306
• Username: database_user (for this database only)
• Password: database_password (for this database only)
• Default Schema: leave blank

Navicat (Mac, Windows, Linux)

Mike Alberghini (a member of the GT Drupal community) has a preference for Navicat because the software:

• Has a good GUI
• Handles multiple databases well,
• Has Mac OS X support
• Is 40% off for educational users
• Saves connection info for ssh tunnels and start them as needed to connect to servers

Screenshots of a successful Web hosting database connection with Navicat are below. 

For Navicat, use the following settings on the "General" tab:

• Connection Name = My Department Site
• Hostname/IP Address = mysql.localhost (this is important for you to connect to Web Hosting)
• Port (leave same) = 3306
• User name = This is the username for your DATABASE's user.
• Password = This is the password for your DATABASE's user.

To finish your connection with Navicat, use the following settings on the "SSH" tab:

• Use SSH tunnel = check YES
• Hostname/IP Address = mydepartment.gatech.edu
• Port (leave same) = 22
• Username = This is the username of the web hosting FTP account for this site.
• password = This is the password for the web hosting FTP account for this site.

Sequel Pro (Mac)

Adam Arrowood (a member of the GT Drupal community) has a preference for Sequel Pro because the product:

• Has a nice GUI, ssh tunneling, etc. as found in other similar products.
• Runs (only) on Mac OS X.
• Is a free product.

Drupal 7 began forcing mySQL to act like a traditional SQL server so that all SQL code used in Drupal will be highly compatible with other database systems like PostgreSQL or SQLite. This means that mySQL statements that syntactically work in other contexts may produce errors under Drupal 7 or 9. Drupal 8+ adds the 'ONLY_FULL_GROUP_BY' restriction, which can potentially cause custom mySQL code that worked in Drupal 7 to fail with errors in Drupal 8+.

Here's the exact settings being used in Drupal 8:

• SET sql_mode = 'ANSI, STRICT_TRANS_TABLES, STRICT_ALL_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, ONLY_FULL_GROUP_BY'

The mySQL Reference Guide has full details on these SQL modes and their effects. (See especially the section on STRICT mode and ONLY_FULL_GROUP_BY mode.)

To allow more than one jump link on each Superblock, a quick hack is needed.

Please note:  This is not guaranteed to work with future versions of Super Block, so proceed at your own risk.

Prerequisites

Log in to GT Github and download the templates/node--super-block.tpl.php file from the gt_ae project.

Adding Multiple Jump Links

1. On your website, edit the content type Super Block.
2. Select Manage Fields.
3. Select Edit, to the right of Jump Link (field_nbsb_jump_link).
4. Under Number of Values, increase the value from 1 to your desired number (supports up to unlimited).
5. Add the templates/node--super-block.tpl.php file to your subtheme's templates/ folder.
6. Clear caches.
7. Test to see if it works.

A shell script that prints out a list of enabled modules in all accessible databases, designed for ssh use when you need to check multiple Drupal 6 or 7 databases at one time.

Editor's Note:  A similar concept would work just as well for Drupal 8, but the database table names and structures have changed in Drupal 8, so you would need to adjust the script accordingly.  Also, be aware that this script will not work on any Drupal instance where you have used a custom table prefix for all of your Drupal site tables.

With thanks to Abdul Manaf on DBA.stackexchange for the basic code.

---

# mysql credential
user="root"
pass="pwd"

all_dbs="$(mysql -u $user -p$pass -Bse 'show databases')"        

# Exclude databases you don't want to check, such as non-Drupal 6 or 7 dbs.
# Then output database name and an alphabetized list of Enabled modules.
for db in $all_dbs
     do
        if [[ "$db" != "information_schema" &&
            "$db" != "mysql" &&
            "$db" != "performance_schema" &&
            "$db" != "test" ]] ; then
            echo '====================='
            echo "DATABASE: $db (ENABLED Modules)"
            echo "---------------------------"
            mysql -u$user -p$pass $db -sN -e "SELECT name FROM system WHERE status = 1 AND type = 'module' ORDER BY name ASC;" 
        fi 
     done

---

Below is SQL code that prints out SQL statements that you can copy and paste back into phpMyAdmin (or any MySQL management tool that can connect to your Drupal database).  These statements will help you get a list of enabled modules, when you need to check multiple Drupal 6 or 7 databases at one time.

With thanks to Aaron Brown on DBA.stackexchange for the basic code.

Be careful to copy the backquotes/backticks (that look a little like left-leaning apostrophes) exactly.

---

SELECT CONCAT('SELECT \`name\` FROM ', schema_name, '.\`system\` WHERE \`status\` =\'1\' AND \`type\` =\'module\' ORDER BY \`name\` ASC;')
FROM information_schema.schemata
WHERE schema_name NOT IN ('information_schema','mysql','performance_schema','test', 'excluded_database');

---

This will print out a series of SQL statements, like the one below, which you could paste into the SQL tab of phpmyAdmin, in order to create lists of enabled modules.  This can be helpful if you don't have ssh access to your site, but still want an easy way to get a simple text list of enabled modules.

SELECT `name` FROM ms6_sample1.`system` WHERE `status` ='1' AND `type` ='module' ORDER BY `name` ASC; SELECT `name` FROM ms7_sample2.`system` WHERE `status` ='1' AND `type` ='module' ORDER BY `name` ASC;

The following table, initially provided by the College of Computing (many thanks!) attempts to summarize the details of a large number of commonly used Drupal 7 modules and any known issues with their latest full (not development) version under PHP 7. In addition, Kevin Pittman of the College of Liberal Arts has added Drupal 9 compatibility details and removal recommendations, to help site administrators decide what to do as they review the modules installed their Drupal 7 sites.

In general, a module is recommended for removal ASAP if it is no longer being maintained and not covered by Drupal's security advisory policy. While not flagged with a removal recommendation, modules without a Drupal 9 version should be scrutinized to see if they are truly needed on a current Drupal 7 site, since there is likely not going to be a future support path for those modules.

Notes on the Drupal 9 column:

• In Core - The module is now part of the official Drupal 9 system and does not have to be downloaded and installed separately under Drupal 9
• Functionality In Core - The functionality provided by the module can be found in some form or fashion within Drupal 9
• In Development - Someone is working on porting the module to Drupal 9, but there is not a stable and production usable version yet
• In Release Candidate - A development version has reached a state where it could be used (with caveats) in production, but careful review by the site administrator is recommended

Module	Machine Name	Category	Latest Version	Removal Recommended?	Drupal 9 Version	Covered by Security Advisory	Last Update (Non-Dev)	Key issue/bug info	Date Checked	Notes
404 Navigation	navigation404	Other	7.x-1.0	N/A	In Core	Y	2011-01-07			If you create and configure a 403 and 404 page within Drupal, you don't need this module and can remove it. 7.x-1.x-dev - updated on 5/9/14
Accordions	accordions	User interface	7.x-1.0-alpha4	Yes	N/A	N	2013-04-23			No further development No longer developed by its maintainers.
Adaptive Image	adaptive_image	Other	7.x-1.4	No	Functionality in Core	Y	2012-02-24		2018-10-05	a few PHP related issues: https://www.drupal.org/project/issues/adaptive_image?text=&status=Open&priorities=All&categories=All&version=7.x&component=All
Address Field	addressfield	Fields	7.x-1.2	No	Functionality in Core	Y	2015-10-07	Patch for 7 compatibility issue https://www.drupal.org/project/addressfield/issues/2628592	2018-10-05	used? Needed? Replaced by Address module in D8.
Admin	admin	Administration	7.x-2.0-beta3	Yes	Use admin_toolbar	N	2014-12-19		2018-11-08
Administration menu	admin_menu	Administration	7.x-3.0-rc5	No	Use admin_toolbar	N	2014-12-19	7.1 issue (https://www.drupal.org/project/admin_menu/issues/3000678) 7.2 - incompatibility by rc5 (https://www.drupal.org/project/admin_menu/issues/3000373) 7.2 issue patched (https://www.drupal.org/project/admin_menu/issues/2929025).	2018-10-05	couldn't replicate 7.1 issue locally.
Administration views	admin_views	Administration	7.x-1.6	No	In Core	Y	2016-08-02		2018-10-05	Included in D8 core.
Admin Tools	admin__tools	Administration	7.x-1.1	No	In Core	Y	2016-08-02		2018-11-08	Included in D8 core.
Advanced help	advanced_help	Other (Administration, Utility)	7.x-1.4	No	Yes	Y	2018-04-14	No major or critical issues	2018-10-05	This module is incompatible with the Fast 404 module. Installing Fast 404 will produce 404 (File not found) errors if you try to look up README.txt-files.
Alpha Pagination	alpha_pagination	Views	7.x-1.7	No	No	Y	2017-09-21
Automatic Nodetitles	auto_nodetitle	Other	7.x-1.0	No	No	Y	2011-06-07		2018-10-05
Back To Top	back_to_top	Other (Content, Content Display)	7.x-1.5	No	Yes	Y	2015-12-16		2018-10-05
Better Exposed Filters	better_exposed_filters	Views	7.x-3.6	No	Yes	Y	2018-09-03	Remove usage of deprecrated each() function for PHP 7.2+ future proofing
Block Class	block_class	Other (Content ,Content Display, Theme Enhancements)	7.x-2.4	No	Yes	Y	2018-07-27	No major or critical issues	10/5/018
Block Class Styles	block_class_styles	Other	7.x-2.6	No	No	Y	2016-01-13	No major or critical ssues		This module has not been ported to Drupal 8. Refer to this issue to find out its progress.
Block reference	blockreference	Fields	7.x-2.7	No	Functionality in Core (EntityReference)	Y	2018-02-15		2018-10-05	used? Required for GT Super blocks module, which we want to avoid using.
Block Title Link	block_titlelink	Other (Content Display, Theme Enhancements)	7.x-1.5	No	No	Y	2015-08-19	Block Title Link not working with PHP 7.*		This module is currently being ported to Drupal 8, but is not usable yet. Help us by following this issue. Couldn't replicate issue on local dev environmentThis module is currently being ported to Drupal 8, but is not usable yet. Help us by following this issue. Couldn't replicate issue on local dev environmentThis module is currently being ported to Drupal 8, but is not usable yet. Help us by following this issue. Couldn't replicate issue on local dev environment
Bootstrap Business	bootstrap_business	Other	7.x-1.1	No	In Development	Y	2014-10-21	No major or critical issues
Brightcove	brightcove	Video	7.x-6.x-dev	No	Yes	Y	2018-01-30	PHP 7 error with variable reuse $client.
Calendar	calendar	Date/Time	7.x-3.5	No	In Development	Y	2014-10-14		2018-10-05	only used if have Event content type (likely connected to Mercury)
CAPTCHA	captcha	Spam control	7.x-1.5	No	Yes	Y	2017-09-06	PHP 7 - sometimes float instead of integer passed to srand() and mt_srand() in image_captcha_image()		This issue has been Closed(fixed) - [7.x-1.x-dev]
CAS	cas	Central Authentication Service	7.x-1.7	No	Yes	Y	2018-02-12	Library issue.	2018-10-05	Older versions of associated phpCAS library may have outdated PHP calls. Highly recommended (and for security updates) to upgrade to the latest phpCAS library.
CAS Attribute Tokens	cas_attributes	Central Authentication Service	7.x-1.0-rc3	Yes	No	N	2013-11-13		2018-10-05	used?
CCK	cck	CCK	7.x-3.0-alpha3	Yes	No	N	2013-12-12		2018-10-05	most moved into Core in D7, only used for a migration
Chaos tools	ctools	Chaos tool suite	7.x-1.14	No	Yes	Y	2018-02-24	7.1 PHPCS warning (https://www.drupal.org/project/ctools/issues/2979350) patched incompatibility for a reserved word (https://www.drupal.org/project/ctools/issues/2941069) other patches (https://www.drupal.org/project/ctools/issues/2635876) (https://www.drupal.org/project/ctools/issues/2713377)	2018-10-05
CKEditor	ckeditor	User interface	7.x-1.18	No	In Core	Y	2017-06-26
CKEditor Image	ckeditor_image	User interface	7.x-1.2	No	In Core	Y	2013-07-09			Drupal 8 has its own image plugin and supports center align.
Collapsiblock	collapsiblock	User interface	7.x-2.0	No	Yes	Y	2018-06-10
Context	context	Context	7.x-3.7	No	Yes	Y	2016-05-18	7.2+ issue patch for create_function (https://www.drupal.org/project/context/issues/2946595)	2018-10-05	used?
Content Access	content access	Content Access	7.x-1.2-beta2	No	In Development	Y	2013-04-15	There are open security issues: Private files downloadable when node access is denied, needs support	2018-11-05	Content access makes use of Drupal's node access API. However, it's recommended to use only one module that does so.
CSS Injector	css_injector	Other (Theme Enhancements)	7.x-1.10	No	No	Y	2013-12-17	No Major or critical issues
Custom Breadcrumbs	custom_breadcrumbs	Other	7.x-2.0-beta11	Yes	Yes	N	2014-09-09			This module has not been ported to Drupal 8. Refer to this issue to find out its progress.
Custom Search	custom_search	Search	7.x-1.20	No	In Development	Y	2015-12-18		2018-11-08
Date	date	Date/Time	7.x-2.10	No	In Core	Y	2017-04-07	version 2.11 planned to have 7.1 fixes, will need to update to this when it is released	2018-10-05	Included in D8 core (mostly).
Dates	dates	Date/Time	7.x-1.0-alpha1	Yes	No	N	2012-10-20		2018-11-08	may be able to uninstall module and still leave preset date formats behind
Diff	diff	Other (Administration, Content Display, Utility)	7.x-3.3	No	Release Candidate	Y	2016-12-20	Deprecating PHP4 style constructors
Display Suite	ds	Display Suite	7.x-2.16	Yes	No	Y	2018-07-03	error (https://www.drupal.org/project/ds/issues/2986390)	2018-10-05	used?
Editable Views	editableviews	Views	7.x-1.0-beta10	Yes	No	N	2015-07-28
Email	email	Fields	7.x-1.3	No	Yes	Y	2014-04-10		2018-10-05	included in D8 core.
Entity API	entity	Other	7.x-1.9	No	In Core	Y	2/142018			This module has been included with Drupal 8 core. Refer to this issue for more information.
Entity Reference	entityreference	Fields	7.x-1.5	No	In Core	Y	2017-08-16	Warning only (https://www.drupal.org/project/entityreference/issues/3006199)	2018-10-05
Entity Rules	entity_rules	Other	7.x-1.0-alpha4	Yes	No	N	2013-12-09
Entity to Text	entity2text	Other (Content Display)	7.x-1.x-dev	Yes	No	N	2015-09-01
Entity tokens	entity_token_display		7.x-1.x-dev	Yes	No	N	2015-09-01		2018-11-08
Entityform	entityform	Entityform	7.x-2.0-rc4	No	No (Use Webform)	Y	2017-05-08	7.1 patch (https://www.drupal.org/project/entityform/issues/2834738)	2018-10-05
Exclude node title	exclude_node_title	Other	7.x-1.9	No	No	Y	2015-06-26	No major or critical issues
External Links	extlink	User interface	7.x-1.20	No	Yes	Y	2018-04-20
Fast Permissions Administration	fpa	Administration	7.x-2.6	No	No	Y	2014-08-22		2018-10-05	duplicate of filter_perms (but less-intuitive UI)
Features	features	Features	7.x-2.10	No	Yes (But you won't need it)	Y	2016-04-18	7.2 issues (https://www.drupal.org/project/features/issues/2931464 https://www.drupal.org/project/features/issues/2957125 https://www.drupal.org/project/features/issues/2642642)	2018-10-05
Features Extra	features_extra	Features Extra	7.x-1.0	No	Yes (But you won't need it)	Y	2016-04-18		2018-11-08
Feed Import	feed_import	Feeds	7.x-3.4	No	No	Y	2015-01-07		2018-10-05	Should just be for initial content import, not ongoing use. Not nearly as well supported or used as Feeds module.
Feeds	feeds	Feeds	7.x-2.0-beta4	Yes	In Development	N	2017-09-24		2018-10-05	used? Make sure in ongoing use, not just for initial content import.
Feeds Tamper	feeds_tamper	Feeds	7.x-1.2	No	In Development	Y	2017-12-10	7-related issues (https://www.drupal.org/project/feeds_tamper/issues/2875221 - not really broken? https://www.drupal.org/project/feeds_tamper/issues/2567431 - has patch https://www.drupal.org/project/feeds_tamper/issues/2863574 - has patch)	2018-10-05	check if this is actually used or just left behind from testing/dev
Feeds XPath Parser	feeds_xpathparser	Feeds	7.x-1.1	Switch to Feeds Extensible Parser (feeds_ex)	No (Use Feeds Extensible Parser)	Y	2015-07-03	recommends using Feeds Extensible Parsers instead.	2018-10-05	used?
Field collection	field_collection	Fields	7.x-1.0-beta12	Yes (Switch to Paragraphs)	No	N	2016-11-17	7.2 issues (https://www.drupal.org/project/field_collection/issues/2979033 https://www.drupal.org/project/field_collection/issues/2992575)	2018-10-05	poorly-supported/-integrated module. Deprecated in D8 for paragraphs
Field Collection Table	field_collection_table	Other (Content, Content Display, Fields)	7.x-1.0-beta5	Yes (Switch to Paragraphs)	No	N	2017-02-21	No major or critical issues		This module has not been ported to Drupal 8. Refer to this issue to find out its progress.
Field formatter settings API	field_formatter_settings	Other	7.x-1.1	No	In Core	Y	2013-09-09	no major or critical issues
Field Group	field_group	Fields	7.x-1.6	No	In Development	Y	2017-11-03	PHP7 patched in current version (https://www.drupal.org/node/2649648)	2018-10-05
Field Permissions	field_permissions	Fields	7.x-1.0	No	In Release Candidate	Y	2016-10-16		2018-10-05
Field Validation	field_validation	Fields	7.x-2.6	No	In Development	Y	2015-06-20		2018-10-05
File Entity	file_entity	Media	7.x-2.22	No	In Core (as Media)	y	2018-06-14
File Field Sources	filefield_sources	Fields	7.x-1.11	No	In Development	Y	2018-02-07		2018-10-05
Filter permissions	filter_perms	Administration	7.x-1.0	No	No	Y	2012-05-16		2018-10-05	duplicate of fpa (but easier UI than fpa); not sure if it uninstalls cleanly
Flex Slider	flexslider	Flex Slider	7.x-2.0-rc2	Yes	No	N	2017-02-12		2018-10-03	No major issues. This site is running it on PHP 7.2, https://www.centralbaptistchurchah.org/
Flex Slider Views Slideshow	flexslider_views_slideshow	Flex Slider	7.x-2.x-dev	Yes	No	N		Flexslider Not Rendering the Thumbnails Field flexslider broken on plugin cache clear		This is the FlexSlider Views Slideshow module which used to be included in FlexSlider by default.
Flickr	flickr	Flickr	7.x-1.8	No	In Development	Y	2015-08-06	No major or critical issues	2018-10-03
Form block	formblock	Other (Content)	7.x-1.0-alpha1	Yes	No	N	2014-07-18	No major or critical issues
Github Flavored Markdown	gfm	Input filters		Yes	No	N		No major or critical issues	2018-10-03
Global Redirect	globalredirect	Path management	7.x-1.6	No	No (Use Redirect)	Y	2018-02-15			Update: For Drupal 8 please use the redirect module. This project is deprecated for D8
Google Analytics	google_analytics	Statistics	7.x-2.5	No	Yes	Y	2018-07-13
Google CSE	google_cse	Other	7.x-2.5	No	No	Y	2017-04-26	No major or critical issues
GT Content Types	gt_content_types	GT	7.x-2.9
GT Tools	gt_tools	GT	7.x-2.9
GT Super block	gt_ct_super_block	GT	7.x-2.9
GT Theme	gt	GT	7.x-2.9
Hide the Toolbar	Hide the Toolbar	toolbar_admin_menu	7.x-1.0	No	In Development	Y			2018-11-08
Htaccess	htaccess	Hide the Toolbar	7.x-2.6	No	In Development	Y			2018-11-08
HTML Mail	htmlmail	Mail	7.x-2.70	No	In Development	Y	2018-02-23		2018-10-04
Image Link Formatter	image_link_formatter	Fields	7.x-1.1	No	No	Y	2016-05-26		2018-10-05
Image resize filter	image_resize_filter	Input filters	7.x-1.16	No	In Development	Y	2015-08-01	PHP Fatal error: Call to a member function getDirectoryPath() on a non-object image_resize_filter/image_resize_filter.module on line 334 all other issues are more than a year old.	2018-10-03
Image URL Formatter	image_url_formatter	Other (Content, Fields)	7.x-1.4	No	No	Y	2013-09-10	No major or critical issues
IMCE	imce	Media	7.x-1.11	No	Yes	Y	2017-05-27	No major or critical issues	2018-10-05	IMCE may have problem working with Google Analytics and Secure pages modules. Just make sure to add *imce* path to the exceptions list of these modules. If IMCE has issues with your custom theme, try enabling admin theme under Common Settings of IMCE admin page or use ThemeKey Module
IMCE Mkdir	imce_mkdir	Media	7.x-1.0	No	No	Y	2011-10-20	No major or critical issues	2018-10-05	This module has not been ported to Drupal 8. Refer to this issue to find out its progress.
Inline Entity Form	inline_entity_form	Fields	7.x-1.8	No	In Release Candidate	Y	2016-04-16		2018-10-05
Insert	insert	Other ( Content Display, Fields, Filters/Editors, JavaScript Utilities, Media)	7.x-1.4	No	Yes	Y	2017-09-17	No unresolved issues Warning: A non-numeric value encountered in aggregateVariables(), https://www.drupal.org/project/insert/issues/2861946
Job Scheduler	job_scheduler	Other	7.x-2.0	Yes	In Development	N	2018-02-13	scheduler does not sometimes run	2018-10-03	Bug - 7.x-2.0-alpha3
jQuery Update	jquery_update	User interface	7.x-2.7	No	In Core	Y	2015-10-20			7.x-3.0-alpha5 - updated on 29 March 20177.x-3.0-alpha5 - updated on 29 March 2017
Libraries	libraries	Other	7.x-2.5	No	In Development	Y	2018-09-10	Version Callback functions that pass parameters by reference not permitted in PHP 7 [7.x-2.x-dev]   - https://www.drupal.org/project/libraries/issues/2779591 Upgrade to 7.x-2.3 breaks WSIWYG editor - https://www.drupal.org/project/libraries/issues/2725769 Finds no library after update [7.x-2.4] - https://www.drupal.org/project/libraries/issues/2999116 Warning after updating [7.x-2.4] - https://www.drupal.org/project/libraries/issues/2998821		Upgrade to latest version in PHP5, as the upgrade process will break in PHP7, but the already-upgraded module should work okay.
Lightweight Directory Access Protocol - LDAP	ldap	Lightweight Directory Access Protocol	7.x-2.4	No	In Development		2013-08-13	No major or critical issues	2018-10-04
Link	link	Fields	7.x-1.5	No	In Core	Y	2018-05-13		2018-10-05	Included in D8 core.
Linkit	linkit	Other	7.x-3.5	No	Yes	Y	2016-01-10		2018-10-04
Mailchimp	mailchimp	Mail	7.x-4.x					https://www.drupal.org/project/mailchimp/issues/2998627 if private fields are being used.
Mail System	mailsystem	Mail	7.x-2.35	No	Yes	Y	2016-07-12	https://www.drupal.org/project/mailsystem/issues/2770619	2018-10-04
Markdown filter	markdown	Input filters	7.x-1.5	No	Yes	Y	2016-05-31	No major or critical issues		currently being refactored. #2952435: Merge in the CommonMark project
Masquerade	masquerade	Other	7.x-1.0-rc7	Yes	In Development	N	2014-03-09	Your not allowed to masquerade as the selected user - https://www.drupal.org/project/masquerade/issues/2269927		7.x-1.x-dev - updated on 11/2/167.x-1.x-de
Media	media	Media	7.x-2.21	No	In Core	Y	2018-08-17	No major or critical issues	2018-10-05	This module has been included with Drupal 8 core. Refer to this issue for more information. Known Issues Accessibility: Media 1.x does not have an out-of-the-box solution for handling HTML attributes, including alt. Audio/Video: Media 1.x does not include any way to 'display' audio and video media files out of the box. The use of MediaElement or MediaFront is recommended. Non images and WYSIWYG: There are several known issues in both Media 1.x and 2.x when embedding non-image media via the WYSWIYG. The use of Entity Embed is recommended.
Media Field	mediafield	Media		Yes	No	N			2018-10-05	obsolete and unsupported.
Media: oEmbed	media_oembed	Media	7.x-2.7	No	No	Y	2016-06-28		2018-10-05
Menu attributes	menu_attributes	Other	7.x-1.0	No	No	Y	2016-02-15
Menu Block	menu_block	Other	7.x-2.7	No	Yes	Y	2015-06-30	Fatal Error: Call to undefined function menu_block_configure_form_follow_validate() https://www.drupal.org/project/menu_block/issues/2574457 Menu block templates doesn't applies - https://www.drupal.org/project/menu_block/issues/2950339		7.x-2.x-dev - updated on 7/8/17
Menu CSS Names	menu_css_names	Other	7.x-1.0-beta2	Yes	No	N	2016-01-07
Mercury Reader	hg_reader	GT	7.x-2.7
Module filter	module_filter	Administration	7.x-2.1	No	Yes	Y	2017-06-09		2018-10-05
Name Field	name	Fields	7.x-1.10	No	In Development (also see Webform)	Y	2015-11-25		2018-10-05	used? Do we need this much name detail?
Node clone	node_clone (clone)	Other (Content Utility)	7.x-1.0	No	No	Y	2015-11-19	No major or critical issues		/This module is currently being ported to Drupal 8, but is not usable yet. Help us by following this issue.
Node Convert	node_convert	Other	7.x-1.2	No	No	Y	2014-06-12
Nodeaccess	nodeaccess	Access control	7.x-1.4	No	In Development	Y	2014-10-06		2018-10-05	Don't know that we use this much.
Nodeblock	nodeblock	Other	7.x-1.7	No	Functionality In Core (also see EntityBlock)	Y	2015-12-02	Required by GT Content types and GT Super Block	2018-10-05	Other node block modules: http://groups.drupal.org/node/93499 7.x-1.x-dev - updated on 4/14/17
Options element	options_element	User interface	7.x-1.12	No	No	Y	2014-04-17	PHP 7.1: A non well formed numeric value encountered in _form_options_from_text() line 404	2018-10-08
Organic groups	og	Organic groups	7.x-2.10	No	In Development	Y	2018-06-28		2018-10-05
Override node options	override_node_options	Permissions	7.x-1.14	No	Yes	Y	2018-03-31
Pathauto	pathauto	Other	7.x-1.3	No	Yes	Y	2015-10-07	PHP Fatal error: Class 'MigrateDestinationHandler' not found - [7.x-1.x-dev] - https://www.drupal.org/project/pathauto/issues/2609618PHP Fatal error: Class 'MigrateDestinationHandler' not found - [7.x-1.x-dev] - https://www.drupal.org/project/pathauto/issues/2609618		7.x-1.x-dev - updated on 8/16/17
Pathologic	pathologic	Input filters	7.x-3.1	No	In Development	Y	2015-11-23	mulitlingual links with Pathologic https://www.drupal.org/project/pathologic/issues/348421. Pathologic rewrites + to %2b in url Detection of HTTPS status for protocol-relative URLs doesn't work	2018-10-03
Phone	phone	Fields	7.x-1.0-beta1	Yes	In Core	N	2014-01-14		2018-10-05	duplicate field to telephone; will not migrate as well to D8
Plupload integration module	plupload	Media	7.x-1.7	No	No	Y	2014-11-07		2018-10-05	Drupal 7 version provides integration between Drupal and Plupload library via form element. You only need the 7.x version if another module tells you to download it. This module has a pre-release version for Drupal 8. To find out more, follow this issue or download below.
reCAPTCHA	recaptcha	Spam control	7.x-2.2	No	Yes	Y	2016-07-23
Redirect	redirect	Other	7.x-1.0-rc3	No	Yes	Y	2015-07-08	PHP Fatal error: Class 'RedirectController' - https://www.drupal.org/project/redirect/issues/2849531PHP Fatal error: Class 'RedirectController' - https://www.drupal.org/project/redirect/issues/2849531		7.x-2.x-dev - updated on 10/5/18
Redirect UUID	uuid_redirect	Other	7.x-1.0-alpha1	Yes	No	N	2012-04-26			7.x-1.x-dev - updated on 5/10/12
References	references	Fields	7.x-2.2	No	In Core	Y	2017-04-18	7 patch available (https://www.drupal.org/project/references/issues/2923099)	2018-10-05	used? Poorly-integrated (entityreference is more future-proof)
Revisioning	revisioning	Other	7.x-1.9	No	In Core	Y	2014-06-26			7.x-1.x-dev - updated on 5/3/18 This module has been included with Drupal 8 core7.x-1.x-dev - updated on 5/3/18 This module has been included with Drupal 8 core
Rules	rules	Rules	7.x-2.11	No	In Development	Y	2018-05-18	Remove usage of deprecrated each() function for PHP 7.2+ future proofing		This issue is closed (duplicate) - [7.x-2.x-dev]
Search Restrict	search_restrict	Other	7.x-1.0	No	No	Y	2011-07-09			Alternative: search_config 7.x-1.x-dev - updated on 7/10/11
Select (or other)	select_or_other	Fields	7.x-2.24	No	In Development	Y	2018-07-25		2018-10-05	active 3.x alpha version. Likely used with webform module
Simplified formats	simplified_formats	Other	7.x-1.0-beta1	Yes	No	N	2013-10-08
Social Share	social_share	Social media	7.x-2.5	No	In Development	Y	2017-01-24
Special menu items	special_menu_items	Other	7.x-2.0	No	In Core	Y	2012-09-04			7.x-2.x-dev - updated on 5/12/15
Strongarm	strongarm	Other	7.x-2.0	No	In Core	Y	2012-06-13			7.x-2.x-dev - updated on 6/7/11
Superfish	superfish	User interface	7.x-2.0	No	Yes	Y	2015-11-25
Table of Contents	tableofcontents	Input filters	7.x-2.x-dev	Yes	No	N	2018-03-19	Critical Issue: PHP Fatal error: Unsupported operand types in ${drupalroot}/includes/theme.inc on line 1074 ,https://www.drupal.org/project/tableofcontents/issues/1955448	2018-10-03
Telephone	telephone	Fields	7.x-1.0-alpha1	Yes	In Core	N	2014-01-14		2018-10-05	duplicate field to phone; backport of D8 core module
Token	token	Other	7.x-1.7	No	Yes	Y	2017-01-25	Tokens Missing (No tokens available - admin/help/token) - upgrade of PHP 5.3.3 to PHP 7.0.10 https://www.drupal.org/project/token/issues/2822160 Error : Cannot use string offset as an array in _token_token_tree_format_row() [7.x-1.x-dev] - https://www.drupal.org/project/token/issues/2825841
Token tweaks	token_tweaks	Other	7.x-1.x-dev	Yes	No	N	2014-01-27
Transliteration	transliteration	Other	7.x-3.2	No	No, but Planned to Go Into Core	Y	2014-03-17	Possible regression: WSOD and PHP Fatal Error when transliterating files [2015] - https://www.drupal.org/project/transliteration/issues/161516
Twitter Block	twitter_block	Other	7.x-2.3	No	In Development	Y	2015-09-15
Universally Unique ID	uuid	UUID	7.x-1.2	No	In Core	Y	2018-07-19	PHP7 compatibility		This issue has been Closed(works as designed) - [7.x-1.x-dev] This module doesn't need to be ported to Drupal 8. All core entities in D8 support UUIDs. The UUID URL is currently under development for a future release of Drupal 8 core.
Video Embed Field	video_embed_field	Media	7.x-2.0-beta11	Yes	Yes	N	2015-09-07		2018-10-05
View Unpublished	view_unpublished	Permissions	7.x-1.2	No	In Development	Y	2014-10-30
Views	views	Views	7.x-3.20	No	In Core	Y	2018-04-14	Parameter 3 to views_ui_build_form_state() expected to be a reference, value given in views_ui_ajax_form() [7.x-3.x-dev] - https://www.drupal.org/project/views/issues/2810431 PHP 7 incompatibility in views_plugin_style_mapping [7.x-3.x-dev] - https://www.drupal.org/project/views/issues/2850719		Reviewed & tested by the community
Views Accordian	views accordian	Views Accordian	7.x-1.1	No	In Core	Y	2018-11-05			Reviewed & tested by the community
Views Bulk Operations	views_bulk_operations	Views	7.x-3.5	No	Yes	Y	2018-05-09	PHP 7.1 upgrade fail - https://www.drupal.org/project/views_bulk_operations/issues/2953645 PHP 7.2+ future proofing, remove usage of deprecated ""create_function()"" - https://www.drupal.org/project/views_bulk_operations/issues/2946220
Views Data Export	views_data_export	Views	7.x-3.2	No	In Development	Y	2017-04-05
Views Field View	views_field_view	Views	7.x-1.2	No	No	Y	2015-09-18	PHP 7.1 Warning non-numeric value		7.x-1.x-dev
Views Responsive Grid	views_responsive_grid	Views	7.x-1.3	No	In Core	Y	2013-04-05			7.x-1.x-dev - updated on 2/13/17
Views Slideshow	views_slideshow	Views	7.x-3.9	No	Yes	Y	2017-06-08	PHP 7.1 causes error [8.x-4.x-dev] - https://www.drupal.org/project/views_slideshow/issues/2834156 Fatal error when using top / bottom widgets with PHP 7.1 [7.x-3.x-dev] - https://www.drupal.org/project/views_slideshow/issues/2835052		These issues have been closed(fixed).
Views Slideshow: Cycle	views_slideshow_cycle; views_slideshow_cycle2	Views		Yes	In Development	N				Drupal 8 only
Void Menu	void_menu	Menu (Path Management)	7.x-1.9	No	No	Y	2014-05-30		2018-10-05	no major or critical issues, https://www.drupal.org/project/issues/void_menu?categories=All
Webform	webform	Webform	7.x-4.18	No	Yes (Full rewrite - read docs for details)	Y	2018-10-01	Fatal error: Cannot use lexical variable $value as a parameter name in components/select.inc on line 765		[7.x-4.x-dev] This issue has been closed(fixed).[7.x-4.x-dev] This issue has been closed(fixed).[7.x-4.x-dev] This issue has been closed(fixed).[7.x-4.x-dev] This issue has been closed(fixed).
Webform Rules	webform_rules	Webform	7.x-1.6	No	No		2013-03-16
Webform Term Options	webform_term_opts	Webform	7.x-4.0	No	No	Y	2014-05-02			Using this module might not be your best option. Consider using Entityform with a Term Reference field instead.
Webform Validation	webform_validation	Webform	7.x-1.15	No	No	Y	2018-10-01
WYSIWYG Filter	wysiwyg_filter	Input filters	7.x-1.6-rc9	Yes	In Core	N	2017-10-24	No major or critical issues	2018-10-04	minimally maintained, maintenance fixes only (This module has been included with Drupal 8 core)"