Articles in this section

See more

Unable to install the Plesk Email Security: ERROR: Missing required additional modules: DBD::mysql

Avatar
Ivan Kamnev
Updated
Follow
kb: technical ext: pes ABT: Group A Plesk Obsidian for Linux

Applicable to:

  • Plesk Obsidian for Linux

Symptoms

  • Unable to install the Plesk Email Security, the error below is shown:

    PLESK_ERROR: ***** problem report *****
    Warning: restart service amavisd failed
    , stderr: Job for amavisd.service failed because the control process exited with err or code. See "systemctl status amavisd.service" and "journalctl -xe" for details.
    ERR [panel] Execution pleskrc has failed with exit code 1, stdout: INFO: : Service: amavisd, Action: restart
    Trying to restart service amavisd... active
    example.com systemd[1]: amavisd.service: control proces s exited, code=exited status=255
    example.com systemd[1]: Failed to start Amavisd-new is an interface between MTA and content checkers..
    example.com systemd[1]: Unit amavisd.service entered failed state.
    example.com systemd[1]: amavisd.service failed.
    ***** problem report *****

  • In an attempt to execute the command from the error, the following messages are shown:

    # journalctl -xe
    Unit amavisd.service has begun starting up.
    example.com amavisd[22804]: ERROR: MISSING REQUIRED ADDITIONAL MODULES:
    example.com amavisd[22804]: DBD::mysql
    example.com amavisd[22804]: DBD::mysql

Cause

The package perl-DBD-MySQL that is required for the Amavis service is missed.

Resolution

Apply one of the solutions below:

For RHEL based systems (CentOS/CloudLinux)
  1. Log into the server via SSH.
  2. Execute the command below to install the perl-DBD-MySQL package:

    # yum install perl-DBD-MySQL

For Debian based systems (Ubuntu/Debian)
  1. Log into the server via SSH.
  2. Execute the command below to install the perl-DBD-MySQL package:

    # apt-get install libdbd-mysql-perl

Comments

3 comments

Sort by Date Votes
  • Avatar
    Robin Labadie

    Installing the Plesk Email Security halted mail reception (everything deferred) because of this issue, which is problematic if you don't notice right away.
    I can confirm this solution worked so thank you for this.

    Isn't there a PPM for this missing dependency?

    0
    Comment actions Permalink
  • Avatar
    Ivan Kamnev

    Hello @Robin Labadie,

    I did not reproduce the issue in my test environment with a fresh Plesk installation.

    The perl-DBD-MySQL is shipped with MariaDB or MySQL.

    The perl-DBD-MySQL package can be missed on the server in case the custom MySQL instance is installed.

     

     

    0
    Comment actions Permalink
  • Avatar
    Robin Labadie

    Hello and thank you for trying to help @Ivan Kammenev.

    Maybe more details are required in order to reproduce the issue, then.

    The environment on which I encountered the issue was a fresh Debian 11.4 install, on which Plesk was installed, then I've migrated my domains and upgraded MariaDB manually.
    Then I've installed the Plesk Email Securty, and Amavis wouldn't start because of the missing dependency. I shall note that I didn't see any error within the Plesk interface upon installing (maybe wasn't paying attention), but I did see them in SSH (probably with systemctl status amavis).

    For the upgrade, MariaDB repos were added using the official MariaDB script which is available here:
    https://mariadb.com/kb/en/mariadb-package-repository-setup-and-usage/

    By the way, I find this method cleaner than using the repos advised in the Plesk upgrade guide (especially since if I recall correctly, before, it was even advising a .ru mirror that didn't work anymore).
    https://support.plesk.com/hc/en-us/articles/213403429--How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux-

    The official MariaDB script provides the following repos:

    # root@ds ~ # cat /etc/apt/sources.list.d/mariadb.list

    # MariaDB Server
    # To use a different major version of the server, or to pin to a specific minor version, change URI below.
    deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/mariadb-server/10.6/repo/debian bullseye main


    # MariaDB MaxScale
    # To use the latest stable release of MaxScale, use "latest" as the version
    # To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
    deb [arch=amd64,arm64] https://dlm.mariadb.com/repo/maxscale/latest/apt bullseye main


    # MariaDB Tools
    deb [arch=amd64] http://downloads.mariadb.com/Tools/debian bullseye main

    This should likely help reproducing and understanding the root cause for the issue. I remain available if more details are required.

    Best regards

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles