Perl Modules not connecting to DB

Most of the hosting companies have cycled their hardware enough to use the Maria DB platform.

This could have a few impacts to your hosting configuration. Here’s what to check.

Database user permission reset

Sometimes during a DB migration the users or the permissions could get corrupted. So the first step is to find your user info in your site config files.

Remove the users from the DB menu to clear out any lingering issues. Then just re-create the same user, with the same password.

Last step is to assign the users to your databases with full permissions. This will hopefully correct any DB connection issues. However this could be a module issue.

Transition to using the “Maria” DB module in cpanel

If the user perms refresh didn’t correct the issue then you may need to convert your connection settings.

The previous SQL modules will no longer work. The shared hosting perms have changed and we must adapt.

Go to cPanel > software > Perl Modules > find a module >> “Maria”

DBD::MariaDB is the name of the module you need to find and install.

Then do an audit of your connection settings and make sure that you’ve adapted to the new module references.

After the change in DB module and configuration your Perl scripting should run as expected.