in reply to Re^3: plugin 'mysql_old_password' cannot be loaded
in thread plugin 'mysql_old_password' cannot be loaded

I realize it's probably not a question involving perl but rather about connecting to mysql. Sorry, but it would help me to see if I could solve this only from the perl side or if I had to ask my DB Admin...

(And ask what ? creating a new user for my DB ? Setting old_passwords to ON ?)

Installing an older version of which one ? DBIx::Class ? DBI ? DBD::Mysql ?

I'm sure I'm not the first one being hit by that.

But anyway thanks for the proposal, I will try that if everything else fails.

Wich module should I downgrade ?

  • Comment on Re^4: plugin 'mysql_old_password' cannot be loaded

Replies are listed 'Best First'.
Re^5: plugin 'mysql_old_password' cannot be loaded
by marto (Cardinal) on Feb 15, 2019 at 15:51 UTC
[reply]
Re^5: plugin 'mysql_old_password' cannot be loaded
by poj (Abbot) on Feb 15, 2019 at 16:53 UTC

    Run this program (with your credentials) on both old and new perls and post the results so we can see which versions you have.

    #!/usr/bin/perl
use strict;
use DBI;

my $dbh = get_dbh();
my ($ver) = $dbh->selectrow_array('SELECT VERSION()');
printf "OS         : %s\n",$^O;
printf "Perl       : %s\n",$^V;
printf "DBD::MySQL : %s\n",$DBD::mysql::VERSION;
printf "Server     : %s\n",$ver;

sub get_dbh {

  my $server   = 'localhost';
  my $database = "pm"; 
  my $user = "user"; 
  my $pw   = "password";
  my $dsn  = "dbi:mysql:$database:$server:3306"; 
  my $dbh  = DBI->connect($dsn, $user, $pw, 
     { RaiseError=>1, AutoCommit=>1 } );
  return $dbh;
}

    [download]
    poj
[reply]
[d/l]
      The output with my 5.24 perl is 
      OS         : MSWin32
Perl       : v5.24.0
DBD::MySQL : 4.033
Server     : 5.5.53-0+deb7u1-log

      [download]
      With the portable 5.28 perl (and a few changes in the code) 
      OS         : MSWin32
Perl       : v5.28.1
DBD::MySQL :
DBI connect('...:3306',...,...) failed: Authentication plugin 'mysql_o
+ld_password' cannot be loaded: The specified module could not be foun
+d.
 at get_version.pl line 21.

      [download]
[reply]
[d/l]
[select]
[reply]

        Is the perl 5.24 also portable strawberry and is it on the same machine as your new 5.28 ?

        poj
[reply]
Re^5: plugin 'mysql_old_password' cannot be loaded
by poj (Abbot) on Feb 19, 2019 at 15:06 UTC
    if I had to ask my DB Admin.

    Ask what the length is of the string in the user.password field

    SELECT LENGTH(PASSWORD) FROM USER 
WHERE USER = 'yourusername'
    poj
[reply]

      Result: 16

[reply]

        Ok, looks like server has been upgraded from a pre 4.1 version.

        Run this query to check if server is running with old_passwords=1

        SELECT PASSWORD('anyword');

        The result should be either 

        1483f47e284cee10 
or
*DEFC3C96B99362885AD525B7AD2A5F02EED43E57

        poj
[reply]
[d/l]

In Section Seekers of Perl Wisdom