replacement for DBI?

jck has asked for the wisdom of the Perl Monks concerning the following question:

I have a script that has worked for years, but now it's throwing an error, pointing to the line that attempts to connect to my database.

line 3: use DBI;

...

line 20: my $dbh = DBI->connect('DBI:mysql:database_name1;host=localho
+st;port=3306', 'username', 'password')
    or die "Couldn't open database: $DBI::errstr; stopped";
line 22: my $dbh2 = DBI->connect('DBI:mysql:database_name2;host=localh
+ost;port=3306', 'username', 'password')
    or die "Couldn't open database: $DBI::errstr; stopped";
[download]

the error message is as follows:

install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC 
(@INC contains: /home/domainname/public_html/cgi-bin/ //perl5/lib/perl
+5 
//perl5/lib/perl5/x86_64-linux-thread-multi //perl/usr/local/lib64/per
+l5 
//perl/usr/local/share/perl5 //perl/usr/lib64/perl5/vendor_perl 
//perl/usr/share/perl5/vendor_perl //perl/usr/lib64/perl5 
//perl/usr/share/perl5 /usr/local/lib64/perl5 /usr/local/share/perl5 
/usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/p
+erl5 /usr/share/perl5 .) at (eval 18) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Mem, Proxy, SQLite, Spo
+nge.
 at /home/domainname/public_html/cgi-bin/events_db_embed.pl line 20.
[download]

should I replace DBI with one of the following? DBM, ExampleP, File, Gofer, Mem, Proxy, SQLite, Sponge.

just as an addendum, I search for DBI as an available module, and it's not listed on my host

Comment on replacement for DBI? Select or Download Code

Replies are listed 'Best First'.
Re: replacement for DBI? by NetWallah (Canon) on Oct 02, 2020 at 00:01 UTC
Did your connection string change ? From https://metacpan.org/pod/DBD::mysql, the connection string should be: `DBI:mysql:database=name2 ...` [download] Your string appears to use "DBI:mysql:database_name2" (Underscore instead of equals). "Imaginary friends are a sign of a mental disorder if they cause distress, including antisocial behavior. Religion frequently meets that description"	[reply] [d/l]
Re^2: replacement for DBI? by jck (Scribe) on Oct 02, 2020 at 00:34 UTC
sorry, I put in "database_name2" as a placeholder. my database name actually does have an underscore in it.	[reply]
Re: replacement for DBI? by LanX (Saint) on Oct 01, 2020 at 23:58 UTC
> `Perhaps the DBD::mysql perl module hasn't been fully installed,` Perhaps the DBD::mysql perl module hasn't been fully installed? DBI is just a frontend which provides the API to different backend drivers. Cheers Rolf _{(addicted to the Perl Programming Language :) Wikisyntax for the Monastery} PS: could you please edit your post in a way, which doesn't require several pages of width? Like linebreaks in the @INC path?	[reply] [d/l]
Re^2: replacement for DBI? by jck (Scribe) on Oct 02, 2020 at 00:13 UTC
sorry - is that better? I just reinstalled DD::mysql, but it's still throwing the same error...	[reply]
Re^3: replacement for DBI? by 1nickt (Canon) on Oct 02, 2020 at 00:23 UTC
Reinstalled to where? How? The way forward always starts with a minimal test.	[reply]
Re^4: replacement for DBI? by jck (Scribe) on Oct 02, 2020 at 00:26 UTC
Re^5: replacement for DBI? by 1nickt (Canon) on Oct 02, 2020 at 00:38 UTC
Some notes below your chosen depth have not been shown here
Re: replacement for DBI? by 1nickt (Canon) on Oct 02, 2020 at 00:21 UTC
The error message is telling you that the DBI can find drivers for the listed DBs, but not for MySQL. The double slashes in the paths in your `@INC` look weird. Did you change it, or maybe your shared hosting server did? Does your host show DBD::mysql as available? The way forward always starts with a minimal test.	[reply] [d/l]
Re^2: replacement for DBI? by jck (Scribe) on Oct 02, 2020 at 00:28 UTC
yes, I just checked that DBD::mysql is installed	[reply]
Re^3: replacement for DBI? by parv (Parson) on Oct 02, 2020 at 00:46 UTC
Below prints "4.046" in my case ... `# If library paths work with your default perl, should print a version +. perl -MDBD::mysql -e 'print qq[$DBD::mysql::VERSION\n]'` [download] If above causes error messages, do consult with your host as already had been suggested.	[reply] [d/l]
Re^4: replacement for DBI? by jck (Scribe) on Oct 02, 2020 at 00:57 UTC
Re: replacement for DBI? by Anonymous Monk on Oct 02, 2020 at 00:07 UTC
"Stop ... don't do anything ... breathe ..." What changed, recently, and exactly when did it change?	[reply]
Re^2: replacement for DBI? by jck (Scribe) on Oct 02, 2020 at 00:25 UTC
the only thing that I know changed was that I updated our PHP version (we're mostly running off a Wordpress site, with some PERL-scripted add-ons)	[reply]
Re^3: replacement for DBI? by Anonymous Monk on Oct 02, 2020 at 15:43 UTC
Did you think to put your source-code under source-code control such as `git`?	[reply]
Re^4: replacement for DBI? by jck (Scribe) on Oct 02, 2020 at 16:18 UTC
Re^5:replacement for DBI? by soonix (Canon) on Oct 02, 2020 at 19:43 UTC


Perl: the Markov chain saw
	PerlMonks