Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

plugin 'mysql_old_password' cannot be loaded

by frazap (Monk)
on Feb 15, 2019 at 07:57 UTC ( [id://1229936]=perlquestion: print w/replies, xml ) Need Help??

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

I setup a new perl (strawberry portable) and I'm stuck with a failing connection to mysql server. That connection was working (and is still working) without problem on my old perl setup. I have no admin rights on the mysql server, I didn't create the users and password myself.

I have tried to move DBIx::Class in perl/site/lib and DBI in perl/vendor/lib from the old to the new install, but that does not change the problem.

The error is
DBI Connection failed: DBI connect('host= ... ;database= ... ;','user_ +name',...) failed: Authentication plugin 'mysql_old_password' cannot +be loaded: The specified module could not be found. at c:/spp/perl/vendor/lib/DBIx/Class/Storage/DBI.pm line 1517. at c:/ +spp/perl/vendor/lib/DBIx/Class/Schema.pm line 1118. DBIx::Class::Schema::throw_exception(Dbc::Schema=HASH(0x5aa0c2 +4), "DBI Connection failed: DBI connect('host=mysql.unifr.ch;datab".. +.) called at c:/spp/perl/vendor/lib/DBIx/Class/Storage.pm line 113 DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DB +I=HASH(0x5aa516c), "DBI Connection failed: DBI connect('host=mysql.un +ifr.ch;datab"...) called at c:/spp/perl/vendor/lib/DBIx/Class/Storage +/DBI.pm line 1558 DBIx::Class::Storage::DBI::catch {...} ("DBI connect('host=mys +ql.unifr.ch;database=dokpe_i02;','dokpe_"...) called at c:/spp/perl/v +endor/lib/Try/Tiny.pm line 123

Thanks for any help

F.

Replies are listed 'Best First'.
Re: plugin 'mysql_old_password' cannot be loaded
by marto (Cardinal) on Feb 15, 2019 at 09:47 UTC

      Thanks for helping

      So the only option is to create a new user and password on the mysql server that would have the same rights as the old one, so that I could use this new one with a recent client, and keep the old one with older client ?

      F

        Marto didn't say anything about logins or passwords. edit:(he did mention password hashing, my mistake.) Marto's comments were about the Perl module you copied being a mismatch for the portable Perl you installed. You need to install the module in your portable Strawberry Perl using cpan. Open a command prompt and run portableshell.bat in the portable Strawberry Perl folder. Then run cpan and install the module.

        Edit:I could be wrong but I believe cpan will let you install an older version of the module so you could find the version of the working one and install it to the new Strawberry Perl. Here is an article about how to do it. The example given is cpan SAMV/Set-Object-1.28.tar.gz for installing a specific version of Set::Object with author SAMV.

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others about the Monastery: (4)
As of 2024-04-20 00:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found