Greetings Perl Monks.

I'm an occasional, though long-time Perl coder.

On a CentOS shared hosting setup, I had a load of perl scripts reading and writing successfully to a Maria database using DBI.

The hosting company, for good reasons, migrated the account to another server running Almalinux, and the above scripts broke. For a long time the hosting company blamed coding errors, which were apparently spontaneously created without human intervention when the account was migrated.

I've spent quite a bit of time investigating and the core issue is that the following error is given (by redirecting STDERR to a text file), together with a 500 server error to browser, by the pared down code below (yes, the original code did have use strict, warnings, diagnostics, redirect to STDERR, db write, disconnect, and attempted to write to browser, among other features).

usr/bin/perl: symbol lookup error: /home/username/perl5/lib/perl5/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so: undefined symbol: Perl_xs_version_bootcheck

#!/usr/bin/perl
use cPanelUserConfig;
use DBI;
our $dbpath = "DBI:mysql:valid_servername:localhost";
our $dbuser = "validUsername";
our $dbpass = "validPassword";
my $result = pushdata();
sub pushdata {
my $dbh = DBI->connect($dbpath,$dbuser,$dbpass);
1;
}

[download]
See also this thread:

https://forum.directadmin.com/threads/error-on-spamassassin-install.67667/

On talking again with the hosting company, they've made further disclosures, stating that they are running Perl v5.26.3 where 'perl scripts and modules are not compatible or wont work'.

Can the Monks share any enlightenment on whether backward compatibility in Perl is now lost and the format of DBI calls needs to change, or whether perhaps I should seek a different hosting company, among other possible solutions? Thanks in advance.

In reply to Almalinux throwing Perl_xs_version_bootcheck undefined error by stingray020

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.