Re^10: plugin 'mysql_old_password' cannot be loaded

OS         : MSWin32
Perl       : v5.24.4
DBD::mysql : 4.046
C:/spp24/perl/site/lib
C:/spp24/perl/vendor/lib
C:/spp24/perl/lib
.

DBI connect('d...h:3306','d...m',...) failed: Authentication plugin 'm
+ysql_old_password' cannot
 be loaded: The specified module could not be found.
 at get_version.pl line 24.
[download]

We don't have the same version of the DBD::mysql driver.

Comment on Re^10: plugin 'mysql_old_password' cannot be loaded Download Code

Replies are listed 'Best First'.
Re^11: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 20, 2019 at 06:47 UTC
I tried to install the version 4.033 of DBD::mysql From cpan, the compilation failed because of missing header files. `dbdimp.c:36:20: fatal error: poll.h: No such file or directory # include <poll.h>` [download] Where can I get these ? Thanks F.	[reply] [d/l]
Re^12: plugin 'mysql_old_password' cannot be loaded by marto (Cardinal) on Feb 20, 2019 at 07:17 UTC
When installing a module and experiencing problems, expecially with old versions, it's important to check the changelog. See https://metacpan.org/changes/distribution/DBD-mysql#L230: `2016-10-14 Patrick Galbraith, Michiel Beijen, DBI/DBD community (4.037 +_01) * Newest versions of libmysqlclient and the MariaDB C connector no lon +ger export the __WIN__ macro. If this macro is not present we would not compile in the poll.h-based async-support. Changed to use the _WIN32 macro instead. Thanks to Sergei Golubchik for suggesting the fix.` [download] Also 0f4f5873168becf8b6640de68778b7406cd9a3d7, rt://68169.	[reply] [d/l]
Re^13: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 20, 2019 at 12:21 UTC
Thanks ! It compiled and most of the tests passed on my local mysql. But the problem is still there `C:\spp24>perl get_version.pl OS : MSWin32 Perl : v5.24.4 DBD::mysql : 4.033 C:/spp24/perl/site/lib C:/spp24/perl/vendor/lib C:/spp24/perl/lib . DBI connect('d...h:3306','d...m',...) failed: Authentication plugin 'm +ysql_old_password' cannot be loaded: The specified module could not b +e found. at get_version.pl line 24.` [download] :-( F	[reply] [d/l]
Re^14: plugin 'mysql_old_password' cannot be loaded by marto (Cardinal) on Feb 20, 2019 at 12:46 UTC
Re^15: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 20, 2019 at 13:30 UTC
Some notes below your chosen depth have not been shown here


P is for Practical
	PerlMonks