Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^8: plugin 'mysql_old_password' cannot be loaded

by frazap (Monk)
on Feb 19, 2019 at 09:34 UTC ( [id://1230153]=note: print w/replies, xml ) Need Help??


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

5.24 is a normal setup.

Both 5.28 + 5.24 are on the same pc.

And I had to rename the folder where 5.24 is to hide it from the path.

I tried to change the line that set the path in the bat that run 5.28 but without success (the window did not stay open)

F

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

Replies are listed 'Best First'.
Re^9: plugin 'mysql_old_password' cannot be loaded
by poj (Abbot) on Feb 19, 2019 at 10:55 UTC

    Try portable 5.24.0.1, download, unzip and run this script using portableshell.bat. Don't change the bat file.

    !/usr/bin/perl use strict; use DBI; use DBD::mysql; printf "OS : %s\n",$^O; printf "Perl : %s\n",$^V; printf "DBD::mysql : %s\n",$DBD::mysql::VERSION; print join "\n",@INC,"\n"; my $dbh = get_dbh(); my ($ver) = $dbh->selectrow_array('SELECT VERSION()'); printf "Server : %s\n",$ver; sub get_dbh { my $server = 'localhost'; my $database = "pm"; my $user = "user"; my $pw = "*****"; my $dsn = "dbi:mysql:$database:$server:3306"; my $dbh = DBI->connect($dsn, $user, $pw, { RaiseError=>1, AutoCommit=>1 } ); return $dbh; }

    I get

    ----------------------------------------------
     Welcome to Strawberry Perl Portable Edition!
     * URL - http://www.strawberryperl.com/
     * see README.TXT for more info
    ----------------------------------------------
    Perl executable: D:\strawberry-perl-5.24.0.1-64bit-portable\perl\bin\perl.exe
    Perl version   : 5.24.0 / MSWin32-x64-multi-thread
    
    D:\strawberry-perl-5.24.0.1-64bit-portable>perl c:/temp/mysql.pl
    OS         : MSWin32
    Perl       : v5.24.0
    DBD::MySQL : 4.033
    D:/strawberry-perl-5.24.0.1-64bit-portable/perl/site/lib
    D:/strawberry-perl-5.24.0.1-64bit-portable/perl/vendor/lib
    D:/strawberry-perl-5.24.0.1-64bit-portable/perl/lib
    .
    
    Server     : 5.6.41
    
    D:\strawberry-perl-5.24.0.1-64bit-portable>
    
    poj
      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.
      We don't have the same version of the DBD::mysql driver.

      F.

        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>

        Where can I get these ?

        Thanks

        F.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://1230153]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others goofing around in the Monastery: (3)
As of 2024-04-26 06:48 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found