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

[download]

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
[reply]

      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

[reply]

        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.

[reply]
[d/l]

Back to Seekers of Perl Wisdom