Re^14: plugin 'mysql_old_password' cannot be loaded

Replies are listed 'Best First'.
Re^15: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 20, 2019 at 13:30 UTC
`Strawberry Perl 5.24.4.1-32bit includes these distributions installed on top of perl 5.24.4: ... 111/475: DB_File-1.841 114/475: DBD-mysql-4.033 119/475: DBI-1.641` [download] Build process `perl makefile.pl dmake dmake test dmake install` [download] output from dmake C:\spp24\cpan\build\DBD-mysql-4.033-0>dmake "C:\spp24\perl\bin\perl.exe" -MExtUtils::Command::MM -e cp_nonempty -- + mysql.bs blib\arch\auto\DBD\mysql\mysql.bs 644 gcc -c -IC:\spp24\perl\vendor\lib\auto\DBI -IC:\spp24\c\bin\..\includ +e\mysql50716 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -s -O2 -DWIN32 -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTEXT -DPERL_ +IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -s -O2 - +DVERSION=\"4.033\" -DXS_VERSION=\"4.033\" "-IC:\spp24\perl\lib\COR +E" dbdimp.c In file included from C:\spp24\c\bin\..\include\mysql50716/mysql.h:48: +0, from dbdimp.h:21, from dbdimp.c:20: C:/spp24/c/i686-w64-mingw32/include/winsock2.h:15:2: warning: #warning + Please include winsock2.h before windows.h [-Wcpp] #warning Please include winsock2.h before windows.h ^ In file included from C:\spp24\perl\lib\CORE/perl.h:5623:0, from C:\spp24\perl\vendor\lib\auto\DBI/DBIXS.h:23, from dbdimp.h:20, from dbdimp.c:20: dbdimp.c: In function 'mysql_db_FETCH_attrib': dbdimp.c:2672:34: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] result= sv_2mortal(newSViv((IV) imp_dbh->pmysql)); ^ C:\spp24\perl\lib\CORE/embed.h:581:46: note: in definition of macro 's +v_2mortal' #define sv_2mortal(a) Perl_sv_2mortal(aTHX_ a) ^ dbdimp.c:2672:26: note: in expansion of macro 'newSViv' result= sv_2mortal(newSViv((IV) imp_dbh->pmysql)); ^ In file included from C:/spp24/c/i686-w64-mingw32/include/combaseapi.h +:129:0, from C:/spp24/c/i686-w64-mingw32/include/objbase.h:14 +, from C:/spp24/c/i686-w64-mingw32/include/ole2.h:17, from C:/spp24/c/i686-w64-mingw32/include/wtypes.h:12, from C:/spp24/c/i686-w64-mingw32/include/winscard.h:1 +0, from C:/spp24/c/i686-w64-mingw32/include/windows.h:97 +, from dbdimp.c:16: dbdimp.c: In function 'mysql_st_internal_execute': dbdimp.c:3261:7: warning: '_errno' redeclared without dllimport attrib +ute after being referenced with dll linkage int errno; ^ In file included from C:\spp24\perl\lib\CORE/perl.h:5623:0, from C:\spp24\perl\vendor\lib\auto\DBI/DBIXS.h:23, from dbdimp.h:20, from dbdimp.c:20: dbdimp.c: In function 'mysql_st_FETCH_attrib': dbdimp.c:4661:35: warning: cast from pointer to integer of different s +ize [-Wpointer-to-int-cast] retsv= sv_2mortal(newSViv((IV) imp_sth->result)); ^ C:\spp24\perl\lib\CORE/embed.h:581:46: note: in definition of macro 's +v_2mortal' #define sv_2mortal(a) Perl_sv_2mortal(aTHX_ a) ^ dbdimp.c:4661:27: note: in expansion of macro 'newSViv' retsv= sv_2mortal(newSViv((IV) imp_sth->result)); ^ "C:\spp24\perl\bin\perl.exe" -p -e "s/~DRIVER~/mysql/g" C:\spp24\perl\ +vendor\lib\auto\DBI\Driver.xst > mysql.xsi "C:\spp24\perl\bin\perl.exe" "C:\spp24\perl\lib\ExtUtils\xsubpp" -typ +emap C:\spp24\perl\lib\ExtUtils\typemap mysql.xs > mysql.xsc Warning: duplicate function definition 'do' detected in mysql.xs, line + 242 Warning: duplicate function definition 'rows' detected in mysql.xs, li +ne 754 "C:\spp24\perl\bin\perl.exe" -MExtUtils::Command -e mv -- mysql.xsc my +sql.c gcc -c -IC:\spp24\perl\vendor\lib\auto\DBI -IC:\spp24\c\bin\..\includ +e\mysql50716 -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -s -O2 -DWIN32 -DPERL_TEXTMODE_SCRIPTS -DPERL_IMPLICIT_CONTEXT -DPERL_ +IMPLICIT_SYS -fwrapv -fno-strict-aliasing -mms-bitfields -s -O2 - +DVERSION=\"4.033\" -DXS_VERSION=\"4.033\" "-IC:\spp24\perl\lib\COR +E" mysql.c "C:\spp24\perl\bin\perl.exe" -MExtUtils::Mksymlists \ -e "Mksymlists('NAME'=>\"DBD::mysql\", 'DLBASE' => 'mysql', 'DL_F +UNCS' => { }, 'FUNCLIST' => [], 'IMPORTS' => { }, 'DL_VARS' => []); +" "C:\spp24\perl\bin\perl.exe" myld g++.exe mysql.def -o blib\arch\auto\ +DBD\mysql\mysql.xs.dll -mdll -s -L"C:\spp24\perl\lib\CORE" -L"C:\spp2 +4\c\lib" dbdimp.o mysql.o "C:\spp24\perl\lib\CORE\libperl524.a" +"C:\spp24\c\bin\..\lib\libmysql.a" "C:\spp24\c\i686-w64-mingw32\lib\l +ibmoldname.a" "C:\spp24\c\i686-w64-mingw32\lib\libkernel32.a" "C:\spp +24\c\i686-w64-mingw32\lib\libuser32.a" "C:\spp24\c\i686-w64-mingw32\l +ib\libgdi32.a" "C:\spp24\c\i686-w64-mingw32\lib\libwinspool.a" "C:\sp +p24\c\i686-w64-mingw32\lib\libcomdlg32.a" "C:\spp24\c\i686-w64-mingw3 +2\lib\libadvapi32.a" "C:\spp24\c\i686-w64-mingw32\lib\libshell32.a" " +C:\spp24\c\i686-w64-mingw32\lib\libole32.a" "C:\spp24\c\i686-w64-ming +w32\lib\liboleaut32.a" "C:\spp24\c\i686-w64-mingw32\lib\libnetapi32.a +" "C:\spp24\c\i686-w64-mingw32\lib\libuuid.a" "C:\spp24\c\i686-w64-mi +ngw32\lib\libws2_32.a" "C:\spp24\c\i686-w64-mingw32\lib\libmpr.a" "C: +\spp24\c\i686-w64-mingw32\lib\libwinmm.a" "C:\spp24\c\i686-w64-mingw3 +2\lib\libversion.a" "C:\spp24\c\i686-w64-mingw32\lib\libodbc32.a" "C: +\spp24\c\i686-w64-mingw32\lib\libodbccp32.a" "C:\spp24\c\i686-w64-min +gw32\lib\libcomctl32.a" -Wl,--enable-auto-image-base "C:\spp24\perl\bin\perl.exe" -MExtUtils::Command -e chmod -- 755 blib\ +arch\auto\DBD\mysql\mysql.xs.dll [download]	[reply] [d/l] [select]
Re^16: plugin 'mysql_old_password' cannot be loaded by marto (Cardinal) on Feb 20, 2019 at 14:08 UTC
I think you need to re read Re^5: plugin 'mysql_old_password' cannot be loaded, and tell me what you don't understand. You haven't stated which versions of the mysql dependencies you're building against. Simply manually building a perl modules isn't going to solve your problem. You need to explain what you think you are doing and why.	[reply]
Re^17: plugin 'mysql_old_password' cannot be loaded by frazap (Monk) on Feb 20, 2019 at 15:06 UTC
Take for example v5.28.1 with mysql-5.7.16 My understanding of this is that perl 5.28.1 is configured to connect to a mysql server version 5.7.16. Is it what you meant ? The server I would like to connect to is 5.5.53. Since I'm able to connect using an old strawberry perl 5.24 install with driver 4.033, but can't connect with a newer perl portable setup, I thought there would be a module to downgrade. Installing portable strawberry perl 5.24 does not gives me the same situation, since the DBD::mysql driver is 4.046. I thought that reinstalling the 4.033 version would work	[reply]


Keep It Simple, Stupid
	PerlMonks