in reply to Re^9: plugin 'mysql_old_password' cannot be loaded
in thread 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.

F.

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]

      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]

        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]

In Section Seekers of Perl Wisdom